Date: December 27, 2000
Bulletin No. 224
|Subject||Archived Data and New Tables for PS Query|
|Purpose||To inform agency staff that certain records have been archived and new tables have been added to the PS Query database|
|Affected Employees||Staff who design or run queries in PS Query and staff who request reports based on PS Query data.|
OSC had previously announced a plan to
archive data to improve performance in both the Production and PS Query
applications. Data from the following tables has been archived:
Pay_Ern_Dist (Pay Earnings Distribution)
Pay_Oth_Earns (Pay Other Earnings)
For the Institution pay cycle, rows in these tables with a check date of March 25, 1999 or earlier have been archived.
For the Administrative pay cycle, rows in these tables with a check date of March 17, 1999 or earlier have been archived.
Refer to the attached chart to locate the tables for the archived data.
|Agency Action||Refer to the attached chart and select the appropriate table to retrieve data through PS Query from the archived tables for rows with a check date on or before March 25, 1999.|
Questions regarding this bulletin may be directed to the Query Help mailbox.