You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can change the legal employer Date, but not the enterprise date in work relationship?

Accepted answer
41
Views
6
Comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!