You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Elements - balance name report for pensionable elements

Received Response
31
Views
2
Comments

Summary:

We need to identify which elements are flagged as pensionable in the balance feed.

Content (required):

We need the element name, and then the name, balance name, effective start date and effective end date from the Balance Feed section.

We cannot find this using the "Payroll - Element Entries Real Time" subject area in OTBI.

We have created a report using the below SQL but cannot see how to include the required details for the balance feed information.

select pet.base_element_name

, pec.base_classification_name

, piv.base_name input_value_name

from pay_element_types_f pet

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!