Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - IRF - Workday Payroll Reporting FAQ

This article provides information about using the new Workday HR and Payroll data in IRF Business Objects reporting

Click to open this article as a PDF document for printing: PDF version


Item

Question

Response

1

What is IRF-Payroll?

IRF-Payroll is a reporting application that currently provides 600 financial and grant administrators, and HR professional across campus with authorized access to payroll data for their units.

IRF-Payroll focuses on reporting and data to support payroll reconciliation for monthly and bi-weekly employees, budget to actual review, tracking and analysis of grant funding, and related exception reporting. IRF-Payroll users access data and reports through a Business Objects application.

IRF-Payroll is one of a suite of Business Objects reporting applications including IRF-Financial and IRF-HR.

2

Will IRF-Payroll be available when Workday goes live?

IRF-Payroll will be updated with Workday data on Monday, January 12, 2015. The application (including standard/canned reports and Business Objects Universe) will be available to current authorized users within a few days following processing of the first bi-weekly payroll in Workday.

3

What reports will be available?

The standard (canned) IRF-Payroll reports will be available and will reflect Workday data starting in January 2015. See the Appendix for a full listing of RF-Payroll standard reports and disposition.

Ad-hoc reports, custom queries and reports that users have developed are expected to be functional with some changes required to update query filters and formatting for data elements that may have changed as a result of implementing Workday (see below).

The IRF support team (irf-support@lists.uchicago.edu) will be available to assist users in making needed modifications to custom queries and ad-hoc reports post go-live.

4

How soon will IRF-Payroll be available after Workday go-live?

The first bi-weekly payroll will process on January 6 and IRF-Payroll will reflect this data starting Monday, January 12.

Before (and after) that date, you will still be able to access and run payroll reports for historical pay periods through 2014.

5

How often will IRF-Payroll be updated?

The refresh frequency will remain the same. Data will be extracted from Workday as part of each bi-weekly and monthly and special payroll run. Within one day following payroll generation from Workday, this data will be loaded to IRF-Payroll and be available for reporting through Business Objects. Please refer to the IRF Loads Calendar.

6

Has data changed?

Examples of data elements used in IRF-Payroll reporting that reflect some changes in Workday include:

  • Job Number
  • Job Codes
  • Earn Type Codes
  • Earn Calc Codes
  • Benefit Level Codes
  • RegTempCasual Codes

These and other data elements have been documented and available in ‘Workday Data Changes and IRF Reporting Impacts’, available by navigating to the IRF Website

7

Will reports still work?

A few of the standard reports needed to be updated to reflect changes in data elements from Workday. BIS has made these changes.

Using the documentation noted above, and with support from irf-support@lists.uchicago.edu, we are available to assist with changes that might be required to update your current IRF-Payroll custom reports and queries.

8

Will historical payroll data still be available?

Yes. All historical payroll data housed in IRF, back to July 1998, will continue to be available and has not changed.

9

How will reporting work that includes data pre and post-Workday in the same report?

All IRF-Payroll standard (canned) reports can be run to include fiscal periods before and after Workday go-live. The reports will show all the data, with some revisions based on several data changes identified above. Please refer to the following KB article at: to be posted

10

Can I still use DeskI to run IRF-Payroll reports?

Yes. We encourage you to use Business Objects Infoview Portal with WebI at https://boreporting.uchicago.edu/InfoViewApp/logon.jsp

However, DeskI is still available while we continue to convert your custom reports to WebI, which is expected to complete in Spring 2015, after which we will upgrade Business Objects and DeskI will be discontinued.

11

What will happen to IRF-HR reporting?

IRF-HR is a Business Objects application that focuses on HR person data, salary funding, and job appointment data from the previous HRMS. This system is currently available to about 150 authorized campus HR administrators.

Data about people will now be accessed directly through Workday, with many standard reports available to administrators with roles in the system. As a result, the IRF-HR application has been frozen with data from December 22, 2014. Authorized users will continue to be able to access this snapshot. IRF-HR will not be updated going forward with data from Workday.

12

If I have existing custom reports using IRF HR, can someone assist us in creating those reports in Workday?

The Workday team is currently developing HR related reports out of the Workday system and will be able to assist you post go-live.

13

Is there any impact on financial reporting using IRF?

The IRF-Financial application includes many standard reports that more than 800 campus users access to reconcile financial (FAS) accounts, conduct budget to actual reporting and post-award grants administration. The FR and TT Business Objects Universes will continue to function as they do currently. Historical reporting since 1989 (Yearly) and July, 1998 (Monthly) will continue to be available. IRF-Financial will continue to be loaded from the University’s financial system (FAS) on a weekly basis, including month-end close.

Appendix: IRF-Payroll Standard Report List

Purpose

Deski Report Name

Webi Report Name

Report Focus

Report Description

General Comments

Individual-level information

PAR-PayHistory-ForEmplID

 

PAR-102-Pay History-For Empl ID or Name

 

Individual(s)

Provides payroll history for employee(s) specified by Empl or Chicago ID number over a specified range of pay period end dates.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayHistory-ForChicagoID

Individual(s)

Provides payroll history for employee(s) specified by Chicago ID number over a specified range of pay period end dates.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayHistory-ForName

Individual(s)

Provides payroll history for employee(s) specified by last name over a specified range of pay period end dates.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PAF-ForEmplID

 

 

 

 

PAR-104-PAF-For Name and Chicago ID

Individual(s)

Displays Personnel Action Form data that is available in the ‘Person’ class. This information is current as of the most recent load of payroll data into IRF. History is not kept for this information.

Note: Employees are looked up by Empl or Chicago ID's.

Recommend this HR data be queried from Workday starting January 2015.

 

PAR-PAF-ForChicagoID

Individual(s)

Displays Personnel Action Form data that is available in the ‘Person’ class. This information is current as of the most recent load of payroll data into IRF. History is not kept for this information.

Note: Employees are looked up by Chicago ID's.

Recommend this HR data be queried from Workday starting January 2015.

 

PAR-PAF-ForName

Individual(s)

Same as PAR-PAF-ForEmplID, except that the employee(s) are looked up by name.

Recommend this HR data be queried from Workday starting January 2015.

Department/Exec Payroll History

PAR-PayExp-BW-ForFASDept

PAR-302-PayExp-BW-ForFASDept

FAS Dept(s)

Provides detail and summary for bi-weekly payroll expenses over a specified time period, for the FAS department.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayExp-Monthly-ForFASDept

PAR-303-PayExp-Monthly-ForFASDept

FAS Dept(s)

Provides detail and summary for monthly payroll expenses over a specified time period, for the FAS department.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayExp-BW-ForJobDept

PAR-300-PayExp-BW-ForJobDept

Job Dept(s)

Provides detail and summary for bi-weekly payroll expenses over a specified time period, for the job department.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayExp-Monthly-ForJobDept

PAR-307-PayExp-Monthly-ForJobDept

Job Dept(s)

Provides detail and summary for monthly payroll expenses over a specified time period, for the job department.

Reflects Workday data for payroll dates starting January 2015.

 

PARx-PayExp-ForHRDept

PAR-308-PayExp-ForHRDept

Resp Dept or Job Dept(s)

Provides detail and summary for payroll expenses over a specified time period, for the responsible or job department.

Reflects Workday data for payroll dates starting January 2015.

 

PARx-PayExp-ForHRorFASDept

PAR-309-PayExp-ForHRorFASDept

FAS Dept, Resp Dept or Job Dept(s)

Provides detail and summary for payroll expenses over a specified time period, for the FAS, responsible or job department.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-AdditionalPay-BW-ForExec

PAR-501-AdditionalPay-BW-ForExec

FAS Exec Level(s)

Shows additional pay for biweekly payroll for a particular range of Pay Period End Dates.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-ExtraService-Monthly-ForExec

PAR-502-ExtraService-Monthly-ForExec

FAS Exec Level(s)

Shows extra service payments made on monthly payroll for a particular range of Pay Period End Dates.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-Overtime-ForExec

PAR-500-Overtime-ForExec

FAS Exec Level(s)

Shows overtime payments charged to accounts in the specified FAS Exec Level(s) for a particular range of Pay Period End Dates.

Reflects Workday data for payroll dates starting January 2015.

Payroll Detail for an FAS Account

PAR-PayDetail-ForFASAcct

PAR-202-PayDetail-ForFASAcct

Account(s)

Provides PAR detail for FAS compensation totals, along with FAS data that is similar to the AMO90 and AMO91 reports.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-PayHistory-ForFASAcct

PAR-201-PayHistory-ForFASAcct

Account(s)

For specified accounts, shows a summary by month of financial activity from FAS and employee compensation activity from PAR over a range of months. Can be run for one or more accounts, and for any range of months.

Reflects Workday data for payroll dates starting January 2015.

Exception Reports

PAR-MismatchedJobDept-ForFASExec

PAR-402-MismatchedJobDept-ForFASExec

Exec Level(s)

Looks for payroll activity charged to accounts in a specified SL Exec Level, during a specified period of time, and returns only payroll transactions for jobs in a department that is different from the FAS department that was charged.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-VisaExpirations-ForExec

PAR-401-VisaExpirations-ForExec

Responsible Exec Level(s)

Selects employees whose visas will be expiring within the date range specified.

Recommend this HR data be queried from Workday starting January 2015.

Reference Reports

PAR-LookUp-EarnTypeCd

PAR-802-LookUp-EarnTypeCd

n/a

Displays the contents of the Earnings Type Reference Table for a specified pay period end date.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-LookUp-EarnCalcCd

PAR-803-LookUp-EarnCalcCd

n/a

Displays the contents of the Earnings Calculation Code Reference Table.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-LookUp-HROrg

PAR-801-LookUp-HROrg

n/a

Displays the contents of the HR Organization Reference Table for a specified pay period end date.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-LookUp-JobCd

PAR-800-LookUp-JobCd

n/a

Displays the contents of the Job Class Reference Table for a specified pay period end date.

Reflects Workday data for payroll dates starting January 2015.

 

PAR-LookUp-PARTransTypeCd

PAR-804-LookUp-PARTransTypeCd

n/a

Displays the contents of the PAR Trans Type Reference Table.

Reflects Workday data for payroll dates starting January 2015.




Keywords:BO PAR HR Report InfoView Webi Deski   Doc ID:45903
Owner:James I.Group:University of Chicago
Created:2015-01-02 12:32 CSTUpdated:2015-01-06 12:29 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0