Running the No Appointment Level Funding Report in HRS

Instructions for Running the No Appointment Level Funding Query 

1. Navigation path: Reporting Tools > Query > Query Viewer.
2. Enter some or all of the report name in the begins with field, UW_FI_NO_APPT_LVL_FUNDING
3. Click Search
4. In the Search Results, locate the query UW_FI_NO_APPT_LVL_FUNDING (No Appt-Level Funding Report), and click the HTML link to run the query results in a new browser window/tab or Excel to download as an Excel document.
   
   
   
5. The UW_FI_NO_APPT_LVL_FUNDING - No Appt-Level Funding Report new window/tab opens, and lists three required search fields: Pay Run ID, Fiscal Year, Org Dept.
   
   In the Pay Run ID required field, enter the Pay Run ID for the payroll in calc (e.g. 2022BW01A).  The Pay Run ID must be in ALL CAPS.
   
   Note: Pay Run IDs begin with the 4-digit calendar year, then BW for biweekly; then the 2-digit month; then an alpha code A, B, or C that represents the first, second or third biweekly payroll of the month.
   
   For a list of Pay Run IDs, refer to the Calendars and Schedules Page, click on the 20XX UW Employee Payroll Calendar.
   In order to return query results, a preliminary payroll calc must have been run for the specified Pay Run ID.
   
   In the Fiscal Year required field, enter the four digit fiscal year.
   
   In the Org Dept required field (Organizational Dept -- also known as appointing dept or major dept), enter all or part of the 7-character Org Dept which starts with your campus alpha identifier (e.g. A961120).
   
   If a partial Org Dept is entered, you must use the percent character % as a wildcard (e.g. A96% or A961%).
   
   Note: You can also enter % to run for all departments at all campuses
6. To view the query results, click the View Results button.
   
   Note:  If you receive the message, "No matching values were found", one of three conditions has occurred:
   
   You neglected to enter information in all three required search fields (Pay Run ID, Fiscal Year, Org Dept), or the Pay Run ID was not entered in ALL CAPS
   
   Your HRS Security access does not allow you to view query results.
   
   Your campus, division, department does not have any employees who are missing either Appointment-level funding or Position-level funding for all or part of their pay period.  No further action is needed.
   
   
   
7. Funding for any employees listed on the report should be entered by noon on the final calc day. See KB Adding or Changing Appointment Level Funding for Employee's Salary Expense in HRS
   

• Calendars and Schedules Page
• UWSS Service Operations - Finance