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

In HCM Extracts how to Create advanced Filter?

edited Jan 2, 2026 9:00AM in HCM Data Loader (HDL) 4 comments

Summary:

This is an task assigned to me where I have to build HCM Extract with Person →Assignment → Payroll → Bank (external) data groups. which I have done successfully but I was getting error with filter criteria.

criteria Filter for active employees, exclude suspended, include pending workers starting within 7 days in the assignment data group.


Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Filter criteria query : ((Extract Assignment Status Type = 'ACTIVE'AND NVL(EffectiveEndDate, TO_DATE('4712-12-31','YYYY-MM-DD')) >= :EFFECTIVE_DATE)OR(Extract Assignment Status Type = 'PENDING_WORKER'AND EffectiveStartDate >= :EFFECTIVE_DATEAND EffectiveStartDate < (:EFFECTIVE_DATE + 8)))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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