HDL – Sample file to cancel Pending Worker Work Relationship
In case, you want to cancel work relationship of a Pending worker, below HDL can be used. Make sure to pass CancelWorkRelationshipFlag as Y.
You can extract the relevant Ids using below SQL:
select hikm.source_system_owner, hikm.source_system_id, ppos.person_id
from per_periods_of_service ppos
where ppos.period_of_service_id = hikm.surrogate_id
and ppos.person_id in (select person_id from per_all_people_f
where person_number = '1894')