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

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

in Payroll and Global Payroll Interface (GPI)

Summary:

I need help to find out how to join the Pension scheme in Calculation Cards > Benefits and Pensions back to the Assignment number/id for a BIP report.

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

Content (please ensure you mask any confidential information):

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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