Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to add multiple filters in HCM Extract Filter Criteria — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add multiple filters in HCM Extract Filter Criteria

Received Response
31
Views
4
Comments

Summary:

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.

Content (required):

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!