{"id":14955,"date":"2023-05-12T08:10:25","date_gmt":"2023-05-12T14:10:25","guid":{"rendered":"http:\/\/201.237.206.56\/Sitios\/ugit.siua.ac.cr\/?p=14955"},"modified":"2023-05-12T08:19:25","modified_gmt":"2023-05-12T14:19:25","slug":"esteban","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=14955","title":{"rendered":"Esteban"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT \n\nPA.ID_PERIODO_ANUAL PERIODO_ANUAL,\nAM.CODIGO || ' \/ '|| AM.DESCRIPCION ACTIVIDAD_MEJORA,\nOP.CODIGO || '.' || MP.CODIGO || '.' || MP.DESCRIPCION META_POA,\nUE.CODIGO UE_COD,\nUE.NOMBRE UE_NOMBRE,\nROUND ((AVG(MPE.EJECUCION)\/ \nCASE (PAF.ANO - PAI.ANO)\n    WHEN 0\n    THEN 1\n    ELSE (PAF.ANO - PAI.ANO)\n  END),2) PROMEDIO,\nBAM.JUSTIFICACION,\nEAM.NOMBRE ESTADO\n\nFROM PPI.ACTIVIDAD_MEJORA AM\nINNER JOIN PPI.META_POA_ACTIVIDAD_MEJORA MPAM ON (AM.ID_ACTIVIDAD_MEJORA = MPAM.ACTIVIDAD_MEJORA)\nINNER JOIN BITACORA_AM BAM ON BAM.ACTIVIDAD_MEJORA = MPAM.ACTIVIDAD_MEJORA AND ( BAM.ID_BITACORA_AM = (\n    SELECT ID_BITACORA_AM \n    FROM BITACORA_AM BAM1 \n    WHERE FECHA = ( \n            SELECT MAX(FECHA) FROM BITACORA_AM BAM2  WHERE (BAM1.ACTIVIDAD_MEJORA = BAM2.ACTIVIDAD_MEJORA) \n        ) AND BAM1.ACTIVIDAD_MEJORA = AM.ID_ACTIVIDAD_MEJORA\n    ) )\nINNER JOIN PPI.META_POA MP ON (MP.ID_META_POA = MPAM.META_POA)\nINNER JOIN PPI.OBJETIVO_POA OP ON (OP.ID_OBJETIVO_POA = MP.OBJETIVO_POA)\nINNER JOIN EPF.UNIDAD_EJECUTORA UE ON (UE.ID_UNIDAD_EJECUTORA = AM.UNIDAD_EJECUTORA)\nINNER JOIN PPI.META_POA_EVALUACION MPE ON (MP.ID_META_POA = MPE.META_POA)\nINNER JOIN PPI.ESTADO_AM EAM ON (AM.ESTADO_AM = EAM.ID_ESTADO_AM)\nINNER JOIN PPI.ETAPA_PLAN EP ON (EP.ID_ETAPA_PLAN= MPE.ETAPA_PLAN AND MPE.ETAPA_PLAN = :etapaPlan)\nINNER JOIN EPF.PERIODO_ANUAL PA ON (PA.ID_PERIODO_ANUAL = EP.PERIODO_ANUAL)\nINNER JOIN PERIODO_ANUAL PAI ON (PAI.ID_PERIODO_ANUAL = AM.PERIODO_ANUAL_INICIAL)\nINNER JOIN PERIODO_ANUAL PAF ON (PAF.ID_PERIODO_ANUAL = AM.PERIODO_ANUAL_FINAL)\nGROUP BY \nPA.ID_PERIODO_ANUAL,\nAM.CODIGO,\nAM.DESCRIPCION,\nOP.CODIGO,\nMP.CODIGO,\nMP.DESCRIPCION,\nUE.CODIGO,\nUE.NOMBRE,\nPAF.ANO - PAI.ANO,\nBAM.JUSTIFICACION,\nEAM.NOMBRE,\nBAM.ID_BITACORA_AM,\nBAM.FECHA\nORDER BY \nUE.CODIGO,\nUE.NOMBRE,\nAM.CODIGO,\nAM.DESCRIPCION;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-14955","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14955"}],"version-history":[{"count":2,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14955\/revisions"}],"predecessor-version":[{"id":14957,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/14955\/revisions\/14957"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}