SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple Assignments

Hi

Navigation: Calculation Cards > Benefits and Pensions

I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report.

If nothing else, the SQL behind the screen below will help me.

I can see the pension scheme is held in this view: pay_dir_card_comp_defs_vl but I can't see how to link that back to the assignment on the screen.

Please see below

1. screen in fusion
2. current SQL
3. current and required output

Thanks in advance

SELECT
pprd.person_id,
ppgd.assignment_id,
ppgd.assignment_number,
pdccf.context_value1 AS pension_payroll_id,