OTBI Reports for Payroll Interface Inbound Records

Use the Oracle Tools OTBI and BI publishers to generate any custom reports with the imported payroll data from third party payroll vendors into the Fusion system.

The Payroll Interface Inbound Records Real Time subject area provides the dimensions for back feed information. You can use these dimensions along with other facts in different subject area for cross subject area reporting. Select the attribute from the listed Dimension to generate your own reports.

The dimensions available in the Payroll Interface Inbound Records Real Time subject area are:

Dimension

Description

Payroll Interface Inbound Record

Holds summary information from third-party payroll providers, such as the payroll name, payroll period, start date, of the processed payroll.

Payroll Interface Inbound Record Information

Holds the details of payroll data processed by third-party payroll providers, such as earning, deductions, and messages.

Dimensions to add from existing subject areas:

Common Dimension

Attributes

Worker

Employees’ Personal Related information like Person Number, Display Name, Address.

Legislative Data Group

Country, Currency

Payroll Statutory Unit

Payroll Statutory Unit name, Payroll Statutory Effective

Payroll

Payroll Name, Payroll Frequency, Payroll Effective End Date, Payroll Effective Start Date

Payroll Period

Period Name, Period Number, Period Year

Payroll Relationship

Payroll Relationship Type, Payroll Relationship Start Date, Payroll Relationship End Date, Payroll Relationship Number

Business Unit

Business Unit Name, Status

Department

Department Name, Description,

Job

Job Name, Job Code, Job Descripion, Job Family

Position

Position Code, Position Decription

Location

Location Code, Location Decription