| Reporting View | Description | Key & Frequency | Recommended Search Columns |
| AUDIT_COURSE_NEEDED
| Contains student audit course results for courses needed with their take type. Also contains courses and credits required for the requirement rule associate with the course.One row per person uid, per result_sequence_numberAUDIT_RESULT_KEY
PERSON_UID,AUDIT_TYPE,COURSE_IDENTIFICATION
PERSON_UID,AUDIT_TYPE,STUDENT_LEVEL,DEGREE,BLOCK_ID | | |
AUDIT_STUDENT_BLOCK
| 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.One row per person uid, per block_sequence_numberPERSON_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 | | |
AUDIT_STUDENT_COURSE
| 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.One row per person uid, per result_sequence_numberAUDIT_RESULT_KEY
PERSON_UID,AUDIT_TYPE,COURSE_IDENTIFICATION
PERSON_UID,AUDIT_TYPE,STUDENT_LEVEL,DEGREE,BLOCK_ID | | |
AUDIT_STUDENT_NON_COURSE
| 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.One row per person uid, per result_sequence_numberAUDIT_RESULT_KEY
PERSON_UID, AUDIT_TYPE, NON_COURSE
PERSON_UID, AUDIT_TYPE, STUDENT_LEVEL, DEGREE, BLOCK_ID | | |
EXCEPTION_APPLIED
| This table contains detailed data for exceptions.One row per person uid, per exception numberPERSON_UID,AUDIT_TYPE,STUDENT_LEVEL,DEGREE,BLOCK_ID
PERSON_UID,AUDIT_TYPE,EXCEPTION_TYPE,EXCEPTION_STATUS,EXCEPTION_SEQUENCE
AUDIT_RESULT_KEY | | |
EXCEPTION_DETAIL
| This table depicts Exceptions appliedOne row per person uid, per exception sequencePERSON_UID,STUDENT_LEVEL,DEGREE,BLOCK_ID
PERSON_UID,EXCEPTION_TYPE,EXCEPTION_STATUS
AUDIT_KEY | | |
PLAN_TEMPLATE_COURSE
| Contains detail information about the registration plan templates that may have been used to create a list of academic periods and courses to be taken in each in sequence of academic periods for the student level and program or degree.One row per academic period per plan sequence number key per plan course key| TEMPLATE_SEQUENCE_NUMBER,TEMPLATE_COURSE_KEY | | |
REGISTRATION_PLAN
| Contains high-level overview information about a registration plan created by the student for the academic period.One row per person per academic period per plan keyPERSON_UID,ACADEMIC_PERIOD,PLAN_SEQUENCE_NUMBER
PERSON_UID,ACADEMIC_PERIOD,PLAN_KEY,PLAN_SEQUENCE_NUMBER,ACADEMIC_PERIOD_KEY | | |
REGISTRATION_PLAN_COURSE
| Contains detail information about the student's registration plan for the person that lists the student courses and or sections to be taken in the academic period.One row per person per academic period per plan sequence number key per plan course keyPERSON_UID,ACADEMIC_PERIOD,PLAN_SEQUENCE_NUMBER,PLAN_COURSE_SEQUENCE_NUMBER
PLAN_COURSE_KEY,PLAN_SEQUENCE_NUMBER | | |
PROJECTED_SEATS_NEEDED
| Contains summary information about the seats needed per the student registration plans.One row academic period per course identification and or course reference numberACADEMIC_PERIOD,COURSE_REFERENCE_NUMBER
COURSE_NUMBER,ACADEMIC_PERIOD
ACADEMIC_PERIOD,COURSE_IDENTIFICATION,COURSE_REFERENCE_NUMBER | | |