OSP AWARD SPONSOR CONTACT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CONTACT_NAME |
XXX |
VARCHAR2 |
90 |
CONTACT_TYPE_CODE |
XXX |
VARCHAR2 |
12 |
CONTACT_TYPE_DESC |
XXX |
VARCHAR2 |
200 |
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_AWARD_NUMBER |
A unique 10 digit number assigned to an award by MIT (OSP). |
VARCHAR2 |
12 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
200 |
ROLODEX_ID |
XXX |
NUMBER |
|
SEQUENCE_NUMBER |
Numerical value identifying the position of this record for the person. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |