|
|
|
FACULTY AWARD DETAIL
This fact table contains the number of awards received by faculty members in an institution.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| FACULTY_AWARD_KEY | Use this field to join together the FACULTY AWARD and the FACULTY AWARD DETAIL tables. | VARCHAR2 | 20 |
| FACULTY_AWARD_YEAR_KEY | Use this field to join together the FACULTY AWARD YEAR and the FACULTY AWARD DETAIL tables. | VARCHAR2 | 9 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NUMBER_OF_AWARDS | Number of awards received by the faculty members. | NUMBER | 5 |
| 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