State Agencies Bulletin No. 184

Subject
Purged Queries
Date Issued
September 5, 2000

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.