Issues on HDL Seniority Dates V3.

Summary:

Hi experts, we are currently experiencing an issue with the HDL mass loading of Seniority Dates. We are using version V3 of the Seniority Dates and would like to mass load the Days adjustments. However, the HDL is not behaving correctly and appears to process the data randomly. Please find the related METADATA we used:

SET FILE_DELIMITER |||| METADATA||||SeniorityDate||||SeniorityDateCode||||PersonNumber||||EntryDate||||EffectiveStartDate||||EffectiveEndDate||||ManualAdjustmentDays||||ManualAdjustmentComments MERGE||||SeniorityDate||||ORA_PER_MIGR_ESD_P||||01021230||||2011/11/01||||2022/12/01||||4712/12/31||||2494||*||Data Migration override

The HDL load fails when the person's record does not contain a value in the Days Adjusted Manually field, meaning that the seniority date has not been overridden. The same issue occurs when the field is set to 0. However, when the Days Adjusted Manually field is set to 1, the system creates a new record and also displays the previous seniority date.