NYS Comptroller Seal  

Bureau of State Payroll Services

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.
Effective Date Immediately
OSC Actions 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_Check
Pay_Ern_Dist (Pay Earnings Distribution)
Pay_Deduction
Pay_Earnings
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

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

Attachment