|
|
|
FACULTY AWARD
This is a dimension table that contains the awards and some of their characteristics that a faculty member in an institution recieved.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| FACULTY_AWARD_CODE | Award Code. Eg. NAS, MacArthur, Guggenheim, Sloan. | VARCHAR2 | 20 |
| FACULTY_AWARD_DESCRIPTION | Description of the award. | VARCHAR2 | 2000 |
| FACULTY_AWARD_KEY | Use this field to join together the FACULTY AWARD and the FACULTY AWARD DETAIL tables. | VARCHAR2 | 20 |
| FACULTY_AWARD_NAME | Name of the award. Eg. "National Academy of Sciences Members", "MacArthur Foundation Fellows", "Guggenheim Fellows", "Sloan Research Fellows". | VARCHAR2 | 100 |
| FACULTY_AWARD_NOTE | The data in this field explains whether the year recorded in the dataset is a calendar year or an academic year. | VARCHAR2 | 250 |
| FACULTY_AWARD_ORGANIZATION | The organization of the award. | VARCHAR2 | 100 |
| FACULTY_AWARD_RANGE | This field contains a value that indicates the years of data available for the award. Eg. "1999-2003" for "Sloan Research Fellows". | VARCHAR2 | 20 |
| FACULTY_AWARD_WEBSITE | The web site of the award organization. | VARCHAR2 | 100 |
| 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