Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD DECISION Table


This table contains all the decision status (e.g. 'Admitted','Not Admitted','Wait Listed') of the graduate admissions application.


Field Name

Description

Data Type

Length

ADM_GRAD_DECISION_KEY

Graduate Admissions Decision Status Key. Use this field to join the ADM GRAD DECISION table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

7

DECISION_CODE

The code of the decision made regarding the application. Some of the valid codes are: A (Admitted), N (Not Admitted), WL (Wait Listed).

VARCHAR2

3

DECISION_DESC

The descriptive text of the Decision Code.

VARCHAR2

30

DECISION_OFFICIAL_CODE

The code of the official decision.

VARCHAR2

4

DECISION_OFFICIAL_STATUS

The status of the decision made. Eg: 'Official', 'Not Official','Not Available'

VARCHAR2

30

IS_ADMITTED

A Y/N flag indicates whether the application has been admitted to the program.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE

8