|
|
|
FROSH PROFILE RESIDENCY
This is a dimension table for Freshmen Profile for Number of Enrollees by Residencty. It contains all the possible values in the categories of residency (resident vs. non resident), ethnicity, gender, and status (full-time vs. part-time).
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| 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 |
| PROFILE_CATEGORY | It contains the three categories in freshmen profiling: Ethnicity, Gender, and Full vs. Part Time Status. | VARCHAR2 | 10 |
| PROFILE_TYPE | The different values in each of the profile category (ie. Ethnicity, Gender, and Status) in Freshmen Profile. For example, the valid profile types in the Ethnicity category are: Nonresident Alien, Asian, African American, Hispanic, Native American, White, Unknown; the profile types for Gender are: Men, Women; and the profile types for Status are: Full-Time, Part-Time. | VARCHAR2 | 30 |
| RESIDENCY | Residency status (ie., tuition billing status): Resident - legal residency used for tuition purposes, anyone whose tuition residency is in your home state. Non-resident - anyone whose tuition residency is NOT in your home state. | VARCHAR2 | 12 |
| 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