Query to retrieve Latest payroll Relationship Number — Cloud Customer Connect
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

Query to retrieve Latest payroll Relationship Number

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

Query to retrieve Latest payroll Relationship Number

Content

Hi ,

 

I am working on a Update Element Entry PBL file and needing to pass Payroll Relationship number for my element which is at Payroll Relationship level.

 

To pass this number I aim looking to find a query to retrieve latest payroll relationship number.

 

I could find them in pay_pay_relationships_dn table but the end date column in this table is same (4712/12/31) for the two rows that are in the table for a given person id.

 

I could see from the application front end that the element entry is tied to a relationship number "xxxx-1" where xxxx is the person number.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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