|
|
|
IPEDS ENROLMENT TOTAL DETAIL
This is a fact table for the Summary of IPEDS Fall Enrollment. It contains the total number of students separated by gender and ethnicity enrolled in an institution for a specified academic year by student level and attendance status (full time or part time).
| 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 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| IPEDS_DEMOGRAPHIC_KEY | Use this field to join to another IPEDS table with the same-name field. | VARCHAR2 | 12 |
| IPEDS_ENRL_TOTAL_STATUS_KEY | Use this field to join the IPEDS ENROLMENT TOTAL DETAIL table with the IPEDS ENRL TOTAL STATUS table. Do not use this field for reporting. | VARCHAR2 | 10 |
| NUMBER_OF_STUDENTS | Number of students | NUMBER | 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