If any employee is on leave of absence (LOA) or on Global Assignment (GA) and the expected return date is 3 months (or more) later (from the beginning of the LOA/GA), IsActive -field is set to False else always Ture.
If Jobinformation.Emplstatus = ‘D’ (dormant) on system date when employment_information-assignment_class = ‘ST’, check the previous Jobinformation record where the Event = ‘AGA’. If the gap between Event AGA start date and global_assignment_information.planned_end_date is >= 3 months, set Is Active field to False.
If Jobinformation.Emplstatus = ‘P’ or ‘U’ on the system date, check the previous Jobinformation record where the Event = ‘10’. If the gap between Event 10 start date and Jobinformation.expected_return_date is => 3 months, set Is Active field to FALSE.