vw_medida_ejecucion

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id_medida

int8

19

√

null

codigo

text

2147483647

√

null

medida

text

2147483647

√

null

id_eje

int8

19

√

null

codigo_eje

text

2147483647

√

null

eje

varchar

100

√

null

comprometido_cop

float8

17,17

√

null

ejecutado_cop

float8

17,17

√

null

por_ejecutar_cop

float8

17,17

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

WITH accion_total AS (
         SELECT a.id AS id_accion,
            COALESCE(sum(ff.valor), (0)::double precision) AS monto_total
           FROM (accion a
             LEFT JOIN fuente_financiacion_accion ff ON ((ff.id_accion_fk = a.id)))
          WHERE ((a.activo = true) AND (a.estado_registro = 'Validado'::estado_registro_enm))
          GROUP BY a.id
        ), accion_medidas AS (
         SELECT DISTINCT a.id AS id_accion,
            m_1.id AS id_medida
           FROM (((accion a
             JOIN indicador_accion ia ON ((ia.id_accion_fk = a.id)))
             JOIN indicador i ON ((i.id = ia.id_indicador_fk)))
             JOIN medida m_1 ON ((m_1.id = i.id_medida_fk)))
          WHERE ((a.activo = true) AND (a.estado_registro = 'Validado'::estado_registro_enm))
        ), accion_medida_count AS (
         SELECT accion_medidas.id_accion,
            count(*) AS n_medidas
           FROM accion_medidas
          GROUP BY accion_medidas.id_accion
        ), ejecutado_medida AS (
         SELECT am.id_medida,
            sum((at.monto_total / (amc.n_medidas)::double precision)) AS ejecutado_cop
           FROM ((accion_medidas am
             JOIN accion_total at ON ((at.id_accion = am.id_accion)))
             JOIN accion_medida_count amc ON ((amc.id_accion = am.id_accion)))
          GROUP BY am.id_medida
        )
 SELECT m.id AS id_medida,
    m.codigo,
    m.nombre AS medida,
    e.id AS id_eje,
    e.codigo AS codigo_eje,
    e.nombre AS eje,
    COALESCE(m.costo_aprox_medida_cop, (0)::double precision) AS comprometido_cop,
    COALESCE(em.ejecutado_cop, (0)::double precision) AS ejecutado_cop,
    (COALESCE(m.costo_aprox_medida_cop, (0)::double precision) - COALESCE(em.ejecutado_cop, (0)::double precision)) AS por_ejecutar_cop
   FROM ((medida m
     JOIN eje e ON ((e.id = m.id_eje_fk)))
     LEFT JOIN ejecutado_medida em ON ((em.id_medida = m.id)))
  WHERE (m.activo = true);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views