E9.2 SQL Help needed ASAP on F08042 table

pamsturgeon

Member
HI All,
I hope someone can help me out. I need to extract employee leave information from the History table (F08042)

I can't create an UBE for this request as JDE is not our source system (it is now our LEGACY System) so I need to extract the data using SQL
I need to report on all employees who were on a leave on or after Jan 1, 2016

That part I can get :)
I am basing the first part of the query on certain TRS codes that we have setup

Now I have to also determine the date they returned from the leave (by somehow reading the next date for PAST) - not sure how to do that
AND I also need to have the supervisor(ANPA), Home Business Unit (HMC) and Pay Class (SALY) from when they went on leave

Has anyone had to build this SQL before and if so, could you please share it with me
Thanks
Pam
 
Top