Overview
Background
In support of secure CHRS Query administration, CHRS administrators and staff need to be able to run various Peoplesoft delivered, CO delivered, and campus-created authorized queries. Because of the limitations of PeopleSoft’s delivered Query tool, a modification was needed to more finely tune what queries may be authorized to be run by a user or group of users.
As part of the Query Runner modification, access to Query Manager and Query Viewer will be removed from general users and replaced with the Query Runner execution page. Designated Query Administrators, and Query writers will retain access to Query Manager and Query Viewer. The Query Runner modification provides a method to enable controlled access and execution of authorized queries. Campus-authorized query administrators (or their designees) will provide the setup and mapping necessary for Query Runner.
This document reviews the setup and configuration of this module.
Review prerequisites
- The role CHR_PT_Query_Access_Control provides access to the Query Access Control Entry page. Limit this role to a maximum of two users per campus.
- Query Runner applies only to public queries.
- Designated Query Administrators must be identified and informed of changes.
- Queries available in Query Runner must be limited to campus datasets and include all required prompts, as users cannot modify criteria on the Query Runner page.
- Campuses should submit an Optimize ticket to request campus-specific security roles for grouping users by query access.
Run queries using Query Runner
The role CHR_PT_Query_Runner provides access to the Query Runner page.
- Navigate to: Menu > Reporting Tools > Query > Query Runner
A list of authorized queries is displayed.
- Click any query link to execute that query.

End of article