PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE returning duplicate rows for Employees with current and future

Summary

PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE returning duplicate rows for Employees with current and future assignment records

Content

Hi All,

Duplicate rows appear only for Employees with current and future assignment records, duplicates do not appear for only current or only future assignment records.

Please find details below:

Root UE: PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE

Threading Database Item: Extract Assignment ID

Key Attributes: Extract Assignment ID, Assignment Effective Start Date, Assignment Effective Latest Change, Assignment Effective Sequence, Assignment Legal Employer ID, Period of Service ID

Test Case:

Today: 18th June 2019

The employee has an assignment update on the 19th of June 2019, a new position is being added