Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ADMISSIONS_DECISION_SLOT

Description Uses data from the ADMISSIONS_DECISION reporting view. Displays up to 5 sets of values based on the last decisions recorded for the academic period and application number.
Key & Frequency One row per person per academic period per application number.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, APPLICATION_NUMBER
ACTIVITY_DATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period or time frame for requested entry via this application and decision record. VARCHAR2(63)  

SARAPPD

SARAPPD_TERM_CODE_ENTRY

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

NA

SYSDATE

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

APPLICATION_NUMBER Application Number Application number for the admission application record for a specific academic period. NUMBER  

SARAPPD

SARAPPD_APPL_NO

DECISION1 Decision 1 Value associated with the application number and decision for this academic period. VARCHAR2(63)  

SARAPPD

SARAPPD_APDC_CODE

DECISION2 Decision 2 Value associated with the application number and decision for this academic period. VARCHAR2(63)  

SARAPPD

SARAPPD_APDC_CODE

DECISION3 Decision 3 Value associated with the application number and decision for this academic period. VARCHAR2(63)  

SARAPPD

SARAPPD_APDC_CODE

DECISION4 Decision 4 Value associated with the application number and decision for this academic period. VARCHAR2(63)  

SARAPPD

SARAPPD_APDC_CODE

DECISION5 Decision 5 Value associated with the application number and decision for this academic period. VARCHAR2(63)  

SARAPPD

SARAPPD_APDC_CODE

DECISION_DATE1 Decision Date 1 Date application decision was applied. DATE  

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE2 Decision Date 2 Date application decision was applied. DATE  

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE3 Decision Date 3 Date application decision was applied. DATE  

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE4 Decision Date 4 Date application decision was applied. DATE  

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE5 Decision Date 5 Date application decision was applied. DATE  

SARAPPD

SARAPPD_APDC_DATE

DECISION_DESC1 Decision Description 1 Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DECISION_DESC2 Decision Description 2 Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DECISION_DESC3 Decision Description 3 Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DECISION_DESC4 Decision Description 4 Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

DECISION_DESC5 Decision Description 5 Decision code description such as applicant accepted, pending decision, quick admit. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER  

SARAPPD

SARAPPD_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA



Ver: 9.0