DAPER ELIG ENROLLMENT Table
This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve student term enrollment data for Athletic Eligibility Requirements. There is one record per student per term (including prior, current, and future terms in which the student has an enrollment profile). The STUDENT YEAR field is not populated if the student has asked to have the information suppressed.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATTENDED |
A flag indicating the student actually attended for any time during the current term. Values are Y or N. NOTE: This includes students who started the term and subsequently withdrew or completed their thesis early and are now gone. Use this field instead of the REGISTERED flag if you want to include these types of students. |
VARCHAR2 |
1 |
ELIGIBLE_TO_REGISTER |
"Y"=the student is eligible to register for the academic term. "N"=No, the student is not eligible to register for the term. |
VARCHAR2 |
1 |
FINAL_TERM_SENIOR |
Y/N -- whether the student is a senior in his/her final academic term. |
VARCHAR2 |
1 |
IS_CURRENT_ACADEMIC_TERM |
A flag indicates whether the academic term is the current academic term: Y/N. |
VARCHAR2 |
1 |
LOAD_LEVEL |
The course load of the student in the registered term. Values: Full Time, Half Time, 3/4 Time, Early Thesis, No Load, Cross-registered, Less Than Half Time, Full Time Senior. |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
REGISTERED |
A flag indicating the student is curently registered in the term. Values include Y or N. NOTE: A student who left (withdrew or finished early due to early thesis) will have an N in this field because he/she is not CURRENTLY registered-even though he/she had been registered. See ATTENDED for a better way to identify these kinds of students. |
VARCHAR2 |
1 |
REGISTRATION_TYPE |
Describes how the student has registered. Cross Registered - a student that is taking courses at MIT but whose primary affiliation is with another university. Special - A student who has registered for one or more courses but is not enrolled in a degree program. Regular - A student who is enrolled in a degree program. Non-resident - A doctoral student who is not living or working on campus. This type of student has complete all requirements other than the thesis. |
VARCHAR2 |
18 |
STUDENT_ELIGIBILITY_TYPE |
Athletic Eligibility: "Athlete" or "Crew" |
VARCHAR2 |
8 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
TERM_UNITS_COMPLETED |
Number of units completed for the academic term. |
NUMBER |
4 |
UNITS_OF_LOAD |
Total of the subject units that the student is registered for this term. Includes subjects registered for as a listener. |
NUMBER |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |