Subject
Query Access to Additional Tables
Date Issued
August 16, 2002
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
08/19/2002
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 |
| Employment | Direct Deposit | DIRECT_DEPOSIT |
| Personal Data | General Comments | GENL_COMMENT |
| Pay Check | Pay Check Earns | PAY_CHECK_EARNS |
| Pay Check | Pay Distribution | PAY_DISTRIBUTN |
| Pay Check | Pay Tax | PAY_TAX |
| Pay Tax | Pay Tax Distribution | PAY_TAX_DIST |
| Job | Position History EE Entry Dates | POSN_HISTORY |
Information These Tables Can Supply
Attachment 1 contains the query table, information available and the field names
Questions
Questions regarding this bulletin may be directed to the Query Help mailbox.