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

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)