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

Nome ad uso interno	Descrizione	Campo presente in PERSON
id_ab	ID	Si (Management software ID)
cd_ruolo	CD Role
ds_ruolo	DS Role	Si (Main role)
cd_inquadr	CD Framing	Si (Level)
ds_inquadr	DS Framing	Si (Framing)
cd_aff_org	CD Role
id_ab_aff_org	ID Organizational affiliation
fl_tipo_rap	fl_tipo_rap
matricola	Matricola	Si
id_contratto	id_contratto
dt_rap_ini	dt_rap_ini
sede	Sede principale	Si
ds_sede	DS Headquarter
cd_comparto	cd_comparto
ds_comparto	ds_comparto
cd_tipo_ruolo	CD Role type	Si (Role type)
ds_tipo_ruolo	DS Role type
fl_docente	Professor
ds_onorifico	Honorary title	Si
cd_ssd	SSD code
area_ssd	Area Sector code
cd_sett_concors	Competition sector code
role_profile	Role \| Profile
role_level	Role \| Level
cognome	Cognome	Si
nome	Name	Si
nome_esteso	Extended name
email	Email	Si
fax	Fax	Si
pec	Email certificata (PEC)	Si
tcu	Cellulare	Si
tfu	Telefono	Si
url	Personal Website Url	Si (Sito web personale)
urlcv	CV Url
id_esse3	Esse3 Id	Si

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

Nome ad uso interno	Descrizione
id_ab	ID
cd_ruolo	CD Role
cd_profilo	CD Profile
cd_tipo_ruolo	CD Role type
id_ab_aff_org	ID Organizational affiliation
area_ssd	Area Sector code
cd_sett_concors	Competition sector code
cd_ssd	SSD code
cd_inquadr	CD Framing
ds_inquadr	DS Framing
fl_docente	Professor
role_profile	Role \| Profile
role_level	Role \| Level
nome_esteso	Extended name
role_id	The role id
profile_id	The profile id

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

Nome ad uso interno	Descrizione	Campo presente in Place
id_ab	ID
cd_sede	Headquarter ID
cd_nodo	Node code
cd_csa	CSA Code
fl_sede_principale	Main headquarter
edificio	Building	Si
quartiere	Neighborhood
indirizzo	Address
cap	Zip code
ds_comune	City ID
nome_breve_sede	Headquarter short name
nome_sede	Headquarter name
num_civico	House number
nome_esteso_uo	OU extended name
cd_tipo_nodo	Tipo di contenuto
cd_macrotipo_nodo	Node macrotype
id	ID
management_software_id	Management Software ID	Si
management_software_id_src	Management Software ID source	Si (Source Management Software ID)
name	Name
address	Address	Si
house_number	House number	Si
province	Province	Si
city	City	Si
photo	Foto	Si
postal_code	Postal code	Si
building	Building
floor	Floor	Si
office	Office	Si
is_main	Is main	Si
organizational_unit	Organizational unit	Si
place_type	Place type	Si
place_macrotype	Place macrotype	Si

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

Nome ad uso interno	Descrizione	Campo presente in Organizational Unit
id_ab	ID
nome_esteso	Extended name
cd_esterno	External ID
cd_csa	CSA code
cd_tipo_nodo	Node type code
ds_tipo_nodo	Node type description
denominazione	Name
cd_macrotipo_nodo	Node macrotype code
management_software_id	Management Software ID	Si
management_software_id_2	Management Software ID - 2	Si (Other management software ID)
name	Name
mission	Mission	Si
structure_type	Structure type	Si
macrostructure_type	Macrostructure type	Si
email	Email	Si
fax	Fax	Si
certified_email	Email certificata (PEC)	Si
mobile_phone	Cellulare	Si
office_phone	Telefono	Si
website_link	Personal Website Url	Si (Link al sito web)
parent	Parent Organizational Unit
headquarter	Sede principale	Si
other_headquarters	Other Headquarters	Si

Page tree

Moduli migrazione Rubrica

UGOV - PERSON

UGOV PERSON_ROLE

UGOV PLACE

UGOV ORGANIZATIONAL_UNIT