EPR AWARD HONOR Table
Stores employee award and honor records, including award names, effective dates, and source information, used for recognition reporting and academic/professional achievement analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AWARD_END_DATE |
End date on which the award or honor concluded, if applicable. |
DATE |
|
AWARD_NAME |
Name or title of the award or honor received by the individual. |
VARCHAR2 |
500 |
AWARD_START_DATE |
Start date on which the award or honor became effective, if applicable. |
DATE |
|
AWARD_YEAR |
Calendar or academic year in which the award or honor was granted. |
VARCHAR2 |
4 |
DATA_SOURCE |
Code identifying the originating system or data source for the award information. |
VARCHAR2 |
3 |
MIT_ID |
MIT ID number of the individual receiving the award or honor. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
SOURCE_LAST_UPDATE_DATE |
Date the award record was last updated in the source system. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |