Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD REPLY Table


This table contains all the reply status (e.g. 'Accepts offer','Not enrolling','Defer Enrollment') of the graduate admissions application.


Field Name

Description

Data Type

Length

ADM_GRAD_REPLY_KEY

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

VARCHAR2

3

IS_ENROLLING

A Y/N flag indicating whether the applicant is going to enroll in the program.

VARCHAR2

1

REPLY_CODE

The coded reply/answer of the applicant regarding his/her admittance to the program. Some of the valid codes are: A (Accepts Offer), DF (Defer Enrollment), N (Not Enrolling), N/A (Not Available).

VARCHAR2

3

REPLY_DESC

The descriptive text of the REPLY CODE

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8