RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE 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 Definition Database Data Type Source Name Source Column
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 Date record was inserted or updated DATE

NA

SYSDATE

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 for the admission application record for a specific academic period. NUMBER

SARAPPD

SARAPPD_APPL_NO

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

SARAPPD

SARAPPD_APDC_CODE

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

SARAPPD

SARAPPD_APDC_CODE

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

SARAPPD

SARAPPD_APDC_CODE

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

SARAPPD

SARAPPD_APDC_CODE

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

SARAPPD

SARAPPD_APDC_CODE

DECISION_DATE1 Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE2 Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE3 Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE4 Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

DECISION_DATE5 Date application decision was applied. DATE

SARAPPD

SARAPPD_APDC_DATE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

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

SARAPPD

SARAPPD_PIDM

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

NA

NA



Ver: 3.1