Error al migrar equivalencias - post contorles

SIU-Guaraní Migración de Datos
35

Hola Alejandro

Respondo

-- G2
SELECT count(DISTINCT m_r.nro_tramite)
FROM mig._cnv_pk_reconocimiento as m_r
JOIN mig.sga_equiv_operac as eo ON eo.operacion_equiv = m_r.operacion_equiv_g2
JOIN mig.sga_equiv_otorgada as e ON e.operacion_equiv = eo.operacion_equiv
WHERE eo.operacion_equiv IN (SELECT operacion_equiv FROM mig.sga_equiv_otorgada)
     AND eo.origen = 'H'
     AND m_r.origen = 'EQUIVALENCIA';

5 registros

SELECT COUNT(DISTINCT m_r.nro_tramite)
  FROM mig._cnv_pk_reconocimiento as m_r
     JOIN mig.sga_resol_activ as rs ON rs.unidad_academica = m_r.unidad_academica AND rs.resol_actividades = m_r.resol_actividades
 WHERE m_r.origen = 'EXTRACURRICULAR';

48161 registros

-- Guarani 3   
SELECT count(DISTINCT r.nro_tramite)-- INTO cnt_homologaciones_g3
  FROM sga_reconocimiento as r
  JOIN sga_reconocimiento_act as ra ON ra.nro_tramite = r.nro_tramite
 WHERE ra.homologada = 'S';

5 registros

Saludos,

Iris