Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Is there a way to get payroll_id/payroll_name associated with an employee in FAW?

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.
Answers
-
0
-
Hi @User_00CZ1
As per below, I didnt see asg_f is not mapped to payroll_d table.
Looping Product team -
@Nupur Joshi-Oracle Any comments pls?
Regards,
Arjun
1 -
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
0