Is there a way to get payroll_id/payroll_name associated with an employee in FAW?

Question

I can see the setup table: dw_pay_payroll_d in FAW having payroll_id, payroll_name. But, how do we link it with person table: dw_person_d or assignment table: dw_wrkfrc_asg_f. Please suggest.

Nupur Joshi-Oracle · Answer

Hi @Rituparna Maity

The mentioned payroll tables are used in FDI payroll offerings like Payroll Balances & Payroll Costing.

Your ask is to expose Payroll Name with assignment data. There are some grain considerations here like payroll relationship ID and assignment Id which is not supported as mentioned by @Mallikarjuna Kuppauru-Oracle in above comment.

Can you please share your exact use case ? accordingly we can guide to provide guidance on what can be an ideal way to achieve the use case.

Regards,

Nupur

Mallikarjuna Kuppauru-Oracle · Answer

Hi @User_00CZ1

As per below, I didnt see asg_f is not mapped to payroll_d table.

https://docs.oracle.com/en/cloud/saas/analytics/22r1/fahia/chapter-relationship-diagram.html#GUID-AF408B5C-E10E-4982-B546-E258B56F8C27

Looping Product team -

@Nupur Joshi-Oracle  Any comments pls?

Regards,

Arjun

RajeshPolavarapu-Oracle · Answer

@Nupur Joshi-Oracle

Can you please help us in providing answer for above question.

Thank You.