Queries
The HCM Query database is available Monday through Friday, 7 am until 6 pm and Saturdays from 8 am until 1 pm. Changes made in the HCM Production database will be applied to the HCM Query database the following business day. Changes made on Saturday will be applied and available to view on Mondays. 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 HR Query Manual contains documentation on each HR query available in the HCM query database. 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 HCM Queries. Refer to this document for help in understanding the SAO HRMS query naming convention, how to use wildcards in prompt fields, etc.