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')
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')
No comments:
Post a Comment