Moduli migrazione Rubrica

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

UGOV PERSON_ROLE

SELECT a.id_ab AS id_ab, a.cd_ruolo AS cd_ruolo, a.cd_profilo AS cd_profilo, a.cd_tipo_ruolo AS cd_tipo_ruolo, a.id_ab_aff_org AS id_ab_aff_org, 
       a.area_ssd AS area_ssd, a.cd_sett_concors AS cd_sett_concors, a.cd_ssd AS cd_ssd, a.cd_inquadr AS cd_inquadr, a.ds_inquadr AS ds_inquadr, 
       a.fl_docente AS fl_docente, CONCAT(id_ab, cd_ruolo, cd_profilo) AS entity_id, CONCAT(cd_ruolo, '+', cd_profilo) AS role_profile, 
       CONCAT(cd_ruolo, '+', cd_inquadr) AS role_level, 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

UNIBS

Questi sono le organizational affiliation migrate su Unibs:

IUSS

Questi sono le organizational affiliation migrate su Iuss:

UGOV PLACE

SELECT a.id_ab AS id_ab, a.cd_sede AS cd_sede, a.cd_nodo AS cd_nodo, a.cd_csa AS cd_csa, a.fl_sede_principale AS fl_sede_principale, a.edificio AS edificio, a.quartiere AS quartiere, 
       a.indirizzo AS indirizzo, a.cap AS cap, a.ds_comune AS ds_comune, a.nome_breve_sede AS nome_breve_sede, a.nome_sede AS nome_sede, a.num_civico AS num_civico, 
       a.nome_esteso_uo AS nome_esteso_uo, a.cd_tipo_nodo AS cd_tipo_nodo, a.cd_macrotipo_nodo AS cd_macrotipo_nodo
FROM v_ie_ac_uo_sedi_attive a

UGOV ORGANIZATIONAL_UNIT

SELECT a.id_ab AS id_ab, a.nome_esteso AS nome_esteso, a.ds_mission AS ds_mission, a.cd_esterno AS cd_esterno, a.cd_csa AS cd_csa, a.cd_tipo_nodo AS cd_tipo_nodo, a.ds_tipo_nodo AS ds_tipo_nodo, 
       a.denominazione AS denominazione, a.cd_macrotipo_nodo AS cd_macrotipo_nodo
FROM v_ie_ac_uo_base_oggi a

Iuss

Questi sono i codici che vengono migrati per iuss pavia: ATE,ARE,DIP,SAC,CDT,CLA,CDL,DOT,CDR,CEN,SDS,UDS,CPR,LMG