Salary Funding IDE

Last Updated
08/12/2022
Description

An export of salary data for both the past (payroll) and the future (projection). Data is displayed by job, project, pay period, HRS distribution percentage, funding source, etc.

Report URL
https://tableau.wisconsin.edu/#/views/SalaryFundingIDE_0/SalaryFundingIDE
Data Cookbook URL (requires authorization)
https://uwmadison.datacookbook.com/institution/reports/31205/versions/63022
Data Domain(s)
Employee Record
Access Restrictions
Employee Record Data Internal
Data Source Information
Badger Analytics, EPM
Data View Information
Badger Analytics: WS_SF_DTL_PRL_PJN_TRANS_VW, WS_SF_EMPL_DEPT_JOB_CLASS_VW, WS_SF_UWMAD_FY_POSITIONS_VW, WS_SF_UW_FISCAL_CAL, WS_SF_PROJECTS_VW, WS_SF_PROJ_DEPT_VW, WS_SF_HRS_DEPT_VW, WS_SF_DEPT_VW, WS_SF_UW_FRINGE_RATES_VW; EPM: SYSADM.PS_UW_HR_ALLJOB
Update Schedule
Daily at 10:30pm
Responsible Office
Office of Human Resources
Important Notes

'Amount' represents the salary paid for past pay periods and the projected salary for future pay periods. Amounts are negative for salary cost transfers or corrections to prior pay periods.

Employees may be listed multiple times because data is displayed according to funding and pay period. Therefore, do not use this data for official counts. To calculate an employee's total salary for a given time period, sum all applicable rows.


Projections are generated from the Salary Projection Star schema in WISDM for the current and next fiscal year according to these following formulas:
Classified employees: (UW_Comp_Rate*HRS_FTE*Funding_Pct)*2
Unclassified employees: UW_Comp_Rate*HRS_FTE*Funding_Pct
Projections assume the latest funding information in the current fiscal year will roll over into the new fiscal year, that no changes are entered into HRS and that bi-weekly employees work the scheduled number of hours. Encumbrances are only approximate calculations.

For a description of each field, see:

https://drive.google.com/file/d/1QiUu1QTVgPw3oJ9Wiinw_IOwjt_m0h7b/view?usp=sharing

Definitions

Name Functional Definition Data Domains
UDDS

A UW System-wide, seven-character organizational code used to identify the Unit, Division, Department, Sub-department associated with a particular personnel, research, financial, or other activity or transaction.

University of Wisconsin - Madison
Fiscal Year

A period that an organization uses for accounting purposes and preparing financial statements. For the university, the fiscal year is from July 1 - June 30 (i.e., FY2016 = July 1, 2015 to June 30, 2016). Summer is the first term in the university fiscal year.

Finance
Accounting Period (Accounting)

Represents a specific time interval (usually a month) for which each transaction is assigned. Possible values are:

  • 1 (Jul)
  • 2 (Aug)
  • 3 (Sep)
  • 4 (Oct)
  • 5 (Nov)
  • 6 (Dec)
  • 7 (Jan)
  • 8 (Feb)
  • 9 (Mar)
  • 10 (Apr)
  • 11 (May)
  • 12 (Jun)
  • 13 (Close)
  • 998 (Year End Adjustments)

Project/grants will typically show Period 13 with Period 1 of the next fiscal year.

Finance
Employment Class

A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc.

Employee Record
Fund (Accounting)

Also known as appropriation, this is a 3 digit number set up by the Legislature to define the funding source and transactions that can be attributed to it.

Finance
Program (Accounting)

A code assigned to classify institutional activities in accordance with NACUBO.

Finance
Project (Accounting)

A code assigned to further specify limitations/classifications on use of funds if needed (e.g., grants).

Finance