Agenda

Querying Academic Requirement Report Tables

Track: Student Information System (SIS)

Session Number: 10512
Date: Wed, Mar 6th, 2024
Time: 8:30 AM - 9:30 AM

Description:

The Academic Advisement/Requirements report can be a fantastic tool utilized to advise students, monitor progress towards degree, and award degrees and/or distinction using Graduation Processing, to name a few.

Running an AAR/ARR individually or by batch produces a handy report, but not everyone wants to scroll through pages and pages of reports to find the information needed. The batch 'generate report' processes can be used in conjunction with query to pull a report of the satisfied (COMP) and/or not satisfied (FAIL) statuses of students' academic requirements.

Join me in exploring querying the academic requirement report tables. This session will review Advisement Report setup (how many reports does your institution ‘keep’?) and querying those SAA_ADB tables to produce data for a cohort of students that will provide staff and advisors a review of their students’ progress without having to scroll through each student’s report.

Time permitting, we will discuss querying the tables that store the academic requirement set up (RQ tables).
Sub-Categorization: Academic Advisement
Session Type: Presentation

Focus Area: Data to Decisions
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1736
ERP Systems: Oracle
Knowledge Level: Intermediate
Field of Study: Select a Value
CPE: No
Sub-Categorization: Academic Advisement
Session Type: Presentation

Focus Area: Data to Decisions
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1736
ERP Systems: Oracle
Knowledge Level: Intermediate
Field of Study: Select a Value
CPE: No