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.