rgreen18
#6 of 7 owners · 2% of the catalog. Authored Oct 22, 2018 → Aug 1, 2022.
All reports
Showing 8 of 8 reports
Student Demographics by Section
This report was developed at the request of Robert Daly, to create a fusion between section level information found on the Course Section Scan report and the demographic attributes found on the RLAB report. After selecting a term code and course, the list can be used to divide up classes into diverse groups for collaborative projects.
Accounting Services Financial Reporting Model
Transaction detail from the operating accounts and general ledger for fiscal years 2010 forward, with balances at the FOAP rollup and ability to slice by Rule Codes, Grants Receivables, Transaction and Activity Dates, Document Codes, and Field Codes. Inspired by the "Tony DB".
Student ID Workflow Dashboard
All new incoming students (UG & G) Those who have uploaded a photo vs who have not Those who have opted in or not opted yet for an ID Who has selected eID vs physical?
No Longer Enrolled in Term
This report provides a list of students that were at one point registered in the selected term and now have no active registrations.
Duplicate Attempt Report
A report that will look for all active students as of a provided sgbstdn cuttoff, then return a list of all courses that had duplicate attempts across all terms the active students have registered within. The reattempted term can also be provided as a parameter to return a single term, or % can be used as a wildcard to return all attempted terms.
Comptroller Collection Reports
A spinoff from the Collectors Reports but with an additional aging band and the ability to slice by FRA Signature Indicator.
CAS Access Analytics
This report cultivates information ingested into and parsed by Sumo Analytics for authentication tickets created by CAS. Using the timestamp, userid, and the name of the application by which there was a successful CAS authentication ticket created from Sumo, the data is joined to various schemas within Banner to determine classifications of the person authenticating within CAS (example: Student, Student Work, Faculty, Administration, ect...). Additionally, Epochs of time have been associated with various date ranges so that periods of times coordinating with events can be compared to one another (example: Pre-Spring Break 2020 / Post Lockout Period). Reports have been produced atop this data showing distinct user counts of the various applications accessed across periods of time, as well as comparisons of average access counts during days of the weeks across weeks of the year across hours of the day. Trends and distributions are illustrated across the various epochs and can be filtered by different applications.