Monday, 28 June 2021

HDL Template for Documents Of Record

 For this use DocumentsOfRecord.dat file.

You can see step by step video to load Documents Of Record using this Link

Please find the below sample template :


METADATA|DocumentsOfRecord|SourceSystemOwner|SourceSystemId|DocumentsOfRecordId|PersonNumber|DocumentTypeId|DocumentType|Country|DocumentCode|DocumentName|DocumentNumber|DateFrom|DateTo|IssuingAuthority|IssuedDate|IssuingCountry|IssuingLocation|Comments|Publish|PublishDate|Status|VerifiedBy|VerifiedDate

MERGE|DocumentsOfRecord|XXTEST|XXTEST_DOCREC01||XXTEST2||Passport||XXTEST_DOCREC01|Passport|XXTEST2123|||||US|||||||


METADATA|DocumentAttachment|SourceSystemOwner|SourceSystemId|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|Title|URLorTextorFileName|File

MERGE|DocumentAttachment|XXTEST|XXTEST_DOCREC01|XXTEST2|Passport||XXTEST_DOCREC01|passport.png|passport.png|FILE|passport.png



No comments:

Post a Comment

Oracle Payroll Balance Adjustments Using HDL (HCM Data Loader) – Complete Guide

Oracle HCM Payroll Balance Adjustments Using HDL – Complete Guide Overview In Oracle Fusion HCM Payroll , organizations sometimes need to ...