Overview:Pre-formatted reports (called Queries) have been developed in HRS to help you pull information for multiple employees from tables across modules. This eliminates the need to look up each individual employee's information. This procedure explains how to run Absence Management query reports.
How to Run a Query
Navigate to: Reporting Tools > Query > Query Viewer.
Enter the name of the query if known or enter a partial string using the % sign to perform a search of all Absence Management queries as shown below.
There are three ways to run a query: HTML, Excel or Schedule. (Hint: you can use the "Add to Favorites" feature to keep a list of your most used queries.)
- Note: The XML option is also available but not often used.
Run to HTML
Click the HTML link. This option executes the query and displays the results at the bottom of the page.
Some queries may prompt the user for Run Control parameters. This helps define the information you wish to retrieve. The screen print below shows a prompt page for the UW_AM_ABS_NOT_APPRVD_FAASLI query. For this particular query, the Run Control parameters required are the Department ID as well as Begin and End Dates. The magnifying glass will provide a list if you need to look up the specific value to enter.
Once you have entered your Run Control parameters, press the ‘View Results’ button. The query results will display at the bottom of the page.
Run to Excel
Click the Excel link. This option executes the query and writes results to an Excel spreadsheet. Depending on your browser, a pop up window will open allowing the options of saving the file, opening the file in Excel, or canceling the query.
Run to Schedule
The schedule option allows you to schedule a query to run a specific day or time. To schedule a query, click the schedule link next to the query you want to run.
Set the Run Control parameters on the Run Control page. You can search for an existing run control or create a new one.
Once the Run Control has been entered, the run control page for the UW_AM_UNPAID_ABSENCES will be displayed. Enter the Run Control parameters.
Click the OK button to continue. The Run Control parameters will be displayed. At this time you can modify your Run Control parameters by clicking on the "Update Parameters" hyperlink.
Enter a description for your query. Then click OK to continue.
You will be redirected to the Process Scheduler Request page. Enter the following parameters:
- Enter the Run Date you want the query to execute
- Enter the Run Time you want the query to execute
- Leave all other parameters as is.
- Check the box next to the Process name for the query you wish to execute.
- Click the OK button to create the schedule request.
To verify that the process has been scheduled, click on the Process Monitor link in the top right corner. This page lists displays all processes, reports, and queries that you have requested to run. You can set how many days up to 99 to retrieve results. Once the specified Date and Time you have set to run the query is reached, the query will be executed and the Run Status will be changed to Success and Distribution Status to Posted.
Once the process has completed you can access the results by clicking the Detatils hyperlink. This will take you to the View Log/Trace page. Click the hyperlink for the report to open it.