...
| 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 | |
| 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
...