|
|
|
IPEDS ENRL DISCP STATUS
This is a dimension table for IPEDS Fall Enrollment by Discipline (CIP). It contains the enrollment status information which include the selected CIP and discipline (e.g. Education, Engineering, Law), level of study (Undergraduate, Graduate, First Professional), attendance status (Full Time, Part Time), and Type of Student (First-time Freshmen, Graduate, First Professional, etc.)
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ATTENDANCE_STATUS | See ATTENDANCE_STATUS_CODE. This field contains the descriptive text for each of the attendance status code. | VARCHAR2 | 40 |
| ATTENDANCE_STATUS_CODE | Attendance status. Possible values are: 1=Full-time, 2=Part-time. | VARCHAR2 | 1 |
| DISCIPLINE_GROUP | Descriptive text for Discipline or CIP code: Eudcation, Engineering, Dentistry, Medicine, Law, Biological Sciences, Mathematics, Physical Sciences, and Business Management. | VARCHAR2 | 80 |
| DISCIPLINE_GROUP_CODE | Discipline or CIP code. Possible CIP values are: 130000 (Education), 140000 (Engineering), 510401 (Dentistry), 511201 (Medicine), 220101 (Law), 260000 (Biological Sciences), 270000 (Mathematics), 400000 (Physical Sciences), and 520000 (Business Management) | VARCHAR2 | 6 |
| 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 |
| LEVEL_OF_STUDY | See LEVEL_OF_STUDY_CODE. This field contains the descriptive text for the various level of study codes. | VARCHAR2 | 40 |
| LEVEL_OF_STUDY_CODE | Level of study. Possible values are: 1=Undergraduate, 2=First-Professional, 3=Graduate. | VARCHAR2 | 1 |
| TYPE_OF_STUDENT | See TYPE_OF_STUDENT_CODE. This field contains a brief description for the various type of student codes. | VARCHAR2 | 25 |
| TYPE_OF_STUDENT_CODE | The type of student counted. Possible values are: 1=Full-time, First-time Freshmen; 3=Full-time, all other undergraduates; 9=Full-time, First-professional; 11=Full-time, Graduate; 15=Part-time, First-time Freshmen; 17=Part-time, all other undergraduates; 23=Part-Time, First-Professional; 25=Part-Time, Graduates | VARCHAR2 | 2 |
| TYPE_OF_STUDENT_DESC | See TYPE_OF_STUDENT_CODE. This field contains a longer description for the various type of student codes. | VARCHAR2 | 80 |
| 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