select distinct p.nm_pess, p.nm_cpf_pess,sv.NU_MATR_CURSO, pf.NM_PROGR_FORM, sta.DS_TP_SIT_ACAD, sa.CD_PERD_LETV as periodo_letivo from siga_programa_formacao pf, siga_vinculo sv, siga_pessoa p, SIGA_SITUACAO_ACADEMICA sa, SIGA_TIPO_SITUACAO_ACADEMICA sta where sv.CD_PROGR_FORM = pf.CD_PROGR_FORM and sv.NU_MATR_CURSO = sa.NU_MATR_CURSO and sa.CD_TP_SIT_ACAD = sta.CD_TP_SIT_ACAD and pf.CD_NIVEL = 1 and sv.CD_MODAL = 1 and p.NM_CPF_PESS = sv.NM_CPF_PESS and sa.CD_PERD_LETV > '2016.2' and sv.NU_MATR_CURSO not in (select vpe.nu_matr_curso from SIGA_VINCULO_POLO_EAD vpe) order by p.nm_pess;