STUDENT ACADEMIC Table
View exposing current student academic detail including current term, registration and attendance flags, course and department, GPA and completed units, GIR progress, PE points, degree history, advisor names, and confidentiality flags.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVISOR_FULL_NAME_1 |
Advisor full name 1 associated with the record. |
VARCHAR2 |
100 |
ADVISOR_FULL_NAME_2 |
Advisor full name 2 associated with the record. |
VARCHAR2 |
100 |
ADVISOR_FULL_NAME_3 |
Advisor full name 3 associated with the record. |
VARCHAR2 |
100 |
ALT_ADVISOR_FULL_NAME_1 |
Alt advisor full name 1 associated with the record. |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_2 |
Alt advisor full name 2 associated with the record. |
VARCHAR2 |
76 |
ALT_ADVISOR_FULL_NAME_3 |
Alt advisor full name 3 associated with the record. |
VARCHAR2 |
76 |
COMPLETED_UNITS_GRAD |
Completed units grad associated with the record. |
NUMBER |
|
COMPLETED_UNITS_UGRAD |
Completed units ugrad associated with the record. |
NUMBER |
|
COURSE |
Course associated with the record. |
VARCHAR2 |
11 |
CUMULATIVE_GPA |
Cumulative gpa associated with the record. |
NUMBER |
|
CUMULATIVE_GPA_GRAD |
Cumulative gpa grad associated with the record. |
NUMBER |
|
CUMULATIVE_GPA_UGRAD |
Cumulative gpa ugrad associated with the record. |
NUMBER |
|
CURRENT_TERM_CODE |
Code identifying current term. |
VARCHAR2 |
6 |
DEGREE_AWARDED_1 |
Degree awarded 1 associated with the record. |
VARCHAR2 |
15 |
DEGREE_AWARDED_2 |
Degree awarded 2 associated with the record. |
VARCHAR2 |
15 |
DEGREE_AWARDED_3 |
Degree awarded 3 associated with the record. |
VARCHAR2 |
15 |
DEGREE_AWARDED_4 |
Degree awarded 4 associated with the record. |
VARCHAR2 |
15 |
DEGREE_AWARDED_5 |
Degree awarded 5 associated with the record. |
VARCHAR2 |
15 |
DEGREE_AWARD_DATE_1 |
Degree award date 1 associated with the record. |
DATE |
|
DEGREE_AWARD_DATE_2 |
Degree award date 2 associated with the record. |
DATE |
|
DEGREE_AWARD_DATE_3 |
Degree award date 3 associated with the record. |
DATE |
|
DEGREE_AWARD_DATE_4 |
Degree award date 4 associated with the record. |
DATE |
|
DEGREE_AWARD_DATE_5 |
Degree award date 5 associated with the record. |
DATE |
|
EARLY_SOPHOMORE_TERM_CODE |
Code identifying early sophomore term. |
VARCHAR2 |
6 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
93 |
GIR_SUBJECT_COMPLETED |
Gir subject completed associated with the record. |
NUMBER |
|
GIR_SUBJECT_REQUIRED |
Gir subject required associated with the record. |
NUMBER |
|
GRAD_ENTRANCE_TYPE_DESC |
Description of grad entrance type. |
VARCHAR2 |
100 |
GRAD_ENTRY_TERM |
Grad entry term associated with the record. |
VARCHAR2 |
6 |
HAS_INCOMPLETE_GRADE |
Has incomplete grade associated with the record. |
VARCHAR2 |
1 |
HAS_MISSING_GRADE |
Has missing grade associated with the record. |
VARCHAR2 |
1 |
HAS_OPEN_GRADE |
Has open grade associated with the record. |
VARCHAR2 |
1 |
HAS_OX_ABSENCE_EXCUSED_GRADE |
Has ox absence excused grade associated with the record. |
VARCHAR2 |
1 |
HOME_DEPARTMENT |
Home department associated with the record. |
VARCHAR2 |
6 |
IS_ATTENDED |
Indicator identifying whether attended (Y/N). |
VARCHAR2 |
1 |
IS_ATTENDED_CONFIDENTIAL |
Indicator identifying whether attended confidential (Y/N). |
VARCHAR2 |
1 |
IS_COURSE_CONFIDENTIAL |
Indicator identifying whether course confidential (Y/N). |
VARCHAR2 |
1 |
IS_CURRENT_STUDENT |
Indicator identifying whether current student (Y/N). |
VARCHAR2 |
1 |
IS_EARLY_SOPHOMORE |
Indicator identifying whether early sophomore (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_SERIOUS_CONFIDENTIAL |
Indicator identifying whether serious confidential (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
60 |
LAST_UGRAD_TERM |
Last ugrad term associated with the record. |
VARCHAR2 |
6 |
LATEST_TERM_ATTENDED |
Latest term attended associated with the record. |
VARCHAR2 |
6 |
LATEST_TERM_ELIGIBLE_TO_REG |
Latest term eligible to reg associated with the record. |
VARCHAR2 |
6 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
15 |
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 |
Original class associated with the record. |
VARCHAR2 |
4 |
PERCENT_GIR_COMPLETED |
Percent gir completed associated with the record. |
NUMBER |
|
PE_POINTS |
Pe points associated with the record. |
NUMBER |
|
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
SWIM_TEST_COMPLETE_FLAG |
Indicator identifying whether swim test complete (Y/N). |
VARCHAR2 |
1 |
UGRAD_ENTRANCE_TYPE_DESC |
Description of ugrad entrance type. |
VARCHAR2 |
100 |
UGRAD_ENTRY_TERM |
Ugrad entry term associated with the record. |
VARCHAR2 |
6 |
UNITS_BEYOND_GIR_COMPLETED |
Units beyond gir completed associated with the record. |
NUMBER |
|
UNITS_BEYOND_GIR_REQUIRED |
Units beyond gir required associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |