UGOV - PERSONQuery 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 |