Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD DECISION Table


View exposing graduate admissions decision reference data including decision codes, official status, and admit indicators used for graduate admissions reporting.


Field Name

Description

Data Type

Length

ADM_GRAD_DECISION_KEY

Surrogate key identifying the adm grad decision.

VARCHAR2

6

DECISION_CODE

Code identifying decision.

VARCHAR2

3

DECISION_DESC

Description of decision.

VARCHAR2

30

DECISION_OFFICIAL_CODE

Code identifying decision official.

VARCHAR2

4

DECISION_OFFICIAL_STATUS

Decision official status as provided by the source.

VARCHAR2

30

IS_ADMITTED

Indicator identifying whether admitted (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE