State Agencies Bulletin No. 332

Query Access to Additional Tables
Date Issued
August 16, 2002


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


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 regarding this bulletin may be directed to the Query Help mailbox.