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!
UKPAY: 'P45 Issued' Report
Hi Everyone,
It is my first time on here so apologies in advance if i am not posting this in the correct place.
Basically, I am trying to create a report which should provide a list of employees who have been issued with P45 together with the date it was issued on (In oracle Application, I believe this is normally displayed on the Assignment -> Tax Information form). Initially, i thought this data was stored in the table Per_Assignment_Extra_Info. Unfortunately, when i run the following code, i only get around 14 records which is definitely incorrect! .
SELECT hr.PAEI.ASSIGNMENT_ID, hr.PAEI.INFORMATION_TYPE, hr.PAEI.AEI_INFORMATION1 P45Issued, hr.PAEI.AEI_INFORMATION3 IssueDate
0