|
|
|
FROSH ENROLL RESIDENCY DETAIL
This fact table, similar to FROSH_ENROLLEE_DETAIL, contains the freshmen profile data for number of enrollees by ethnicity, gender, and full-time/part-time status. The records in this table, however, are further grouped by residency status (ie. resident vs. non resident). There is one record per academic year per institution per category (ethnicity, gender, and status) and residency.
| 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