Sunday, 9 January 2022

Cancel Work Relationship HDL

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId|CancelWorkRelationshipFlag
DELETE|WorkRelationship|FUSION|300000012545898|300000012549658|Y
select hik.source_system_owner, hik.source_system_id, ppos.person_id
 from per_periods_of_service ppos, hrc_integration_key_map hik
 where ppos.period_of_service_id = hik.surrogate_id
  and ppos.person_id in (select person_id from per_all_people_f
where person_number = '12345678')