Elements - balance name report for pensionable elements
We need to identify which elements are flagged as pensionable in the balance feed.
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.
, piv.base_name input_value_name
from pay_element_types_f pet