FPR IR AWARD NEW Table
View exposing faculty award records from institutional research sources used in Faculty Professional Record reporting and review.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_AGENCY |
Award agency associated with the record. |
VARCHAR2 |
150 |
AWARD_DISCIPLINE |
Award discipline associated with the record. |
VARCHAR2 |
200 |
AWARD_END_DATE |
Date associated with award end. |
DATE |
|
AWARD_HONOR_DATA_SOURCE |
Award honor data source associated with the record. |
VARCHAR2 |
200 |
AWARD_HONOR_DATE_UPDATED |
Award honor date updated associated with the record. |
DATE |
|
AWARD_NAME_DETAIL |
Award name detail associated with the record. |
VARCHAR2 |
4000 |
AWARD_START_DATE |
Date associated with award start. |
DATE |
|
AWARD_TYPE |
Award type associated with the record. |
VARCHAR2 |
60 |
AWARD_YEAR |
Award year associated with the record. |
VARCHAR2 |
10 |
COMPOSITE_ID |
Business identifier for the composite. |
VARCHAR2 |
62 |
DEPARTMENT_TIME_OF_AWARD |
Department time of award associated with the record. |
VARCHAR2 |
120 |
INSTITUTION_TIME_OF_AWARD |
Institution time of award associated with the record. |
VARCHAR2 |
120 |
JOINT_AWARD_INFO |
Joint award info associated with the record. |
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 |
Date the record was loaded into the data warehouse. |
DATE |