Load the metadata file for terminate an employee using HDL

Dat File Name: Worker.dat
 
METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId
 
MERGE|WorkRelationship|HCM Connects|1004|2013/09/17|TERMINATION||Y|300000000000000
MERGE|WorkRelationship|HCM Connects|786786|2024/07/16|RESIGNATION|RESIGN_PERSONAL|Y|300000065159414
 
 
SELECT 
    a.PERSON_NUMBER AS Person_Number, 
    p.PERIOD_OF_SERVICE_ID AS Period_of_Service_ID 
FROM 
    PER_ALL_PEOPLE_F a
JOIN 
    PER_PERIODS_OF_SERVICE p ON a.PERSON_ID = p.PERSON_ID
WHERE 
    a.PERSON_NUMBER = '786786'

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - HDL Templates
Posted by : Mohammad
Follow on Linkedin