RETURN TO BANNER EDW META DATA REPORTS LIST
Application Decision Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_APPLICATION_DECISION

Description Application Decision Dimension table provides general information relative to decisions on an application.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
APPLICANT_ACCEPT_IND Identifies whether student acceptance is indicated by the decision. VARCHAR2(63)

ADMISSIONS_DECISION

APPLICANT_ACCEPT_IND

NO

NO APPLICATION DECISION
APPLICATION_DECISION_KEY Key for the application decision dimension. NUMBER

ETL GENERATED

NA

NO

NO APPLICATION DECISION
APPLICATION_INACTIVE_IND Identifies whether decision causes the application to become inactive. VARCHAR2(63)

ADMISSIONS_DECISION

APPLICATION_INACTIVE_IND

NO

NO APPLICATION DECISION
DECISION Value associated with the application number and decision for this academic period. VARCHAR2(63)

ADMISSIONS_DECISION

DECISION

NO

NO APPLICATION DECISION
DECISION_LD Long description of the application decision. VARCHAR2(255)

ADMISSIONS_DECISION

DECISION_DESC

NO

NO APPLICATION DECISION
DECISION_SD Short description of the application decision. VARCHAR2(255)

ADMISSIONS_DECISION

DECISION_DESC

NO

NO APPLICATION DECISION
DECISION_SOURCE Identifies whether this decision is an institution decision or applicant decision. VARCHAR2(63)

ADMISSIONS_DECISION

DECISION_SOURCE

NO

NO APPLICATION DECISION
DECISION_SOURCE_LD Long description for the decision is an institution decision or applicant decision. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO APPLICATION DECISION
DECISION_SOURCE_SD Short description for the decision is an institution decision or applicant decision. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO APPLICATION DECISION
INSTITUTION_ADMIT_IND Identifies whether institutional acceptance of application is indicated by the decision. VARCHAR2(63)

ADMISSIONS_DECISION

INSTITUTION_ADMIT_IND

NO

NO APPLICATION DECISION
INSTITUTION_DENIED_IND This field indicates that the decision code is a reject decision. VARCHAR2(63)

ADMISSIONS_DECISION

INSTITUTION_DENIED_IND

NO

NO APPLICATION DECISION
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO APPLICATION DECISION
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO APPLICATION DECISION


Ver: 9.0