For more information, please refer to this announcement explaining best practices for getting answers to questions.
HDL to load corrections to assignment is giving error
Content
Hi,
I am trying to make corrections to a workers assignmnet by changing the Action code but i am getting the error. Following is the worker.dat file i am using to make these corrections.
error:
The corresponding date effective record in the WorkTerms for date 2018-02-01, action ALLOCATE_GRP_CMP, and effective sequence 1 is missing for the Assignments.
|
SYNTAX USED:
COMMENT Business Entity : WorkTerms
COMMENT ##############################################################################
METADATA|WorkTerms|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PeriodOfServiceId|BusinessUnitId|ActionCode|SystemPersonType
MERGE|WorkTerms|100000000170382|2018/02/01|4712/12/31|1|Y|100000000164848|100000000012032|PROMOTION|EMP
COMMENT Business Entity : Assignment
COMMENT ##############################################################################
METADATA|Assignment|AssignmentId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|WorkTermsAssignmentId|AssignmentType|AssignmentStatusTypeCode|BusinessUnitId|PrimaryAssignmentFlag|SystemPersonType