Unable to update Employment Contract for existing employee using HDL

Summary:

We need to update existing employees who have contract type "Permanent" to "Limited" for 3 years using HDL.

From frond end UI page, we are able to end date the employee contract with type "Permanent" on 30-Nov-2023, then add new record and choose start date as 01-Dec-2023 and choose Limited type and mention 3 years as duration and automatically the contract end date will be calculated as 30-Nov-2026.

The same need to be done for many employees so we need to do it through HDL.

Content (please ensure you mask any confidential information):

One sample employee who has employment action "Location Change" on 01-Sep-2023 and his contract is Permanent from 04-Oct-2020, so the below HDL is used.