|
|
|
FROSH ENROLLEE DETAIL
This fact table contains the freshmen profile data for the number of enrollees by ethnicity, gender, and full-time vs. part-time status. For each academic year and institution, it contains the number of entering freshmen grouped by ethnicity (eg. White, African American, Asian, Hispanic, Nonresident Alien, Native American), Gender (Men, Women), and Status (Full-Time, Part-Time).
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| FRESHMEN_COUNT | Number of entering first-time freshmen | NUMBER | 6 |
| FRESHMEN_PERCENT | Percent of entering first-time freshmen for a profile category (eg. ethnicity, gender, status) based on the total number of entering first-time freshment. | NUMBER | 6.1 |
| FROSH_PROFILE_KEY | Use this field to join together the FROSH_PROFILE and the FROSH ENROLLEE DETAIL tables for freshmen profile data for number of enrollees by ethnicity, gender, or status. | VARCHAR2 | 11 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| 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