Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT GRAD ENROLLMENT Table


View exposing student grad enrollment data.


Field Name

Description

Data Type

Length

CURRENT_ACADEMIC_TERM

Current academic term associated with the record.

VARCHAR2

6

DEGREE_AWARD_TERM

Degree award term associated with the record.

VARCHAR2

6

DEGREE_COURSE_1

Degree course 1 associated with the record.

VARCHAR2

30

DEGREE_COURSE_2

Degree course 2 associated with the record.

VARCHAR2

30

ELIGIBLE_TO_REG_NEXT_TERM

Eligible to reg next term associated with the record.

VARCHAR2

1

EMAIL_ADDRESS

Email address associated with the record.

VARCHAR2

60

ENROLL_STATUS

Enroll status associated with the record.

VARCHAR2

50

FIRST_NAME

First name associated with the person or organization.

VARCHAR2

15

GRAD_ENTRANCE_TYPE

Grad entrance type associated with the record.

VARCHAR2

1

GRAD_ENTRY_TERM

Grad entry term associated with the record.

VARCHAR2

6

HOME_DEPARTMENT_CODE

Home department code associated with the record.

VARCHAR2

6

HOME_DEPARTMENT_DESC

Home department desc associated with the record.

VARCHAR2

30

IS_COURSE_CONFIDNTL

Indicator identifying whether course confidntl (Y/N).

VARCHAR2

1

IS_DEGREE_CANDIDATE

Indicator identifying whether degree candidate (Y/N).

VARCHAR2

1

IS_EMAIL_CONFIDNTL

Is email confidntl associated with the record.

VARCHAR2

1

IS_INCOMING_NEW_STUDENT

Indicator identifying whether incoming new student (Y/N).

VARCHAR2

1

IS_OFFICE_ADDR_CONFIDNTL

Indicator identifying whether office addr confidntl (Y/N).

VARCHAR2

1

IS_OFFICE_PHONE_CONFIDNTL

Is office phone confidntl associated with the record.

VARCHAR2

1

IS_REGISTERED

Indicator identifying whether registered (Y/N).

VARCHAR2

1

LAST_NAME

Last name associated with the person or organization.

VARCHAR2

60

LAST_UGRAD_TERM_AT_MIT

Last ugrad term at mit associated with the record.

VARCHAR2

6

LOAD_LEVEL

Load level associated with the record.

VARCHAR2

50

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

OFFICE_LOCATION

Office location associated with the record.

VARCHAR2

30

OFFICE_PHONE

Office phone associated with the record.

VARCHAR2

9

REGISTRATION_GROUP

Registration group associated with the record.

VARCHAR2

50

REGISTRATION_TYPE

Registration type associated with the record.

VARCHAR2

50

UPCOMING_ACADEMIC_TERM

Upcoming academic term associated with the record.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE