...
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_PERSONITEM_SC_MAMV-anchor |
---|
| ODS_L2_ASN1820_PERSONITEM_SC_MAMV-anchor |
---|
|
...
...
Questa vista contiene le pubblicazioni di ogni persona che presente nella tabella precedente
...
come ODS_L2_ASN1820_PERSON_SC_MV, ma i dati recuperati sono quelli "master" . Le pubblicazioni sono calcolate dai dati "piu' validati". Sono presenti i FLAG per ogni indicatore: precisano se quella riga e' stato utilizzato (si-no) per il relativo calcolo.
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 |
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) | | |
DISCRIMINATORIDE_ISMN | NY | VARCHAR2(2554000) | | |
FIRSTIDE_NAMESCOPUS | Y | VARCHAR2(2554000) | | |
FKIS_ORG_UNIT_ACA_FIELDCLASS_A | Y | NUMBER | | |
IS_SCIENTIFICA | Y | NUMBER | | |
ITEM_ID | 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_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-anchor |
---|
| ODS_L2_ASN1820_PERSON_SC_MA-anchor |
---|
|
come ODS_L2_ASN1820_PERSON_SC_MV, ma i dati recuperati sono quelli "master"
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 | 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_10YCOUNT_ISBN | Y | NUMBER(10,0) | | |
SUM_CC_TOTAL_LAST_15YCOUNT_ISI | Y | NUMBER(10,0) | | |
THRESHOLD_AC_IND_1COUNT_ISMN | Y | NUMBER(10,0) | | |
THRESHOLD_AC_IND_2COUNT_ISSN | Y | NUMBER(10,0) | | |
THRESHOLD_AC_IND_3COUNT_ITEM | Y | NUMBER(10,0) | | |
THRESHOLD_CA_1_IND_1COUNT_SCOPUS | 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 |
...
(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 |
...
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) | | |
LAST_10Y_ARTICLES_AND_CON | Y | NUMBER(10,0) | | |
LAST_10Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | | |
LAST_10Y_BOOKCOUNT_ITEM | Y | NUMBER(10,0) | | |
COUNT_SCOPUSLAST_15Y_ARTICLES_CLASS_A | Y | NUMBER(10,0) | | |
DEPARTMENTLAST_15Y_BOOK | Y | VARCHAR2NUMBER(4000)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-anchor |
---|
| ODS_L2_ASN1820_PERSON_SC_MI-anchor |
---|
|
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_MV-anchor |
---|
| ODS_L2_ASN1820_PERSON_SC_MV-anchor |
---|
|
Questa vista contiene l'elenco delle persone, con relativo SC (SETTORE CONCORSUALE) e SSD (SETTORE SCIENTIFICO DISCIPLINARE), e tutti gli indici calcolati, nonche' i FLAG di superamento soglia. Tutti i dati sono calcolati a partire dai dati "piu' validati" delle pubblicazioni. La chiave primaria della vista e' composta da:
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) | | questa colonna permette di gestire simulazioni personalizzate dall'utente, ad es. con SC variato.Nel caso dell'elaborazione standard, quella in cui l'SC e' calcolato a partire da RM, il valore di questa riga e' "AUTO_2020".Nel caso dell'elaborazione standard, quella in cui l'SC e' calcolato a partire da RM, a partire dallanno precedente (2019) il valore di questa riga e' "AUTO_2019". Per le elaborazioni manuali il valore della colonna e' "MANUAL_2020" e "MANUAL_2019" | DISCRIMINATOR | N | VARCHAR2(255) |
FIRST_NAME | Y | VARCHAR2(255) | | |
FK_ORG_UNIT_ACA_FIELD | N | NUMBER(10,0) | | identificativo IRIS del settore concorsuale SC |
FK_ORG_UNIT_ACA_FIELD_2000 | N | NUMBER(10,0) | | identificativo IRIS del settore disciplinare SSD |
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) | | identificativo IRIS della persona |
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 | | |