STUDENT CURRENT ENROLLMENT Table
View exposing student current 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 |
CONTINUING_IND |
Continuing ind associated with the record. |
VARCHAR2 |
1 |
COURSE |
Course associated with the record. |
VARCHAR2 |
12 |
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 |
CURRENT_TERM_CODE |
Code identifying current term. |
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 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
2 |
ENROLL_STATUS_DESCRIPTION |
Description of enroll status. |
VARCHAR2 |
50 |
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_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_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_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_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
1 |
LOAD_LEVEL_CODE |
Code identifying load level. |
VARCHAR2 |
2 |
LOAD_LEVEL_CODE_DESCRIPTION |
Description of load level code. |
VARCHAR2 |
50 |
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 |
REGISTERED |
Registered associated with the record. |
VARCHAR2 |
1 |
REGULAR_STUDENT_IND |
Regular student ind associated with the record. |
VARCHAR2 |
1 |
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_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
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_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 |
UNITS_OF_LOAD |
Units of load associated with the record. |
NUMBER |
3 |
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 |