Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT GRAD GEN EXAM DETAIL Table


This table contains graduate students' general exam credit dates.


Field Name

Description

Data Type

Length

GENERAL_EXAM_TAKEN_DATE

XXX

DATE

8

GENERAL_EXAM_TAKEN_TERM

XXX

VARCHAR2

6

HOME_DEPARTMENT

The home (major) department of a person.

VARCHAR2

4

IS_EARLIEST_EXAM_DATE

XXX

VARCHAR2

1

IS_LATEST_EXAM_DATE

XXX

VARCHAR2

1

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

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

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

DATE

8