|
|
|
FACULTY DEMOGRAPHIC
This is a dimension table for Faculty Profile by CIP. It contains the demographic (gender and race/ethnicity) information.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ETHNICITY | Race/Ethnicity | VARCHAR2 | 60 |
| ETHNICITY_CODE | Race/Ethnicity code: 1=Nonresident alien, 2=Black, non-Hispanic, 3=American Indian or Alaskan Native, 4=Asian or Pacific Islander, 5=Hispanic, 6=White, non-Hispanic, 7=Unknown. | VARCHAR2 | 1 |
| FACULTY_DEMOGRAPHIC_KEY | Use this field to join together the FACULTY_DEMOGRAPHIC and the FACULTY_PROFILE_DETAIL tables for faculty profile and headcount information by gender and ethnicity. | VARCHAR2 | 2 |
| GENDER | Gender | VARCHAR2 | 12 |
| GENDER_CODE | Gender code: 1=Male, 2=Female | VARCHAR2 | 1 |
| 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