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!
OTL: PTO hours entered in approved timecards per employee in OTL.
All,
I have a requirement to create a query to get the total of PTO hours entered in approved timecards per employee in OTL. I am not familiar with the OTL tables and wonder which are the tables to get this info from. I see the hxc_timecard_summary table and resource_id (person) and timecard_id in that table.
From there, how can I go about getting the total PTO hours entered in approved timecards for any given period.
Any help will be greatly appreciated.
Thanks
--Paul Fernandez
I have a requirement to create a query to get the total of PTO hours entered in approved timecards per employee in OTL. I am not familiar with the OTL tables and wonder which are the tables to get this info from. I see the hxc_timecard_summary table and resource_id (person) and timecard_id in that table.
From there, how can I go about getting the total PTO hours entered in approved timecards for any given period.
Any help will be greatly appreciated.
Thanks
--Paul Fernandez
0