CANCELED_HIRE system person type not populated after cancellation of employee work relationship

Summary:

CANCELED_HIRE system person type not populated after cancellation of employee work relationship

Content (please ensure you mask any confidential information):

When we cancel work relationship for an employee(new starters who have not joined), data gets deleted from per_all_assignments_m table. However, we can see a row in PER_PERSON_TYPE_USAGES_F table with SYSTEM_PERSON_TYPE as 'CANCELED_HIRE'. However, lately we can see deleting employee work relationship is now completely deleting the row from PER_PERSON_TYPE_USAGES_F table. We have HCM extract built on this logic with 'PER_EXT_SEC_PERSON_UE' as root data group user entity with the below filter criteria.