DAPER ELIG STUDENT Table
This table is created specifically for use by the Department of Athletics, Physical Eudcation, Recreation (DAPER) to retrieve student data from the Data Warehouse to monitor the athletic eligibililty of student athletes. There is one record per student in the table. Data items include student biographic information, term and home addresses, previous college name, cumulative GPA, registration information for all athletes; and course(s) of major and degree requirements for Crew members. Students who have asked to have their email address, term and home addresses, or course information suppressed, the corresponding fields of their records are not populated.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CITIZENSHIP_STATUS |
Citizenship status of the applicant. Possible values are: International, Permanent Resident, US Citizen, Unknown. |
VARCHAR2 |
30 |
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 |
CUMULATIVE_GPA |
Cumulative GPA |
NUMBER |
3.1 |
CURRENT_ACADEMIC_TERM |
Term code (eg. 2002FA, 2004SP) of the current academic term. |
VARCHAR2 |
6 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEGREE_DESIGNATION_TERM |
The academic term when the first major of the student was declared. |
VARCHAR2 |
6 |
ELIGIBLE_TO_REG_NEXT_TERM |
"Y"=the student is eligible to register for the upcoming term. "N"=the student is not eligible to register for the upcoming term. |
VARCHAR2 |
1 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ETHNICITY |
Ethnicity |
VARCHAR2 |
40 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GIR_SUBJECT_COMPLETED |
Number of GIR (General Institute Requirements) subjects completed. |
NUMBER |
3.1 |
GIR_SUBJECT_REQUIRED |
Number of GIR (General Institute Requirements) subjects required. |
NUMBER |
3.1 |
HOME_ADDRESS_1 |
Home address line 1. |
VARCHAR2 |
30 |
HOME_ADDRESS_2 |
Home address line 2. |
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_ZIP |
Zip code in home address. |
VARCHAR2 |
10 |
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 |
PERCENT_GIR_COMPLETED |
Percent GIR (General Institute Requirements) completed. |
NUMBER |
3.2 |
PREVIOUS_COLLEGE_NAME |
The name of the previous college/university the student attended. Usually, this is applicable to transfer undergraduate students only. |
VARCHAR2 |
60 |
REGISTERED_PREVIOUS_TERM |
A flag indicates whether the student was registered during the previous "regular" term. Regular terms are Fall and Spring terms. |
VARCHAR2 |
1 |
STUDENT_ELIGIBILITY_TYPE |
Athletic Eligibility: "Athlete" or "Crew" |
VARCHAR2 |
8 |
TERMS_AT_MIT |
Number of Fall and Spring terms where Load Level is Full Time, including the current term. |
NUMBER |
2 |
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 |
UNITS_BEYOND_GIR_COMPLETED |
Number of units beyond GIR (General Institute Requirements) completed. |
NUMBER |
3.1 |
UNITS_BEYOND_GIR_REQUIRED |
Number of units beyond GIR (General Institute Requirements) required. |
NUMBER |
3.1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
YEARS_RECEIVED_FIN_AID |
The number os years a student athlete has received financial aid, including the current term. |
NUMBER |
3 |