ORCID TO MITID Table
View exposing mappings between ORCID identifiers and MIT identifiers including MIT ID status and warehouse load attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
MITID_STATUS |
Mitid status associated with the record. |
VARCHAR2 |
1 |
MITID_STATUS_DESC |
Description of mitid status. |
VARCHAR2 |
9 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
ORCID |
Orcid associated with the record. |
VARCHAR2 |
112 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |