What is the minimum information necessary to update contracts
Summary:
Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTRACTS_F.ASSIGNMENT_ID = PER_ALL_ASSIGNMENTS_M.ASSIGNMENT_ID to get the work terms table or PER_CONTRACTS_F.ASSIGNMENT_ID = PER_ALL_ASSIGNMENTS_M.WORK_TERMS_ASSIGNMENT_ID to get assignment table and getting period of service ID from either of them but I do not have source system ID or source system owner to merge with the current contracts.
Is there an SQL that I can use that pulls only the required information and I can directly upload as a HDL so that I can merge with the current contracts without any issues?
I was hoping I could just use METADATA and MERGE for Contract without including Assignment or WorkTerms.
Contracts missing PERIOD_OF_SERVICE_ID are 1000+ which is why I am trying to minimize information inside of the HDL so that any other data changes cannot be affected.
Original data was uploaded years ago, we are now on v2 of contract BO.
Version (include the version you are using, if applicable):
25A
Code Snippet (add any code snippets that support your topic, if applicable):
select "PER_CONTRACTS_F"."CONTRACT_ID" as "ContractId","PER_CONTRACTS_F"."EFFECTIVE_START_DATE" as "EffectiveStartDate","PER_CONTRACTS_F"."EFFECTIVE_END_DATE" as "EffectiveEndDate","PER_ALL_ASSIGNMENTS_M"."PERIOD_OF_SERVICE_ID" as "PeriodOfServiceId"
from"FUSION"."PER_ALL_ASSIGNMENTS_M" "PER_ALL_ASSIGNMENTS_M","FUSION"."PER_CONTRACTS_F" "PER_CONTRACTS_F"
where "PER_CONTRACTS_F"."ASSIGNMENT_ID"="PER_ALL_ASSIGNMENTS_M"."ASSIGNMENT_ID"and "PER_CONTRACTS_F"."PERIOD_OF_SERVICE_ID" is null
order by "PER_CONTRACTS_F"."CONTRACT_ID" ASC