How to add multiple filters in HCM Extract Filter Criteria
We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set.
We want to add another filter under HCM Extract Data Group Filter Criteria. Current filter looks like below:
(pptum.system_person_type IN ('EMP', 'EX_EMP'))
We want to add another filter, where if an employee has been terminated, then we want to check if the same employee has been rehired or not. If the employee is rehired than we want to filter out that employee from our results. In order to achieve this, I am adding a SQL condition, where code is checking for not exists condition i.e. if the effective_start_date of terminated assignment is less than effective_start_date of rehire assignmnet as shown below: