Worker - HDL error for update Position in the employee
Hi team I need help with Worker HDL, We need to update the position of some employees but it always does, but it is not clear what information is missing
following the message and the HDL model being used
METADATA | WorkTerms | AssignmentId | PersonId | ActionCode | PeriodOfServiceId | EffectiveStartDate | EffectiveEndDate | EffectiveSequence | EffectiveLatestChange | PositionCode | PositionId |
|---|---|---|---|---|---|---|---|---|---|---|---|
MERGE | WorkTerms | 300001009992687 | 300000243106413 | ASG_CHANGE | 300001009992681 | 2025/02/28 | 4712/12/31 | 1 | Y | 60233363 | 300000019133930 |
METADATA | Assignment | AssignmentId | PersonId | ActionCode | WorkTermsAssignmentId | EffectiveStartDate | EffectiveEndDate | EffectiveSequence | EffectiveLatestChange | PositionCode | PositionId |
MERGE | Assignment | 300001009992687 | 300000243106413 | ASG_CHANGE | 300001009992682 | 2025/02/28 | 4712/12/31 | 1 | Y | 60233363 | 300000019133930 |
Message error 1 - The corresponding date effective record in the {PARENTNAME} for date {DATE}, action {ACTION}, and effective sequence {SEQ} is missing for the {CHILDNAME}.
Message error 2 - Work terms records are required when you create or update assignments.