Integrated Service Center

Workday Reports


Known Issues
Retro Period issues impacting reporting – including Earnings and Actuals

Based on the current security configuration and restrictions in Workday, the ISC is unable to expose retro period data without exposing an entire set of data that has strict restrictions. We are aware that this is impacting operations of campus units. We are actively working to resolve this issue on two fronts: 1) by requesting changes to the Workday security model to allow for more nuanced control in this essential area, and 2) by working with the payroll, security and reporting teams within the ISC and EDW to find alternative solutions.

Last Updated: 9/19/2017

Online Check Register Replacement Reports

A number of you have contacted the ISC to inquire about the Online Check Register report, which many of you employ to validate payroll results for your department. Although that report is not available, the good news is that the ISC Reports team has developed the following reports that will provide you with the information you need:

Payroll Reports to run prior to Final Pay Calculation

  • R0430 – Earnings and Actuals – Prompt for Worker
  • R0431 – Earnings and Actuals – Prompt for Org.
  • R0526.1 – Gross Wages Comparison and Verification (prior to and after final payroll results)

Other useful reports:

  • R0525 – Payroll Costing by Organization
  • R0525.1 – Payroll Costing by Allocation Cost Center

Last Updated: 8/4/2017

 

Recent Updates
Employee Download By Organization R0314

This report was updated to include a new column labeled “Distribution FTE” which shows the distribution percent as a raw FTE percent. Thus if someone is 50% FTE and is 50% allocated to a cost center, their Distribution FTE shows as .25 for that allocation.

Updated: 9/19/2017 at 5:00pm

Payroll Costing by Organization – R0525
Payroll Costing by Allocation Cost Center – R0525.1

These reports have been updated to include a field that shows the prorated monthly pay rate based on the worker’s FTE. They have been updated to show the allocation amount based on the prorated monthly pay rate, and this column was relabeled to “Distribution % x Total Base Pay x FTE”

Updated: 9/14/2017 at 1:30pm

Employee Download By Organization R0314
Current Worker with Active Position (Cost Center Details) R0350.2

These reports have been updated to show the allocation amount based on the prorated monthly pay rate, and this column was relabeled to “Distribution Amount (Dist % x Total Base Pay x FTE)”.

Updated: 9/14/2017 at 1:30pm

Gross Wages Comparision and Verification R0526.1

This report has been updated to include Employee ID and Supervisory Organization.

Updated: 9/11/2017 at 4:55pm

This report was created to supplement the original R0526 report but without the security impacts. This report helps you compare gross wages across pay periods (by worker(s)) in an organization.
Update: This report was originally only showing regular (REG) earnings, and not all gross pay components. This has been resolved.

Updated: 8/3/2017 at 4:45pm

Earnings and Actuals – Prompt for Worker R0430

Updated to add Percentage for each Journal Line entry.

Updated: 8/31/2017 at 5:00pm

Earnings and Actuals – Prompt for Organization R0431

Updated to add Percentage for each Journal Line entry.

Updated: 8/31/2017 at 5:00pm

This report has been updated to remove a filter that restricted Unpaid Academic results from being displayed.

Updated: 8/17/2017 at 5:20pm

Summarized Worker Hours R0521.1

This report has been created to summarize all worker time blocks for a certain period of time and has drill-down options to see more specific details.

Updated: 8/17/2017 at 4:30pm

Reported Time Blocks R0521

This report has been updated to include the following fields:

  • Approved By – Shows the final approver of the time block, which could be the Time and Absence Approver, or someone from the ISC in rare cases.
  • Final Status – Shows whether the time block was approved, automatically approved, or manually advanced.

Updated: 8/9/2017 at 9:30am

This report has been updated to include the following requested fields:

  • Submitted By – Showing who submitted the time block, which could be the Worker directly, the Time and Absence Initiate, or the someone from ISC in rare cases
  • Most Recent Submission – As time blocks can be submitted multiple times, this shows the most recent submission
  • Approval Date

Updated: 7/26/2017 at 1:30pm

Payroll Costing by Allocation Cost Center – R0525.1

This report has been modified to allow optional filtering based on Allocation Start Dates and/or Allocation End Dates.

Updated: 8/7/2017 at 10:30am

This report has been created to allow filtering of Costing Allocations by Cost Center ID (Org Code), Cost Center, UW Project, UW Option, UW Task or Grant.

Updated: 7/26/2017 at 4:00pm

Unapproved Time in a Pay Period R0283

This report has been updated to resolve an issue where employees with unapproved and/or unsubmitted time blocks were not appearing as designed.

Last Updated: 8/4/2017 at 4:30pm

Payroll Costing by Organization – R0525

This report has been updated to allow filtering by all organization types, including Cost Center, Cost Center Hierarchy, Supervisory Organization, etc.

Updated: 7/26/2017 at 4:00pm


Reports by Security Role

Access to reports in Workday is dependent upon your Security Role.

Summaries of reports by Security Role are available in the PDF documents linked below.

If you need a report to which your Security Role does not currently provide access, complete and submit a Security Role Change Request form.

Locating a Report

A full list of existing Workday reports can be found in the Workday Reports Catalog.

Note for Medical Centers Employees
If you find an existing report in the Workday Reports Catalog that will work but you do not have access due to your Security Role, please email the WMS Team for assistance.


View the Workday Reports Catalog

Can’t Find a Report to Meet Your Needs?

The ISC may be able to suggest an existing report. Contact the ISC detailing the information you’re looking for.

Data may also be available in UW’s Enterprise Data Warehouse (EDW).

If no existing Workday report will meet your needs, submit a Workday Report Request to request that a new report be built, detailing the desired information and business need. Be advised that report requests can take several weeks to complete, so submit your request well in advance of your required date.

Open a Workday Report Request

Note for Medical Centers Employees
If no report exists that meets your needs, email the WMS Team for assistance. Provide as much information as possible about the desired information and business need for the report in your email. A WMS report writer will contact you to gather any additional information needed and to provide a timeline for completion.