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

SGHE 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
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

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

AUDIT_TYPE_DESC Audit type description. VARCHAR2(255)

CALCULATION

CASE WHEN DAP_AUDIT_TYPE

BLOCK_DESC Block title. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

DAP_REQ_MST

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

DAP_REQ_TITLE

BLOCK_GPA Block grade point average. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER2

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

DAP_RESULT_DTL

DAP_REQ_ID

BLOCK_QUALITY_POINTS Block quality points used in GPA calculation. NUMBER

DAP_RESULT_DTL

DAP_NUMBER3

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 categorization such as Degree, Major, Minor, Concentration, etc. VARCHAR2(63)

DAP_REQ_MST

DAP_RESULT_DTL

DAP_BLOCK_TYPE

DAP_REQ_ID

BLOCK_TYPE_DESC Block type description. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

UCX_SCR004

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

UCX_VALUE

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_MST

DAP_BLOCK_VALUE

BLOCK_VALUE_DESC Block value description. VARCHAR2(255)

CONSTANT

CONSTANT

CONSTANT

DAP_REQ_MST

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT COURSES'

DAP_REQ_TITLE

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

DAP_REQ_MST

DAP_CAT_YR_STOP

CATALOG_YEAR_END_DESC Catalog year end description. VARCHAR2(255)

STVACYR

STVACYR_DESC

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

DAP_REQ_MST

DAP_CAT_YR_START

CATALOG_YEAR_START_DESC Catalog year start description. VARCHAR2(255)

STVACYR

STVACYR_DESC

COURSES_APPLIED Number of courses counted. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

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

ETL GENERATED

NA

COURSES_APPLIED_RANGE_DESC Courses applied range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

COURSES_NEEDED Number of courses needed. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER2

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

ETL GENERATED

NA

COURSES_NEEDED_RANGE_DESC Courses needed range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

COURSES_REQUIRED Minimum number of courses that must be taken. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

CREDITS_APPLIED Number of credits counted. NUMBER

DAP_RESULT_DTL

DAP_NUMBER1

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

ETL GENERATED

NA

CREDITS_APPLIED_RANGE_DESC Credits applied range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

CREDITS_NEEDED Number of credits needed. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER1

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

ETL GENERATED

NA

CREDITS_NEEDED_RANGE_DESC Credits needed range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

CREDITS_PCT_CMPLETE_RANGE_DESC Credits percent complete range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

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

CREDITS_PERCENT_COMPLETE Block credits percent complete. NUMBER

CONSTANT

0

CREDITS_REQUIRED Minimum number of credits that must be taken. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

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

GPA_RANGE Range that the block GPA falls within based upon pre-defined ODS EXTRACT PARAMETERS. VARCHAR2(63)

ETL GENERATED

NA

GPA_RANGE_DESC GPA range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

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

MINIMUM_GPA Minimum GPA required for the block. NUMBER

DAP_RESULT_DTL

DAP_NUMBER2

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

DAP_RESULT_DTL

DAP_NUMBER4

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

NA

NA

REQUIRE_PCT_CMPLETE_RANGE_DESC Requirements percent complete range description. VARCHAR2(255)

ETL GENERATED

NA

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

ETL GENERATED

NA

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

REQUIRE_PERCENT_COMPLETE Block requirements percent complete. NUMBER

CONSTANT

DAP_RESULT_DTL

0

DAP_NUMBER1

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

STUDENT_CLASSIFICATION_DESC Student classification description. VARCHAR2(255)

STVLCLAS

STVCLAS_DESC

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

CONSTANT

NULL

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: 8.5