I'm pulling a rpt together of all employee(s) who have an indicator in HR_User_Data 1 and 2. Of those people, I need to list all New Hires, Rehires, Terms Action=PAY, Action Reason=PRO. I only need to see 'Action_Reason' = 'PRO' under the 'Action'= 'Pay'. Seems confusing...I'm going cross eyed. If I pull the New Hire and Terms portion, any terms who were also hired in the same 'Action Date' range, I only get one row for the most current 'Action'.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.