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_COURSE - Audit Student Course

Description Contains student audit course results and details for courses counted, courses needed, fall-through courses counted, insufficient courses counted and over-the-limit courses. If courses are needed, they are identified as may take, must take, or can't take. If courses are counted, then their equivalent course details are displayed such as grade, transfer or repeat course information. Also contains courses and credits required for the requirement rule associate with the course.
Key & Frequency One row per person uid, per result_sequence_number
Recommended Search Columns AUDIT_RESULT_KEY
PERSON_UID, AUDIT_TYPE, COURSE_IDENTIFICATION
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_RESCLASS_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 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

ADVICE_DESC Advice Description Advice description. VARCHAR2(255)  

DAP_RESULT_DTL

DAP_FREETEXT

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 Degree Works 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_COURSE_KEY Audit Course KEY Unique system generated sequence number associated to each audit course result row. NUMBER  

DAP_RESCLASS_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

CONSTANT

CONSTANT

DAP_REQ_BLOCK

DAP_REQ_MST

'FALL-THROUGH COURSES'

'INSUFFICIENT COURSES'

'OVER-THE-LIMIT 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

CAMPUS Campus Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_LOCATION

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)  

STVCAMP

STVCAMP_DESC

CAMPUS_DESC_DW Campus Description Dw Institution campus name for Degree Works. VARCHAR2(255)  

UCX_STU576

UCX_VALUE

COURSE_APPLIED_IND Course Applied Indicator Indicates whether this course was applied in the audit. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED'

COURSE_CREDITS Course Credits Credits associated with this course. NUMBER  

DAP_RESCLASS_DTL

DAP_SS_CREDITS

COURSE_CREDITS_DW Course Credits Dw Credits associated with this course audited in Degree Works. NUMBER  

DAP_RESCLASS_DTL

DAP_AUD_CREDITS

COURSE_CREDIT_TYPE Course Credit Type Course credit type. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_TRANSFER_TYPE

COURSE_CREDIT_TYPE_DESC Course Credit Type Description Course credit type description. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_TRANSFER_TYPE

COURSE_FALLTHROUGH_IND Course Fallthrough Indicator Indicates whether this course was placed in the fall-through section for the audit. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'FALLCLASSAPPLIED'

COURSE_IDENTIFICATION Course Identification Course subject and course number combined. VARCHAR2(63)  

CALCULATION

DAP_VALUE1 || DAP_VALUE2

COURSE_INSUFFICIENT_IND Course Insufficient Indicator Indicates whether this course was placed in the insufficient section for the audit. Counted toward the degree GPA. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'INSUFFCLASSAPPLIED'

COURSE_INTERNAL_KEY 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

COURSE_NEEDED_IND Course Needed Indicator Indicates whether this course was needed in the audit. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'CLASSNEEDED'

COURSE_NUMBER Course Number Course number associated with the subject for the course. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE2

COURSE_OVER_THE_LIMIT_IND Course Over The Limit Indicator Indicates whether this course was placed in the over-the-limit section for the audit. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'OTLCLASSAPPLIED'

COURSE_PASSED_IND Course Passed Indicator Indicates whether the course section counts as a passed course and the course credits are added to the passed credits based on the final grade assigned to the person. VARCHAR2(1)  

DAP_RESCLASS_DTL

DAP_PASS

COURSE_REFERENCE_NUMBER Course Reference Number Computer assigned internal unique number for the schedule offering. VARCHAR2(63)  

NA

NULL

COURSE_SOURCE Course Source Indicates the source of the course VARCHAR2(63)  

CALCULATION

CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')

COURSE_SOURCE_DESC Course Source Description Course source description. VARCHAR2(255)  

CALCULATION

CASE WHEN (C.DAP_TRANSFER = 'C') AND (C.DAP_INPROGRESS = 'N')

COURSE_STATUS Course Status Course status. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_CLASS_STATUS

COURSE_STATUS_DESC Course Status Description Course status description. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_CLASS_STATUS

COURSE_TITLE_SHORT Course Title Short Course title short. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_COURSE_TITLE

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

FINAL_GRADE Final Grade Grade earned by the student for this course. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_GRADE

GPA_CREDITS GPA - Grade Point Average or Average Credits Credits associated with this course counted toward the GPA. NUMBER  

DAP_RESCLASS_DTL

DAP_GPA_CREDITS

GPA_QUALITY_POINTS GPA - Grade Point Average or Average Quality Points   NUMBER  

DAP_RESCLASS_DTL

DAP_GPA_GRD_PTS

GRADE_TYPE Grade Type Grade mode associated with this section or offering of the course. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_GRADE_TYPE

GRADE_TYPE_DESC Grade Type Description Grade type description. VARCHAR2(255)  

STVGMOD

STVGMOD_DESC

GRADE_TYPE_DESC_DW Grade Type Description Dw Grade type description for Degree Works. VARCHAR2(255)  

UCX_STU356

UCX_VALUE

GRADE_VALUE Grade Value Numeric value assigned to a grade symbol to be used to measure course performance statistics. This will only be present if a final grade has been recorded for either in progress or grades rolled to history for the student course. NUMBER  

DAP_RESCLASS_DTL

DAP_GRADE_NUM

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

INCOMPLETE_GRADE_IND Incomplete Grade Indicator Indicates whether the grade is an incomplete grade. VARCHAR2(1)  

DAP_RESCLASS_DTL

DAP_INCOMPLETE

INSTITUTION_COURSE_IND Institution Course Indicator Indicates whether the subject or course was taken at this institution and is in academic history. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_TRANSFER = 'C' AND DAP_INPROGRESS = 'N'

INSUFFICIENT_REASON Insufficient Reason Reason why the course is in the insufficient section. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_REASON_INSUF

INSUFFICIENT_REASON_DESC Insufficient Reason Description Insufficient reason description. VARCHAR2(255)  

CALCULATION

CASE WHEN DAP_REASON_INSUF

IN_PROGRESS_COURSE_IND In Progress Course Indicator Indicates whether the course is in progress and not yet graded. VARCHAR2(1)  

CALCULATION

CASE WHEN R.DAP_RESULT_TYPE = 'CLASSNEEDED' THEN 'N' WHEN R.DAP_RESULT_TYPE <> 'CLASSNEEDED' AND R.DAP_AUDIT_TYPE = 'PL'

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

PASS_FAIL_GRADE_IND Pass Fail Grade Indicator Indicates whether the grade mode is specified as pass/fail. VARCHAR2(1)  

DAP_RESCLASS_DTL

DAP_PASSFAIL

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

RAD_PRIMARY_MST

RAD_USER_DEF1

PLANNED_COURSE_IND Planned Course Indicator Indicates whether the course is planned for an audit type of planning. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_RESULT_TYPE = 'CLASSAPPLIED' AND AUDIT_TYPE = 'PL'

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

NA

NA

QUALITY_POINTS Quality Points Quality points associated with the grade. NUMBER  

DAP_RESCLASS_DTL

DAP_GRADE_POINTS

REPEAT_COURSE_NUMBER Repeat Course Number Course number that was repeated. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_REPEAT_NUM

REPEAT_POLICY Repeat Policy Determines how repeated courses are processed. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_REPEAT_PLCY1

REPEAT_POLICY_DESC Repeat Policy Description Repeat policy description. VARCHAR2(255)  

UCX_AUD047

DAP_VALUE

REPEAT_SUBJECT Repeat Subject Course that was repeated    

DAP_RESCLASS_DTL

DAP_REPEAT_DISC

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_COURSES_NEEDED Rule Courses Needed Number of courses still needed on the rule. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE2

RULE_COURSE_REQUIRED Rule Course Required Number of courses originally required on the rule. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE2

RULE_CREDITS_NEEDED Rule Credits Needed Number of credits still needed on the rule. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE1

RULE_CREDITS_REQUIRED Rule Credits Required Number of credits originally required on the rule. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE1

RULE_OPERATOR_NEEDED Rule Operator Needed Determines if the relationship between the courses and credits is an AND relationship or an OR relationship. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE3

RULE_OPERATOR_REQUIRED Rule Operator Required Determines if the relationship between the courses and credits is an AND relationship or an OR relationship. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE3

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)  

STVCLAS

STVCLAS_DESC

STUDENT_CLASSIFICATION_DESC_DW Student Classification Description DW Student classification description from Degree Works. 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 Degree Works Student level description from Degree Works. VARCHAR2(255)  

UCX_STU350

UCX_VALUE

SUBJECT Subject Main instructional subject area for this course. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE1

SUBJECT_DESC Subject Description Subject code description. VARCHAR2(255)  

STVSUBJ

STVSUBJ_DESC

SUBJECT_DESC_DW Subject Description Dw Subject/discipline code description from Degree Works. VARCHAR2(255)  

UCX_STU352

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

TRANSFER_COURSE_IDENTIFICATION Transfer Course ID Course subject and course number combined from the transfer institution. VARCHAR2(63)  

DAP_RESCLASS_DTL

DAP_TR_COURSE

TRANSFER_COURSE_IND Transfer Course Indicator Indicates whether this course was taken at and transferred from another post secondary institution. VARCHAR2(1)  

CALCULATION

CASE WHEN DAP_TRANSFER = 'T'

TRANSFER_COURSE_INST_DESC Transfer Course Institution Description Name of the post secondary transfer institution. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_TR_SCHL_NAME

TRANSFER_COURSE_TITLE Transfer Course Title Transfer institution course title. VARCHAR2(255)  

DAP_RESCLASS_DTL

DAP_TR_TITLE

WITH_ADVICE With Advice Advice information. VARCHAR2(63)  

DAP_RESULT_DTL

DAP_VALUE3



Ver: 9.0