FPR IR AWARD NEW Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_AGENCY |
The agency which confers the award. Eg. American Physical Society, American Academy of Arts and Letters, CIES (Council for International Exchange of Scholars), Department of Energy, Association for Computing Machinery, David and Lucile Packard Foundation, etc. |
VARCHAR2 |
150 |
AWARD_DISCIPLINE |
Discipline of this award. Eg. Art, Mathematics, Chemistry, Music, Physics, Biological Science, etc. |
VARCHAR2 |
200 |
AWARD_END_DATE |
The expiration/end date of the award. |
DATE |
|
AWARD_HONOR_DATA_SOURCE |
Source of award honor data. Eg.: awarding agency, self reported, MIT news site, department reported, etc. |
VARCHAR2 |
200 |
AWARD_HONOR_DATE_UPDATED |
Last update date of this award honor record. |
DATE |
|
AWARD_NAME_DETAIL |
Name of award -- more descriptive than AWARD_NAME. |
VARCHAR2 |
4000 |
AWARD_START_DATE |
The begin date of the award. |
DATE |
|
AWARD_TYPE |
Type of award (Example: Fellowship, Gift, Grant, Contract, Consortium Membership, Cooperative Agreement, etc.) |
VARCHAR2 |
60 |
AWARD_YEAR |
XXX |
VARCHAR2 |
10 |
COMPOSITE_ID |
XXX |
VARCHAR2 |
62 |
DEPARTMENT_TIME_OF_AWARD |
Department of the award recipient at the time he/she received the award |
VARCHAR2 |
120 |
INSTITUTION_TIME_OF_AWARD |
Institution of the award recipient at the time he/she received the award. |
VARCHAR2 |
120 |
JOINT_AWARD_INFO |
XXX |
VARCHAR2 |
200 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |