HDL Template for Fusion HCM Mass Load

HDL stands for HCM Data Load, an easy way to load mass data for different objects in Fusion application. This article is to compile all the possible objects and their HDL format to make it available easily for all

Area of Responsibility -

METADATA|AreasOfResponsibility|ResponsibilityName|ResponsibilityType|StartDate|Status|PersonNumber|AssignmentNumber|WorkContactsFlag
DELETE|AreasOfResponsibility|HR Specialist-IN|HR Specialist|1951/01/01|Active|11111|E11111|Y

METADATA|AreasOfResponsibility|ResponsibilityName|ResponsibilityType|StartDate|Status|PersonNumber|AssignmentNumber|OrganizationName|WorkContactsFlag
MERGE|AreasOfResponsibility|VP|VP|2022/07/01|Active|11111|E111111|Executive|Y

Job -

METADATA|Job|SourceSystemOwner|SourceSystemId|ActiveStatus|SetCode|EffectiveStartDate|EffectiveEndDate|Name|JobCode
MERGE|Job|VISION|Assistant-Administration|A|COMMON|1901/01/01|4712/12/31|Assistant-Administration|Assistant-Administration

Job Legislative -

METADATA|JobLegislative|JobCode|SequenceNumber|SetCode|JobId|EffectiveStartDate|LegislationCode|InformationCategory|EFF_CATEGORY_CODE|FLEX:PER_JOBS_LEG_EFF|_JOB_GROUP(PER_JOBS_LEG_EFF=HRX_US_JOBS)|_EEO1_CATEGORY(PER_JOBS_LEG_EFF=HRX_US_JOBS)|_FLSA_STATUS(PER_JOBS_LEG_EFF=HRX_US_JOBS)
MERGE|JobLegislative|Assistant-Administration|1|COMMON|300000003698703|1901/01/01|US|HRX_US_JOBS|JOB_LEG|HRX_US_JOBS||ADMIN|NONEXEMPT

Department -

METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationId|LocationSetCode|SourceSystemOwner|SourceSystemId|ClassificationName
MERGE|Organization|1951/01/01|4712/12/31|Executive|DEPARTMENT|||VISION|Executive|DEPARTMENT

Payroll Relationship -

METADATA|AssignedPayroll|AssignmentNumber|PayrollDefinitionCode|EffectiveStartDate|EffectiveEndDate|LegislativeDataGroupName|SourceSystemOwner|SourceSystemId
MERGE|AssignedPayroll|E711|Bi Weekly|2015/09/14||US Legislative Data Group|VISION|300000010271881

Time Card Load -

METADATA|TimeRecordGroup|GroupType|ResourceType|PersonNumber|AssignmentNumber|TcStartTime|TcStopTime
MERGE|TimeRecordGroup|RPTD_TIME|PERSON|12345|E12345|2019/06/09 00:00:00|2019/06/15 23:59:59 

METADATA|TimeRecord|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|OrderEntered|StartTime|StopTime|TmRecType|AssignmentNumber
MERGE|TimeRecord|RPTD_TIME|PERSON|12345|2019/06/09 00:00:00|2019/06/15 23:59:59|1|2019/06/11 08:10:50|2019/06/11 17:06:32|RANGE|E12345

METADATA|TimeRepositoryAttribute|GroupType|ResourceType|PersonNumber|TcStartTime|TcStopTime|OrderEntered|AttributeName|AttributeDataType|AttributeStringValue
MERGE|TimeRepositoryAttribute|RPTD_TIME|PERSON|12345|2019/06/09 00:00:00|2019/06/15 23:59:59|1|PayrollTimeType|STRING|REG

Talent Profile -

METADATA|TalentProfile|ProfileCode|ProfileStatusCode|ProfileUsageCode|PersonNumber
MERGE|TalentProfile|VIS_1234|A|P|11111

METADATA|ProfileItem|ProfileItemId|DateFrom|DateTo|ContentTypeId|ProfileCode|ITEM_TEXT240_10|SectionId
MERGE|ProfileItem|123456789|2020/06/01|4712/12/31|101|VIS_1234|Lead|300000082236435

Value Set -

ValueSetCode|Value|Description|EnabledFlag|SortOrder
VISION_VS|11|Butterfly|Y|

Position -

METADATA|Position|BusinessUnitName|PositionCode|EffectiveEndDate|EffectiveStartDate|ActiveStatus|DepartmentName|FTE|Frequency|StandardWorkingFrequency|HeadCount|HiringStatus|JobCode|JobSetCode|LocationCode|LocationSetCode|Name|PositionType|ProbationPeriod|ProbationPeriodUnitCd|RegularTemporary|SeasonalFlag|StandardWorkingHours|StartTime|EndTime|WorkingHours|SourceSystemId|SourceSystemOwner
MERGE|Position|BU NAME||4712/12/31|1951/01/01|A|Department_Name|20|W|W|20|APPROVED|JOB_CODE|JOB_REFERENCE_SET|||POSITION_NAME|SHARED|||R|N|40|8:00|17:00|40|FUSION_PL_0012142022|FUSION_HDL

Organization Tree -

METADATA|OrganizationTreeNode|TreeStructureCode|TreeCode|TreeVersionName|OrganizationName|ClassificationCode|ParentOrganizationName|ParentClassificationCode
MERGE|OrganizationTreeNode|PER_ORG_TREE_STRUCTURE|VISION_TREE_CODE|VISION_TREE_CODE_V_1.0|Department_Name|DEPARTMENT|Parent_Department|FUN_BUSINESS_UNIT

Default Expense Account -

METADATA|Assignment|AssignmentNumber|WorkTermsNumber|ActionCode|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|EffectiveEndDate|PeriodOfServiceId|DefaultExpenseAccount
MERGE|Assignment|E10000|ET10000|ASG_CHANGE|Y|1|2009/09/09|4712/12/31|100000007164363|1111.1111111.1111.1110101.00000.0000.0000

User-Defined Tables -

METADATA|UserDefinedTable|UserTableCode|RangeOrMatch|UserKeyUnits|UserRowTitle|UserTableName|LegislativeDataGroupName

MERGE|UserDefinedTable|PERDIEM_COUNTRY_CLASS|M|T||PERDIEM_COUNTRY_CLASS|US Legislative Data Group

METADATA|UserDefinedTableColumn|UserColumnCode|DataType|UserColumnName|UserTableCode|LegislativeDataGroupName|FormulaName

MERGE|UserDefinedTableColumn|COUNTRY|T|COUNTRY|PERDIEM_COUNTRY_CLASS|US Legislative Data Group|

METADATA|UserDefinedTableRow|DisplaySequence|EffectiveEndDate|EffectiveStartDate|RowHighRange|RowLowRangeOrName|UserTableCode|LegislativeDataGroupName|RowName

MERGE|UserDefinedTableRow|4|4712/12/31|1951/01/01||AQ|PERDIEM_COUNTRY_CLASS|US egislative Data Group|AQ

METADATA|UserDefinedTableColumnInstance|EffectiveEndDate|EffectiveStartDate|Value|LegislativeDataGroupName|UserColumnCode|RowLowRangeOrName|UserTableCode

MERGE|UserDefinedTableColumnInstance|4712/12/31|1951/01/01|C|US Legislative Data Group|COUNTRY|AQ|PERDIEM_COUNTRY_CLASS

Modify the DOJ of Employee through the HDL -

METADATA|WorkRelationship|PeriodOfServiceId|PersonNumber|LegalEmployerName|NewStartDate

MERGE|WorkRelationship|300000018121215|30503|LE NAME|2020/09/01

Bank Accounts

METADATA|ExternalBankAccount|BankName|BankBranchName|AccountNumber|IBAN|CountryCode|CurrencyCode|SourceSystemOwner|SourceSystemId|AccountName

MERGE|ExternalBankAccount|EmployeeBankName|BankBranch|168XXXXXXXXXXXXX|XXXXXXXXXXXXXXXXXX|US|USD|FUSION_UPLOAD|XX|Employee Name

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

MERGE|ExternalBankAccountOwner|72XXX|EmployeeBankName|168XXXXXXXXXXXXX|US|USD|BankBranch|Y|FUSION_UPLOAD|XX|XX

Personal Payment Method

METADATA|PersonalPaymentMethod|LegislativeDataGroupName|AssignmentNumber|PersonalPaymentMethodCode|EffectiveStartDate|PaymentAmountType|Percentage|BankAccountType|SecondaryAccountReference|OrganizationPaymentMethodCode|GUID|BankName|BankBranchName|BankCountryCode|BankAccountNumber

MERGE|PersonalPaymentMethod|SA Legislative Data Group|E224XXX|E224XXX-EFT|2021/01/01|P|100|||XXXX Bank Transfer||Employee Bank Name|Bank Branch|US|682XXXXXXXXXX

to be continued . . .