Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD TIME Table


View exposing graduate admissions time reference data including entry term, year, month, and academic year attributes used for graduate admissions reporting.


Field Name

Description

Data Type

Length

ACADEMIC_YEAR

Academic year as provided by the source.

VARCHAR2

4

ADM_GRAD_TIME_KEY

Surrogate key identifying the adm grad time.

VARCHAR2

6

ENTRY_MONTH

Entry month as provided by the source.

VARCHAR2

9

ENTRY_TERM

Entry term as provided by the source.

VARCHAR2

6

ENTRY_TERM_DESC

Description of entry term.

VARCHAR2

30

ENTRY_YEAR

Entry year as provided by the source.

VARCHAR2

4

ENTRY_YEAR_DESC

Description of entry year.

VARCHAR2

24

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE