How to update Termination Record using HDL?

Tags: HCM Data Loader, VIP Content
You are currently viewing How to update Termination Record using HDL?
How to update Termination Record using HDL

In this article we will look into how to update the termination record using HDL.

Normally there won’t be a need to update the termination record. However there could be scenarios where the actual termination date needs to be preponed or postponed as per manager’s discretion and data upload needs to be done to update this information.

Also there could be scenarios like incorrect data getting loaded and we need to tag them to specific action/action_reason while terminating employees so that they can be skipped from other interfaces by identifying them with custom action and action reason.

If there is a need to update just the actual termination date, we can do it directly by providing the actual termination date and setting the CorrectTerminationFlag to Y.

Table of Contents

Sample Worker.dat to correct ActualTerminationDate:

METADATA|WorkRelationship|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ProjectedTerminationDate|CorrectTerminationFlag
MERGE|WorkRelationship|123456|Fusion HCM Knowledgebase Inc|2010/01/01|E|Y|2021/01/01|2021/01/01|2021/01/01|2021/01/01|Y

If there is a need to modify the action/action_reason as well, then the above approach won’t work and there isn’t a straight forward solution to implement it.

We need to first reverse terminate the existing termination row and then load the new termination using the right action/action_reason combination.

Sample Worker.dat for Reverse Termination:

METADATA|WorkRelationship|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|ReverseTerminationFlag
MERGE|WorkRelationship|123456|Fusion HCM Knowledgebase Inc|2010/01/01|E|Y|Y

Sample Worker.dat to load the Termination with correct Action/Action_Reason:

METADATA|WorkRelationship|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ProjectedTerminationDate|TerminateWorkRelationshipFlag|RehireRecommendationFlag|RehireReason|ActionCode|ReasonCode
MERGE|WorkRelationship|123456|Fusion HCM Knowledgebase Inc|2010/01/01|E|Y|2021/02/02|2021/02/02|2021/02/02|2021/02/02|Y|N||PURGE|PURGE
If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.