UR Faculty to Workday Comparison Audit Report
Purpose

This report identifies changes to faculty appointment data in Workday during a set timeframe. Its purpose is to allow users to view changes and audit the data. An example of how this report can be used is to review changes to ensure correct entry of promotions (job code changes) and tenure status (tenure date).

Description

Scope

  • All faculty are included when searching.

Data Sources

  • Data are sourced from UR Faculty (Interfolio) and myURHR (Workday HCM).

Timing

  • Data are refreshed daily.

Prompts

The report can be run using the following prompts. Clarifications are noted below. Please see the Specification Terms for more definitions. 

  • Employee First Name Search
    • Note that this search is CaSe sensitive
  • Employee Last Name Search
    • Note that this search is CaSe sensitive
  • Jobcode
  • WD Primary Job Indicator
    • Allows user to select Primary and/or Secondary Job
  • FIS Division Filter
  • Academic Unit
    • labeled as "Units of Appointment" on the prompt screen.

Fields

The following fields are included on the report. Clarifications are noted below. Please see the Specification Terms for more definitions. All fields prefixed  with 'WD' are from Workday. All others are from Interfolio.

  • URID
  • Employee ID
    • Labeled as "EMPLID"
  • Position ID
  • WD Position NBR
  • WD Primary IND
  • Appointment Sequence
  • WD Last Name
  • WD First Name
  • Row Status
    • Labeled as "Activity Status"
  • WD Empl Status
  • Last Updated
  • Faculty Jobcode
  • WD Jobcode
  • Academic Unit
    • Labeled as "Unit of Appointment"
  • Business Title
  • WD Func Title
  • WD Position Desc
  • Division
  • WD Division Name
  • WD Dept Name
  • WD Dept Family
  • WD U Emply Type Class
  • Faculty Job Family
  • SMD Components
  • Tenure Status
  • Tenure Date
  • WD Tenure Date
  • Appointment Start Date
  • WD Position Entry Date
  • Appointment Expected End Date
  • WD Appointment Exp End Date
  • Base Length
  • Reappointment Notice Deadline
  • Renewal Cycle
  • Appointment Time Status
  • WD Time Type
  • WD FTE
  • WD STD Hours
  • Public Appointment Notes
  • Entry By
Additional Details

How to run the report:

  1. All filter prompts are optional
  2. Choose 1 or more divisions and then click the Submit button to see/choose units
  3. Use calendar icons to select dates
  4. Use Right scroll bar to scroll down to additional filter prompts
  5. Click Submit button to apply filters selected
  6. Output options include PDF, HTML, Excel (keeps formatting), Excel data (grouped columns are ungrouped), CSV (just data columns delimited by commas
  7. To save personal version of report with your prompts saved choose Save as report view