Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT GRAD GEN EXAM DETAIL Table


View exposing student grad gen exam detail data.


Field Name

Description

Data Type

Length

GENERAL_EXAM_TAKEN_DATE

Date associated with general exam taken.

DATE

GENERAL_EXAM_TAKEN_TERM

General exam taken term associated with the record.

VARCHAR2

6

HOME_DEPARTMENT

Home department associated with the record.

VARCHAR2

6

IS_EARLIEST_EXAM_DATE

Date associated with is earliest exam.

VARCHAR2

1

IS_LATEST_EXAM_DATE

Date associated with is latest exam.

VARCHAR2

1

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE