|
|
|
FROSH YIELD RESIDENCY DETAIL
This is the version of the freshmen profile yield rate table with records grouped by residency status (ie. resident vs. non resident). There is one record per academic year per institutio per residency status.
| 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 |
| APPLICATION_YIELD_PCNT | Yield (%) of application = (Number of Admits / Number of Applications ) * 100 | NUMBER | 6.1 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| MATRICULATION_YIELD_PCNT | Matriculation rate = (Number of Enrolled Students / Number of Admits) * 100 | NUMBER | 6.1 |
| NUM_OF_ADMITS | Number of first-time freshmen who applied admitted to the institution. | NUMBER | 5 |
| NUM_OF_APPLICATIONS | Number of first-time freshmen who applied for admissions to the institution. | NUMBER | 5 |
| NUM_OF_ENROLLED | Number of admitted first-time freshmen who enrolled at the institution. | NUMBER | 5 |
| 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