For more information, please refer to this announcement explaining best practices for getting answers to questions.
How can change the legal employer Date, but not the enterprise date in work relationship?
Summary:
How can change the legal employer Date, but not the enterprise date in work relationship?
Content (please ensure you mask any confidential information):
Hello team.
We have an issue, the Legal Employer dates were loaded and the enterprise date the same, but we need to change only the legal employer date. We try to do it through the following HDL, where we want to change the legal employer date to 2023, but keeping the enterprise seniority which is 2022.
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId|LegalEmployerName|NewStartDate|DateStart
MERGE|WorkRelationship|HRC_SQLLOADER|20220013_PERIOD_OF_SERVICE|300000017092178|LEGAL EMPLOYER TEST|2023/08/18|2022/08/18
But when loading this HDL it is also modifying (to 2023) the Enterprise one, the Oracle team tells us that this is the expected sharing, but I would like to know if someone in the community knows how to change only the date of the legal employer, please?