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

Banner Operational Data Store
Reporting View Target: AUDIT_STUDENT_BLOCK - Audit Student Block

Description Contains data for a student audit on block credits and courses needed, block credits and courses required, block credits and courses counted, and block gpa as well as information about the block itself. Percentages for credits or courses completed by block and ranges that various counts or percentages fall into.
Key & Frequency One row per person uid, per block_sequence_number
Recommended Search Columns PERSON_UID,AUDIT_TYPE,REQUIRE_PCT_COMPLETE_RANGE
PERSON_UID,AUDIT_TYPE,CREDITS_PCT_COMPLETE_RANGE
PERSON_UID,AUDIT_TYPE,GPA_RANGE
PERSON_UID,AUDIT_TYPE,AUDIT_ACADEMIC_PERIOD,STUDENT_LEVEL,DEGREE,BLOCK_SEQUENCE_NUMBER

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(255)

NA

NA

NO

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

DAP_RESULT_DTL

DAP_ACTIVE_TERM

NO

NO
AUDIT_ACADEMIC_PERIOD_DESC Current audit academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

NO

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

UCX_STU016

UCX_VALUE

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
AUDIT_ACADEMIC_YEAR_DESC Audit academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

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

DAP_RESULT_DTL

DAP_AUDIT_TYPE

NO

NO
AUDIT_TYPE_DESC Audit type description. VARCHAR2(255)

CALCULATION

CASE WHEN DAP_AUDIT_TYPE

NO

NO
BLOCK_DESC Block title. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

DAP_REQ_BLOCK

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

TITLE

NO

NO

NO

NO

NO
BLOCK_GPA Block grade point average. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER2

NO

NO

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

DAP_RESULT_DTL

DAP_REQ_ID

NO

NO
BLOCK_QUALITY_POINTS Block quality points used in GPA calculation. NUMBER

DAP_RESULT_DTL

DAP_NUMBER3

NO

NO
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

NO

NO
BLOCK_TYPE Block categorization such as Degree, Major, Minor, Concentration, etc. VARCHAR2(63)

DAP_REQ_BLOCK

DAP_RESULT_DTL

BLOCK_TYPE

DAP_REQ_ID

NO

NO

NO
BLOCK_TYPE_DESC Block type description. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

UCX_SCR004

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

UCX_VALUE

NO

NO

NO

NO

NO
BLOCK_VALUE Value of the degree or major like BA for Bachelor of Arts degree or ANTH for a major in anthropology. VARCHAR2(63)

DAP_REQ_BLOCK

BLOCK_VALUE

NO

NO
BLOCK_VALUE_DESC Block value description. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

DAP_REQ_BLOCK

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

TITLE

NO

NO

NO

NO

NO
CATALOG_YEAR_END Last catalog year where the degree requirements were defined for the institution. VARCHAR2(63)

DAP_REQ_BLOCK

PERIOD_STOP

NO

NO
CATALOG_YEAR_END_DESC Catalog year end description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

NO
CATALOG_YEAR_START Earliest catalog year where the degree requirements were defined for the institution. VARCHAR2(63)

DAP_REQ_BLOCK

PERIOD_START

NO

NO
CATALOG_YEAR_START_DESC Catalog year start description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

NO
COURSES_APPLIED Number of courses counted. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

NO

NO
COURSES_APPLIED_RANGE Range that the number of block courses counted falls within based upon pre-defined cleansing rules. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
COURSES_APPLIED_RANGE_DESC Courses applied range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
COURSES_APPLIED_RANGE_ORDER Courses applied range order concatenated with courses applied range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
COURSES_NEEDED Number of courses needed. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER2

NO

NO

NO
COURSES_NEEDED_RANGE Range that the number of block courses needed falls within based upon pre-defined cleansing rules. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
COURSES_NEEDED_RANGE_DESC Courses needed range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
COURSES_NEEDED_RANGE_ORDER Courses needed range order concatenated with courses needed range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
COURSES_REQUIRED Minimum number of courses that must be taken. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

NO

NO
CREDITS_APPLIED Number of credits counted. NUMBER

DAP_RESULT_DTL

DAP_NUMBER1

NO

NO
CREDITS_APPLIED_RANGE Range that the number of block credits counted falls within based upon pre-defined cleansing rules. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
CREDITS_APPLIED_RANGE_DESC Credits applied range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_APPLIED_RANGE_ORDER Credits applied range order concatenated with credits applied range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_NEEDED Number of credits needed. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER1

NO

NO

NO
CREDITS_NEEDED_RANGE Range that the number of block credits needed falls within based upon pre-defined cleansing rules. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
CREDITS_NEEDED_RANGE_DESC Credits needed range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_NEEDED_RANGE_ORDER Credits needed range order concatenated with credits needed range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_PCT_CMPLETE_RANGE_DESC Credits percent complete range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_PCT_CMPLTE_RANGE_ORDER Credits percent complete range order concatenated with credits percent range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
CREDITS_PCT_COMPLETE_RANGE Range that the block percent credits complete falls within based upon pre-defined ODS EXTRACT PARAMETERS. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
CREDITS_PERCENT_COMPLETE Block credits percent complete. NUMBER

CONSTANT

0

NO

NO
CREDITS_REQUIRED Minimum number of credits that must be taken. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

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_RESULT_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
GPA_RANGE Range that the block GPA falls within based upon pre-defined ODS EXTRACT PARAMETERS. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
GPA_RANGE_DESC GPA range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
GPA_RANGE_ORDER GPA range order concatenated with GPA range description. VARCHAR2(255)

ETL GENERATED

NA

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
MINIMUM_GPA Minimum GPA required for the block. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

NO

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

NA

NA

NO

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

NA

NA

NO

NO
NAME Name of the student (Last name, First name Middle Initial format). VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
OVERFLOW_CREDITS Fall-through overflow credits. Used in calculation block percentage of credit completed for block sequence 1. NUMBER

DAP_RESULT_DTL

DAP_NUMBER4

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(255)

NA

NA

NO

NO
REQUIRE_PCT_CMPLETE_RANGE_DESC Requirements percent complete range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
REQUIRE_PCT_CMPLTE_RANGE_ORDER Requirements percent complete range order concatenated with requirements percent range description. VARCHAR2(255)

ETL GENERATED

NA

NO

NO
REQUIRE_PCT_COMPLETE_RANGE Range that the block percent requirements complete falls within based upon pre-defined ODS EXTRACT PARAMETERS. VARCHAR2(63)

ETL GENERATED

NA

NO

NO
REQUIRE_PERCENT_COMPLETE Block requirements percent complete. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER1

NO

NO

NO
STUDENT_CLASSIFICATION Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc.. VARCHAR2(63)

FUNCTION

SOKODSF.F_CLASS_CALC_FNC

NO

NO
STUDENT_CLASSIFICATION_DESC Student classification description. VARCHAR2(255)

STVLCLAS

STVCLAS_DESC

NO

NO
STUDENT_CLASSIFICATION_DESC_DW Student classification description from Degree Works. VARCHAR2(255)

CONSTANT

NULL

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_RESULT_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