IR AWARD HONOR DETAIL Table
Honors bestowed.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_HONOR_COUNT |
The field always contain a value of 1 (one). It's used to sum up the number of Honor records. |
NUMBER |
22 |
AWARD_HONOR_DATA_SOURCE |
Source of award honor data. Eg.: awarding agency, self reported, MIT news site, department reported, etc. |
VARCHAR2 |
200 |
AWARD_WEBPAGE_URL |
The URL for the website about the award. |
VARCHAR2 |
200 |
DATE_UPDATED |
Last update date of the record. |
DATE |
8 |
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 |
IR_AWARD_DISCIPLINE_KEY |
XXX |
VARCHAR2 |
30 |
IR_AWARD_KEY |
Use this field to join together the IR_AWARD and IR_AWARD_HONOR_DETAIL tables. |
VARCHAR2 |
30 |
IR_AWARD_PERSON_KEY |
Use this field to join together tables IR_AWARD_HONOR_DETAIL and IR_AWARD_PERSON. |
VARCHAR2 |
20 |
JOINT_AWARD_INFO |
XXX |
VARCHAR2 |
200 |
POSITION_STATUS_TIME_OF_AWARD |
Position or employment status of the award recepient at the time he/she received the award |
VARCHAR2 |
120 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
YEAR_AWARDED |
The year(s) the award/honor was bestowed or represents. |
VARCHAR2 |
10 |