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 |