Queries
The HRQUERY database is available 24 hours a day beginning Mondays at 7 am through Saturdays at 5 pm with the exception of Wednesday nights. The system is brought down at 5 pm each Wednesday for a data refresh and is available again at 7 am Thursday morning. Another data refresh occurs during the weekend. You must submit a Query Access Request Form before you will have authority to run the public queries defined for the Human Resources, Benefits and Payroll modules.
The Payroll Query Manual contains documentation on each Payroll query available in the State Accounting HCM query database (HRQUERY). Refer to this manual to review the purpose, the data elements returned, and any special instructions that should be followed when running each query.
The Data Dictionary Query Manual contains documentation on special queries that were created to provide reference information for customers with authority to create queries. Refer to this document for information on running these queries to obtain a listing of records, fields, field definitions and related information.
The Run Only Query User Procedure provides information on how to run State Accounting HCM Queries. Refer to this document for help in understanding the State Accounting HCM query naming convention, how to use wildcards in prompt fields, etc.