OSP AWARD PERSON Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
1 |
KEY_PERSON_PROJECT_ROLE |
XXX |
VARCHAR2 |
60 |
MIT_AWARD_KEY |
Key used to join tables with facts about OSP Awards. This field should be used only for joining data, NOT for reporting. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
PERSON_ROLE |
XXX |
VARCHAR2 |
10 |
PERSON_ROLE_CODE |
XXX |
VARCHAR2 |
12 |
ROLODEX_ID |
XXX |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |