...
Le precendenti viste (ODS_L1_IR_ITEM_MASTER e ODS_L1_IR_ITEM_MOST_VALIDATED) non sono state alterate, quindi presentano gli stessi dati di sempre.
Con questo rilascio sono stati aggiunti in ODS_L1_RM_PERSON:
- KEYWORD_ATECO_CONCAT VARCHAR2(4000 CHAR)
- KEYWORD_ATECO_COUNT NUMBER(10,0)
- KEYWORD_ERC2013_CONCAT VARCHAR2(4000 CHAR)
- KEYWORD_ERC2013_COUNT NUMBER(10,0)
- KEYWORD_ERC2016_CONCAT VARCHAR2(4000 CHAR)
- KEYWORD_ERC2016_COUNT NUMBER(10,0)
- KEYWORD_ISICRUI_CONCAT VARCHAR2(4000 CHAR)
- KEYWORD_ISICRUI_COUNT NUMBER(10,0)
- KEYWORD_USER_DEFINED_CONCAT VARCHAR2(4000 CHAR)
- KEYWORD_USER_DEFINED_COUNT NUMBER(10,0)
Dalla versione 18.10.0.0 sono inoltre state rese disponibili su ODS le tabelle ODS_L1_RM_PERSON_TUTORSHIP e ODS_L1_RM_PERSON_ACTIVITIES.
La tabella ODS_L1_RM_PERSON_TUTORSHIP presenta come colonne:
- RM_PERSON_LINK_ID NUMBER(10,0), chiave primaria
- DISCRIMINATOR VARCHAR2(255),
- RM_PERSON_PARENT_ID NUMBER(10,0),
- RM_PERSON_PARENT_FIRST_NAME VARCHAR2(4000),
- RM_PERSON_PARENT_LAST_NAME VARCHAR2(4000),
- RM_PERSON_CHILD_ID NUMBER(10,0),
- RM_PERSON_CHILD_FIRST_NAME VARCHAR2(4000),
- RM_PERSON_CHILD_LAST_NAME VARCHAR2(4000),
- TUT_START_DATE TIMESTAMP(6), per startDate
- TUT_END_DATE TIMESTAMP(6), per endDate
- TUT_TYPE_ID NUMBER(10,0), per type
- TUT_TYPE_DES VARCHAR2(4000), per type
- TUT_NAME VARCHAR2(4000), per name
- TUT_DESCRIPTION VARCHAR2(4000), per description
- TUT_MANAGED_BY VARCHAR2(4000), per managedBy.
La tabella ODS_L1_RM_PERSON_ACTIVITIES ha colonne:
- RM_PERSON_ELEM_ID NUMBER(10,0), chiave primaria
- RM_PERSON_ID NUMBER(10,0),
- DISCRIMINATOR VARCHAR2(255),
- ACT_TYPE_ID NUMBER(10,0), per iaType, externalTutorshipType, incomingType, networkType
- ACT_TYPE_DES VARCHAR2(4000), per iaType, externalTutorshipType, incomingType, networkType
- ACT_START_DATE TIMESTAMP(6), per startDate
- ACT_END_DATE TIMESTAMP(6), per endDate
- ACT_YEAR NUMBER(10,0), per year
- ACT_CYCLE VARCHAR2(4000), per cycle
- ACT_DESCRIPTION VARCHAR2(4000), per description
- ACT_EXT_ORG_ID NUMBER(10,0), per miurExternalOrganization
- ACT_EXT_ORG_DES VARCHAR2(4000), per miurExternalOrganization
- ACT_EXT_ORG_TYPE_DES VARCHAR2(4000), per miurExternalOrganization
- ACT_INTERNATIONAL_RELEVANCE NUMBER(1,0), per internationalRelevance
- ACT_MANAGED_BY VARCHAR2(4000), per managedBy
- ACT_NAME VARCHAR2(4000), per name
- ACT_OTHER_INFO VARCHAR2(4000), per otherInfo
- ACT_PHD_COURSE_ID NUMBER(10,0), per phdCourse
- ACT_PHD_COURSE_DES VARCHAR2(4000), per phdCourse
- ACT_PROJECT_NAME VARCHAR2(4000), per projectName
- ACT_ROLE_TYPE_ID NUMBER(10,0), per rnpRoleType
- ACT_ROLE_TYPE_DES VARCHAR2(4000), per rnpRoleType
- ACT_TUTOREE VARCHAR2(4000), per tutoree - stringa
- ACT_TUTOREE_ID NUMBER(10,0), per tutoree - person
- ACT_TUTOREE_FIRST_NAME VARCHAR(4000), per tutoree - person
- ACT_TUTOREE_LAST_NAME VARCHAR(4000), per tutoree - person
- ACT_URL VARCHAR2(4000), per url
- ACT_AP_ITEM_SOURCE_ID NUMBER(10,0), per apItemSourceId
- ACT_AP_ITEM_SOURCE_IDE VARCHAR2(4000), per apItemSourceIdentifier.
Reportistica&Analisi
Nella tendina "tipologia di metadati da estrarre" è ora possibile scegliere:
...