Pending Worker Termination removes record from per_Periods_of_service
Summary:
Pending Worker Termination removes record from per_Periods_of_service
Content (please ensure you mask any confidential information):
Hi All,
Greetings!
As we know - when there is a pending worker record created in HCM Cloud - it will have the related work relationship and assignment and the data does exist in tables like PER_ALL_PEOPLE_F (person), PER_ALL_ASSIGNMENTS_M(assignment with pending worker type) and PER_PERIODS_OF_SERVICE (service record with PERIOD_TYPE ='P')
But there are cases observed where the pending worker has been terminated (as they are not going to get hired) and the data gets completely cleared from the PER_PERIODS_OF_SERVICE table which also does not remove any trace of pending worker termination.