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

Banner Operational Data Store
Reporting View Target: EXCEPTION_APPLIED - Exception Applied

Description This table contains detailed data for exceptions.
Key & Frequency One row per person uid, per exception number
Recommended Search Columns PERSON_UID,AUDIT_TYPE,STUDENT_LEVEL,DEGREE,BLOCK_ID
PERSON_UID,AUDIT_TYPE,EXCEPTION_TYPE,EXCEPTION_STATUS,EXCEPTION_SEQUENCE
AUDIT_RESULT_KEY

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

AUDIT_ACADEMIC_PERIOD Student's active academic period used in Degree Works for audits. VARCHAR2(63)

DAP_RESULT_DTL

DAP_ACTIVE_TERM

AUDIT_ACADEMIC_PERIOD_DESC Current audit academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

AUDIT_ACADEMIC_PERIOD_DESC_DW Current academic period description from Degree Works. VARCHAR2(255)

UCX_STU016

UCX_VALUE

AUDIT_ACADEMIC_YEAR Audit academic year associated with the academic period on this record. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

AUDIT_ACADEMIC_YEAR_DESC Audit academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

AUDIT_RESULT_CREATE_DATE Audit_Result_Create date. DATE

DAP_RESULT_DTL

DAP_CREATE_DATE

AUDIT_RESULT_KEY Unique identication id. NUMBER

DAP_RESULT_DTL

UNIQUE_ID

AUDIT_TYPE Audit type determining if this is an academic audit, finanical aid audit or athletic eligibility audit. VARCHAR2(63)

DAP_RESULT_DTL

DAP_AUDIT_TYPE

AUDIT_TYPE_DESC Audit type description. VARCHAR2(255)

CALCULATION

CASE WHEN DAP_AUDIT_TYPE

BLOCK_ID Block identification grouping a set of requirements. VARCHAR2(63)

DAP_RESULT_DTL

DAP_REQ_ID

BLOCK_SEQUENCE_NUMBER One up system generated sequence number associated to the block id in the order in which blocks are processed for the audit. NUMBER

DAP_RESULT_DTL

DAP_BLOCK_SEQ_NUM

BLOCK_TYPE Result type. VARCHAR2(255)

DAP_RESULT_DTL

DAP_RESULT_TYPE

DEGREE Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. VARCHAR2(63)

DAP_RESULT_DTL

DAP_DEGREE

DEGREE_DESC Degree description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

DEGREE_DESC_DW Degree description from Degree Works. VARCHAR2(255)

UCX_STU307

UCX_VALUE

EXCEPTION_CLUSTER Exception cluster. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE3

EXCEPTION_COMMENT Exception comment. VARCHAR2(255)

DAP_RESULT_DTL

DAP_FREETEXT

EXCEPTION_SEQUENCE Exception sequence. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE1

EXCEPTION_STATUS Exception status. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE4

EXCEPTION_TYPE Exception type. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE2

EXCEPTION_TYPE_DESC Exception type description. VARCHAR2(255)

UCX_AUD014

UCX_VALUE

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

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

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RAD_PRIMARY_MST

RAD_USER_DEF1

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

NA

NA

REQUEST_ID Exception request id. VARCHAR2(63)

DAP_RESULT_DTL

DAP_STU_ID

RESULT_SEQUENCE_NUMBER Result sequence number. NUMBER

DAP_RESULT_DTL

DAP_RESULT_SEQ_NUM

STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

DAP_RESULT_DTL

DAP_SCHOOL

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

STUDENT_LEVEL_DESC_DW Student level description from Degree Works. VARCHAR2(255)

UCX_STU350

UCX_VALUE



Ver: 9.1