PeopleSoft: Access Queries

Who can use it?

Authorized CSS/FMS/HCM users who have completed Query training and have requested Query Security Access.

To obtain access to CSS/FMS/HCM follow the links below

What is it?

Query is a PeopleSoft end-user reporting tool that will allow users to write reports in order to extract information from FMS and CSS.  Query allows users to create and run reports against the FMS or CSS database with these queries being as simple or as complex as needed. Queries can be created for a one-time use or they may be created and saved for future repeated use.  Query will be the PeopleSoft version of Focus reports in SIS.

Query users will benefit from having a basic understanding of the data that the query will be based upon (such as, in what record the data is stored), and the relationships of other records within the database. 

Where to get it?

Query offers two types of user access: Query Viewer and Query Manager

How to use it?

Query Viewer

  • Query Viewer provides 'read-only' access to predefined queries. Users with Query Viewer access can search, run, print and download query data
  • Query Viewer Information

Query Manager

  • Query Manager allows users to create new queries, modify existing queries, and schedule queries to run at a later date
  • Query Manager Information

General Query Information

How much does it cost?

There are no costs associated with this service.