Reporting View Target: AUDIT_STUDENT_NON_COURSE

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_NON_COURSE - Audit Student Non-Course

Description Contains student audit non-course results and details for non-courses counted, courses needed,and fall-through courses counted. If non-courses are needed, they are identified as may take, must take, or can't take. If non-courses are counted, then their equivalent non-course details are displayed.
Key & Frequency One row per person uid, per result_sequence_number
Recommended Search Columns AUDIT_RESULT_KEY
PERSON_UID, AUDIT_TYPE, NON_COURSE
PERSON_UID, AUDIT_TYPE, STUDENT_LEVEL, DEGREE, BLOCK_ID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)
DAP_RESNONCR_DTL

DAP_TERM

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_DESC_DW Academic Period Description Dw Current academic period description from Degree Works. VARCHAR2(255)
UCX_STU016

UCX_VALUE

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)
STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Audit academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

ADMINISTRATIVE_GROUP 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 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 Dw Current academic period description from Degree Works. VARCHAR2(255)
UCX_STU016

UCX_VALUE

AUDIT_ACADEMIC_YEAR 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 Audit academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

AUDIT_NON_COURSE_KEY Audit Non Course KEY Unique system generated sequence number associated to each audit non-course result row. NUMBER
DAP_RESNONCR_DTL

UNIQUE_ID

AUDIT_RESULT_CREATE_DATE Audit Result Create Date Date the audit results were created. DATE
DAP_RESULT_DTL

DAP_CREATE_DATE

AUDIT_RESULT_KEY Audit Result KEY Unique system generated sequence number associated to each audit result row. NUMBER
DAP_RESULT_DTL

UNIQUE_ID

AUDIT_RESULT_TYPE Audit Result Type Result type identified in the student audit such as CLASSAPPLIED or FALLCLASSNEEDED. VARCHAR2(63)
DAP_RESULT_DTL

DAP_RESULT_TYPE

AUDIT_RESULT_TYPE_DESC Audit Result Type Description Audit result type description. VARCHAR2(255)
CALCULATION

CASE WHEN DAP_RESULT_TYPE

AUDIT_RUN_DATE Audit Run Date Date the audit was run. DATE
CALCULATION

DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'

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

CASE WHEN DAP_AUDIT_TYPE

BLOCK_DESC Block Description Block title. VARCHAR2(255)
CONSTANT
DAP_REQ_BLOCK
DAP_REQ_MST

'FALL-THROUGH NON-COURSES'
TITLE
DAP_REQ_TITLE

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

DAP_REQ_ID

BLOCK_RULE_ID Block Rule ID Rule identification associated with a rule used in a scribed block. VARCHAR2(63)
CONSTANT
DAP_RESULT_DTL

'NA'
DAP_RULE_ID

BLOCK_RULE_LABEL Block Rule Label Label text uniquely identifying the rule within the block. VARCHAR2(255)
CONSTANT
DAP_RESULT_DTL

'NA'
DAP_FREETEXT

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

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 Dw Degree description from Degree Works. VARCHAR2(255)
UCX_STU307

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(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

MGKFUNC.F_GET_PERSON_INFO

NONCOURSE_APPLIED_IND Noncourse Applied Indicator Indicates whether this non-course was applied in the audit. VARCHAR2(1)
CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'

NONCOURSE_FALLTHROUGH_IND Noncourse Fallthrough Indicator Indicates whether this non-course was placed in the fall-through section for the audit. VARCHAR2(1)
CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'

NONCOURSE_NEEDED_IND Noncourse Needed Indicator Indicates whether this non-course was needed in the audit. VARCHAR2(1)
CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'

NON_COURSE Non Course Non-course. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE1

NON_COURSE_DESC Non Course Description Non-course description. VARCHAR2(255)
STVNCRQ
STVQPTP

STVNCRQ_DESC
STVQPTP_DESC

NON_COURSE_DESC_DW Non Course Description Dw Non-course description from Degree Works. VARCHAR2(255)
DAP_RESNONCR_DTL

DAP_COURSE_TITLE

NON_COURSE_INTERNAL_KEY Non Course Internal KEY Unique system generated sequence number associated to each course or non-course for that student. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE3

NON_COURSE_OPERATOR Non Course Operator Operator like > or = used with the non-course and non-course value. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE2

NON_COURSE_STATUS Non Course Status Non-course requirement status. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE2

NON_COURSE_STATUS_DESC Non Course Status Description Non-course requirement status description. VARCHAR2(255)
STVNCST

STVNCST_DESC

NON_COURSE_VALUE Non Course Value Non-course value. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE3

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

RAD_USER_DEF1

PLANNED_NON_COURSE_IND Planned Non Course Indicator Indicates whether the non-course is planned for an audit type of planning. Functional after Degree Works upgrade to 4.1.4. VARCHAR2(1)
CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'

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

NA

RESULT_SEQUENCE_NUMBER Result Sequence Number One up system generated sequence number associated to each result recorded for the block id in the order in which rules are processed for the audit. NUMBER
DAP_RESULT_DTL

DAP_RESULT_SEQ_NUM

RULE_NON_COURSES_NEEDED Rule Non Courses Needed Number of non-courses still needed on the rule. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE2

STUDENT_CLASSIFICATION 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 Student classification description. VARCHAR2(255)
STVLCLAS

STVCLAS_DESC

STUDENT_CLASSIFICATION_DESC_DW Student Classification Description Dw Student classification description. VARCHAR2(255)
CONSTANT

NULL

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 Course level description. VARCHAR2(255)
STVLEVL

STVLEVL_DESC

STUDENT_LEVEL_DESC_DW Student Level Description Dw Student level description from Degree Works. VARCHAR2(255)
UCX_STU350

UCX_VALUE

TAKE_TYPE Take Type Determines if the course must be taken, or may be taken or can't be taken. VARCHAR2(63)
DAP_RESULT_DTL

DAP_VALUE4

TAKE_TYPE_DESC Take Type Description Course take type description. VARCHAR2(255)
FUNCTION

CASE WHEN DAP_VALUE4

Ver: 9.0

Description	Contains student audit non-course results and details for non-courses counted, courses needed,and fall-through courses counted. If non-courses are needed, they are identified as may take, must take, or can't take. If non-courses are counted, then their equivalent non-course details are displayed.
Key & Frequency	One row per person uid, per result_sequence_number
Recommended Search Columns	AUDIT_RESULT_KEY PERSON_UID, AUDIT_TYPE, NON_COURSE PERSON_UID, AUDIT_TYPE, STUDENT_LEVEL, DEGREE, BLOCK_ID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	DAP_RESNONCR_DTL	DAP_TERM
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_DESC_DW	Academic Period Description Dw	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Audit academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	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	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 Dw	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE
AUDIT_ACADEMIC_YEAR	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	Audit academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
AUDIT_NON_COURSE_KEY	Audit Non Course KEY	Unique system generated sequence number associated to each audit non-course result row.	NUMBER	DAP_RESNONCR_DTL	UNIQUE_ID
AUDIT_RESULT_CREATE_DATE	Audit Result Create Date	Date the audit results were created.	DATE	DAP_RESULT_DTL	DAP_CREATE_DATE
AUDIT_RESULT_KEY	Audit Result KEY	Unique system generated sequence number associated to each audit result row.	NUMBER	DAP_RESULT_DTL	UNIQUE_ID
AUDIT_RESULT_TYPE	Audit Result Type	Result type identified in the student audit such as CLASSAPPLIED or FALLCLASSNEEDED.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_RESULT_TYPE
AUDIT_RESULT_TYPE_DESC	Audit Result Type Description	Audit result type description.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_RESULT_TYPE
AUDIT_RUN_DATE	Audit Run Date	Date the audit was run.	DATE	CALCULATION	DAP_VALUE2 \|\| DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'
AUDIT_TYPE	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	Audit type description.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_AUDIT_TYPE
BLOCK_DESC	Block Description	Block title.	VARCHAR2(255)	CONSTANT DAP_REQ_BLOCK DAP_REQ_MST	'FALL-THROUGH NON-COURSES' TITLE DAP_REQ_TITLE
BLOCK_ID	Block ID	Block identification grouping a set of requirements.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_REQ_ID
BLOCK_RULE_ID	Block Rule ID	Rule identification associated with a rule used in a scribed block.	VARCHAR2(63)	CONSTANT DAP_RESULT_DTL	'NA' DAP_RULE_ID
BLOCK_RULE_LABEL	Block Rule Label	Label text uniquely identifying the rule within the block.	VARCHAR2(255)	CONSTANT DAP_RESULT_DTL	'NA' DAP_FREETEXT
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
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 Dw	Degree description from Degree Works.	VARCHAR2(255)	UCX_STU307	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(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the student (Last name, First name Middle Initial format).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NONCOURSE_APPLIED_IND	Noncourse Applied Indicator	Indicates whether this non-course was applied in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'
NONCOURSE_FALLTHROUGH_IND	Noncourse Fallthrough Indicator	Indicates whether this non-course was placed in the fall-through section for the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'
NONCOURSE_NEEDED_IND	Noncourse Needed Indicator	Indicates whether this non-course was needed in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'
NON_COURSE	Non Course	Non-course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1
NON_COURSE_DESC	Non Course Description	Non-course description.	VARCHAR2(255)	STVNCRQ STVQPTP	STVNCRQ_DESC STVQPTP_DESC
NON_COURSE_DESC_DW	Non Course Description Dw	Non-course description from Degree Works.	VARCHAR2(255)	DAP_RESNONCR_DTL	DAP_COURSE_TITLE
NON_COURSE_INTERNAL_KEY	Non Course Internal KEY	Unique system generated sequence number associated to each course or non-course for that student.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3
NON_COURSE_OPERATOR	Non Course Operator	Operator like > or = used with the non-course and non-course value.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
NON_COURSE_STATUS	Non Course Status	Non-course requirement status.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
NON_COURSE_STATUS_DESC	Non Course Status Description	Non-course requirement status description.	VARCHAR2(255)	STVNCST	STVNCST_DESC
NON_COURSE_VALUE	Non Course Value	Non-course value.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST	RAD_USER_DEF1
PLANNED_NON_COURSE_IND	Planned Non Course Indicator	Indicates whether the non-course is planned for an audit type of planning. Functional after Degree Works upgrade to 4.1.4.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RESULT_SEQUENCE_NUMBER	Result Sequence Number	One up system generated sequence number associated to each result recorded for the block id in the order in which rules are processed for the audit.	NUMBER	DAP_RESULT_DTL	DAP_RESULT_SEQ_NUM
RULE_NON_COURSES_NEEDED	Rule Non Courses Needed	Number of non-courses still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2
STUDENT_CLASSIFICATION	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	Student classification description.	VARCHAR2(255)	STVLCLAS	STVCLAS_DESC
STUDENT_CLASSIFICATION_DESC_DW	Student Classification Description Dw	Student classification description.	VARCHAR2(255)	CONSTANT	NULL
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	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_LEVEL_DESC_DW	Student Level Description Dw	Student level description from Degree Works.	VARCHAR2(255)	UCX_STU350	UCX_VALUE
TAKE_TYPE	Take Type	Determines if the course must be taken, or may be taken or can't be taken.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE4
TAKE_TYPE_DESC	Take Type Description	Course take type description.	VARCHAR2(255)	FUNCTION	CASE WHEN DAP_VALUE4