STUDENT ACADEMIC Table
This table contains student's academic information such as GPA, required & completed GIR units, swim test. There is one record per student.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
ADVISOR_FULL_NAME_1 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_1) to the student. |
VARCHAR2 |
90 |
ADVISOR_FULL_NAME_2 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_2) to the student. |
VARCHAR2 |
90 |
ADVISOR_FULL_NAME_3 |
Full name of the advisor (corresponding to ADVISOR_MIT_ID_3) to the student. |
VARCHAR2 |
90 |
ALT_ADVISOR_FULL_NAME_1 |
XXX |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_2 |
XXX |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_3 |
XXX |
VARCHAR2 |
76 |
COMPLETED_UNITS_GRAD |
Number of completed units, graduate. |
NUMBER |
4 |
COMPLETED_UNITS_UGRAD |
Number of completed units, undergraduate. |
NUMBER |
4 |
COURSE |
The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term. |
VARCHAR2 |
9 |
CUMULATIVE_GPA |
Cumulative GPA |
NUMBER |
3.1 |
CUMULATIVE_GPA_GRAD |
Cumulative GPA, graduate. |
NUMBER |
2.1 |
CUMULATIVE_GPA_UGRAD |
Cumulative GPA, undergraduate. |
NUMBER |
2.1 |
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
DEGREE_AWARDED_1 |
XXX |
VARCHAR2 |
16 |
DEGREE_AWARDED_2 |
XXX |
VARCHAR2 |
16 |
DEGREE_AWARDED_3 |
XXX |
VARCHAR2 |
16 |
DEGREE_AWARDED_4 |
XXX |
VARCHAR2 |
16 |
DEGREE_AWARDED_5 |
XXX |
VARCHAR2 |
16 |
DEGREE_AWARD_DATE_1 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_2 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_3 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_4 |
The date when the degree was awarded. |
DATE |
8 |
DEGREE_AWARD_DATE_5 |
The date when the degree was awarded. |
DATE |
8 |
EARLY_SOPHOMORE_TERM_CODE |
XXX |
VARCHAR2 |
6 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
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 |
GRAD_ENTRANCE_TYPE_DESC |
Descriptive text for GRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
GRAD_ENTRY_TERM |
The entrance term of a graudate student |
VARCHAR2 |
6 |
HAS_INCOMPLETE_GRADE |
XXX |
VARCHAR2 |
1 |
HAS_MISSING_GRADE |
XXX |
VARCHAR2 |
1 |
HAS_OPEN_GRADE |
XXX |
VARCHAR2 |
1 |
HAS_OX_ABSENCE_EXCUSED_GRADE |
XXX |
VARCHAR2 |
1 |
HOME_DEPARTMENT |
The home (major) department of a person. |
VARCHAR2 |
4 |
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_ATTENDED_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her attended information kept confidential. |
VARCHAR2 |
1 |
IS_COURSE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her course of major kept confidential. |
VARCHAR2 |
5 |
IS_CURRENT_STUDENT |
A flag indicating whether this person in the STUDENT table is considered a current student for the current academic term. |
VARCHAR2 |
1 |
IS_EARLY_SOPHOMORE |
XXX |
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_SERIOUS_CONFIDENTIAL |
A "Y" in this field indicates that the student wants his/her record kept confidential |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her year information kept confidential. |
VARCHAR2 |
5 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UGRAD_TERM |
The last term code when the student received his/her SB degree or before he/she entered MIT as a graduate student. |
VARCHAR2 |
6 |
LATEST_TERM_ATTENDED |
The last/latest academic term in which the student attended -- ie. the is_attended field in the student's enrollment profile is set to 'Y'. |
VARCHAR2 |
6 |
LATEST_TERM_ELIGIBLE_TO_REG |
The last/latest academic term in which the student is eligible to register -- ie. the eligible_to_reg field in the student's enrollment profile is set to 'Y'. |
VARCHAR2 |
6 |
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 |
ORIGINAL_CLASS |
XXX |
VARCHAR2 |
4 |
PERCENT_GIR_COMPLETED |
Percent GIR (General Institute Requirements) completed. |
NUMBER |
3.2 |
PE_POINTS |
This field contains a numeric value of 0 to 8 which indicates the number of PE points the student has. |
NUMBER |
1 |
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 |
UGRAD_ENTRANCE_TYPE_DESC |
Descriptive text for UGRAD_ENTRANCE_TYPE |
VARCHAR2 |
50 |
UGRAD_ENTRY_TERM |
The entrance term of a undergraduate student |
VARCHAR2 |
6 |
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 |