We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Have in Extract result both records in case of rehire, the terminated one and the future one

Received Response
7
Views
2
Comments
edited Nov 10, 2020 8:55PM in HCM Integrations 2 comments

Summary

The future record is needed to trigger onboarding

Content

Hi,

we have to have in the Extract result both record in case of rehire, the terminated one and the future one. 

Actual behaviour is:

Active employees --> listed 

Future employees ( not rehired) --> listed 

Terminated employees --> listed 

Rehired employees --> Terminated record listed, future record not listed

 

The current filter we have is the following one:

((((asg.assignment_type IN ('E','C')) AND (asg.primary_assignment_flag='Y'))
    )
    AND ((pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') BETWEEN asg.effective_start_date AND asg.effective_end_date)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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