Page History

UGOV - PERSON

Query del migrate
SELECT a.id_ab AS id_ab, a.cd_ruolo AS cd_ruolo, a.ds_ruolo AS ds_ruolo, a.cd_inquadr AS cd_inquadr, a.ds_inquadr AS ds_inquadr, 
       a.cd_aff_org AS cd_aff_org, a.id_ab_aff_org AS id_ab_aff_org, a.fl_tipo_rap AS fl_tipo_rap, a.matricola AS matricola, 
       a.id_contratto AS id_contratto, a.dt_rap_ini AS dt_rap_ini, a.sede AS sede, a.ds_sede AS ds_sede, a.cd_comparto AS cd_comparto, 
       a.ds_comparto AS ds_comparto, a.cd_tipo_ruolo AS cd_tipo_ruolo, a.ds_tipo_ruolo AS ds_tipo_ruolo, a.fl_docente AS fl_docente, 
       a.cd_sett_concors AS cd_sett_concors, CONCAT(cd_ruolo, '+', cd_profilo) AS role_profile, CONCAT(cd_ruolo, '+', cd_inquadr) AS role_level, 
       IF(a.cd_onorifico = '0000' or a.ds_onorifico = 'Non assegnato', NULL, a.ds_onorifico) AS ds_onorifico, IF(a.cd_onorifico = '0000' or a.pref_onor = 'Non assegnato', NULL, a.pref_onor) AS ds_onorifico_breve, 
       a.cod_fisc AS codice_fiscale, if(a.DS_AFF_ORG = 'Descrizione non valida', NULL, a.DS_AFF_ORG) AS ds_aff_org, if(a.CD_SSD = '000000000000', NULL, a.DS_SSD) AS ds_ssd, 
       if(a.CD_SSD = '000000000000', NULL, a.CD_SSD) AS cd_ssd, if(a.AREA_SSD = '00', NULL, a.DS_AREA_SSD) AS ds_area_ssd, if(a.AREA_SSD = '00', NULL, a.AREA_SSD) AS area_ssd
FROM v_ie_ru_pers_attivo a