STUDENT ENROLLMENT Y REPORT Table
View exposing student enrollment y report data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BIRTH_DATE |
Date associated with birth. |
DATE |
|
CITIZENSHIP |
Citizenship associated with the record. |
VARCHAR2 |
30 |
COUNTER |
Counter associated with the record. |
NUMBER |
1 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship associated with the record. |
VARCHAR2 |
32 |
COURSE |
Course associated with the record. |
VARCHAR2 |
9 |
COURSE_DEFINITION |
Course definition associated with the record. |
VARCHAR2 |
50 |
COURSE_DEPARTMENT |
Course department associated with the record. |
VARCHAR2 |
4 |
COURSE_OPTION |
Course option associated with the record. |
VARCHAR2 |
4 |
DEPARTMENT_BUDGET_CODE |
Code identifying department budget. |
VARCHAR2 |
6 |
ENROLLMENT_KEY |
Surrogate key identifying the enrollment. |
VARCHAR2 |
15 |
ENROLL_STATUS |
Enroll status associated with the record. |
VARCHAR2 |
50 |
ETHNICITY |
Ethnicity associated with the record. |
VARCHAR2 |
50 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
60 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
1 |
GRADUATE_ENTRY_TERM |
Graduate entry term associated with the record. |
VARCHAR2 |
6 |
GRADUATE_LEVEL |
Graduate level associated with the record. |
VARCHAR2 |
3 |
HOME_ADDR_COUNTRY |
Home addr country associated with the record. |
VARCHAR2 |
30 |
HOME_ADDR_STATE |
Home addr state associated with the record. |
VARCHAR2 |
2 |
IPEDS_ETHNICITY |
Ipeds ethnicity associated with the record. |
VARCHAR2 |
50 |
IPEDS_GENDER |
Ipeds gender associated with the record. |
VARCHAR2 |
1 |
IS_AMERICAN_INDIAN_ALASKA_NATV |
Indicator identifying whether american indian alaska natv (Y/N). |
VARCHAR2 |
1 |
IS_AMER_INDIAN_ALASKA_NATV_IR |
Indicator identifying whether amer indian alaska natv ir (Y/N). |
VARCHAR2 |
1 |
IS_ASIAN |
Indicator identifying whether asian (Y/N). |
VARCHAR2 |
1 |
IS_ASIAN_IR |
Indicator identifying whether asian ir (Y/N). |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMERICAN |
Indicator identifying whether black or african american (Y/N). |
VARCHAR2 |
1 |
IS_BLACK_OR_AFRICAN_AMER_IR |
Indicator identifying whether black or african amer ir (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO |
Indicator identifying whether hispanic or latino (Y/N). |
VARCHAR2 |
1 |
IS_HISPANIC_OR_LATINO_IR |
Indicator identifying whether hispanic or latino ir (Y/N). |
VARCHAR2 |
1 |
IS_INTERNATIONAL_NOT_CITZ_PR |
Indicator identifying whether international not citz pr (Y/N). |
VARCHAR2 |
1 |
IS_INTERNTL_NOT_CITZ_PR_IR |
Indicator identifying whether interntl not citz pr ir (Y/N). |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REPORTED |
Indicator identifying whether more than one race reported (Y/N). |
VARCHAR2 |
1 |
IS_MORE_THAN_ONE_RACE_REP_IR |
Indicator identifying whether more than one race rep ir (Y/N). |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PACIFIC_ISL |
Indicator identifying whether native hawaiian pacific isl (Y/N). |
VARCHAR2 |
1 |
IS_NATIVE_HAWAIIAN_PAC_ISL_IR |
Indicator identifying whether native hawaiian pac isl ir (Y/N). |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD |
Indicator identifying whether no ethnicity on record (Y/N). |
VARCHAR2 |
1 |
IS_NO_ETHNICITY_ON_RECORD_IR |
Indicator identifying whether no ethnicity on record ir (Y/N). |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKNOWN |
Indicator identifying whether race ethnicity unknown (Y/N). |
VARCHAR2 |
1 |
IS_RACE_ETHNICITY_UNKN_IR |
Indicator identifying whether race ethnicity unkn ir (Y/N). |
VARCHAR2 |
1 |
IS_WHITE |
Indicator identifying whether white (Y/N). |
VARCHAR2 |
1 |
IS_WHITE_IR |
Indicator identifying whether white ir (Y/N). |
VARCHAR2 |
1 |
IS_YEAR_5 |
Indicator identifying whether year 5 (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 |
OFFICE_BUILDING |
Office building associated with the record. |
VARCHAR2 |
20 |
OFFICE_LOCATION |
Office location associated with the record. |
VARCHAR2 |
30 |
REGISTRATION_GROUP |
Registration group associated with the record. |
VARCHAR2 |
50 |
REGISTRATION_TYPE |
Registration type associated with the record. |
VARCHAR2 |
30 |
STUDENT_TERM_ENROLLMENT_KEY |
Surrogate key identifying the student term enrollment. |
VARCHAR2 |
15 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
SUPER_COURSE |
Super course associated with the record. |
VARCHAR2 |
9 |
SUPER_COURSE_ROMAN |
Super course roman associated with the record. |
VARCHAR2 |
20 |
TERM_ADDRESS_CATEGORY |
Term address category associated with the record. |
VARCHAR2 |
30 |
TERM_CITY |
Term city associated with the record. |
VARCHAR2 |
40 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
TERM_COUNTRY |
Term country associated with the record. |
VARCHAR2 |
100 |
TERM_STATE |
Term state associated with the record. |
VARCHAR2 |
2 |
TERM_STREET1 |
Term street1 associated with the record. |
VARCHAR2 |
30 |
TERM_STREET2 |
Term street2 associated with the record. |
VARCHAR2 |
30 |
TERM_STREET3 |
Term street3 associated with the record. |
VARCHAR2 |
30 |
TERM_ZIP_CODE5 |
Term zip code5 associated with the record. |
VARCHAR2 |
5 |
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 |