Job Data by Date Range Report
Select Prompts
You’ll need to set these prompts before clicking Apply:
| Prompt | Suggested Selection |
|---|---|
| Start Date and End Date | Adjust the Start Date to the beginning of the period you want to consider. End Date defaults to the current date so you may not need to adjust it. |
| Parent Org Node Code or Parent Org Node Code - Desc |
If you don’t make a selection for Parent Org Node Code, be sure to uncheck the box for “-“ before clicking Apply. |
| Union Code | Use Union Code when you’re looking for only members of unions. |
| Employee Class - Desc | Use Employee Class – Desc when you want all member of a title series or classification such as 9 – Academic: Faculty. |
| Action Reason - Desc | To find employees with range adjustments or merit increases, you’ll need to open the Search dialog box. Use the screen shots below to guide your search for range adjustments and merit increases. |
Use Select Values dialog box to search and make complex selections
The Select Values dialog box allows you to search for values in a prompt. This is helpful when you need to select values with text and you're not sure of the spelling or you want to select multiple values easily.
In this example, we want to find employees who have had a promotion or a merit increase. From the Action Reason - Desc prompt, select More/Search... at the bottom of the drop-down list to open the Select Values dialog box.
First we'll search for values with "promotion" in the text.
- Type “promotion” in the text box.
- Select Contains from the Name drop-down list.
- Uncheck the Match Case box.
- Click Search.
- Click >> to move all of the results to the Selected pane.
- Do not click OK yet.
The next step is to search for values with "merit" in the text. The Select Values dialog box should be open and have the promotion values in the Selected pane on the right.
- Type “merit” in the text box.
- Click Search.
- Select AMR – Academic Merit/Reappointment from the search results.
- Click > to move only the selected item to the Selected pane.
- Click OK to complete the selection.
With the promotions and merit increases selected in the Action Reason - Desc prompt, you are ready to generate the report. Click Apply in the prompts section.
Review Report Results
The report includes employees listed by Org Node, Action Code and Reason, and several other columns.
