DAPER PE STUDENT Table
This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve PE student data from the Data Warehouse. The table contains records of students who are eligible to register in the current and the upcoming academic terms. The fields of e-mail address, term address, home address and Course information are not populated if the student has asked to have the information suppressed.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE_1 |
Identifies the primary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major. |
VARCHAR2 |
9 |
COURSE_1_DESC |
Descriptive text for COURSE_1 |
VARCHAR2 |
30 |
COURSE_2 |
Identifies the secondary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". |
VARCHAR2 |
9 |
COURSE_2_DESC |
Descriptive text for COURSE_2 |
VARCHAR2 |
30 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEGREE_AWARD_TERM |
The term code (eg. 2002SP, 2003SP) represents the academic term when the student was awarded a degree or is expected to receive a degree (for STUDENT DEGREE CANDIDATE). |
VARCHAR2 |
6 |
DEGREE_STATUS |
Description of degree status. |
VARCHAR2 |
2 |
DEGREE_STATUS_DESC |
Degree status codes: AW (Degree awarded), AP (Degree applicant), CN (Degree Candidate), XX (Degree awarded, but not verified). The status indicates whether the degree in the record is an awarded or expected degree from MIT. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_STREET_1 |
Line 1 of Street in home address |
VARCHAR2 |
30 |
HOME_STREET_2 |
Line 2 of Street in home address |
VARCHAR2 |
30 |
HOME_ZIP |
Zip code in home address. |
VARCHAR2 |
10 |
IS_ATTENDED |
"Y" indicates that the student attended at least some part of the current term. "N" indicates that the student never attended this term. In the FINAID AID APPLICANT and FINAID APPLICANT tables, "Y" indicates that the student has attended at least partially in any one of the three terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not attended in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_DEGREE_CANDIDATE |
A flag indicates whether the student is a degree candidate for the next degree award term. Y (Yes), N (No). |
VARCHAR2 |
1 |
IS_ELIGIBLE_TO_REG |
A flag indicates whether the student is eligible to register for the current academic year: Y (Yes), N (No) |
VARCHAR2 |
1 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_TRANSFER_STUDENT |
XXX |
VARCHAR2 |
1 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
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 |
PE_POINTS |
This field contains a numeric value of 0 to 8 which indicates the number of PE points the student has. |
NUMBER |
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_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 |
SWIM_TEST_COMPLETE_FLAG |
A value of "A" in this field indicates that the student has completed his/her swim test. Blank or an "I" shows that the swim test is not complte. "I" was entered when a swim test was initially marked as complete but later rescinded as an error. |
VARCHAR2 |
1 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
40 |
TERM_STATE |
The student's home state for the current term. |
VARCHAR2 |
2 |
TERM_STREET_1 |
Term address, street 1 |
VARCHAR2 |
30 |
TERM_STREET_2 |
Term address, street 2 |
VARCHAR2 |
30 |
TERM_STREET_3 |
Term address, street 3 |
VARCHAR2 |
30 |
TERM_ZIP |
The student's home zip code for the current term. |
VARCHAR2 |
9 |
UGRAD_ENTRANCE_TYPE |
Entrance types for undergraduate students: "E"=Student entered the MIT undergraduate program as a freshman, "T"=Student entered the MIT undergraduate program as a transfer student, "O"=Student who is a cross registered undergraduate or an entering special undergraduate. |
VARCHAR2 |
1 |
UGRAD_ENTRY_TERM |
The entrance term of a undergraduate student |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |