|
|
|
FROSH PROFILE
This is a dimension table for Freshmen Profile for Number of Enrollees. It contains all the possible values for profile categories in ethnicity, gender, and full-time/part-time status.
| 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 |
| 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