ADM GRAD APPLICATION DETAIL Table
View exposing graduate application detail including applicant, time, program, degree objective, decision, reply, demographic, citizenship, fee, and address-related attributes used for graduate admissions reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_APPLICANT_KEY |
Surrogate key identifying the adm grad applicant. |
VARCHAR2 |
8 |
ADM_GRAD_APPLICATION_KEY |
Surrogate key identifying the adm grad application. |
VARCHAR2 |
10 |
ADM_GRAD_ATTD_SCH_1_KEY |
Surrogate key identifying the adm grad attd sch 1. |
VARCHAR2 |
27 |
ADM_GRAD_ATTD_SCH_2_KEY |
Surrogate key identifying the adm grad attd sch 2. |
VARCHAR2 |
27 |
ADM_GRAD_CITIZENSHIP_KEY |
Surrogate key identifying the adm grad citizenship. |
VARCHAR2 |
4 |
ADM_GRAD_DECISION_KEY |
Surrogate key identifying the adm grad decision. |
VARCHAR2 |
7 |
ADM_GRAD_DEGREE_OBJECTIVE_KEY |
Surrogate key identifying the adm grad degree objective. |
VARCHAR2 |
6 |
ADM_GRAD_DEMOGRAPHIC_KEY |
Surrogate key identifying the adm grad demographic. |
VARCHAR2 |
6 |
ADM_GRAD_ENROLL_SCHOOL_KEY |
Surrogate key identifying the adm grad enroll school. |
VARCHAR2 |
7 |
ADM_GRAD_FEE_STATUS_KEY |
Surrogate key identifying the adm grad fee status. |
VARCHAR2 |
2 |
ADM_GRAD_HOME_ADDR_GEO_KEY |
Surrogate key identifying the adm grad home addr geo. |
VARCHAR2 |
10 |
ADM_GRAD_PROGRAM_KEY |
Surrogate key identifying the adm grad program. |
VARCHAR2 |
21 |
ADM_GRAD_REPLY_ADDR_GEO_KEY |
Surrogate key identifying the adm grad reply addr geo. |
VARCHAR2 |
10 |
ADM_GRAD_REPLY_KEY |
Surrogate key identifying the adm grad reply. |
VARCHAR2 |
3 |
ADM_GRAD_SURVEY_KEY |
Surrogate key identifying the adm grad survey. |
VARCHAR2 |
10 |
ADM_GRAD_TIME_KEY |
Surrogate key identifying the adm grad time. |
VARCHAR2 |
6 |
APPLICATION_COUNT |
Count value for application count. |
NUMBER |
|
APPLICATION_CREATED_BY |
Application created by as provided by the source. |
VARCHAR2 |
20 |
APPLICATION_CREATED_DATE |
Date associated with application created. |
DATE |
|
APPLICATION_RECEIVED_DATE |
Date associated with application received. |
DATE |
|
APPLICATION_SOURCE |
Application source as provided by the source. |
VARCHAR2 |
30 |
APPLICATION_UPDATED_BY |
Application updated by as provided by the source. |
VARCHAR2 |
20 |
APPLICATION_UPDATED_DATE |
Date associated with application updated. |
DATE |
|
DECISION_MADE_OFFICIAL_BY |
Decision made official by as provided by the source. |
VARCHAR2 |
20 |
DECISION_OFFICIAL_DATE |
Date associated with decision official. |
DATE |
|
LATEST_DECISION_DATE |
Date associated with latest decision. |
DATE |
|
LATEST_REPLY_DATE |
Date associated with latest reply. |
DATE |
|
ONLINE_APPLICATION_ID |
Business identifier for the online application. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |