NYS Comptroller Seal  

Bureau of State Payroll Services

Date:  March 12, 2002

Bulletin No. 306


Subject New Generic Public Queries in the PS Query Database
Purpose To provide information about additional public queries available for agency use.
Affected Employees Agency PaySR users with access to create and/or run PS Queries.
Effective Date Immediately
Background Information York State Payroll Users Group, has designed new generic queries and added them to the public query section of PS Query. Generic public queries make it easier for PS Query users to retrieve information needed for frequently used reports or data requests.

The new queries, described in the attached listing, are grouped into these five categories:
General Interest 
Archived Data 
"Difference" Queries 
Duplicate Overtime Payments 
Position Management

Agency Actions Payroll officers should distribute this bulletin to users with PS Query access.  Users can run these queries to obtain the results described in the attachment.  If it is necessary to modify a query, it should be saved as a private version before making any changes.  Instructions on how to save a public query as a private version are included in the attachment.
Questions Refer to the PS Query training materials available on the Payroll Services page of the OSC website. Open the OSC page at osc.state.ny.us. Then click the Comptroller's News for State Agencies button. Click the link to the State Payroll Services website.

Questions about access to PS Query, security and passwords should be directed to your agency's security coordinator. Other questions may be directed to the Query Help mailbox.