Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
How to retrieve deduction information from the database?
I have been asked to write a query which retrieves the following deduction information for our employees:
GRE
Employee Name
Employee Number
Assignment Number
Deduction Date
Deduction (Element) Name
Deduction Amount
Total Amount Owed
Amount Withheld to Date
Remaining Balance
I can get most of that information from the 'apps.pay_us_deductions_report_v' with the below query, but it does not include the 'Amount Withheld to Date' or the 'Remaining Balance'. Is there a better view that I can utilize which includes that information, or perhaps a function to calculate them?
SELECT pudrv.gre,
pudrv.full_name,
pudrv.employee_number,