|
|
|
FROSH YIELD DETAIL
This is a fact table contains the data for freshmen profile yield rates. There is one record for an insitution in an academic year. Each record contains yield rate information which includes the number of applications, number of admits, number of enrolled, application yield percent, and matriculation yield percent.
| 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 |
| 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