Topics Map > Human Resource System (HRS) > Finance
Running the Funding Change Report in HRS
OverviewYou can run the Funding Change Report by 7-character appointing Department (e.g. A538500) to view funding adds, changes, deletes; date and time the entry occurred; specific Fiscal Year; the name of the staff person who made the change or the specific batch Finance Fiscal Year End process or SQL (Structured Query Language) process that made the change automatically.
The report lists funding level changes for appointment, position or department level funding from the Funding Data Entry page in HRS. The Funding Change Report can also be downloaded to an Excel spreadsheet.
- HRS Security Role Needed: FI Campus User Funding Reports; also see Funding and Direct Retro Security by Campus in HRS
- From the HRS Main Menu, navigate to: UW Financial Reports > Funding (CA) Audit Report.
Accessible from the Finance WorkCenter found at Payroll for North America>Payroll Distribution>Commitment Accounting USA>UW Finance WorkCenter. For more information about the WorkCenter, see KB Setting Up a WorkCenter in HRS .
Note: The letters "CA" in the screen title refer to Commitment Accounting.
- In the Funding (CA) Audit Report search screen, enter or create a run control. For more information see Setting Up Run Control IDs in HRS
- In the Funding (CA) Audit Report tab:
a. In the required field for Department ID, enter the entire 7-character appointing Department which starts with your campus alpha identifier (e.g. A538500). If unknown, click on the data look-up icon, and search for valid appointing Department IDs.
Warning: This report does not accept partial appointing Department IDs nor the wildcard character of %. If a partial appointing Department ID is entered (e.g. A53%), the report will run to Success, but produce no results.
b. In the optional Date Parameters section:
(1) Select a Begin Date and End Date for the report -- or --
(2) Leave blank to run the report for the current Fiscal Year begin and end dates.
Note: Fiscal Year 2014 began July 1, 2013, and ends June 30, 2014.
c. In the optional Additional Parameters section, enter one of the following or leave all blank:
- Click the Run button.
- In the Process Scheduler Request screen:
a. Select the output file format, such as PDF or CSV
b. Click OK.
- The Funding (CA) Audit Report tab will display again. Click Process Monitor to monitor the status. See Viewing the Process Monitor in HRS for more information.
- Click Details > View Log/Trace. The File List section contains the output file in the format you chose. Click on the file name to view the report results.
- The Funding Change Report results open in a new window.
Explanation of Column Headings on the Funding Change Reporta. Date/Time of Entry: The day/month/year and time (e.g.hours/minutes/seconds), sorted in ascending order, that the funding change was entered on theFunding Data Entrypage in HRS.
b. Changed By: The name of the staff person who made the funding change --or-- the specific Fiscal Year End* process that made the funding change. *A user with a listing similar to “UW_BAT_FI” or “U:PHIRE_SQL” signifies funding that was populated as part of the annual fiscal year end funding process. This process is completed each year in early June. Information specific to each year can be found on the Finance Team’s Fiscal Year End web page: https://uwservice.wisconsin.edu/administration/finance/
c. Action: Type of change made. (See table below for explanations of each Action).
|Add||New funding row added. This row displays the new funding that was added.|
|Chg (Change)||Existing funding row changed. This row displays the result of the change.|
|Del (Delete)||Existing funding row deleted. This row shows the existing funding that was deleted.|
d.Employee ID: The 8-digit Employee ID for whom the appointment level funding was changed, as listed on theFunding Data Entry page in HRS.
Note:If theEmployee IDfield is blank, funding changes were made to either Department level funding or Position level funding. (See Employee Name field below).
e. Empl Rcd: The employee's primary or secondary job on which Appointment-level funding changes were made, as listed on theFunding Data Entrypage in HRS.
Note: The default value is zero.
f. Fiscal Year: The four-digit fiscal year in which the change occurred, as listed on theFunding Data Entrypage in HRS.
g. Employee Name: The name of the employee for whom the Appointment-level funding change was made, as listed on theFunding Data Entrypage in HRS.
(1) If the words,"position = [8-digit Position number]"display in theEmployee Namefield, this represents changes made to Position-level funding.
(2) If the Employee Name field is blank, this represents changes made to Department-level funding.
h. Funding Eff Date (Funding Effective Date): The funding Effective Date entered as a result of the Add, Change or Delete Action, as listed on the Funding Data Entry page in HRS.
i. Fund Eff Seq (Funding Effective Sequence): The funding effective sequence number entered as a result of the Add, Change or Delete Action, as listed on the Funding Data Entry page in HRS.
Note: The effective sequence tracks the sequence of changes, when multiple funding records have the same funding effective date; the highest number takes precedence.
j. Fund Status (Funding Status): Represents changes made to the *Status field on the Funding Data Entry page in HRS. The default value is Active.
If the *Status field is changed to Inactive, HRS will ignore all funding rows entered.
k. Fund Seq (Funding Sequence): Represents numbering changes to the *SEQ# field on the Funding Data Entry page, Funding Distribution section in HRS.
Note: HRS automatically renumbers the *SEQ# field, if an entry is made in the ERNCD (earnings code) column on the Funding Data Entry page. (Refer to HRS KnowledgeBase document, Designate Funding for Payroll Earnings Code Differently Than Regular Pay in HRS).
l. Funding Combination Code: Changes made to the salary expense funding chartfields (also known as "funding string"), from the Funding Data Entry page, Funding Distribution section in HRS.
For example, the funding combination code 133-538500-4-MSN-PRJ51UR is made up of the following 5 segments:
(1) Fund (3-digit fund code) Example: 133
(2) Funding Dept (6-digit funding department) Example: 538500
(3) Program code (1-character program code) Example: 4
(4) Campus abbreviation (3-character campus abbreviation) Example: MSN
(5) Project, if applicable (7-character Project/Grant ID) Example: PRJ51UR
m. Earnings Code: Represents changes made to the 3-character ERNCD (earnings code) field on the Funding Data Entry page, Funding Distribution section in HRS.
Note: On the Funding Data Entry page, the ERNCD field is used to designate that funding for a payroll earnings code for items such as Retro Pay, Overtime or an Overload, for example, are funded differently than the employee's regular earnings. See HRS KnowledgeBase document Designate Funding for Payroll Earnings Code Differently Than Regular Pay in HRS.
n. Fund Dist % (Funding Distribution percentage): Changes made to the Distrib % field on the Funding Data Entry page, Funding Distribution section in HRS.
- Adding or Changing Appointment Level Funding for Employee's Salary Expense in HRS
- Adding or Changing Department Level Funding for an Organizational Department in HRS
- Adding or Changing Position Level Funding for Employee Salary Expenses in HRS
- Designate Funding for Payroll Earnings Code Differently Than Regular Pay in HRS
- Finance Report List in HRS
- Funding and Direct Retro Security by Campus in HRS
- Salary Funding Levels Assigned During Payroll Processing in HRS
- HR Report List for HRS
- Campus Codes Used in Location / Appointing Department / Academic or Summer Pay Groups in HRS
- Setting Up Run Control IDs in HRS
- Viewing the Process Monitor in HRS
- Setting Up a WorkCenter in HRS