|
|
|
IPEDS ENRL TOTAL STATUS
This is a dimension table for the Summary of IPEDS Fall Enrollment. It contains all the possible values for the level of study (Undergraduate, Graduate, First Professional), attendance status (Full-Time, Part-Time), 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 |
| 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 |
| 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