NYS Comptroller Seal  

Bureau of State Payroll Services

Date: February 27, 2003

  Bulletin No. 369

Subject Query Access to Additional Tables
Purpose To inform agencies that they now have access to other query tables in QRY1.
Affected Employees Agency users who create or run queries.
Effective Date Immediately.
Parent Tables with the Added Tables in QRY1 Users must have access to the parent table in order to have access to the added table.

Parent Table Added Table Query Name
Pay Check Pay Calendar PAY_CALENDAR
Pay Check Archived Pay Check Earnings NY_PAY_CHK_ERN
Information These Tables Can Supply Attachment 1 contains the query table name, information available, and the field names.
Questions Questions regarding this bulletin may be directed to the Query Help mailbox.
Attachment - Query Table Information