Subject
Query Access to Additional Tables
Date Issued
February 27, 2003
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.