Pending Worker HDL Error
Summary:
Pending Worker HDL Error
Content (required):
We checked through existing notes and other details, but for the given load , we did not find the exact solution-
Error #
You must provide only one parent record Worker and it must start on the earliest effective start date and not have an end date
Sample Load #
METADATA|AssignmentSupervisor|AssignmentId(SourceSystemId)|EffectiveStartDate|ManagerType|PersonId(SourceSystemId)|PrimaryFlag|ManagerPersonNumber|ActionCode|SourceSystemOwner|SourceSystemId|AssignmentNumber
MERGE|AssignmentSupervisor|ASG_2022857|2023/02/09|LINE_MANAGER|WORKER_2022857|N|3891139|ADD_PEN_WKR|ODS|SUPER_2022857|
METADATA|Worker|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|SourceSystemOwner|SourceSystemId|ApplicantNumber
MERGE|Worker|2023/02/09|||2023/02/09|2000/01/01|ADD_PEN_WKR|ODS|WORKER_2022857|2022857
METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentType|EffectiveStartDate|EffectiveLatestChange|EffectiveSequence|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|SystemPersonType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryWorkTermsFlag|SourceSystemOwner|SourceSystemId|LabourUnionMemberFlag|ProjectedStartDate|ProposedUserPersonType|PeriodOfServiceId(SourceSystemId)|PersonNumber|AssignmentNumber|FLEX:PER_ASG_DF|division(PER_ASG_DF=Global Data Elements)|hrLocation(PER_ASG_DF=Global Data Elements)|legacyLocation(PER_ASG_DF=Global Data Elements)|puc(PER_ASG_DF=Global Data Elements)