v_secciones_ce

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

sed_codigo

varchar

15

√

null

sec_pk

int8

19

√

null

sg_secciones.sec_pk

Implied Constraint

R

sec_nombre

varchar

255

√

null

sec_estado

varchar

50

√

null

matricula

int8

19

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT c.sed_codigo,
    c.sec_pk,
    c.sec_nombre,
    c.sec_estado,
    c.matricula
   FROM ( SELECT DISTINCT sede.sed_codigo,
            sec.sec_pk,
            sec.sec_nombre,
            sec.sec_estado,
            count(DISTINCT per.per_nie) AS matricula
           FROM (((((((((((((((centros_educativos.sg_secciones sec
             LEFT JOIN centros_educativos.sg_matriculas mat ON ((sec.sec_pk = mat.mat_seccion_fk)))
             LEFT JOIN centros_educativos.sg_servicio_educativo see ON ((sec.sec_servicio_educativo_fk = see.sdu_pk)))
             LEFT JOIN centros_educativos.sg_grados g ON ((g.gra_pk = see.sdu_grado_fk)))
             LEFT JOIN centros_educativos.sg_rel_mod_ed_mod_aten mod ON ((g.gra_relacion_modalidad_fk = mod.rea_pk)))
             LEFT JOIN centros_educativos.sg_modalidades moe ON ((mod.rea_modalidad_educativa_fk = moe.mod_pk)))
             LEFT JOIN catalogo.sg_modalidades_atencion moa ON ((mod.rea_modalidad_atencion_fk = moa.mat_pk)))
             LEFT JOIN centros_educativos.sg_ciclos cic ON ((moe.mod_ciclo = cic.cic_pk)))
             LEFT JOIN centros_educativos.sg_niveles niv ON ((cic.cic_nivel = niv.niv_pk)))
             LEFT JOIN centros_educativos.sg_sedes sede ON ((see.sdu_sede_fk = sede.sed_pk)))
             LEFT JOIN centros_educativos.sg_direcciones dir ON ((sede.sed_direccion_fk = dir.dir_pk)))
             LEFT JOIN catalogo.sg_departamentos dep ON ((dir.dir_departamento = dep.dep_pk)))
             LEFT JOIN catalogo.sg_municipios mun ON ((dir.dir_municipio = mun.mun_pk)))
             LEFT JOIN centros_educativos.sg_estudiantes est ON ((mat.mat_estudiante_fk = est.est_pk)))
             LEFT JOIN centros_educativos.sg_personas per ON ((est.est_persona = per.per_pk)))
             LEFT JOIN centros_educativos.sg_sedes_ced_pri pri ON ((sede.sed_pk = pri.sed_pk)))
          WHERE ((sec.sec_anio_lectivo_fk = 47) AND (mat.mat_anulada = false) AND (mat.mat_retirada = false) AND ((mat.mat_estado)::text = 'ABIERTO'::text) AND ((sec.sec_estado)::text = 'ABIERTA'::text) AND (sede.sed_implementadora_fk IS NULL) AND (sede.sed_centro_adscrito IS NULL) AND ((sede.sed_codigo)::text = ANY (ARRAY[('10016'::character varying)::text, ('10023'::character varying)::text, ('10024'::character varying)::text, ('10026'::character varying)::text, ('10029'::character varying)::text, ('10031'::character varying)::text, ('10032'::character varying)::text, ('10062'::character varying)::text, ('10072'::character varying)::text, ('10076'::character varying)::text, ('10077'::character varying)::text, ('10109'::character varying)::text, ('10115'::character varying)::text, ('10121'::character varying)::text, ('10146'::character varying)::text, ('10147'::character varying)::text, ('10152'::character varying)::text, ('10170'::character varying)::text, ('10176'::character varying)::text, ('10177'::character varying)::text, ('10475'::character varying)::text, ('10867'::character varying)::text, ('20001'::character varying)::text, ('20006'::character varying)::text, ('20018'::character varying)::text, ('20024'::character varying)::text, ('21322'::character varying)::text, ('21584'::character varying)::text, ('60003'::character varying)::text, ('60011'::character varying)::text, ('60015'::character varying)::text, ('60018'::character varying)::text, ('60020'::character varying)::text, ('60027'::character varying)::text, ('60032'::character varying)::text, ('60039'::character varying)::text, ('60057'::character varying)::text, ('60066'::character varying)::text, ('60077'::character varying)::text, ('60079'::character varying)::text, ('60097'::character varying)::text, ('60099'::character varying)::text, ('60139'::character varying)::text, ('60208'::character varying)::text, ('60249'::character varying)::text, ('60260'::character varying)::text, ('60261'::character varying)::text, ('60266'::character varying)::text, ('86146'::character varying)::text, ('86345'::character varying)::text, ('86487'::character varying)::text, ('10182'::character varying)::text, ('10185'::character varying)::text, ('10191'::character varying)::text, ('10195'::character varying)::text, ('10200'::character varying)::text, ('10213'::character varying)::text, ('10221'::character varying)::text, ('10230'::character varying)::text, ('10240'::character varying)::text, ('10250'::character varying)::text, ('10257'::character varying)::text, ('10258'::character varying)::text, ('10262'::character varying)::text, ('10292'::character varying)::text, ('10320'::character varying)::text, ('10335'::character varying)::text, ('10341'::character varying)::text, ('10344'::character varying)::text, ('10369'::character varying)::text, ('10371'::character varying)::text, ('10380'::character varying)::text, ('10428'::character varying)::text, ('10438'::character varying)::text, ('10439'::character varying)::text, ('10451'::character varying)::text, ('10453'::character varying)::text, ('10463'::character varying)::text, ('10466'::character varying)::text, ('10492'::character varying)::text, ('10498'::character varying)::text, ('10506'::character varying)::text, ('10507'::character varying)::text, ('10528'::character varying)::text, ('11041'::character varying)::text, ('20035'::character varying)::text, ('20040'::character varying)::text, ('20042'::character varying)::text, ('20067'::character varying)::text, ('20074'::character varying)::text, ('20080'::character varying)::text, ('20084'::character varying)::text, ('20095'::character varying)::text, ('21032'::character varying)::text, ('21085'::character varying)::text, ('21564'::character varying)::text, ('60022'::character varying)::text, ('60248'::character varying)::text, ('60292'::character varying)::text, ('62006'::character varying)::text, ('62014'::character varying)::text, ('62019'::character varying)::text, ('62022'::character varying)::text, ('62024'::character varying)::text, ('62031'::character varying)::text, ('62049'::character varying)::text, ('62066'::character varying)::text, ('62070'::character varying)::text, ('62072'::character varying)::text, ('62073'::character varying)::text, ('62074'::character varying)::text, ('62081'::character varying)::text, ('62091'::character varying)::text, ('62097'::character varying)::text, ('86152'::character varying)::text, ('86283'::character varying)::text, ('86291'::character varying)::text, ('86351'::character varying)::text, ('86467'::character varying)::text, ('86468'::character varying)::text, ('86478'::character varying)::text, ('86548'::character varying)::text, ('88122'::character varying)::text, ('88152'::character varying)::text, ('90002'::character varying)::text, ('90039'::character varying)::text, ('10124'::character varying)::text, ('10556'::character varying)::text, ('10559'::character varying)::text, ('10582'::character varying)::text, ('10624'::character varying)::text, ('10633'::character varying)::text, ('10637'::character varying)::text, ('10642'::character varying)::text, ('10644'::character varying)::text, ('10681'::character varying)::text, ('10682'::character varying)::text, ('10689'::character varying)::text, ('10696'::character varying)::text, ('10698'::character varying)::text, ('10700'::character varying)::text, ('10703'::character varying)::text, ('10715'::character varying)::text, ('10721'::character varying)::text, ('10730'::character varying)::text, ('10733'::character varying)::text, ('10734'::character varying)::text, ('10743'::character varying)::text, ('10750'::character varying)::text, ('10850'::character varying)::text, ('20108'::character varying)::text, ('20127'::character varying)::text, ('21074'::character varying)::text, ('21363'::character varying)::text, ('21571'::character varying)::text, ('60163'::character varying)::text, ('60296'::character varying)::text, ('64018'::character varying)::text, ('64019'::character varying)::text, ('64051'::character varying)::text, ('64067'::character varying)::text, ('64070'::character varying)::text, ('64072'::character varying)::text, ('64078'::character varying)::text, ('64107'::character varying)::text, ('64108'::character varying)::text, ('64112'::character varying)::text, ('64116'::character varying)::text, ('64124'::character varying)::text, ('86367'::character varying)::text, ('86406'::character varying)::text, ('10753'::character varying)::text, ('10762'::character varying)::text, ('10764'::character varying)::text, ('10789'::character varying)::text, ('10794'::character varying)::text, ('10802'::character varying)::text, ('10814'::character varying)::text, ('10822'::character varying)::text, ('10828'::character varying)::text, ('10831'::character varying)::text, ('10832'::character varying)::text, ('10874'::character varying)::text, ('10886'::character varying)::text, ('10898'::character varying)::text, ('10913'::character varying)::text, ('10918'::character varying)::text, ('10919'::character varying)::text, ('10937'::character varying)::text, ('10942'::character varying)::text, ('10953'::character varying)::text, ('10961'::character varying)::text, ('10972'::character varying)::text, ('10978'::character varying)::text, ('10981'::character varying)::text, ('10982'::character varying)::text, ('10983'::character varying)::text, ('10990'::character varying)::text, ('13790'::character varying)::text, ('14849'::character varying)::text, ('20149'::character varying)::text, ('20151'::character varying)::text, ('21116'::character varying)::text, ('60142'::character varying)::text, ('60143'::character varying)::text, ('60153'::character varying)::text, ('60223'::character varying)::text, ('66001'::character varying)::text, ('66005'::character varying)::text, ('66016'::character varying)::text, ('66020'::character varying)::text, ('66021'::character varying)::text, ('66026'::character varying)::text, ('66036'::character varying)::text, ('66037'::character varying)::text, ('66039'::character varying)::text, ('66041'::character varying)::text, ('66055'::character varying)::text, ('66069'::character varying)::text, ('66073'::character varying)::text, ('66076'::character varying)::text, ('66083'::character varying)::text, ('66087'::character varying)::text, ('66088'::character varying)::text, ('66095'::character varying)::text, ('66103'::character varying)::text, ('66106'::character varying)::text, ('66108'::character varying)::text, ('66109'::character varying)::text, ('66115'::character varying)::text, ('66117'::character varying)::text, ('66122'::character varying)::text, ('66127'::character varying)::text, ('66129'::character varying)::text, ('66130'::character varying)::text, ('66147'::character varying)::text, ('66148'::character varying)::text, ('66150'::character varying)::text, ('86164'::character varying)::text, ('86216'::character varying)::text, ('86222'::character varying)::text, ('86224'::character varying)::text, ('86323'::character varying)::text, ('86501'::character varying)::text, ('10424'::character varying)::text, ('10668'::character varying)::text, ('10724'::character varying)::text, ('11013'::character varying)::text, ('11019'::character varying)::text, ('11021'::character varying)::text, ('11034'::character varying)::text, ('11039'::character varying)::text, ('11077'::character varying)::text, ('11095'::character varying)::text, ('11099'::character varying)::text, ('11104'::character varying)::text, ('11111'::character varying)::text, ('11114'::character varying)::text, ('11121'::character varying)::text, ('11128'::character varying)::text, ('11143'::character varying)::text, ('11146'::character varying)::text, ('11164'::character varying)::text, ('11175'::character varying)::text, ('11186'::character varying)::text, ('11213'::character varying)::text, ('11217'::character varying)::text, ('11231'::character varying)::text, ('11234'::character varying)::text, ('11243'::character varying)::text, ('11257'::character varying)::text, ('11260'::character varying)::text, ('11277'::character varying)::text, ('11284'::character varying)::text, ('13596'::character varying)::text, ('20178'::character varying)::text, ('20183'::character varying)::text, ('20218'::character varying)::text, ('20222'::character varying)::text, ('20227'::character varying)::text, ('20250'::character varying)::text, ('20258'::character varying)::text, ('20265'::character varying)::text, ('20266'::character varying)::text, ('20271'::character varying)::text, ('21015'::character varying)::text, ('21017'::character varying)::text, ('21068'::character varying)::text, ('21119'::character varying)::text, ('21138'::character varying)::text, ('21195'::character varying)::text, ('21198'::character varying)::text, ('21304'::character varying)::text, ('21448'::character varying)::text, ('21453'::character varying)::text, ('21505'::character varying)::text, ('21540'::character varying)::text, ('21547'::character varying)::text, ('21557'::character varying)::text, ('21589'::character varying)::text, ('21611'::character varying)::text, ('60118'::character varying)::text, ('60122'::character varying)::text, ('60157'::character varying)::text, ('60255'::character varying)::text, ('68003'::character varying)::text, ('68024'::character varying)::text, ('68034'::character varying)::text, ('68049'::character varying)::text, ('68060'::character varying)::text, ('68067'::character varying)::text, ('68070'::character varying)::text, ('68076'::character varying)::text, ('68091'::character varying)::text, ('68095'::character varying)::text, ('68097'::character varying)::text, ('68160'::character varying)::text, ('68168'::character varying)::text, ('68180'::character varying)::text, ('68184'::character varying)::text, ('68190'::character varying)::text, ('68195'::character varying)::text, ('68197'::character varying)::text, ('86410'::character varying)::text, ('88029'::character varying)::text, ('88035'::character varying)::text, ('10140'::character varying)::text, ('10219'::character varying)::text, ('10332'::character varying)::text, ('10529'::character varying)::text, ('10609'::character varying)::text, ('10651'::character varying)::text, ('10895'::character varying)::text, ('11306'::character varying)::text, ('11317'::character varying)::text, ('11319'::character varying)::text, ('11322'::character varying)::text, ('11334'::character varying)::text, ('11344'::character varying)::text, ('11346'::character varying)::text, ('11351'::character varying)::text, ('11376'::character varying)::text, ('11382'::character varying)::text, ('11411'::character varying)::text, ('11429'::character varying)::text, ('11441'::character varying)::text, ('11450'::character varying)::text, ('11471'::character varying)::text, ('11491'::character varying)::text, ('11495'::character varying)::text, ('11503'::character varying)::text, ('11533'::character varying)::text, ('11541'::character varying)::text, ('11554'::character varying)::text, ('11574'::character varying)::text, ('11583'::character varying)::text, ('11584'::character varying)::text, ('11591'::character varying)::text, ('11615'::character varying)::text, ('11619'::character varying)::text, ('11623'::character varying)::text, ('11625'::character varying)::text, ('11651'::character varying)::text, ('11656'::character varying)::text, ('11662'::character varying)::text, ('11667'::character varying)::text, ('11671'::character varying)::text, ('11673'::character varying)::text, ('11679'::character varying)::text, ('11690'::character varying)::text, ('11708'::character varying)::text, ('11723'::character varying)::text, ('11724'::character varying)::text, ('11751'::character varying)::text, ('11756'::character varying)::text, ('11760'::character varying)::text, ('11763'::character varying)::text, ('11782'::character varying)::text, ('13597'::character varying)::text, ('14741'::character varying)::text, ('14820'::character varying)::text, ('20171'::character varying)::text, ('20282'::character varying)::text, ('20306'::character varying)::text, ('20320'::character varying)::text, ('20334'::character varying)::text, ('20353'::character varying)::text, ('20354'::character varying)::text, ('20394'::character varying)::text, ('20402'::character varying)::text, ('20415'::character varying)::text, ('20424'::character varying)::text, ('20449'::character varying)::text, ('20460'::character varying)::text, ('20469'::character varying)::text, ('20516'::character varying)::text, ('20524'::character varying)::text, ('20541'::character varying)::text, ('20545'::character varying)::text, ('20547'::character varying)::text, ('20549'::character varying)::text, ('20559'::character varying)::text, ('20590'::character varying)::text, ('20595'::character varying)::text, ('20596'::character varying)::text, ('20628'::character varying)::text, ('20633'::character varying)::text, ('20638'::character varying)::text, ('20648'::character varying)::text, ('20688'::character varying)::text, ('20704'::character varying)::text, ('20707'::character varying)::text, ('20718'::character varying)::text, ('20752'::character varying)::text, ('20760'::character varying)::text, ('20773'::character varying)::text, ('20790'::character varying)::text, ('20792'::character varying)::text, ('20799'::character varying)::text, ('20811'::character varying)::text, ('20834'::character varying)::text, ('21007'::character varying)::text, ('21023'::character varying)::text, ('21258'::character varying)::text, ('21261'::character varying)::text, ('21372'::character varying)::text, ('21386'::character varying)::text, ('21457'::character varying)::text, ('21459'::character varying)::text, ('21460'::character varying)::text, ('21478'::character varying)::text, ('21546'::character varying)::text, ('21549'::character varying)::text, ('21551'::character varying)::text, ('21574'::character varying)::text, ('21601'::character varying)::text, ('60185'::character varying)::text, ('60247'::character varying)::text, ('60279'::character varying)::text, ('60284'::character varying)::text, ('60295'::character varying)::text, ('60306'::character varying)::text, ('70001'::character varying)::text, ('70004'::character varying)::text, ('70035'::character varying)::text, ('70061'::character varying)::text, ('70065'::character varying)::text, ('70069'::character varying)::text, ('70074'::character varying)::text, ('70077'::character varying)::text, ('70093'::character varying)::text, ('70098'::character varying)::text, ('86237'::character varying)::text, ('86329'::character varying)::text, ('86330'::character varying)::text, ('86384'::character varying)::text, ('86392'::character varying)::text, ('86400'::character varying)::text, ('88069'::character varying)::text, ('88130'::character varying)::text, ('88135'::character varying)::text, ('88138'::character varying)::text, ('88156'::character varying)::text, ('90031'::character varying)::text, ('90049'::character varying)::text, ('11809'::character varying)::text, ('11821'::character varying)::text, ('11828'::character varying)::text, ('11833'::character varying)::text, ('11836'::character varying)::text, ('11838'::character varying)::text, ('11858'::character varying)::text, ('11860'::character varying)::text, ('11861'::character varying)::text, ('11865'::character varying)::text, ('11872'::character varying)::text, ('11873'::character varying)::text, ('11878'::character varying)::text, ('11884'::character varying)::text, ('11888'::character varying)::text, ('11890'::character varying)::text, ('11910'::character varying)::text, ('11915'::character varying)::text, ('20841'::character varying)::text, ('20846'::character varying)::text, ('21167'::character varying)::text, ('21228'::character varying)::text, ('21519'::character varying)::text, ('60211'::character varying)::text, ('72006'::character varying)::text, ('72008'::character varying)::text, ('72019'::character varying)::text, ('72020'::character varying)::text, ('72059'::character varying)::text, ('72078'::character varying)::text, ('86532'::character varying)::text, ('86536'::character varying)::text, ('88078'::character varying)::text, ('10303'::character varying)::text, ('11964'::character varying)::text, ('11977'::character varying)::text, ('11999'::character varying)::text, ('12007'::character varying)::text, ('12015'::character varying)::text, ('12030'::character varying)::text, ('12034'::character varying)::text, ('12065'::character varying)::text, ('12074'::character varying)::text, ('12079'::character varying)::text, ('12083'::character varying)::text, ('12097'::character varying)::text, ('12104'::character varying)::text, ('12109'::character varying)::text, ('12112'::character varying)::text, ('12113'::character varying)::text, ('12119'::character varying)::text, ('12120'::character varying)::text, ('12124'::character varying)::text, ('12131'::character varying)::text, ('20857'::character varying)::text, ('20861'::character varying)::text, ('21498'::character varying)::text, ('21610'::character varying)::text, ('60273'::character varying)::text, ('74003'::character varying)::text, ('74013'::character varying)::text, ('74079'::character varying)::text, ('74089'::character varying)::text, ('74092'::character varying)::text, ('86244'::character varying)::text, ('86374'::character varying)::text, ('86377'::character varying)::text, ('12137'::character varying)::text, ('12157'::character varying)::text, ('12162'::character varying)::text, ('12172'::character varying)::text, ('12175'::character varying)::text, ('12178'::character varying)::text, ('12181'::character varying)::text, ('12189'::character varying)::text, ('12198'::character varying)::text, ('12199'::character varying)::text, ('12216'::character varying)::text, ('12217'::character varying)::text, ('12220'::character varying)::text, ('12221'::character varying)::text, ('12235'::character varying)::text, ('12237'::character varying)::text, ('12245'::character varying)::text, ('12306'::character varying)::text, ('14868'::character varying)::text, ('20879'::character varying)::text, ('60170'::character varying)::text, ('60269'::character varying)::text, ('76013'::character varying)::text, ('76016'::character varying)::text, ('76018'::character varying)::text, ('76020'::character varying)::text, ('76030'::character varying)::text, ('76032'::character varying)::text, ('76051'::character varying)::text, ('76056'::character varying)::text, ('76059'::character varying)::text, ('76069'::character varying)::text, ('86265'::character varying)::text, ('86269'::character varying)::text, ('86430'::character varying)::text, ('88165'::character varying)::text, ('88172'::character varying)::text, ('88180'::character varying)::text, ('88187'::character varying)::text, ('10411'::character varying)::text, ('12351'::character varying)::text, ('12360'::character varying)::text, ('12367'::character varying)::text, ('12395'::character varying)::text, ('12399'::character varying)::text, ('12404'::character varying)::text, ('12405'::character varying)::text, ('12443'::character varying)::text, ('12452'::character varying)::text, ('78013'::character varying)::text, ('78016'::character varying)::text, ('78017'::character varying)::text, ('78029'::character varying)::text, ('78037'::character varying)::text, ('78043'::character varying)::text, ('78047'::character varying)::text, ('78050'::character varying)::text, ('78062'::character varying)::text, ('78065'::character varying)::text, ('78090'::character varying)::text, ('86418'::character varying)::text, ('90009'::character varying)::text, ('11154'::character varying)::text, ('12491'::character varying)::text, ('12509'::character varying)::text, ('12513'::character varying)::text, ('12518'::character varying)::text, ('12520'::character varying)::text, ('12567'::character varying)::text, ('12568'::character varying)::text, ('12571'::character varying)::text, ('12583'::character varying)::text, ('12586'::character varying)::text, ('12602'::character varying)::text, ('12626'::character varying)::text, ('12628'::character varying)::text, ('12633'::character varying)::text, ('12636'::character varying)::text, ('12641'::character varying)::text, ('12656'::character varying)::text, ('12660'::character varying)::text, ('12683'::character varying)::text, ('12685'::character varying)::text, ('12687'::character varying)::text, ('12713'::character varying)::text, ('12718'::character varying)::text, ('12725'::character varying)::text, ('12743'::character varying)::text, ('12760'::character varying)::text, ('12771'::character varying)::text, ('12778'::character varying)::text, ('13707'::character varying)::text, ('14789'::character varying)::text, ('14831'::character varying)::text, ('21000'::character varying)::text, ('60176'::character varying)::text, ('60179'::character varying)::text, ('60181'::character varying)::text, ('60182'::character varying)::text, ('60183'::character varying)::text, ('60251'::character varying)::text, ('60271'::character varying)::text, ('80017'::character varying)::text, ('80036'::character varying)::text, ('80045'::character varying)::text, ('80046'::character varying)::text, ('80052'::character varying)::text, ('80060'::character varying)::text, ('80068'::character varying)::text, ('80070'::character varying)::text, ('80085'::character varying)::text, ('80095'::character varying)::text, ('80097'::character varying)::text, ('80110'::character varying)::text, ('80113'::character varying)::text, ('80115'::character varying)::text, ('80122'::character varying)::text, ('80135'::character varying)::text, ('80147'::character varying)::text, ('80159'::character varying)::text, ('80168'::character varying)::text, ('86413'::character varying)::text, ('86507'::character varying)::text, ('88090'::character varying)::text, ('10296'::character varying)::text, ('10354'::character varying)::text, ('10628'::character varying)::text, ('10805'::character varying)::text, ('12549'::character varying)::text, ('12779'::character varying)::text, ('12796'::character varying)::text, ('12797'::character varying)::text, ('12800'::character varying)::text, ('12807'::character varying)::text, ('12812'::character varying)::text, ('12813'::character varying)::text, ('12817'::character varying)::text, ('12827'::character varying)::text, ('12828'::character varying)::text, ('12833'::character varying)::text, ('12837'::character varying)::text, ('12841'::character varying)::text, ('12844'::character varying)::text, ('12850'::character varying)::text, ('12873'::character varying)::text, ('12876'::character varying)::text, ('12877'::character varying)::text, ('12879'::character varying)::text, ('12881'::character varying)::text, ('12886'::character varying)::text, ('12905'::character varying)::text, ('12914'::character varying)::text, ('12920'::character varying)::text, ('12921'::character varying)::text, ('12959'::character varying)::text, ('12967'::character varying)::text, ('12969'::character varying)::text, ('12986'::character varying)::text, ('12990'::character varying)::text, ('13034'::character varying)::text, ('13045'::character varying)::text, ('13053'::character varying)::text, ('13055'::character varying)::text, ('13062'::character varying)::text, ('13075'::character varying)::text, ('13084'::character varying)::text, ('13094'::character varying)::text, ('13097'::character varying)::text, ('13098'::character varying)::text, ('13122'::character varying)::text, ('13125'::character varying)::text, ('14876'::character varying)::text, ('20920'::character varying)::text, ('20923'::character varying)::text, ('20927'::character varying)::text, ('20932'::character varying)::text, ('20956'::character varying)::text, ('20958'::character varying)::text, ('21029'::character varying)::text, ('21099'::character varying)::text, ('21530'::character varying)::text, ('21612'::character varying)::text, ('82001'::character varying)::text, ('82041'::character varying)::text, ('82045'::character varying)::text, ('82051'::character varying)::text, ('82056'::character varying)::text, ('82062'::character varying)::text, ('82064'::character varying)::text, ('82074'::character varying)::text, ('82078'::character varying)::text, ('82079'::character varying)::text, ('82090'::character varying)::text, ('82096'::character varying)::text, ('82105'::character varying)::text, ('82106'::character varying)::text, ('82113'::character varying)::text, ('82127'::character varying)::text, ('82128'::character varying)::text, ('82134'::character varying)::text, ('82138'::character varying)::text, ('82145'::character varying)::text, ('82154'::character varying)::text, ('82158'::character varying)::text, ('82159'::character varying)::text, ('82160'::character varying)::text, ('86301'::character varying)::text, ('86303'::character varying)::text, ('86514'::character varying)::text, ('10879'::character varying)::text, ('11014'::character varying)::text, ('13158'::character varying)::text, ('13222'::character varying)::text, ('13232'::character varying)::text, ('13249'::character varying)::text, ('13253'::character varying)::text, ('13258'::character varying)::text, ('13270'::character varying)::text, ('13280'::character varying)::text, ('13287'::character varying)::text, ('20238'::character varying)::text, ('21245'::character varying)::text, ('21456'::character varying)::text, ('60189'::character varying)::text, ('60299'::character varying)::text, ('84001'::character varying)::text, ('84015'::character varying)::text, ('84017'::character varying)::text, ('84033'::character varying)::text, ('84034'::character varying)::text, ('84055'::character varying)::text, ('84057'::character varying)::text, ('84063'::character varying)::text, ('84064'::character varying)::text, ('84076'::character varying)::text, ('84082'::character varying)::text, ('84084'::character varying)::text, ('84111'::character varying)::text, ('84124'::character varying)::text, ('86522'::character varying)::text, ('13322'::character varying)::text, ('13323'::character varying)::text, ('13328'::character varying)::text, ('13332'::character varying)::text, ('13338'::character varying)::text, ('13342'::character varying)::text, ('13346'::character varying)::text, ('13352'::character varying)::text, ('13367'::character varying)::text, ('13370'::character varying)::text, ('13374'::character varying)::text, ('13376'::character varying)::text, ('13416'::character varying)::text, ('13425'::character varying)::text, ('13429'::character varying)::text, ('13430'::character varying)::text, ('13439'::character varying)::text, ('13456'::character varying)::text, ('13479'::character varying)::text, ('13499'::character varying)::text, ('13502'::character varying)::text, ('13523'::character varying)::text, ('13524'::character varying)::text, ('13529'::character varying)::text, ('13531'::character varying)::text, ('13536'::character varying)::text, ('13547'::character varying)::text, ('13551'::character varying)::text, ('13564'::character varying)::text, ('13568'::character varying)::text, ('13579'::character varying)::text, ('13584'::character varying)::text, ('13586'::character varying)::text, ('20978'::character varying)::text, ('21151'::character varying)::text, ('21561'::character varying)::text, ('86001'::character varying)::text, ('86009'::character varying)::text, ('86010'::character varying)::text, ('86017'::character varying)::text, ('86020'::character varying)::text, ('86032'::character varying)::text, ('86034'::character varying)::text, ('86045'::character varying)::text, ('86050'::character varying)::text, ('86057'::character varying)::text, ('86060'::character varying)::text, ('86085'::character varying)::text, ('86090'::character varying)::text, ('86125'::character varying)::text, ('86336'::character varying)::text, ('86450'::character varying)::text, ('10090'::character varying)::text, ('10111'::character varying)::text, ('10173'::character varying)::text, ('20003'::character varying)::text, ('21294'::character varying)::text, ('60100'::character varying)::text, ('10190'::character varying)::text, ('10407'::character varying)::text, ('10470'::character varying)::text, ('20038'::character varying)::text, ('20062'::character varying)::text, ('20097'::character varying)::text, ('21235'::character varying)::text, ('60197'::character varying)::text, ('62001'::character varying)::text, ('62004'::character varying)::text, ('62017'::character varying)::text, ('86274'::character varying)::text, ('88017'::character varying)::text, ('10641'::character varying)::text, ('10660'::character varying)::text, ('10676'::character varying)::text, ('10717'::character varying)::text, ('10727'::character varying)::text, ('10738'::character varying)::text, ('14707'::character varying)::text, ('20144'::character varying)::text, ('64023'::character varying)::text, ('86401'::character varying)::text, ('90003'::character varying)::text, ('10806'::character varying)::text, ('10834'::character varying)::text, ('10849'::character varying)::text, ('10866'::character varying)::text, ('10900'::character varying)::text, ('10948'::character varying)::text, ('10969'::character varying)::text, ('10997'::character varying)::text, ('60043'::character varying)::text, ('60239'::character varying)::text, ('66002'::character varying)::text, ('66030'::character varying)::text, ('66102'::character varying)::text, ('10478'::character varying)::text, ('10595'::character varying)::text, ('11122'::character varying)::text, ('11190'::character varying)::text, ('11228'::character varying)::text, ('11232'::character varying)::text, ('11249'::character varying)::text, ('20192'::character varying)::text, ('20203'::character varying)::text, ('21216'::character varying)::text, ('21275'::character varying)::text, ('21405'::character varying)::text, ('21407'::character varying)::text, ('21503'::character varying)::text, ('10598'::character varying)::text, ('10607'::character varying)::text, ('11307'::character varying)::text, ('11340'::character varying)::text, ('11364'::character varying)::text, ('11370'::character varying)::text, ('11377'::character varying)::text, ('11414'::character varying)::text, ('11477'::character varying)::text, ('11546'::character varying)::text, ('11570'::character varying)::text, ('11575'::character varying)::text, ('11674'::character varying)::text, ('11735'::character varying)::text, ('11748'::character varying)::text, ('11777'::character varying)::text, ('20309'::character varying)::text, ('20333'::character varying)::text, ('20382'::character varying)::text, ('20473'::character varying)::text, ('20530'::character varying)::text, ('20710'::character varying)::text, ('20812'::character varying)::text, ('21256'::character varying)::text, ('21337'::character varying)::text, ('60250'::character varying)::text, ('86386'::character varying)::text, ('88044'::character varying)::text, ('90055'::character varying)::text, ('11811'::character varying)::text, ('11819'::character varying)::text, ('11880'::character varying)::text, ('20848'::character varying)::text, ('11960'::character varying)::text, ('12009'::character varying)::text, ('12096'::character varying)::text, ('12121'::character varying)::text, ('12132'::character varying)::text, ('14867'::character varying)::text, ('20859'::character varying)::text, ('20868'::character varying)::text, ('20872'::character varying)::text, ('21350'::character varying)::text, ('74048'::character varying)::text, ('74049'::character varying)::text, ('74062'::character varying)::text, ('74065'::character varying)::text, ('74090'::character varying)::text, ('12151'::character varying)::text, ('12206'::character varying)::text, ('12251'::character varying)::text, ('12265'::character varying)::text, ('12321'::character varying)::text, ('12331'::character varying)::text, ('12419'::character varying)::text, ('12459'::character varying)::text, ('78007'::character varying)::text, ('78058'::character varying)::text, ('78082'::character varying)::text, ('88110'::character varying)::text, ('90046'::character varying)::text, ('12485'::character varying)::text, ('12507'::character varying)::text, ('12525'::character varying)::text, ('12572'::character varying)::text, ('12708'::character varying)::text, ('60253'::character varying)::text, ('80106'::character varying)::text, ('80138'::character varying)::text, ('80141'::character varying)::text, ('12793'::character varying)::text, ('12826'::character varying)::text, ('12872'::character varying)::text, ('12891'::character varying)::text, ('12979'::character varying)::text, ('13001'::character varying)::text, ('13066'::character varying)::text, ('13068'::character varying)::text, ('13083'::character varying)::text, ('13111'::character varying)::text, ('20928'::character varying)::text, ('20942'::character varying)::text, ('20961'::character varying)::text, ('82013'::character varying)::text, ('82031'::character varying)::text, ('82040'::character varying)::text, ('82151'::character varying)::text, ('86304'::character varying)::text, ('13139'::character varying)::text, ('13142'::character varying)::text, ('13241'::character varying)::text, ('13262'::character varying)::text, ('60298'::character varying)::text, ('84071'::character varying)::text, ('13321'::character varying)::text, ('13339'::character varying)::text, ('13409'::character varying)::text, ('13445'::character varying)::text, ('13482'::character varying)::text, ('13537'::character varying)::text, ('86012'::character varying)::text, ('86100'::character varying)::text, ('86108'::character varying)::text, ('86130'::character varying)::text, ('86240'::character varying)::text, ('86335'::character varying)::text, ('86456'::character varying)::text, ('10022'::character varying)::text, ('10178'::character varying)::text, ('14825'::character varying)::text, ('20004'::character varying)::text, ('90038'::character varying)::text, ('10483'::character varying)::text, ('62013'::character varying)::text, ('62046'::character varying)::text, ('62095'::character varying)::text, ('10569'::character varying)::text, ('10596'::character varying)::text, ('10608'::character varying)::text, ('10687'::character varying)::text, ('10731'::character varying)::text, ('10740'::character varying)::text, ('64022'::character varying)::text, ('10911'::character varying)::text, ('66006'::character varying)::text, ('66107'::character varying)::text, ('86322'::character varying)::text, ('20190'::character varying)::text, ('20492'::character varying)::text, ('68021'::character varying)::text, ('11372'::character varying)::text, ('11741'::character varying)::text, ('20296'::character varying)::text, ('20302'::character varying)::text, ('20446'::character varying)::text, ('20466'::character varying)::text, ('20625'::character varying)::text, ('21016'::character varying)::text, ('21127'::character varying)::text, ('21493'::character varying)::text, ('70042'::character varying)::text, ('11824'::character varying)::text, ('11842'::character varying)::text, ('11875'::character varying)::text, ('60328'::character varying)::text, ('72082'::character varying)::text, ('11984'::character varying)::text, ('12075'::character varying)::text, ('12116'::character varying)::text, ('60169'::character varying)::text, ('86433'::character varying)::text, ('88171'::character varying)::text, ('12441'::character varying)::text, ('78080'::character varying)::text, ('12565'::character varying)::text, ('12569'::character varying)::text, ('12739'::character varying)::text, ('14823'::character varying)::text, ('86316'::character varying)::text, ('12966'::character varying)::text, ('12997'::character varying)::text, ('13050'::character varying)::text, ('13057'::character varying)::text, ('20966'::character varying)::text, ('21233'::character varying)::text, ('82014'::character varying)::text, ('82146'::character varying)::text, ('86552'::character varying)::text, ('13178'::character varying)::text, ('13229'::character varying)::text, ('13242'::character varying)::text, ('84121'::character varying)::text, ('13412'::character varying)::text, ('13443'::character varying)::text, ('86003'::character varying)::text, ('10037'::character varying)::text, ('60005'::character varying)::text, ('10430'::character varying)::text, ('10496'::character varying)::text, ('20092'::character varying)::text, ('20099'::character varying)::text, ('60196'::character varying)::text, ('62076'::character varying)::text, ('10548'::character varying)::text, ('10588'::character varying)::text, ('10631'::character varying)::text, ('21298'::character varying)::text, ('64109'::character varying)::text, ('10863'::character varying)::text, ('20150'::character varying)::text, ('11071'::character varying)::text, ('11291'::character varying)::text, ('60215'::character varying)::text, ('10967'::character varying)::text, ('11366'::character varying)::text, ('11415'::character varying)::text, ('11422'::character varying)::text, ('11532'::character varying)::text, ('11553'::character varying)::text, ('11652'::character varying)::text, ('11684'::character varying)::text, ('20502'::character varying)::text, ('20506'::character varying)::text, ('21132'::character varying)::text, ('21471'::character varying)::text, ('70056'::character varying)::text, ('11862'::character varying)::text, ('11874'::character varying)::text, ('11965'::character varying)::text, ('12117'::character varying)::text, ('20869'::character varying)::text, ('74042'::character varying)::text, ('14783'::character varying)::text, ('76022'::character varying)::text, ('90008'::character varying)::text, ('12316'::character varying)::text, ('12457'::character varying)::text, ('12590'::character varying)::text, ('12652'::character varying)::text, ('12774'::character varying)::text, ('20900'::character varying)::text, ('80053'::character varying)::text, ('80086'::character varying)::text, ('84078'::character varying)::text, ('84081'::character varying)::text, ('86013'::character varying)::text, ('10047'::character varying)::text, ('10095'::character varying)::text, ('10392'::character varying)::text, ('20128'::character varying)::text, ('60301'::character varying)::text, ('11229'::character varying)::text, ('11469'::character varying)::text, ('11598'::character varying)::text, ('11675'::character varying)::text, ('20312'::character varying)::text, ('90026'::character varying)::text, ('11785'::character varying)::text, ('12560'::character varying)::text, ('12746'::character varying)::text, ('80044'::character varying)::text, ('12839'::character varying)::text, ('12890'::character varying)::text, ('13082'::character varying)::text, ('13373'::character varying)::text, ('10169'::character varying)::text, ('10208'::character varying)::text, ('10455'::character varying)::text, ('14850'::character varying)::text, ('11349'::character varying)::text, ('11374'::character varying)::text, ('11573'::character varying)::text, ('11603'::character varying)::text, ('20279'::character varying)::text, ('21306'::character varying)::text, ('12294'::character varying)::text, ('13130'::character varying)::text, ('82153'::character varying)::text, ('90012'::character varying)::text, ('13422'::character varying)::text, ('11008'::character varying)::text, ('12601'::character varying)::text, ('10479'::character varying)::text, ('60198'::character varying)::text, ('11028'::character varying)::text, ('11695'::character varying)::text, ('12090'::character varying)::text, ('74078'::character varying)::text, ('13260'::character varying)::text, ('84126'::character varying)::text, ('21489'::character varying)::text, ('10066'::character varying)::text, ('10999'::character varying)::text, ('21568'::character varying)::text, ('70038'::character varying)::text, ('11792'::character varying)::text, ('21425'::character varying)::text, ('13264'::character varying)::text, ('10394'::character varying)::text, ('11138'::character varying)::text, ('11493'::character varying)::text, ('14865'::character varying)::text, ('72083'::character varying)::text, ('10052'::character varying)::text, ('20801'::character varying)::text, ('90006'::character varying)::text, ('12585'::character varying)::text])))
          GROUP BY sede.sed_codigo, sec.sec_pk, sec.sec_nombre, sec.sec_estado) c;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views