Restore Outstanding objects in a custom table?

Been trying to find a solution for restoring Outstanding objects in a custom table. 

The scenarios is like this, Sync from HR-system -> Custom Staging Table -> Person.

The reason for the "staging" table is cause I want to catch some changes there before they're synced to Person, if for some reason an identity is missing from HR, they're marked as Outstanding in the staging table, If the same identity returns in the sync I want to be able to remove the Outstanding state. 

Parents Reply Children