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!
UK PAY: Need help in extracting Employee Payroll Balances
Hi,
We need to extract Employee Payroll balances.
columns:
Employee Number
Balance Name
Dimension Name
Balance upload date
Balance Value
I tried using Pay_latest_balances, but it does not contain all data ( certain balance type id's were missing )
tried PAY_PERSON_LATEST_BALANCES, but it has no data
as we are in the U.K , tried using PAY_gb_balances_v, but this table has millions of rows. not sure how to filter them down to a employee level. it does not have person_id, only assignment level data.
could anyone please suggest a SQL to retrieve the above information
Tagged:
0