select 'UFRPE' as sg_ies, 'UNIVERSIDADE FEDERAL RURAL DE PERNAMBUCO' as nm_ies, '587' as cd_emec_ies, v.nm_cpf_pess as nr_cpf, p.nm_pess as nm_pessoa, p.nm_sexo as sg_sexo, to_char(p.dt_nasc,'DD/MM/YYYY') as dt_nascimento, trunc((months_between(sysdate, p.dt_nasc))/12) as nr_idade, pf.cd_inep as cd_emec_curso, pf.nm_progr_form as nm_curso, t.nm_turno as nm_turno, case pf.tp_grad when '0' then 'BACHARELADO' when '1' then 'LICENCIATURA' end as nm_grau, ca.nm_campus as nm_campus, ci.nm_cidd as nm_cidade, ci.nm_sigl_uf as sg_estado, v.nu_ano_admis as nr_ano_ingresso, v.nu_semtr_admis as nr_semestre_ingresso, case when p.nm_email_secd is null then 'email_nao_informado' else p.nm_email_secd end as nm_email from siga_vinculo v, siga_pessoa p, siga_programa_formacao pf, siga_turno_vinculo tv, siga_turno t, siga_vinculo_perfil vp, siga_campus ca, siga_cidade ci, siga_perfil pe where v.nm_cpf_pess=p.nm_cpf_pess and v.cd_progr_form=pf.cd_progr_form and v.nu_matr_curso=tv.nu_matr_curso and v.nu_matr_curso=vp.nu_matr_curso and vp.cd_perf=pe.cd_perf and vp.tp_perf=pe.tp_perf and v.fl_vinc='1' and pf.cd_nivel in (1) -- Graduacao and tv.cd_turno=t.cd_turno and tv.cd_perd_letv=(select max(tv1.cd_perd_letv) from siga_turno_vinculo tv1 where tv1.nu_matr_curso=tv.nu_matr_curso) and vp.cd_perd_letv=(select max(vp1.cd_perd_letv) from siga_vinculo_perfil vp1 where vp1.nu_matr_curso=vp.nu_matr_curso) and pf.cd_progr_form not in (14,15,85) and pf.cd_campus=ca.cd_campus and ca.cd_cidd=ci.cd_cidd -- and v.nm_cpf_pess IN ('03732225488','02312302497') order by ca.NM_CAMPUS, pf.nm_progr_form, p.nm_pess