Elements - balance name report for pensionable elements

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