EPR PUBLICATION Table
View exposing publication records associated with Employee Professional Record data used for scholarly and professional activity reporting and review.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATA_SOURCE |
Data source associated with the record. |
VARCHAR2 |
18 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PUBLICATION_DATE |
Date associated with publication. |
DATE |
|
PUBLICATION_NAME |
Publication name associated with the record. |
VARCHAR2 |
32767 |
PUBLICATION_STATUS |
Publication status associated with the record. |
VARCHAR2 |
50 |
PUBLICATION_TYPE |
Publication type associated with the record. |
VARCHAR2 |
50 |
PUBLICATION_URL |
Publication url associated with the record. |
VARCHAR2 |
1000 |
PUBLICATION_YEAR |
Publication year associated with the record. |
VARCHAR2 |
4 |
SOURCE_LAST_UPDATE_DATE |
Date associated with source last update. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |