NYS Comptroller Seal  

Bureau of State Payroll Services

Date: September 5, 2000 

 Bulletin No. 184

Subject Purged Queries
Purpose To notify staff that queries have been purged from the PS Query database according to the procedures in Payroll Bulletin # 175.
Affected Employees Staff who use PS Query or request reports based on data in the query database.
Effective Date September 5, 2000
OSC Actions  OSC has purged public and private queries from the PS Query database that were not renamed according to the instructions in Payroll Bulletin # 175. Only those query which were renamed and started with "%" were retained.

After the records were purged, the percent sign (%) was removed from the remaining, renamed queries, and the query names were restored to their original format.

All generic public queries start with "00" (zero zero).

Agency Actions 

Verify that the necessary queries have been retained. It is no longer necessary to save queries with an initial "%".
Use the following naming convention for public and private queries: AgencyCode_queryname.

Questions Questions regarding this bulletin may be directed to the Query Help mailbox.