STUDENT TERM ENROLLMENT Table
View exposing student term enrollment data.
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 |
ADVISOR_MIT_ID_1 |
Advisor mit id 1 associated with the record. |
VARCHAR2 |
9 |
ADVISOR_MIT_ID_2 |
Advisor mit id 2 associated with the record. |
VARCHAR2 |
9 |
ADVISOR_MIT_ID_3 |
Advisor mit id 3 associated with the record. |
VARCHAR2 |
9 |
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 |
ALT_ADVISOR_MIT_ID_1 |
Alt advisor mit id 1 associated with the record. |
VARCHAR2 |
9 |
ALT_ADVISOR_MIT_ID_2 |
Alt advisor mit id 2 associated with the record. |
VARCHAR2 |
9 |
ALT_ADVISOR_MIT_ID_3 |
Alt advisor mit id 3 associated with the record. |
VARCHAR2 |
9 |
ATTENDED |
Attended associated with the record. |
VARCHAR2 |
1 |
CAN_SEE_ALL_DATA |
Can see all data associated with the record. |
CHAR |
|
CONTINUING_IND |
Continuing ind associated with the record. |
VARCHAR2 |
1 |
COURSE |
Course associated with the record. |
VARCHAR2 |
12 |
COURSE_1 |
Course 1 associated with the record. |
VARCHAR2 |
12 |
COURSE_1_DESCRIPTION |
Description of course 1. |
VARCHAR2 |
30 |
COURSE_2 |
Course 2 associated with the record. |
VARCHAR2 |
12 |
COURSE_2_DESCRIPTION |
Description of course 2. |
VARCHAR2 |
30 |
COURSE_3 |
Course 3 associated with the record. |
VARCHAR2 |
12 |
COURSE_3_DESCRIPTION |
Description of course 3. |
VARCHAR2 |
30 |
COURSE_DESCRIPTION |
Description of course. |
VARCHAR2 |
30 |
CO_OP_IND |
Co op ind associated with the record. |
VARCHAR2 |
1 |
CROSS_REGISTERED_IND |
Cross registered ind associated with the record. |
VARCHAR2 |
1 |
DEPT_1 |
Dept 1 associated with the record. |
VARCHAR2 |
6 |
DEPT_2 |
Dept 2 associated with the record. |
VARCHAR2 |
6 |
DEPT_3 |
Dept 3 associated with the record. |
VARCHAR2 |
6 |
DID_NOT_ATTEND_IND |
Did not attend ind associated with the record. |
VARCHAR2 |
100 |
EARLIEST_SEPARATION_DATE |
Date associated with earliest separation. |
DATE |
|
EARLY_THESIS_IND |
Early thesis ind associated with the record. |
VARCHAR2 |
1 |
ELIGIBLE_TO_REG |
Eligible to reg associated with the record. |
VARCHAR2 |
1 |
ENROLLMENT_KEY |
Surrogate key identifying the enrollment. |
VARCHAR2 |
15 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
2 |
ENROLL_STATUS_DESCRIPTION |
Description of enroll status. |
VARCHAR2 |
50 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
GRAD_COURSE_1 |
Grad course 1 associated with the record. |
VARCHAR2 |
12 |
GRAD_COURSE_1_DESCRIPTION |
Description of grad course 1. |
VARCHAR2 |
30 |
GRAD_COURSE_2 |
Grad course 2 associated with the record. |
VARCHAR2 |
12 |
GRAD_COURSE_2_DESCRIPTION |
Description of grad course 2. |
VARCHAR2 |
30 |
GRAD_COURSE_3 |
Grad course 3 associated with the record. |
VARCHAR2 |
12 |
GRAD_COURSE_3_DESCRIPTION |
Description of grad course 3. |
VARCHAR2 |
30 |
GRAD_COURSE_SELECTOR_KEY |
Surrogate key identifying the grad course selector. |
VARCHAR2 |
30 |
GRAD_DEPT_1 |
Grad dept 1 associated with the record. |
VARCHAR2 |
6 |
GRAD_DEPT_2 |
Grad dept 2 associated with the record. |
VARCHAR2 |
6 |
GRAD_DEPT_3 |
Grad dept 3 associated with the record. |
VARCHAR2 |
6 |
GRAD_DEPT_OFC_1 |
Grad dept ofc 1 associated with the record. |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_2 |
Grad dept ofc 2 associated with the record. |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_3 |
Grad dept ofc 3 associated with the record. |
VARCHAR2 |
4 |
GRAD_DEPT_OFC_SELECTOR_KEY |
Surrogate key identifying the grad dept ofc selector. |
VARCHAR2 |
30 |
GRAD_DEPT_SELECTOR_KEY |
Surrogate key identifying the grad dept selector. |
VARCHAR2 |
30 |
GRAD_HOME_DEPT |
Grad home dept associated with the record. |
VARCHAR2 |
6 |
GRAD_THESIS_SUPERVISOR_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
GRAD_THESIS_SUPERVISOR_NAME |
Grad thesis supervisor name associated with the record. |
VARCHAR2 |
100 |
GRAD_ULT_DEGREE_1 |
Grad ult degree 1 associated with the record. |
VARCHAR2 |
3 |
GRAD_ULT_DEGREE_2 |
Grad ult degree 2 associated with the record. |
VARCHAR2 |
3 |
GRAD_ULT_DEGREE_3 |
Grad ult degree 3 associated with the record. |
VARCHAR2 |
3 |
HOME_DEPT |
Home dept associated with the record. |
VARCHAR2 |
6 |
IS_COURSE_CONFIDENTIAL |
Indicator identifying whether course confidential (Y/N). |
VARCHAR2 |
1 |
IS_DATES_ATTND_CONFIDENTIAL |
Indicator identifying whether dates attnd confidential (Y/N). |
VARCHAR2 |
1 |
IS_DEGREES_CONFIDENTIAL |
Indicator identifying whether degrees confidential (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_MOST_CURRENT_TERM |
Indicator identifying whether most current term (Y/N). |
VARCHAR2 |
1 |
IS_PRE_REGISTERED |
Indicator identifying whether pre registered (Y/N). |
VARCHAR2 |
1 |
IS_REG_TYPE_CONFIDENTIAL |
Indicator identifying whether reg type confidential (Y/N). |
VARCHAR2 |
1 |
IS_SERIOUS_CONFIDENTIAL |
Indicator identifying whether serious confidential (Y/N). |
VARCHAR2 |
1 |
IS_VISITING_STUDENT |
Indicator identifying whether visiting student (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 |
LEAVE_OF_ABSENCE_END_DATE |
Date associated with leave of absence end. |
DATE |
|
LEAVE_OF_ABSENCE_REASON_CODE |
Code identifying leave of absence reason. |
VARCHAR2 |
2 |
LEAVE_OF_ABSENCE_START_DATE |
Date associated with leave of absence start. |
DATE |
|
LOAD_LEVEL_CODE |
Code identifying load level. |
VARCHAR2 |
2 |
LOAD_LEVEL_CODE_DESCRIPTION |
Description of load level code. |
VARCHAR2 |
50 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
15 |
MINOR_1 |
Minor 1 associated with the record. |
VARCHAR2 |
4 |
MINOR_1_DESCRIPTION |
Description of minor 1. |
VARCHAR2 |
60 |
MINOR_2 |
Minor 2 associated with the record. |
VARCHAR2 |
4 |
MINOR_2_DESCRIPTION |
Description of minor 2. |
VARCHAR2 |
60 |
MINOR_COMPLETE_CODE_1 |
Minor complete code 1 associated with the record. |
VARCHAR2 |
4 |
MINOR_COMPLETE_CODE_2 |
Minor complete code 2 associated with the record. |
VARCHAR2 |
4 |
MINOR_COMPLETE_DESC_1 |
Minor complete desc 1 associated with the record. |
VARCHAR2 |
60 |
MINOR_COMPLETE_DESC_2 |
Minor complete desc 2 associated with the record. |
VARCHAR2 |
60 |
MINOR_PROPOSE_CODE_1 |
Minor propose code 1 associated with the record. |
VARCHAR2 |
4 |
MINOR_PROPOSE_CODE_2 |
Minor propose code 2 associated with the record. |
VARCHAR2 |
4 |
MINOR_PROPOSE_DESC_1 |
Minor propose desc 1 associated with the record. |
VARCHAR2 |
60 |
MINOR_PROPOSE_DESC_2 |
Minor propose desc 2 associated with the record. |
VARCHAR2 |
60 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NEWLY_ADMITTED_IND |
Newly admitted ind associated with the record. |
VARCHAR2 |
1 |
NON_RESIDENT_IND |
Non resident ind associated with the record. |
VARCHAR2 |
1 |
PRIMARY_ADVISOR_EMAIL_ADDRESS |
Primary advisor email address associated with the record. |
VARCHAR2 |
100 |
PRIMARY_ADVISOR_FULL_NAME |
Primary advisor full name associated with the record. |
VARCHAR2 |
100 |
PRIMARY_ADVISOR_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 |
Registered associated with the record. |
VARCHAR2 |
1 |
REGULAR_STUDENT_IND |
Regular student ind associated with the record. |
VARCHAR2 |
1 |
REG_ENDED_EARLY_DATE |
Date associated with reg ended early. |
DATE |
|
REG_ENDED_EARLY_REASON |
Reg ended early reason associated with the record. |
VARCHAR2 |
31 |
REG_GROUP |
Reg group associated with the record. |
VARCHAR2 |
1 |
REG_GROUP_DESCRIPTION |
Description of reg group. |
VARCHAR2 |
50 |
REG_TYPE |
Reg type associated with the record. |
VARCHAR2 |
1 |
REG_TYPE_DESCRIPTION |
Description of reg type. |
VARCHAR2 |
50 |
RETURNING_FORMER_IND |
Returning former ind associated with the record. |
VARCHAR2 |
1 |
SPECIAL_STUDENT_IND |
Special student ind associated with the record. |
VARCHAR2 |
1 |
STUDENT_TERM_ENROLLMENT_KEY |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
STUDENT_YEAR_PROGRESS |
Student year progress associated with the record. |
VARCHAR2 |
3 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
UGRAD_COURSE_1 |
Ugrad course 1 associated with the record. |
VARCHAR2 |
12 |
UGRAD_COURSE_1_DESCRIPTION |
Description of ugrad course 1. |
VARCHAR2 |
30 |
UGRAD_COURSE_2 |
Ugrad course 2 associated with the record. |
VARCHAR2 |
12 |
UGRAD_COURSE_2_DESCRIPTION |
Description of ugrad course 2. |
VARCHAR2 |
30 |
UGRAD_COURSE_3 |
Ugrad course 3 associated with the record. |
VARCHAR2 |
12 |
UGRAD_COURSE_3_DESCRIPTION |
Description of ugrad course 3. |
VARCHAR2 |
30 |
UGRAD_DEPT_1 |
Ugrad dept 1 associated with the record. |
VARCHAR2 |
6 |
UGRAD_DEPT_2 |
Ugrad dept 2 associated with the record. |
VARCHAR2 |
6 |
UGRAD_DEPT_3 |
Ugrad dept 3 associated with the record. |
VARCHAR2 |
6 |
UGRAD_DEPT_OFC_1 |
Ugrad dept ofc 1 associated with the record. |
VARCHAR2 |
6 |
UGRAD_DEPT_OFC_2 |
Ugrad dept ofc 2 associated with the record. |
VARCHAR2 |
4 |
UGRAD_DEPT_OFC_3 |
Ugrad dept ofc 3 associated with the record. |
VARCHAR2 |
4 |
UGRAD_ULT_DEGREE_1 |
Ugrad ult degree 1 associated with the record. |
VARCHAR2 |
3 |
UGRAD_ULT_DEGREE_2 |
Ugrad ult degree 2 associated with the record. |
VARCHAR2 |
3 |
UGRAD_ULT_DEGREE_3 |
Ugrad ult degree 3 associated with the record. |
VARCHAR2 |
3 |
UG_YEAR |
Ug year associated with the record. |
VARCHAR2 |
1 |
ULT_DEGREE_1 |
Ult degree 1 associated with the record. |
VARCHAR2 |
3 |
ULT_DEGREE_2 |
Ult degree 2 associated with the record. |
VARCHAR2 |
3 |
ULT_DEGREE_3 |
Ult degree 3 associated with the record. |
VARCHAR2 |
3 |
UNITS_OF_LOAD |
Units of load associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WITHDRAWN_IND |
Withdrawn ind associated with the record. |
VARCHAR2 |
1 |
WITHDRAW_DATE |
Date associated with withdraw. |
DATE |