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

Is there a way to connect PAY_ACTION_INFORMATION table and PAY_FLOW_INSTANCES table?

Accepted answer
44
Views
2
Comments
edited Mar 2, 2022 5:06PM in Payroll and Global Payroll Interface (GPI) 2 comments

Summary:

I would like to see the change only extract resultant data in the backend tables by connecting the extract instance name.

Content (required):

I would like to see the change only extract resultant data in the backend tables by connecting the extract instance name. We could see the extract results in PAY_ACTION_INFOMRATION/PAY_ACTION_DETAILS records. But unable to find a way to join to PAY_FLOW_INSTANCES table.

we could see the request id of each threads triggered as part of the extract run in PAY_ACTION_DETAILS. Still I couldn't find a way to connect them together to pull a report. Ultimate objective is to pull all the employees processed during a particular extract run.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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