Salary Funding IDE
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.
|Data Cookbook URL (requires authorization)|
|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|
|Daily at 10:30pm|
|Office of Human Resources|
'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.
For a description of each field, see:
|Name||Functional Definition||Data Domains|
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|
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.
|Accounting Period (Accounting)||
Represents a specific time interval (usually a month) for which each transaction is assigned. Possible values are:
Project/grants will typically show Period 13 with Period 1 of the next fiscal year.
A classification system used to group employees with common attributes; examples: FA = Faculty, SH = Student Hourly, CP = University Staff, etc.
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.
A code assigned to classify institutional activities in accordance with NACUBO.
A code assigned to further specify limitations/classifications on use of funds if needed (e.g., grants).