Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT ENROLLMENT WEEK5 Table


Student term enrollment information as of the fifth week (ADD Date) of the academic term. There is one record per student per term.


Field Name

Description

Data Type

Length

ADDRESS_COUNTRY

The country of the student's home address.

VARCHAR2

30

ADDRESS_STATE

The U.S. state code of the student's home address.

VARCHAR2

2

BIRTH_DATE

Date of birth.

DATE

8

CITIZENSHIP

Citizenship status: International, US Citizen, US Permanent Resident.

VARCHAR2

30

COUNTRY_OF_CITIZENSHIP

The country where the person has citizenship.

VARCHAR2

30

COURSE

The major program (eg. "6 2", "15 M", "18 D") in which the student is enrolled in for the current term.

VARCHAR2

9

COURSE_DESC

Descriptive text for the course of the major of the student for the academic term.

VARCHAR2

30

DEPARTMENT

The department of the primary Course/major: 6, 10, HIST, etc.

VARCHAR2

4

ENROLL_STATUS

The status of the student's registration for the term. Values include: Eligible to register, Registered, Early Thesis, Withdrew After 5th Week, etc. In the STUDENT and STUDENT_TERM_ENROLLMENT tables, only the codes (eg. EL, RE, ET, WR, WE) are shown.

VARCHAR2

2

ETHNICITY

Ethnicity

VARCHAR2

40

GENDER

The person's gender.

VARCHAR2

30

GRADUATE_ENTRY_TERM

The academic term where the student started matriculating as a graduate student.

VARCHAR2

6

GRAD_COURSE_1

Identifies the primary graduate degree program or track the student is enrolled in for the term. Examples: 1 M, 1 D, 1 CTP, 15 M ...

VARCHAR2

12

GRAD_COURSE_1_DESC

This field identifies the primary graduate degree program (course of major) the student is enrolled in for the academic term.

VARCHAR2

30

GRAD_COURSE_2

Identifies the second, if any, graduate degree program the student is enrolled in for the term. Examples: 1 D, 1 CTP, 15 M, ...

VARCHAR2

12

GRAD_COURSE_2_DESC

Identifies the second, if any, graduate degree program (course of major) the student is enrolled in for the academic term.

VARCHAR2

30

GRAD_DEPARTMENT_1

This field contains the student's primary graduate department for the academic term.

VARCHAR2

4

GRAD_DEPARTMENT_2

The student's second, if any, graduate department of registration for the academic term.

VARCHAR2

4

GRAD_ULTIMATE_DEGREE_1

The primary ultimate graduate degree for which the student has enrolled in his/her home department. Values include: SB, MNG, SM, MA, MCP, DOC, etc. NDG (for No Degree) is used for Special Students.

VARCHAR2

3

GRAD_ULTIMATE_DEGREE_1_DESC

Descriptive text for the degree codes in GRAD ULTIMATE DEGREE 1.

VARCHAR2

40

GRAD_ULTIMATE_DEGREE_2

The ultimate graduate degree for which the student has enrolled in his/her second department, if any. Values include: SB, MNG, SM, MA, MCP, DOC, etc. NDG (No Degree) is used for special students.

VARCHAR2

3

GRAD_ULTIMATE_DEGREE_2_DESC

Descriptive text for the degree codes in GRAD ULTIMATE DEGREE 2.

VARCHAR2

40

IPEDS_ETHNICITY

Ethnicity as defined by IPEDS

VARCHAR2

50

IS_BIRTH_DATE_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her date of birth information kept confidential.

VARCHAR2

1

IS_COURSE_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her course of major kept confidential.

VARCHAR2

5

IS_DATES_ATTND_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her attended dates information kept confidential.

VARCHAR2

1

IS_DOUBLE_MAJOR

A "Y" in this field indicates that the student is enrolled pursuing an undergraduate double major. "N" otherwise

VARCHAR2

1

IS_REG_TYPE_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her registration type information kept confidential.

VARCHAR2

5

IS_SERIOUS_CONFIDENTIAL

A "Y" in this field indicates that the student wants his/her record kept confidential

VARCHAR2

1

IS_YEAR_5

This field contains a 'Y' if the student is a fifth year senior for the academic term, otherwise the field contains an 'N'.

VARCHAR2

1

IS_YEAR_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her year information kept confidential.

VARCHAR2

5

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

LOAD_LEVEL

The course load of the student in the registered term. Values: Full Time, Half Time, 3/4 Time, Early Thesis, No Load, Cross-registered, Less Than Half Time, Full Time Senior.

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

The registration group in which the student is categorized for the academic term. Some possible values include: Entering Freshman, Entering Transfer Student, New Regular Grad Student, Continuing Registration or Non-Resident Student.

VARCHAR2

50

REGISTRATION_TYPE

Describes how the student has registered. Cross Registered - a student that is taking courses at MIT but whose primary affiliation is with another university. Special - A student who has registered for one or more courses but is not enrolled in a degree program. Regular - A student who is enrolled in a degree program. Non-resident - A doctoral student who is not living or working on campus. This type of student has complete all requirements other than the thesis.

VARCHAR2

18

SCHOOL

The name of the school from which the person earned the highest or most recent degree.

VARCHAR2

50

STUDENT_YEAR

The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable.

VARCHAR2

1

STUDENT_YEAR_DESC

Descriptive text for the student's primary year of degree for the current academic term. Eg.: Freshman, Senior, Graduate Student.

VARCHAR2

30

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

UGRAD_COURSE_1

The primary undergraduate major or degree program which the student is enrolled in for the term

VARCHAR2

12

UGRAD_COURSE_1_DESC

The primary undergraduate major or degree program in which the student is enrolled for the academic term.

VARCHAR2

30

UGRAD_COURSE_2

The second undergraduate major or degree program, if any, which the student is enrolled in for the term

VARCHAR2

9

UGRAD_COURSE_2_DESC

The second undergraduate major or degree program in which the student is enrolled for the academic term.

VARCHAR2

30

UGRAD_DEPARTMENT_1

This field contains the student's primary undergraduate department for the academic term.

VARCHAR2

4

UGRAD_DEPARTMENT_2

The student's second undergraduate department for the term, if any.

VARCHAR2

4

UGRAD_ULTIMATE_DEGREE_1

The ultimate undergraduate degree for which the student has enrolled in his/her home department. Values include: SB and NDG (No Degree) for Special Students.

VARCHAR2

3

UGRAD_ULTIMATE_DEGREE_1_DESC

Descriptive text for the degree codes in UGRAD ULTIMATE DEGREE 1.

VARCHAR2

40

UGRAD_ULTIMATE_DEGREE_2

The undergraduate degree for which the student has enrolled in his/her second department, if any. Values include SB, and NDG (No Degree) for Special Students.

VARCHAR2

3

UGRAD_ULTIMATE_DEGREE_2_DESC

Descriptive codes for the degree codes in UGRAD ULTIMATE DEGREE 2.

VARCHAR2

40

ULTIMATE_DEGREE

The degree code (eg. SB, SM, MA, MBA, DOC) of the primary ultimate degree that the student is seeking.

VARCHAR2

3

ULTIMATE_DEGREE_DESC

Description of the degree codes in ULTIMATE DEGREE.

VARCHAR2

40

UNDERGRAD_ENTRY_TERM

The academic term where the student started matriculating as an undergraduate student.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8