Oracle/PeopleSoft ERP Project

Query Information | Viewer | Manager | Documentation | FAQs

Query Viewer

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 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.  



 In order to obtain Query Viewer access, users will need to:

1.  Complete 2 prerequisite online classes:  Fundamentals of Database Structure & Query Viewer

Please follow the class description/enrollment information link below for enrollment details, associated documentation, details regarding required quiz scores and completion of CSS 110-140 for CSS users.

 
2.  Request Security Access

Security Access for Query Viewer may be requested following successful completion of the two online classes.  Access may be requested by selecting Query Runner access using one of the Security Access Request forms and following the documented submission process.