|
|
|
IPEDS ENROLMENT DISCP DETAIL
This is a fact table for IPEDS Fall Enrollment by Discipline (CIP). It contains the total number of students, grouped by gender and ethnicity, enrolled in an institution for a specified academic year by student level and attendance status (full time or part time) in various selected disciplines (or CIP codes). The disciplines include: Education, Engineering, Dentistry, Medicine, Law, Biological Sciences/Life Sciences, Mathematics, Physical Sciences, and Business Management.
| 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 |
| CIP_KEY | Use this field to join to another table with the same-name field (ie. CIP_KEY) for CIP information such as the CIP program code, category code, four-digit code, and the corresponding descriptions. | VARCHAR2 | 7 |
| 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_DISCP_STATUS_KEY | Use this field to join the IPEDS ENROLMENT DISCP DETAIL table with the IPEDS ENRL DISCP 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