|
|
|
FACULTY AWARD YEAR
This is a dimension table that contains the award year information to be used in the Faculty Awards data model.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AWARD_YEAR | The year in which the award was received. | VARCHAR2 | 9 |
| FACULTY_AWARD_YEAR_KEY | Use this field to join together the FACULTY AWARD YEAR and the FACULTY AWARD DETAIL tables. | VARCHAR2 | 9 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home