BG@100 ERP Project

Query Information | Viewer | Manager | Documentation | FAQs

Query Frequently Asked Questions

 

 

   Q:  What is query?
A:  A query is a request for ad hoc information.  The meaning of ad hoc is immediately available.  For example, the data results in a query are immediately available to the specific time the query is run.  A query is a set of records(s), fields, and rows that provides specific data.
 
Q: What is PeopleSoft query?
A:  PeopleSoft Query is an end user reporting tool.  PeopleSoft query has two components:  Query Viewer and Query Manager.
 
Q: What is Query Viewer?
A:  Query Viewer enables users to: search for a query, run a public query and display results in a browser window or HTML, download query results to an Excel spreadsheet, and print a query.
 
Q: Who are Query Viewers?
A:  Query Viewers are users who only need to run pre-existing, public queries authored by Query Managers.  Query Viewers are chosen by functional leads, Directors, Chairs, etc.  Query Viewer typically download results into an Excel spreadsheet.
 
Q: How does a user gain Query Viewer access?
A:  A user can gain Query VIewer access by following the steps outlined at:  http://www.bgsu.edu/offices/cio/bgat100/page81584.html
 
Q: What is a public query?
A: A public query is authored by a Query Manager for all query users to view.
 
Q: What is a private query?
A: A private query is authored by a Query Manager that only the author or owner of the query can view or modify.
 
Q: What is Query Manager?
A: Query Manager is an end user reporting tool.  Query Manager is one component of PeopleSoft Query.  Query Managers retrieve data from the database by selecting records, adding fields to query content, viewing fields selected for output, changing the column order for multiple fields, changing the sort order for multiple fields, editing field properties, viewing and editing query properties.
 
Q: Who are Query Managers?
A: Query Managers are chosen by functional leads, Directors, Chairs, etc.  Query Managers are selected to write or author queries for their specific functional area.
 
Q:  How does a user gain access to Query Manager?
A: A user can gain Query Manager access by following the steps outlined at:  http://www.bgsu.edu/offices/cio/bgat100/page81585.html