Reporting View Target: AUDIT_STUDENT_BLOCK

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

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