HDL Template for Personal Payment Method Details

 HDL Template for Personal Payment Method Details

Prerequisite: 

1. Bank and Bank Branches data should be loaded. Click here to find the sample bank details.  

2. External bank Account should be loaded. Click here to find the sample file.  

For this use PersonalPaymentMethod.dat file.

You can see step by step video to load Personal Payment Method Details using this Link

Please find the below sample template :

METADATA|PersonalPaymentMethod|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|AssignmentNumber|PersonalPaymentMethodCode|EffectiveStartDate|PaymentAmountType|Amount|Percentage|ProcessingOrder|OrganizationPaymentMethodCode|BankName|BankBranchNumber|BankCountryCode|BankAccountNumber|BankAccountType

MERGE|PersonalPaymentMethod|XXTEST|XXTEST_PAYMETHOD2|US Legislative Data Group|XXTEST_ASSIGN2|XXTEST_PAYMETHOD2|2021/04/19|P||100|1|Direct Deposit|American Bank|000000123|US|3456|Checking

HDL Template for External Bank Account Details

HDL Template for External Bank Account Details   

Prerequisite: 

1. Bank and Bank Branches data should be loaded. Click here to find the sample bank details.   

For this use ExternalBankAccount.dat file.

You can see step by step video to load External Bank Account Details using this Link

Please find the below sample template :

METADATA|ExternalBankAccount|SourceSystemOwner|SourceSystemId|AccountNumber|BankBranchName|BankName|CountryCode|CurrencyCode|AccountType

MERGE|ExternalBankAccount|XXTEST|XXTEST_BANKACCT2|123456|AMC123|American Bank|US|USD|Checking

METADATA|ExternalBankAccountOwner|SourceSystemOwner|SourceSystemId|PersonNumber|AccountNumber|BankBranchNumber|BankNumber|CountryCode|CurrencyCode|BankBranchName|BankName|ExternalBankAccountId(SourceSystemId)

MERGE|ExternalBankAccountOwner|XXTEST|XXTEST_ACCTOWNER2|XXTEST2|123456|123|Test123|US|USD|AMC123|American Bank|XXTEST_BANKACCT2

HDL Template for Bank and Bank Branch Details

  For this use Bank.dat and BankBranch.dat file.

You can see step by step video to load Bank and Bank Branch Details using this Link

Please find the below sample template :

Bank :

METADATA|Bank|BankName|CountryCode|BankNumber|SourceSystemOwner|SourceSystemId

MERGE|Bank|American Bank|US|Test123|XXTEST|XXTEST_BANKTest123

Bank Branch: 

METADATA|BankBranch|BankName|BankBranchNumber|BankBranchName|CountryCode|EftSwiftCode|SourceSystemOwner|SourceSystemId

MERGE|BankBranch|American Bank|123|AMC123|US||XXTEST|XXTEST_BANKBRANCHAM123

HDL Template for Assigned Payroll Details of Worker

 For this use AssignedPayroll.dat file.

You can see step by step video to load Assigned Payroll details of worker using this Link

Please find the below sample template :

METADATA|AssignedPayroll|EffectiveStartDate|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|StartDate

MERGE|AssignedPayroll|2021/04/09|XXTEST_ASSIGN1|Weekly|US Legislative Data Group|2021/04/09

HDL Template for Element Entry Details of Worker

 For this use ElementEntry.dat file.

You can see step by step video to element entry details of worker using this Link

Please find the below sample template for Element Entry Details:

METADATA|ElementEntry|EffectiveEndDate|EffectiveStartDate|ElementName|LegislativeDataGroupName|MultipleEntryCount|EntryType|AssignmentNumber|SourceSystemOwner|SourceSystemId|ReplaceLastEffectiveEndDate

MERGE|ElementEntry|4712/12/31|2021/04/06|Housing Allowance Expat|US Legislative Data Group||E|XXTEST_ASSIGN1|XXTEST|XXTEST_ENTRY2|

METADATA|ElementEntryValue|EffectiveEndDate|EffectiveStartDate|InputValueName|ScreenEntryValue|AssignmentNumber|ElementName|LegislativeDataGroupName|ElementEntryId(SourceSystemId)|SourceSystemOwner|SourceSystemId|ReplaceLastEffectiveEndDate

MERGE|ElementEntryValue|4712/12/31|2021/04/06|Periodicity|PRD|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE4|

MERGE|ElementEntryValue|4712/12/31|2021/04/06|Amount|100|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE5|

MERGE|ElementEntryValue|4712/12/31|2021/04/06|Process Separately|Y|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE6|

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