Suggestions on what logic can be used to Identify a new/updated Person row in a Changes-Only Extract

Summary

Suggestions on what logic can be used to Identify a new/updated Person row in a Changes-Only Extract

Content

Hi All,

The HCM Extract contains a record with a combination of Person and Assignment attributes in a multiple work relationship - multiple assignment scenario.

When we run the Extract for the first time (Full File), all records will be treated as 'New' in the destination system as this is the Initial load.

The issue comes up when we run the Extract in Changes-Only mode.

Say a new Assignment is created for that person, we need to pass a value U_C where U means update the person record and create a new assignment record in the destination system.