Changes Only - ignore change in count
Summary:
Regarding HCM EXTRACT Changes mode.
The requirement is to pick up new absences.
The extract contains ABS_EXT_ABSENCES_ENTRY_UE with absence entry id as a key.
DAY 1: person has 5 absences
DAY 2: person has 4 absences (reason relates to effective date or could be related to withdraw).
How can I avoid a 'missing' absence being flagged as a change?
e.g. OLD - NEW = Difference in value should be ignored (5 absences - 4 absences = 1, should not be flagged).
But NEW - OLD = Difference should be picked up (5 absences - 4 absences = 1, should be flagged)
I appreciate that the archive table needs to be populated with the new dataset.