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

Banner Operational Data Store
Reporting View Target: EXCEPTION_DETAIL - Exception Detail

Description This table depicts Exceptions applied
Key & Frequency One row per person uid, per exception sequence
Recommended Search Columns PERSON_UID,STUDENT_LEVEL,DEGREE,BLOCK_ID
PERSON_UID,EXCEPTION_TYPE,EXCEPTION_STATUS
AUDIT_KEY

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

NA

NA

NO

NO
APPLY_STATUS Exception apply status. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_APPLY_STATUS

NO

NO
AUDIT_CREATE_DATE Created date. DATE

DAP_EXCEPT_DTL

DAP_CREATE_DATE

NO

NO
AUDIT_CREATE_ID Created user id. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_CREATE_ID

NO

NO
AUDIT_CREATE_USER Created user. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_CREATE_WHO

NO

NO
AUDIT_KEY Unique identication id. NUMBER

DAP_EXCEPT_DTL

UNIQUE_ID

NO

NO
AUDIT_LAST_USER Exception last modified user. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_USER_LAST

NO

NO
AUDIT_MODIFIED_DATE Exception modified date. DATE

DAP_EXCEPT_DTL

DAP_MOD_DATE

NO

NO
AUDIT_MODIFIED_DETAIL Exception modified details. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_WHAT

NO

NO
AUDIT_MODIFIED_ID Exception modified user id. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_MOD_ID

NO

NO
AUDIT_MODIFIED_TIME Exception modified time. DATE

DAP_EXCEPT_DTL

DAP_TIMESTAMP

NO

NO
BLOCK_DESC Block title. VARCHAR2(255)

CONSTANT

'EXCEPTION'

NO

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

DAP_EXCEPT_DTL

DAP_REQ_ID

NO

NO
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_EXCEPT_DTL

DAP_DEGREE

NO

NO
DEGREE_DESC Degree description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

NO

NO
DEGREE_DESC_DW Degree description from Degree Works. VARCHAR2(255)

UCX_STU307

UCX_VALUE

NO

NO
EXCEPTION_BUFFER Exception buffer. VARCHAR2(255)

DAP_EXCEPT_DTL

DAP_EXC_BUFFER

NO

NO
EXCEPTION_CLUSTER Exception Cluster. VARCHAR2(4)

DAP_EXCEPT_DTL

DAP_EXC_CLUSTER

NO

NO
EXCEPTION_DETAILS Exception details. VARCHAR2(255)

DAP_EXCEPT_DTL

DAP_EXC_DETAILS

NO

NO
EXCEPTION_LABEL Exception label. VARCHAR2(255)

DAP_EXCEPT_DTL

DAP_EXC_LABEL

NO

NO
EXCEPTION_NUMBER Exception number. NUMBER

DAP_EXCEPT_DTL

DAP_EXC_NUM

NO

NO
EXCEPTION_OLD_REQUEST Exception old request. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_EXC_REQ_OLD

NO

NO
EXCEPTION_REMARK Exception remark. VARCHAR2(255)

DAP_EXCEPT_DTL

DAP_EXC_REMARK

NO

NO
EXCEPTION_STATUS Exception status. VARCHAR2(2)

DAP_EXCEPT_DTL

DAP_EXC_STATUS

NO

NO
EXCEPTION_STATUS_DESC Exception status description. VARCHAR2(255)

UCX_AUD015

UCX_VALUE

NO

NO
EXCEPTION_TYPE Exception type. VARCHAR2(2)

DAP_EXCEPT_DTL

DAP_EXC_TYPE

NO

NO
EXCEPTION_TYPE_DESC Exception type description. VARCHAR2(255)

UCX_AUD014

UCX_VALUE

NO

NO
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

NO

NO
LABEL_TAG Label tag. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_LABEL_TAG

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
NODE_ID Node identification number. NUMBER

DAP_EXCEPT_DTL

DAP_NODE_ID

NO

NO
NODE_NUM Node number. NUMBER

DAP_EXCEPT_DTL

DAP_NOTE_NUM

NO

NO
NODE_TYPE Node type. NUMBER

DAP_EXCEPT_DTL

DAP_NODE_TYPE

NO

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

RAD_PRIMARY_MST

RAD_USER_DEF1

NO

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

NA

NA

NO

NO
REQUEST_ID Exception request id. VARCHAR2(63)

DAP_EXCEPT_DTL

DAP_STU_ID

NO

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

DAP_EXCEPT_DTL

DAP_SCHOOL

NO

NO
STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

NO

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

UCX_STU350

UCX_VALUE

NO

NO


Ver: 9.2