How to update new record for same effective date
Hi,
I am trying to update a record for an employee with same effective date.
Scenario : Employee already has an record with effective start date as 30-Oct-2023 and I am trying to create new record with same effective start date and by using below HDL, It's overriding existing record.
HDL :
METADATA|WorkTerms|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PersonNumber|DateStart|AssignmentId|PeriodOfServiceId|AssignmentNumber|PrimaryWorkTermsFlag
MERGE|WorkTerms|MANAGER_CHANGE|2023/10/30|4712/12/31|1|Y|****|2014/08/25|****|****|****|Y
METADATA|Assignment|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|BusinessUnitId|WorkTermsAssignmentId|AssignmentNumber|AssignmentId|AssignmentStatusTypeCode|PrimaryAssignmentFlag
MERGE|Assignment|MANAGER_CHANGE|2023/10/30|4712/12/31|1|Y|****|****|****|****|ACTIVE_PROCESS|Y
METADATA|AssignmentSupervisor|EffectiveStartDate|PrimaryFlag|AssignmentNumber|ManagerPersonNumber|ManagerAssignmentNumber|ManagerType