HDL Template for Person Contact Details

 For this use Contact.dat

You can see step by step video to load person contact details using this Link

Please find the below sample template :

METADATA|Contact|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate

MERGE|Contact|XXTEST|XXTEST_PERCNT2|2019/09/01|4712/12/31|XXTEST_CNT1|2019/09/01

METADATA|ContactName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title

MERGE|ContactName|XXTEST|XXTEST_CNTNM2|XXTEST_PERCNT2|2019/09/01|4712/12/31|US|GLOBAL|ADAM||TEST|MR.

METADATA|ContactRelationship|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|RelatedPersonId(SourceSystemId)|ContactType|BeneficiaryFlag|DependentFlag|EmergencyContactFlag|BondholderFlag

MERGE|ContactRelationship|XXTEST|XXTEST_CREL_CNT2|2019/09/01|4712/12/31|XXTEST_PERCNT2|XXTEST_PER1|Emergency|||Y|

HDL Template for Person Profile Photo

 For this use  Worker.dat

You can see step by step video to upload the profile photo of worker using this Link

Please find the below sample template :

Save the Blob images in BlobFiles folder and make zip of both .dat and BlobFiles folder 

METADATA|PersonImage|SourceSystemOwner|SourceSystemId|PersonNumber|Image|ImageName|PrimaryFlag

MERGE|PersonImage|XXTEST|XXTEST_PER_IMAGE1|XXTEST2|images.jpeg|XXTEST2|Y

HDL Template for Termination of Worker

 for this use Worker.dat

You can see step by step video to termination of worker using this Link

Please find the below sample template :

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|DateStart|WorkerType|ActionCode|TerminateWorkRelationshipFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ProjectedTerminationDate|Comments

MERGE|WorkRelationship|US1 Legal Entity|XXTEST2|2018/01/01|E|TERMINATION|Y|2021/01/02|2021/01/02|2021/01/02|2021/01/02|Sample termination file

HDL Template for Global Transfer of Worker

 For this use Worker.dat

You can see step by step video to do global transfer of worker using this Link

Please find the below sample template :

METADATA|WorkRelationship|PersonNumber|LegalEmployerName|DateStart|ActualTerminationDate|PrimaryFlag|WorkerNumber|WorkerType|RehireRecommendationFlag|OnMilitaryServiceFlag|ActionCode|ReasonCode|DateOfDeath|GlobalTransferFlag

MERGE|WorkRelationship|XXTEST2|US3 Legal Entity|2021/01/05||Y|XXTEST2|E|Y|N|GLB_TRANSFER|||Y

METADATA|WorkTerms|ActionCode|PersonNumber|LegalEmployerName|DateStart|WorkerType|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentType|PersonTypeCode|AssignmentStatusTypeCode|BusinessUnitShortCode|GradeCode|JobCode|LocationCode|DepartmentName|PrimaryWorkTermsFlag|SystemPersonType|ReasonCode

MERGE|WorkTerms|GLB_TRANSFER|XXTEST2|US3 Legal Entity|2021/01/05|E|XXTEST_WRKTERM2-1|2021/01/05|4712/12/31|Y|1|ET|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE1|XXTEST_CFO|XXTEST_LOC5|XXTEST Department1|Y|EMP|REORG

METADATA|Assignment|ActionCode|PersonNumber|LegalEmployerName|DateStart|WorkerType|AssignmentNumber|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentType|PersonTypeCode|AssignmentStatusTypeCode|BusinessUnitShortCode|GradeCode|JobCode|LocationCode|DepartmentName|ManagerFlag|LabourUnionMemberFlag|ReasonCode

MERGE|Assignment|GLB_TRANSFER|XXTEST2|US3 Legal Entity|2021/01/05|E|XXTEST_ASSIGN2-1|XXTEST_WRKTERM2-1|2021/01/05|4712/12/31|Y|1|E|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE1|XXTEST_CFO|XXTEST_LOC5|XXTEST Department1|Y|N|REORG

HDL Template for Assignment Changes of Worker

 For this use Worker.dat

You can see step by step video to make any changes in assignment of worker using this Link

Please find the below sample template :

METADATA|WorkTerms|ActionCode|PersonNumber|LegalEmployerName|DateStart|WorkerType|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentType|PersonTypeCode|AssignmentStatusTypeCode|BusinessUnitShortCode|GradeCode|JobCode|LocationCode|DepartmentName|PrimaryWorkTermsFlag|SystemPersonType|ReasonCode

MERGE|WorkTerms|ASG_CHANGE|XXTEST2|US1 Legal Entity|2018/01/01|E|XXTEST_WRKTERM2|2018/01/01|2021/01/02|Y|1|ET|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE1|XXTEST_CFO|XXTEST_LOC5|XXTEST Department1|Y|EMP|PER_REORGANIZATION

MERGE|WorkTerms|ASG_CHANGE|XXTEST2|US1 Legal Entity|2018/01/01|E|XXTEST_WRKTERM2|2021/01/03|4712/12/31|Y|1|ET|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE2|XXTEST_PM|XXTEST_LOC6|XXTEST Department2|Y|EMP|PER_REORGANIZATION

METADATA|Assignment|ActionCode|PersonNumber|LegalEmployerName|DateStart|WorkerType|AssignmentNumber|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentType|PersonTypeCode|AssignmentStatusTypeCode|BusinessUnitShortCode|GradeCode|JobCode|LocationCode|DepartmentName|ManagerFlag|LabourUnionMemberFlag|ReasonCode

MERGE|Assignment|ASG_CHANGE|XXTEST2|US1 Legal Entity|2018/01/01|E|XXTEST_ASSIGN2|XXTEST_WRKTERM2|2021/01/03|4712/12/31|Y|1|E|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE2|XXTEST_PM|XXTEST_LOC6|XXTEST Department2|Y|N|PER_REORGANIZATION

MERGE|Assignment|ASG_CHANGE|XXTEST2|US1 Legal Entity|2018/01/01|E|XXTEST_ASSIGN2|XXTEST_WRKTERM2|2018/01/01|2021/01/02|Y|1|E|Employee|ACTIVE_PROCESS|US1 Business Unit|XXTEST_GRADE1|XXTEST_CFO|XXTEST_LOC5|XXTEST Department1|Y|N|PER_REORGANIZATION

HDL Template for Reverse Termination of Worker

For this you can use Worker.dat.

You can see step by step video to reverse termination of worker using this Link

Please find the below sample template :

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|DateStart|WorkerType|LegalEmployerName|ReverseTerminationFlag

MERGE|WorkRelationship|XXTEST|XXTEST_PDSERVICE2|XXTEST_PER2|XXETST2|2018/01/01|E|US1 Legal Entity|Y

HDL Template for Assignment Supervisor

To load the assignment supervisor we will use Worker.dat template.

You can see step by step video to load assignment supervisor using this Link

Please find the below sample template :

METADATA|AssignmentSupervisor|AssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|ManagerAssignmentId(SourceSystemId)|ManagerId(SourceSystemId)|ManagerType|PersonId(SourceSystemId)|PrimaryFlag

MERGE|AssignmentSupervisor|XXTEST_ASSIGN2|XXTEST|XXTEST_MANAGER1|2018/01/01|4712/12/31|XXTEST_ASSIGN1|XXTEST_PER1|LINE_MANAGER|XXTEST_PER2|Y