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 Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP 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 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 Audit Academic period description Current audit academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

UCX_STU016

UCX_VALUE

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

STVTERM

STVTERM_ACYR_CODE

AUDIT_ACADEMIC_YEAR_DESC Academic year description Audit academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

AUDIT_RESULT_CREATE_DATE Create date Audit_Result_Create date. DATE

DAP_RESULT_DTL

DAP_CREATE_DATE

AUDIT_RESULT_KEY Result key Unique identication id. NUMBER

DAP_RESULT_DTL

UNIQUE_ID

AUDIT_TYPE 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 Audit type description. VARCHAR2(255)

CALCULATION

CASE WHEN DAP_AUDIT_TYPE

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

DAP_RESULT_DTL

DAP_REQ_ID

BLOCK_SEQUENCE_NUMBER 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 Block type Result type. VARCHAR2(255)

DAP_RESULT_DTL

DAP_RESULT_TYPE

DEGREE 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 Degree description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

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

UCX_STU307

UCX_VALUE

EXCEPTION_CLUSTER Cluster Exception cluster. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE3

EXCEPTION_COMMENT Comment Exception comment. VARCHAR2(255)

DAP_RESULT_DTL

DAP_FREETEXT

EXCEPTION_SEQUENCE Exception sequence Exception sequence. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE1

EXCEPTION_STATUS Exception status Exception status. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE4

EXCEPTION_TYPE Exception type Exception type. VARCHAR2(63)

DAP_RESULT_DTL

DAP_VALUE2

EXCEPTION_TYPE_DESC Exception type description Exception type description. VARCHAR2(255)

UCX_AUD014

UCX_VALUE

ID 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 Multi source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RAD_PRIMARY_MST

RAD_USER_DEF1

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

NA

NA

REQUEST_ID Request ID Exception request id. VARCHAR2(63)

DAP_RESULT_DTL

DAP_STU_ID

RESULT_SEQUENCE_NUMBER Sequence number Result sequence number. NUMBER

DAP_RESULT_DTL

DAP_RESULT_SEQ_NUM

STUDENT_LEVEL 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 Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

UCX_STU350

UCX_VALUE



Ver: 9.2