Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT TERM ENROLLMENT Table


Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term.


Field Name

Description

Data Type

Length

ADVISOR_FULL_NAME_1

Full name of the advisor (corresponding to ADVISOR_MIT_ID_1) to the student.

VARCHAR2

90

ADVISOR_FULL_NAME_2

Full name of the advisor (corresponding to ADVISOR_MIT_ID_2) to the student.

VARCHAR2

90

ADVISOR_FULL_NAME_3

Full name of the advisor (corresponding to ADVISOR_MIT_ID_3) to the student.

VARCHAR2

90

ADVISOR_MIT_ID_1

MIT ID of the primary advisor to the student for a specific Course (usually the designated primary Course of the student).

VARCHAR2

9

ADVISOR_MIT_ID_2

MIT ID of the primary advisor to the student for a secondary Course which the student is enrolled in.

VARCHAR2

9

ADVISOR_MIT_ID_3

MIT ID of the primary advisor to the student for a secondary Course which the student is enrolled in.

VARCHAR2

9

ATTENDED

A flag indicating the student actually attended for any time during the current term. Values are Y or N. NOTE: This includes students who started the term and subsequently withdrew or completed their thesis early and are now gone. Use this field instead of the REGISTERED flag if you want to include these types of students.

VARCHAR2

1

CAN_SEE_ALL_DATA

XXX

CHAR

4

CONTINUING_IND

A flag indicating the student is continuing his/her enrollment from last (regular) term. Values include Y and N.

VARCHAR2

1

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_1

Identifies the primary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M". For students who are both at the graduate and undergraduate level, the "first" ie. "1" course is always their graduate program/major.

VARCHAR2

9

COURSE_1_DESCRIPTION

XXX

VARCHAR2

30

COURSE_2

Identifies the secondary program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M".

VARCHAR2

9

COURSE_2_DESCRIPTION

XXX

VARCHAR2

30

COURSE_3

Identifies the third program or course of major the student is enrolled in for the term. Examples: "6 3", "18", "15 M".

VARCHAR2

12

COURSE_3_DESCRIPTION

XXX

VARCHAR2

30

COURSE_DESCRIPTION

The description of the course or program (eg. "Elec. Eng & Comp Sci" for "6 2", "Management - SM" for "15 M", "Mathematics Doctoral" for "18 D") in which a student is enrolled.

VARCHAR2

30

CO_OP_IND

A flag indicating the student is registered as a Co-Op student during this term. Values include Y or N.

VARCHAR2

1

CROSS_REGISTERED_IND

A flag indicating the student is from another college and is cross-registered at MIT. Values include Y(es) and N(o).

VARCHAR2

1

DEPT_1

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". This is the primary department of the student. For students who are both at the graduate and undergraduate level, the "first" ie. "1" department is always the department of their graduate program/major.

VARCHAR2

6

DEPT_2

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci".

VARCHAR2

6

DEPT_3

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci".

VARCHAR2

6

DID_NOT_ATTEND_IND

A flag indicating the student had at one point been expected to register, but either withdrew effective on Registration Day or merely never showed up. Values include Y or N.

VARCHAR2

1

EARLIEST_SEPARATION_DATE

The earliest time when a student is expected to graduate from his/her current program.

VARCHAR2

8

EARLY_THESIS_IND

A flag indicating the student finished his/her thesis before the term ended. Values include Y or N. Specific to GRADUATE AWARDS: Stipends cease once the student has completed his/her thesis, so this may prove helpful in resolving why Payroll's "Stipend Paid Amounts" may appear different for a particular student. Tuition is pro-rated manually on MITSIS when a student leaves early.

VARCHAR2

1

ELIGIBLE_TO_REG

A flag indicating the student is eligible to register for the term. Values include Y or N. NOTE: this flag means that the student has basic eligibility to register from the Registrar's perspective, i.e., s/he has been admitted for this term, is returning from a leave of absence or is a continuing student and has not graduated and has NOT been forced to withdraw for disciplinary or academic reasons. It does NOT MEAN that the student HAS NO HOLDS, financial, medical, or otherwise.

VARCHAR2

1

ENROLLMENT_KEY

Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting.

VARCHAR2

15

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

ENROLL_STATUS_DESCRIPTION

Descriptive text for ENROLL_STATUS

VARCHAR2

50

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

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_DESCRIPTION

Descriptive text for GRAD_COURSE_1

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_DESCRIPTION

Descriptive text for GRAD_COURSE_2

VARCHAR2

30

GRAD_COURSE_3

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

VARCHAR2

12

GRAD_COURSE_3_DESCRIPTION

Descriptive text for GRAD_COURSE_3

VARCHAR2

30

GRAD_COURSE_SELECTOR_KEY

This field is used for GRADUATE AWARDS. It allows you to search for students who may be registered in a given degree track or program either as their first, second, or third course level.

VARCHAR2

30

GRAD_DEPT_1

This field contains the student's primary graduate department for the term. It is the same as the GRAD_HOME_DEPT field. (Note: For GRADUATE AWARDS, department offices should use the GRAD_DEPT_OFC_1 field instead.)

VARCHAR2

6

GRAD_DEPT_2

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

VARCHAR2

6

GRAD_DEPT_3

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

VARCHAR2

6

GRAD_DEPT_OFC_1

This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and the course he/she is enrolled in for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.)

VARCHAR2

4

GRAD_DEPT_OFC_2

This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and course for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.)

VARCHAR2

4

GRAD_DEPT_OFC_3

This field is used for GRADUATE AWARDS. It contains the code for the departmental office that has been connected to this student and course for this term. All courses have one or more departmental offices associated with them. For example: Course 6 1 has the departmental office 6U; 7 WD has the two offices connected: 7G and WHOI. The departmental office code may not be applicable if this record is for a Course that is associated with only a degree and not with a Course of registration. (This should not normally occur, but it may.)

VARCHAR2

4

GRAD_DEPT_OFC_SELECTOR_KEY

This field is used for GRADUATE AWARDS. It allows you to search for students who may be registred in your department office either as their first, second, or third course of registration.

VARCHAR2

30

GRAD_DEPT_SELECTOR_KEY

This field is used for GRADUATE AWARDS. It allows you to search for students who may be registered in your deparment as their first, second, or third course of registration. It may be used to help identify students who have no official enrollment or payroll affiliation with your department.

VARCHAR2

30

GRAD_HOME_DEPT

The student's primary graudate department of registration for the term.

VARCHAR2

6

GRAD_THESIS_SUPERVISOR_MIT_ID

XXX

VARCHAR2

9

GRAD_THESIS_SUPERVISOR_NAME

XXX

VARCHAR2

90

GRAD_ULT_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_ULT_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 (for No Degree) is used for Special STudents.

VARCHAR2

3

GRAD_ULT_DEGREE_3

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

VARCHAR2

3

HOME_DEPT

The primary or home department of a student for the term

VARCHAR2

4

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_DEGREES_CONFIDENTIAL

A "Y" or "S" in this field indicates that the student wants his/her degree 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_MOST_CURRENT_TERM

XXX

VARCHAR2

1

IS_PRE_REGISTERED

'Y' indicates the student has pre-registered for at least a subject in the term. '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_VISITING_STUDENT

XXX

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_NAME

The person's last name.

VARCHAR2

30

LEAVE_OF_ABSENCE_END_DATE

XXX

DATE

7

LEAVE_OF_ABSENCE_REASON_CODE

XXX

VARCHAR2

2

LEAVE_OF_ABSENCE_START_DATE

XXX

DATE

7

LOAD_LEVEL_CODE

Code indicating the level of the load the student is taking this term. Values include: 3Q=3 quarters time,FT=full time,HT=half time,LH=Less than half time. This field may be blank if student never attended this term.

VARCHAR2

2

LOAD_LEVEL_CODE_DESCRIPTION

Descriptive text for LOAD_LEVEL_CODE

VARCHAR2

50

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

MINOR_1

XXX

VARCHAR2

4

MINOR_1_DESCRIPTION

XXX

VARCHAR2

60

MINOR_2

XXX

VARCHAR2

4

MINOR_2_DESCRIPTION

XXX

VARCHAR2

60

MINOR_COMPLETE_CODE_1

Contains the minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has completed in the term. The Minor Completion Form has been submitted.

VARCHAR2

4

MINOR_COMPLETE_CODE_2

Contains the second minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has completed in the term. The Minor Completion Form has been submitted.

VARCHAR2

4

MINOR_COMPLETE_DESC_1

Descriptive name of the minor field for MINOR_COMPLETE_CODE_1

VARCHAR2

60

MINOR_COMPLETE_DESC_2

Descriptive name of the minor field for MINOR_COMPLETE_CODE_2.

VARCHAR2

60

MINOR_PROPOSE_CODE_1

Contains the minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has indicated/proposed he/she would pursue starting from the term. The Minor Proposal Form has been submitted.

VARCHAR2

4

MINOR_PROPOSE_CODE_2

Contains the second minor field (eg. "14" for Economics, "15" for Management, "21M" for Music) that the student has indicated/proposed he/she would pursue starting from the term. The Minor Proposal Form has been submitted.

VARCHAR2

4

MINOR_PROPOSE_DESC_1

Descriptive name of the minor field for MINOR_PROPOSE_CODE_1.

VARCHAR2

60

MINOR_PROPOSE_DESC_2

Descriptive name of the minor field for MINOR_PROPOSE_CODE_2.

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

A flag indicating the student was newly-admitted during this term. Valid values are Y(es) or N(o).

VARCHAR2

1

NON_RESIDENT_IND

A flag indicating the student is a Non-Resident Thesis student. Valid values are Y(es) and N(o).

VARCHAR2

1

PRIMARY_ADVISOR_EMAIL_ADDRESS

XXX

VARCHAR2

100

PRIMARY_ADVISOR_FULL_NAME

XXX

VARCHAR2

90

PRIMARY_ADVISOR_MIT_ID

XXX

VARCHAR2

9

REGISTERED

A flag indicating the student is curently registered in the term. Values include Y or N. NOTE: A student who left (withdrew or finished early due to early thesis) will have an N in this field because he/she is not CURRENTLY registered-even though he/she had been registered. See ATTENDED for a better way to identify these kinds of students.

VARCHAR2

1

REGULAR_STUDENT_IND

A flag indicating the student is a Regular student, i.e., pursuing a degree at MIT this term. This does NOT include non-resident thesis students (see Non-Resident Ind field). Values include Y(es) and N(o).

VARCHAR2

1

REG_ENDED_EARLY_DATE

XXX

DATE

7

REG_ENDED_EARLY_REASON

XXX

VARCHAR2

60

REG_GROUP

Registration Group. Values include:C=Continuing Registration or Non-resident Student,E=Entering Freshman (Reg),F=Registered Student with Former Attendance,N=New Regular Grad Student,O=New Special/Cross-Registered Student,P=Speciall/Cross-Registered, Previously Attended, R=New Regular Grad/Former MIT undegraduate,T=Entering Transfer Student (Reg).

VARCHAR2

1

REG_GROUP_DESCRIPTION

Descriptive text for REG_GROUP

VARCHAR2

50

REG_TYPE

Registration type. Values include:N=Regular Non-Resident Student, R=Regular Resident Student, S=Special Student, X=Cross Registered or Exchange Student.

VARCHAR2

1

REG_TYPE_DESCRIPTION

Descriptive text for REG_TYPE

VARCHAR2

50

RETURNING_FORMER_IND

A flag indicating the student has attended MIT in the past and is returning to MIT this term. Values include Y and N. This flag is set to Y if the student was either a regular student with former attendance or was once a special or cross-registered student with previous attendance.

VARCHAR2

1

SPECIAL_STUDENT_IND

A flag indicating the student is a Special MIT student. Values include Y(es) and N(o).

VARCHAR2

1

STUDENT_TERM_ENROLLMENT_KEY

Use this field to join to the STUDENT TERM ENROLLMENT table

VARCHAR2

15

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_PROGRESS

XXX

VARCHAR2

3

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_DESCRIPTION

Descriptive text for UGRAD_COURSE_1

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_DESCRIPTION

Descriptive text for UGRAD_COURSE_2

VARCHAR2

30

UGRAD_COURSE_3

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

VARCHAR2

9

UGRAD_COURSE_3_DESCRIPTION

Descriptive text for UGRAD_COURSE_3

VARCHAR2

30

UGRAD_DEPT_1

The student's primary undergraduate department for the term. This is the same as the HOME_DEPT field

VARCHAR2

6

UGRAD_DEPT_2

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

VARCHAR2

6

UGRAD_DEPT_3

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

VARCHAR2

6

UGRAD_DEPT_OFC_1

This field is used for GRADUATE AWARDS. It contains the student's primary undergraduate department office for the term.

VARCHAR2

6

UGRAD_DEPT_OFC_2

This field is specific to GRADUATE AWARDS. It contains the student's second undergraduate department office for the term

VARCHAR2

4

UGRAD_DEPT_OFC_3

This field is specific to GRADUATE AWARDS. It contains the student's thirdundergraduate department offi ce for the term

VARCHAR2

4

UGRAD_ULT_DEGREE_1

The primary 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_ULT_DEGREE_2

The third ultimate undergraduate degree, if any, for which the student has enrolled in his/her home department.

VARCHAR2

3

UGRAD_ULT_DEGREE_3

The secondary ultimate undergraduate degree, if any, for which the student has enrolled in his/her home department.

VARCHAR2

3

UG_YEAR

The student's undergraduate year. Values include 1, 2, 3, 4 if the student is an undergraduate. Otherwise it should be null. Note: for undergraduates who are admitted directly to the graduate school, this field stays populated with "4" until s/he actually picks up his/her undergraduate degree. Since the student can wait to pick up his/her undergraduate degree until s/he picks up his/her graduate degree, many students are still coded as undergraduates in this filed long past the time the student has probably completed all of his/her undergraduate requirements.

VARCHAR2

1

ULT_DEGREE_1

XXX

VARCHAR2

3

ULT_DEGREE_2

XXX

VARCHAR2

3

ULT_DEGREE_3

XXX

VARCHAR2

3

UNITS_OF_LOAD

Total of the subject units that the student is registered for this term. Includes subjects registered for as a listener.

NUMBER

3

WAREHOUSE_LOAD_DATE

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

DATE

8

WITHDRAWN_IND

A flag indicating the student withdrew at some point DURING THE TERM for which the award was granted. Valid values are Y or N.

VARCHAR2

1

WITHDRAW_DATE

The date the student withdrew from school during the term.

DATE

8