STUDENT ENROLLMENT WEEK5 Table
View exposing student enrollment week5 data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_COUNTRY |
Address country associated with the record. |
VARCHAR2 |
30 |
ADDRESS_STATE |
Address state associated with the record. |
VARCHAR2 |
2 |
BIRTH_DATE |
Date associated with birth. |
DATE |
|
CITIZENSHIP |
Citizenship associated with the record. |
VARCHAR2 |
30 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship associated with the record. |
VARCHAR2 |
32 |
COURSE |
Course associated with the record. |
VARCHAR2 |
9 |
COURSE_DESC |
Description of course. |
VARCHAR2 |
30 |
DEPARTMENT |
Department associated with the record. |
VARCHAR2 |
4 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
30 |
ETHNICITY |
Ethnicity associated with the record. |
VARCHAR2 |
50 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
1 |
GRADUATE_ENTRY_TERM |
Graduate entry term associated with the record. |
VARCHAR2 |
6 |
GRAD_COURSE_1 |
Grad course 1 associated with the record. |
VARCHAR2 |
9 |
GRAD_COURSE_1_DESC |
Description of grad course 1. |
VARCHAR2 |
30 |
GRAD_COURSE_2 |
Grad course 2 associated with the record. |
VARCHAR2 |
9 |
GRAD_COURSE_2_DESC |
Description of grad course 2. |
VARCHAR2 |
30 |
GRAD_DEPARTMENT_1 |
Grad department 1 associated with the record. |
VARCHAR2 |
4 |
GRAD_DEPARTMENT_2 |
Grad department 2 associated with the record. |
VARCHAR2 |
4 |
GRAD_ULTIMATE_DEGREE_1 |
Grad ultimate degree 1 associated with the record. |
VARCHAR2 |
3 |
GRAD_ULTIMATE_DEGREE_1_DESC |
Description of grad ultimate degree 1. |
VARCHAR2 |
40 |
GRAD_ULTIMATE_DEGREE_2 |
Grad ultimate degree 2 associated with the record. |
VARCHAR2 |
3 |
GRAD_ULTIMATE_DEGREE_2_DESC |
Description of grad ultimate degree 2. |
VARCHAR2 |
40 |
IPEDS_ETHNICITY |
Ipeds ethnicity associated with the record. |
VARCHAR2 |
50 |
IS_BIRTH_DATE_CONFIDENTIAL |
Indicator identifying whether birth date confidential (Y/N). |
VARCHAR2 |
1 |
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_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_5 |
Indicator identifying whether year 5 (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
LOAD_LEVEL |
Load level associated with the record. |
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 |
REGISTRATION_GROUP |
Registration group associated with the record. |
VARCHAR2 |
50 |
REGISTRATION_TYPE |
Registration type associated with the record. |
VARCHAR2 |
30 |
SCHOOL |
School associated with the record. |
VARCHAR2 |
30 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
STUDENT_YEAR_DESC |
Description of student year. |
VARCHAR2 |
30 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
UGRAD_COURSE_1 |
Ugrad course 1 associated with the record. |
VARCHAR2 |
9 |
UGRAD_COURSE_1_DESC |
Description of ugrad course 1. |
VARCHAR2 |
30 |
UGRAD_COURSE_2 |
Ugrad course 2 associated with the record. |
VARCHAR2 |
9 |
UGRAD_COURSE_2_DESC |
Description of ugrad course 2. |
VARCHAR2 |
30 |
UGRAD_DEPARTMENT_1 |
Ugrad department 1 associated with the record. |
VARCHAR2 |
4 |
UGRAD_DEPARTMENT_2 |
Ugrad department 2 associated with the record. |
VARCHAR2 |
4 |
UGRAD_ULTIMATE_DEGREE_1 |
Ugrad ultimate degree 1 associated with the record. |
VARCHAR2 |
3 |
UGRAD_ULTIMATE_DEGREE_1_DESC |
Description of ugrad ultimate degree 1. |
VARCHAR2 |
40 |
UGRAD_ULTIMATE_DEGREE_2 |
Ugrad ultimate degree 2 associated with the record. |
VARCHAR2 |
3 |
UGRAD_ULTIMATE_DEGREE_2_DESC |
Description of ugrad ultimate degree 2. |
VARCHAR2 |
40 |
ULTIMATE_DEGREE |
Ultimate degree associated with the record. |
VARCHAR2 |
3 |
ULTIMATE_DEGREE_DESC |
Description of ultimate degree. |
VARCHAR2 |
40 |
UNDERGRAD_ENTRY_TERM |
Undergrad entry term associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |