State Agencies Bulletin No. 306

New Generic Public Queries in the PS Query Database
Date Issued
March 12, 2002


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


Background Information

New 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" Qeries
  • 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.


Refer to the PS Query training materials available on the Payroll Services page of the OSC website. Open the OSC page at 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.