vw_total_grados_media_2025 - siges.centros

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

codigo_ce

varchar

15

√

null

total_primer

numeric

0

√

null

total_segund

numeric

0

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT DISTINCT c.codigo_ce,
    sum(c.total_primer) AS total_primer,
    sum(c.total_segund) AS total_segund
   FROM ( SELECT vw.codigo_ce,
            vw.grado,
            count(DISTINCT vw.nie_estudiante) AS total_primer,
            0 AS total_segund
           FROM (((centros_educativos.vw_matricula2025_total vw
             LEFT JOIN centros_educativos.sg_sedes sede ON (((vw.codigo_ce)::text = (sede.sed_codigo)::text)))
             LEFT JOIN centros_educativos.sg_sedes_ced ced ON ((sede.sed_pk = ced.sed_pk)))
             LEFT JOIN catalogo.sg_tipos_organismo_administrativo toa ON ((ced.ced_tipo_organismo_administrativo_fk = toa.toa_pk)))
          WHERE (((vw.sector)::text <> ALL ((ARRAY['CIR_INF'::character varying, 'CIR_ALF'::character varying])::text[])) AND ((vw.nivel)::text = 'Educación Media'::text) AND ((vw.grado)::text = 'Primer Año'::text))
          GROUP BY vw.codigo_ce, vw.grado
        UNION
         SELECT vw.codigo_ce,
            vw.grado,
            0 AS total_primer,
            count(DISTINCT vw.nie_estudiante) AS total_segund
           FROM (((vw_matricula2025_total vw
             LEFT JOIN centros_educativos.sg_sedes sede ON (((vw.codigo_ce)::text = (sede.sed_codigo)::text)))
             LEFT JOIN centros_educativos.sg_sedes_ced ced ON ((sede.sed_pk = ced.sed_pk)))
             LEFT JOIN catalogo.sg_tipos_organismo_administrativo toa ON ((ced.ced_tipo_organismo_administrativo_fk = toa.toa_pk)))
          WHERE (((vw.sector)::text <> ALL ((ARRAY['CIR_INF'::character varying, 'CIR_ALF'::character varying])::text[])) AND ((vw.nivel)::text = 'Educación Media'::text) AND ((vw.grado)::text = 'Segundo Año'::text))
          GROUP BY vw.codigo_ce, vw.grado) c
  GROUP BY c.codigo_ce;

Possibly Referenced Tables/Views

vw_matricula2025_total