Entonces la diferencia la da en las actividades extracurriculares que se informan en sga_reconocimiento y sga_reconocimiento_act
Fijate si esta consulta devuelve registros. Si devuelve son las actividades extracurriculares que no se pasaron a G3.
-- Guarani 2
SELECT
mig.sga_activ_alumno.resol_actividades,
mig.sga_activ_alumno.unidad_academica,
mig.sga_activ_alumno.carrera,
mig.sga_activ_alumno.legajo,
mig.sga_activ_alumno.actividad,
mig.sga_activ_alumno.fecha
FROM mig.sga_resol_activ
JOIN mig.sga_activ_resol ON mig.sga_activ_resol.unidad_academica = mig.sga_resol_activ.unidad_academica AND
mig.sga_activ_resol.resol_actividades = mig.sga_resol_activ.resol_actividades
JOIN mig.sga_activ_alumno ON mig.sga_activ_alumno.unidad_academica = mig.sga_activ_resol.unidad_academica AND
mig.sga_activ_alumno.resol_actividades = mig.sga_activ_resol.resol_actividades AND
mig.sga_activ_alumno.area = mig.sga_activ_resol.area AND
mig.sga_activ_alumno.actividad = mig.sga_activ_resol.actividad AND
mig.sga_activ_alumno.fecha = mig.sga_activ_resol.fecha
JOIN mig.sga_alumnos_resol ON mig.sga_alumnos_resol.unidad_academica = mig.sga_activ_alumno.unidad_academica AND
mig.sga_alumnos_resol.resol_actividades = mig.sga_activ_alumno.resol_actividades AND
mig.sga_alumnos_resol.carrera = mig.sga_activ_alumno.carrera AND
mig.sga_alumnos_resol.legajo = mig.sga_activ_alumno.legajo
EXCEPT
-- Guarani 3
SELECT m_r.resol_actividades,
alu.unidad_academica, alu.carrera, alu.legajo, e.codigo as materia, r.fecha
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento
JOIN mig._cnv_pk_reconocimiento as m_r ON m_r.nro_tramite = m_r.nro_tramite
Y corre esta otra sin recuperar el dato resol_actividades:
-- Guarani 2
SELECT
mig.sga_activ_alumno.unidad_academica,
mig.sga_activ_alumno.carrera,
mig.sga_activ_alumno.legajo,
mig.sga_activ_alumno.actividad,
mig.sga_activ_alumno.fecha
FROM mig.sga_resol_activ
JOIN mig.sga_activ_resol ON mig.sga_activ_resol.unidad_academica = mig.sga_resol_activ.unidad_academica AND
mig.sga_activ_resol.resol_actividades = mig.sga_resol_activ.resol_actividades
JOIN mig.sga_activ_alumno ON mig.sga_activ_alumno.unidad_academica = mig.sga_activ_resol.unidad_academica AND
mig.sga_activ_alumno.resol_actividades = mig.sga_activ_resol.resol_actividades AND
mig.sga_activ_alumno.area = mig.sga_activ_resol.area AND
mig.sga_activ_alumno.actividad = mig.sga_activ_resol.actividad AND
mig.sga_activ_alumno.fecha = mig.sga_activ_resol.fecha
JOIN mig.sga_alumnos_resol ON mig.sga_alumnos_resol.unidad_academica = mig.sga_activ_alumno.unidad_academica AND
mig.sga_alumnos_resol.resol_actividades = mig.sga_activ_alumno.resol_actividades AND
mig.sga_alumnos_resol.carrera = mig.sga_activ_alumno.carrera AND
mig.sga_alumnos_resol.legajo = mig.sga_activ_alumno.legajo
EXCEPT
-- Guarani 3
SELECT alu.unidad_academica, alu.carrera, alu.legajo, e.codigo as materia, r.fecha
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento
¿Que valores retornan las siguientes consultas?
1)
SELECT filas FROM mig._tablas_g3 where tabla = 'sga_reconocimiento_act';
2)
SELECT count(*)
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento
JOIN mig._cnv_pk_reconocimiento as m_r ON m_r.nro_tramite = m_r.nro_tramite
2) SELECT count(*)
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento
JOIN mig._cnv_pk_reconocimiento as m_r ON m_r.nro_tramite = m_r.nro_tramite
WHERE m_r.origen = 'EXTRACURRICULAR';
4)
SELECT count(*)
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento
JOIN mig._cnv_pk_reconocimiento as m_r ON m_r.nro_tramite = m_r.nro_tramite
WHERE r_act.homologada = 'N';
5)
SELECT count(*)
FROM sga_reconocimiento as r
JOIN mig._cnv_pk_alumnos as alu ON alu.alumno = r.alumno
JOIN sga_reconocimiento_act as r_act on r_act.nro_tramite = r.nro_tramite
JOIN mig._cnv_pk_elementos as e ON e.elemento = r_act.elemento;