...
| Anchor | ||||
|---|---|---|---|---|
|
ODS_L2_ASN1820_ITEM_MA
| Nome Colonna | Annullabile | Tipo dato | Fonte | Comment |
| DATE_ISSUED_YEAR | Y | NUMBER(10,0) | ||
| DES_NUMBEROFAUTHORS_INT | Y | NUMBER(10,0) | ||
| DISCRIMINATOR | N | VARCHAR2(255) | ||
| FK_ORG_UNIT_ACA_FIELD | N | NUMBER(10,0) | ||
| FK_ORG_UNIT_ACA_FIELD_2000 | N | NUMBER(10,0) | ||
| FLAG_H_INDEX_10 | Y | NUMBER(1,0) | ||
| FLAG_H_INDEX_15 | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES_AND_CON | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES_CLASS_A | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_BOOK | Y | NUMBER(1,0) | ||
| FLAG_LAST_15Y_ARTICLES_CLASS_A | Y | NUMBER(1,0) | ||
| FLAG_LAST_15Y_BOOK | Y | NUMBER(1,0) | ||
| FLAG_LAST_5Y_ARTICLES | Y | NUMBER(1,0) | ||
| FLAG_LAST_5Y_ARTICLES_AND_CON | Y | NUMBER(1,0) | ||
| FLAG_SUM_CC_TOTAL_LAST_10Y | Y | NUMBER(1,0) | ||
| FLAG_SUM_CC_TOTAL_LAST_15Y | Y | NUMBER(1,0) | ||
| IDE_ISBN | Y | VARCHAR2(4000) | ||
| IDE_ISI | Y | VARCHAR2(4000) | ||
| IDE_ISMN | Y | VARCHAR2(4000) | ||
| IDE_SCOPUS | Y | VARCHAR2(4000) | ||
| IS_CLASS_A | Y | NUMBER | ||
| IS_SCIENTIFICA | Y | NUMBER | ||
| ITEM_ID | N | NUMBER(10,0) | ||
| LAST_MODIFIED | Y | TIMESTAMP(6)(,6) | ||
| MASTER_HANDLE | Y | VARCHAR2(256) | ||
| MASTER_ROW_CREATION_TS | Y | TIMESTAMP(6)(,6) | ||
| OWNING_COLLECTION_DES | Y | VARCHAR2(512) | ||
| REL_ISPARTOFJOURNAL_ISSN | Y | VARCHAR2(4000) | ||
| RM_PERSON_ID | N | NUMBER(10,0) | ||
| SCO_CC_TOTAL | Y | NUMBER(10,0) | ||
| SCO_DOC_TYPE | Y | VARCHAR2(17) | ||
| SCO_DOC_TYPE_ORIG | Y | VARCHAR2(255) | ||
| SCO_PUB_YEAR | Y | NUMBER(10,0) | ||
| TITLE | Y | VARCHAR2(4000) | ||
| TYPE_MIUR_DES | Y | VARCHAR2(4000) | ||
| TYPE_MIUR_ID | Y | NUMBER(10,0) | ||
| WOS_CC_TOTAL | Y | NUMBER(10,0) | ||
| WOS_DOC_TYPE | Y | VARCHAR2(255) | ||
| WOS_PUB_YEAR | Y | NUMBER(10,0) |
| Anchor | ||||
|---|---|---|---|---|
|
ODS_L2_ASN1820_ITEM_MI
| Nome Colonna | Annullabile | Tipo dato | Fonte | Comment |
| DATE_ISSUED_YEAR | Y | NUMBER(10,0) | ||
| DES_NUMBEROFAUTHORS_INT | Y | NUMBER(10,0) | ||
| DISCRIMINATOR | N | VARCHAR2(255) | ||
| FK_ORG_UNIT_ACA_FIELD | N | NUMBER(10,0) | ||
| FK_ORG_UNIT_ACA_FIELD_2000 | N | NUMBER(10,0) | ||
| FLAG_H_INDEX_10 | Y | NUMBER(1,0) | ||
| FLAG_H_INDEX_15 | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES_AND_CON | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_ARTICLES_CLASS_A | Y | NUMBER(1,0) | ||
| FLAG_LAST_10Y_BOOK | Y | NUMBER(1,0) | ||
| FLAG_LAST_15Y_ARTICLES_CLASS_A | Y | NUMBER(1,0) | ||
| FLAG_LAST_15Y_BOOK | Y | NUMBER(1,0) | ||
| FLAG_LAST_5Y_ARTICLES | Y | NUMBER(1,0) | ||
| FLAG_LAST_5Y_ARTICLES_AND_CON | Y | NUMBER(1,0) | ||
| FLAG_SUM_CC_TOTAL_LAST_10Y | Y | NUMBER(1,0) | ||
| FLAG_SUM_CC_TOTAL_LAST_15Y | Y | NUMBER(1,0) | ||
| IDE_ISBN | Y | VARCHAR2(4000) | ||
| IDE_ISI | Y | VARCHAR2(4000) | ||
| IDE_ISMN | Y | VARCHAR2(4000) | ||
| IDE_SCOPUS | Y | VARCHAR2(4000) | ||
| IS_CLASS_A | Y | NUMBER | ||
| IS_SCIENTIFICA | Y | NUMBER | ||
| ITEM_ID | N | NUMBER(10,0) | ||
| LAST_MODIFIED | Y | TIMESTAMP(6)(,6) | ||
| MASTER_HANDLE | Y | VARCHAR2(256) | ||
| MASTER_ROW_CREATION_TS | Y | TIMESTAMP(6)(,6) | ||
| OWNING_COLLECTION_DES | Y | VARCHAR2(512) | ||
| REL_ISPARTOFJOURNAL_ISSN | Y | VARCHAR2(4000) | ||
| RM_PERSON_ID | N | NUMBER(10,0) | ||
| SCO_CC_TOTAL | Y | NUMBER(10,0) | ||
| SCO_DOC_TYPE | Y | VARCHAR2(17) | ||
| SCO_DOC_TYPE_ORIG | Y | VARCHAR2(255) | ||
| SCO_PUB_YEAR | Y | NUMBER(10,0) | ||
| TITLE | Y | VARCHAR2(4000) | ||
| TYPE_MIUR_DES | Y | VARCHAR2(4000) | ||
| TYPE_MIUR_ID | Y | NUMBER(10,0) | ||
| WOS_CC_TOTAL | Y | NUMBER(10,0) | ||
| WOS_DOC_TYPE | Y | VARCHAR2(255) | ||
| WOS_PUB_YEAR | Y | NUMBER(10,0) |
| Anchor | ||||
|---|---|---|---|---|
|
ODS_L2_ASN1820_PERSON_SC_MA
| Nome Colonna | Annullabile | Tipo dato | Fonte | Comment |
| ACADEMIC_AREA | Y | VARCHAR2(4000) | ||
| AC_IND_1 | Y | NUMBER | ||
| AC_IND_2 | Y | NUMBER | ||
| AC_IND_3 | Y | NUMBER | ||
| AVG_NUMBEROFAUTHORS | Y | NUMBER | ||
| BIRTH_DATE | Y | TIMESTAMP(6)(,6) | ||
| CA_1_IND_1 | Y | NUMBER | ||
| CA_1_IND_2 | Y | NUMBER | ||
| CA_1_IND_3 | Y | NUMBER | ||
| CA_2_IND_1 | Y | NUMBER | ||
| CA_2_IND_2 | Y | NUMBER | ||
| CA_2_IND_3 | Y | NUMBER | ||
| CODICE_FISCALE | Y | VARCHAR2(4000) | ||
| COUNT_ISBN | Y | NUMBER(10,0) | ||
| COUNT_ISI | Y | NUMBER(10,0) | ||
| COUNT_ISMN | Y | NUMBER(10,0) | ||
| COUNT_ISSN | Y | NUMBER(10,0) | ||
| COUNT_ITEM | Y | NUMBER(10,0) | ||
| COUNT_SCOPUS | Y | NUMBER(10,0) | ||
| DEPARTMENT | Y | VARCHAR2(4000) | ||
| DISCRIMINATOR | N | VARCHAR2(255) | ||
| FIRST_NAME | Y | VARCHAR2(255) | ||
| FK_ORG_UNIT_ACA_FIELD | N | NUMBER(10,0) | ||
| FK_ORG_UNIT_ACA_FIELD_2000 | N | NUMBER(10,0) | ||
| FLAG_AC | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_CA_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_CA_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_OR | Y | NUMBER(1,0) | ||
| GRUPPO | Y | VARCHAR2(1) | ||
| H_INDEX_10 | Y | NUMBER | ||
| H_INDEX_15 | Y | NUMBER | ||
| IDENTIFICATION_NUMBER | Y | VARCHAR2(4000) | ||
| IS_BIBLIO | Y | NUMBER(1,0) | ||
| LAST_10Y_ARTICLES | Y | NUMBER(10,0) | ||
| LAST_10Y_ARTICLES_AND_CON | Y | NUMBER(10,0) | ||
| LAST_10Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | ||
| LAST_10Y_BOOK | Y | NUMBER(10,0) | ||
| LAST_15Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | ||
| LAST_15Y_BOOK | Y | NUMBER(10,0) | ||
| LAST_5Y_ARTICLES | Y | NUMBER(10,0) | ||
| LAST_5Y_ARTICLES_AND_CON | Y | NUMBER(10,0) | ||
| LAST_NAME | Y | VARCHAR2(255) | ||
| ORCID | Y | VARCHAR2(4000) | ||
| ORG_UNIT_ACA_FIELD | Y | VARCHAR2(4000) | ||
| ORG_UNIT_ACA_FIELD_2000 | Y | VARCHAR2(4000) | ||
| RESEARCHER_ID | Y | VARCHAR2(4000) | ||
| RES_TITLE | Y | VARCHAR2(4000) | ||
| RM_PERSON_ID | N | NUMBER(10,0) | ||
| ROLE_DES | Y | VARCHAR2(4000) | ||
| SCOPUS_ID | Y | VARCHAR2(4000) | ||
| SUM_CC_TOTAL_LAST_10Y | Y | NUMBER(10,0) | ||
| SUM_CC_TOTAL_LAST_15Y | Y | NUMBER(10,0) | ||
| THRESHOLD_AC_IND_1 | Y | NUMBER | ||
| THRESHOLD_AC_IND_2 | Y | NUMBER | ||
| THRESHOLD_AC_IND_3 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_1 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_2 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_3 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_1 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_2 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_3 | Y | NUMBER |
| Anchor | ||||
|---|---|---|---|---|
|
ODS_L2_ASN1820_PERSON_SC_MI
| Nome Colonna | Annullabile | Tipo dato | Fonte | Comment |
| ACADEMIC_AREA | Y | VARCHAR2(4000) | ||
| AC_IND_1 | Y | NUMBER | ||
| AC_IND_2 | Y | NUMBER | ||
| AC_IND_3 | Y | NUMBER | ||
| AVG_NUMBEROFAUTHORS | Y | NUMBER | ||
| BIRTH_DATE | Y | TIMESTAMP(6)(,6) | ||
| CA_1_IND_1 | Y | NUMBER | ||
| CA_1_IND_2 | Y | NUMBER | ||
| CA_1_IND_3 | Y | NUMBER | ||
| CA_2_IND_1 | Y | NUMBER | ||
| CA_2_IND_2 | Y | NUMBER | ||
| CA_2_IND_3 | Y | NUMBER | ||
| CODICE_FISCALE | Y | VARCHAR2(4000) | ||
| COUNT_ISBN | Y | NUMBER(10,0) | ||
| COUNT_ISI | Y | NUMBER(10,0) | ||
| COUNT_ISMN | Y | NUMBER(10,0) | ||
| COUNT_ISSN | Y | NUMBER(10,0) | ||
| COUNT_ITEM | Y | NUMBER(10,0) | ||
| COUNT_SCOPUS | Y | NUMBER(10,0) | ||
| DEPARTMENT | Y | VARCHAR2(4000) | ||
| DISCRIMINATOR | N | VARCHAR2(255) | ||
| FIRST_NAME | Y | VARCHAR2(255) | ||
| FK_ORG_UNIT_ACA_FIELD | N | NUMBER(10,0) | ||
| FK_ORG_UNIT_ACA_FIELD_2000 | N | NUMBER(10,0) | ||
| FLAG_AC | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_AC_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_CA_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_1_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_CA_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_1 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_2 | Y | NUMBER(1,0) | ||
| FLAG_CA_2_IND_3 | Y | NUMBER(1,0) | ||
| FLAG_OR | Y | NUMBER(1,0) | ||
| GRUPPO | Y | VARCHAR2(1) | ||
| H_INDEX_10 | Y | NUMBER | ||
| H_INDEX_15 | Y | NUMBER | ||
| IDENTIFICATION_NUMBER | Y | VARCHAR2(4000) | ||
| IS_BIBLIO | Y | NUMBER(1,0) | ||
| LAST_10Y_ARTICLES | Y | NUMBER(10,0) | ||
| LAST_10Y_ARTICLES_AND_CON | Y | NUMBER(10,0) | ||
| LAST_10Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | ||
| LAST_10Y_BOOK | Y | NUMBER(10,0) | ||
| LAST_15Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | ||
| LAST_15Y_BOOK | Y | NUMBER(10,0) | ||
| LAST_5Y_ARTICLES | Y | NUMBER(10,0) | ||
| LAST_5Y_ARTICLES_AND_CON | Y | NUMBER(10,0) | ||
| LAST_NAME | Y | VARCHAR2(255) | ||
| ORCID | Y | VARCHAR2(4000) | ||
| ORG_UNIT_ACA_FIELD | Y | VARCHAR2(4000) | ||
| ORG_UNIT_ACA_FIELD_2000 | Y | VARCHAR2(4000) | ||
| RESEARCHER_ID | Y | VARCHAR2(4000) | ||
| RES_TITLE | Y | VARCHAR2(4000) | ||
| RM_PERSON_ID | N | NUMBER(10,0) | ||
| ROLE_DES | Y | VARCHAR2(4000) | ||
| SCOPUS_ID | Y | VARCHAR2(4000) | ||
| SUM_CC_TOTAL_LAST_10Y | Y | NUMBER(10,0) | ||
| SUM_CC_TOTAL_LAST_15Y | Y | NUMBER(10,0) | ||
| THRESHOLD_AC_IND_1 | Y | NUMBER | ||
| THRESHOLD_AC_IND_2 | Y | NUMBER | ||
| THRESHOLD_AC_IND_3 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_1 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_2 | Y | NUMBER | ||
| THRESHOLD_CA_1_IND_3 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_1 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_2 | Y | NUMBER | ||
| THRESHOLD_CA_2_IND_3 | Y | NUMBER |