Query to join BEN_PRTT_ENRT_RSLT to Payroll Tables (PAY_RUN_BALANCES)

Summary:

Hi experts, Just wondering if there's a way to connect the benefits table BEN_PRTT_ENRT_RSLT to payroll table (ex. PAY_RUN_BALANCES). We have a BIP report requirement to basically get enrollments details like plan names, plan types, option name including the Balance value (from Payroll) of the enrollment (from BEN_PRTT_ENRT_RSLT) for a given Pay Period.

Any insights is greatly appreciated.

Thank you,

Ben

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):