STUDENT ALL ENROLLMENT Table
View exposing student all enrollment data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COURSE |
Course associated with the record. |
VARCHAR2 |
11 |
CURRENT_TERM_CODE |
Code identifying current term. |
VARCHAR2 |
6 |
DEGREE_1 |
Degree 1 associated with the record. |
VARCHAR2 |
3 |
DEGREE_2 |
Degree 2 associated with the record. |
VARCHAR2 |
3 |
DEGREE_3 |
Degree 3 associated with the record. |
VARCHAR2 |
3 |
DEGREE_4 |
Degree 4 associated with the record. |
VARCHAR2 |
3 |
DEGREE_5 |
Degree 5 associated with the record. |
VARCHAR2 |
3 |
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 |
|
DEGREE_AWARD_TERM_1 |
Degree award term 1 associated with the record. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_2 |
Degree award term 2 associated with the record. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_3 |
Degree award term 3 associated with the record. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_4 |
Degree award term 4 associated with the record. |
VARCHAR2 |
6 |
DEGREE_AWARD_TERM_5 |
Degree award term 5 associated with the record. |
VARCHAR2 |
6 |
DEGREE_DEPARTMENT_1 |
Degree department 1 associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_2 |
Degree department 2 associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_3 |
Degree department 3 associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_4 |
Degree department 4 associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_5 |
Degree department 5 associated with the record. |
VARCHAR2 |
4 |
DEGREE_OPTION_1 |
Degree option 1 associated with the record. |
VARCHAR2 |
4 |
DEGREE_OPTION_2 |
Degree option 2 associated with the record. |
VARCHAR2 |
4 |
DEGREE_OPTION_3 |
Degree option 3 associated with the record. |
VARCHAR2 |
4 |
DEGREE_OPTION_4 |
Degree option 4 associated with the record. |
VARCHAR2 |
4 |
DEGREE_OPTION_5 |
Degree option 5 associated with the record. |
VARCHAR2 |
4 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
93 |
GRAD_COHORT |
Grad cohort associated with the record. |
VARCHAR2 |
5 |
GRAD_ENTRANCE_TYPE |
Grad entrance type associated with the record. |
VARCHAR2 |
1 |
GRAD_ENTRANCE_TYPE_DESC |
Description of grad entrance type. |
VARCHAR2 |
100 |
GRAD_ENTRY_TERM |
Grad entry term associated with the record. |
VARCHAR2 |
6 |
HOME_DEPARTMENT |
Home department associated with the record. |
VARCHAR2 |
6 |
IS_ATTENDED |
Indicator identifying whether attended (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_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_ELIGIBLE |
Indicator identifying whether eligible (Y/N). |
VARCHAR2 |
1 |
IS_E_MAIL_CONFIDENTIAL |
Indicator identifying whether e mail confidential (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether 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_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_CODE |
Code identifying latest term. |
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 |
NAME_SUFFIX |
Name suffix associated with the record. |
VARCHAR2 |
20 |
REGISTRATION_TYPE |
Registration type associated with the record. |
VARCHAR2 |
100 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
UGRAD_COHORT |
Ugrad cohort associated with the record. |
VARCHAR2 |
5 |
UGRAD_ENTRANCE_TYPE |
Ugrad entrance type associated with the record. |
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |