You are currently viewing Sample HCM Data Loader (HDL) files for all Business Objects
Sample HCM Data Loader (HDL) files for all Business Objects

In this article, I will be sharing the sample HCM Data Loader templates to get the business objects loaded.

Want to learn Fusion Technical tools? Check out this article

If you are new to HDL, please go through previous posts to get basics of HDL.

Sample HDL files for Business Objects in Fusion HCM:

Setup Business Objects:
ActionReasons.dat
METADATA|ActionReasons|SourceSystemOwner|SourceSystemId|ActionReasonCode|ActionReason|StartDate|EndDate
MERGE|ActionReasons|VISION|TEST_AR|TEST_ACTNREASON|Test Reason|2000/01/01|4712/12/31
ActionReasonsTranslation.dat
METADATA|ActionReasonsTranslation|SourceSystemOwner|SourceSystemId|ActionReason|Language
MERGE|ActionReasonsTranslation|VISION|AR_VISION_PERF|Accomplissement|FR
Actions.dat
METADATA|Actions|SourceSystemOwner|SourceSystemId|ActionCode|ActionName|ActionTypeCode|StartDate|EndDate
MERGE|Actions|VISION|TEST_ACTN|TEST_ACTION|Test Action|EMPL_PROMOTION|2000/01/01|
METADATA|ActionReasonUsage|ActionCode|ActionReasonCode|StartDate|EndDate
MERGE|ActionReasonUsage|TEST_ACTION|TEST_ACTNREASON|2000/01/01|
ActionsTranslation.dat
METADATA|ActionsTranslation|SourceSystemOwner|SourceSystemId|Language|ActionName|Description
MERGE|ActionsTranslation|VISION|ACT_VISION_PROM|FR|Performance|Changement est survenu en raison de la performance des employes
CalendarEvent.dat
COMMENT Data for Business Object: CalendarEvent Version: V2 Created on: 27-08-2013
METADATA|CalendarEvent|CalendarEventId|Name|Description|Category|CoverageType|ShortCode|StartDateTime|EndDateTime|TreeCode|TreeStructureCode|TreeVersionName|SourceSystemOwner|SourceSystemId|GUID
MERGE|CalendarEvent||TestName1|Create|PH|O|Testing1|2012/10/10 09:01:10|2016/10/10 09:01:10|GenOrg_Tree4 C|PER_ORG_TREE_STRUCTURE|GenOrg_Tree4 V1|VISION|CE000111001|
Work Structures Business Objects:
Grade.dat
METADATA|Grade|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|GradeCode|SetCode|GradeName|ActiveStatus
MERGE|Grade|VISION|55902_GRADE|1951/01/01|4712/12/31|03-MCR_GRD_M001|COMMON|03-Marketing Executive|A
MERGE|Grade|VISION|55903_GRADE|1951/01/01|4712/12/31|03-MCR_GRD_M002|COMMON|03-Marketing Manager|A
GradeRate.dat
METADATA|GradeRate|SourceSystemId|SourceSystemOwner|EffectiveEndDate|EffectiveStartDate|LegislativeDataGroup|RateType|GradeRateName|CurrencyCode|RateFrequency|AnnualizationFactor|ActiveStatus
MERGE|GradeRate|GRTHXSIDPSIA|VISION|4712/12/31|1900/01/01|US|SALARY|HXSID_PSIA_ _PSI Salary Plan 1|USD|ANNUAL|1.00000|A
MERGE|GradeRate|GRTHXSIDCWBA|VISION|4712/12/31|1900/01/01|US|SALARY|HXSID_CWBA_ _CWB Salary Plan 1|USD|ANNUAL|1.00000|A
METADATA|GradeRateValue|SourceSystemId|SourceSystemOwner|EffectiveStartDate|EffectiveEndDate|RateId(SourceSystemId)|RateObjectId(SourceSystemId)|LegislativeDataGroup|MinimumAmount|MaximumAmount|MidValueAmount|ValueAmount
MERGE|GradeRateValue|GRVHXSIDPSIA001|VISION|1900/01/01|4712/12/31|GRTHXSIDPSIA|GRDHXSID001|US|20000|40000|30000|
MERGE|GradeRateValue|GRVHXSIDCWBA001|VISION|1900/01/01|4712/12/31|GRTHXSIDCWBA|GRDHXSID001|US|25000|50000|37500|
GradeLadder.dat
METADATA|GradeLadder|GradeLadderId|EffectiveStartDate|EffectiveEndDate|GradeLadderName|ActionReasonCode|GradeSetId|GradeType|ActiveStatus|GradeSetCode|SourceSystemOwner|SourceSystemId|GUID
MERGE|GradeLadder||2000/01/01|4712/12/31|GRD_LDR_HDL_001|||STEP|Active|COMMON|VISION|GRD_LDR_HDL_001|
METADATA|GradesInLadder|GradesInLadderId|EffectiveStartDate|EffectiveEndDate|GradeLadderId(SourceSystemId)|GradeId|GradesInLadderSequence|GradeSetCode|GradeCode|GradeLadderName|SourceSystemOwner|SourceSystemId|GUID
MERGE|GradesInLadder||2000/01/01|4712/12/31|GRD_LDR_HDL_001||1|COMMON|TEST_GRD_1598|GRD_LDR_HDL_001|VISION|GRD_LDR_HDL_001_TEST_GRD_1598|
METADATA|StepRate|RateId|EffectiveStartDate|EffectiveEndDate|LegislativeDataGroupId|LegislationCode|GradeLadderId(SourceSystemId)|RateName|RateType|CurrencyCode|RateFrequency|AnnualizationFactor|ActiveStatus|LegislativeDataGroup|GradeLadderName|SourceSystemOwner|SourceSystemId|GUID
MERGE|StepRate||2000/01/01|4712/12/31|||GRD_LDR_HDL_001|STP_RATE_HDL_001|SALARY|USD|Annual|1|Active|Vision Corporation US LDG|GRD_LDR_HDL_001|VISION|STP_RATE_HDL_001|
METADATA|StepRateValue|RateValueId|EffectiveStartDate|EffectiveEndDate|RateId(SourceSystemId)|RateObjectId|StepRateValueAmount|LegislationCode|RateName|GradeSetCode|GradeCode|GradeStepName|LegislativeDataGroup|GradeLadderName|SourceSystemOwner|SourceSystemId|GUID
MERGE|StepRateValue||2000/01/01|4712/12/31|STP_RATE_HDL_001||5000||STP_RATE_HDL_001|COMMON|TEST_GRD_1598|TEST_GRD_1598_STEP1|Vision Corporation US LDG|GRD_LDR_HDL_001|VISION|STP_RATE_HDL_001_VAL|
Job.dat
METADATA|Job|SourceSystemOwner|SourceSystemId|ActiveStatus|BenchmarkJobFlag|SetCode|EffectiveStartDate|EffectiveEndDate|Name|ApprovalAuthority|JobCode|MedicalCheckupRequired|JobFamilyName
MERGE|Job|VISION|93068_JOB|A|N|COMMON|1951/01/01|4712/12/31|05-Marketing Executive||05-MCR_M001|N|
MERGE|Job|VISION|93069_JOB|A|N|COMMON|1951/01/01|4712/12/31|05-Marketing Manager||05-MCR_M002|N|
JobFamily.dat
METADATA|JobFamily|SourceSystemId|SourceSystemOwner|EffectiveStartDate|EffectiveEndDate|JobFamilyName|ActiveStatus
MERGE|JobFamily|JOFK0HM01|VISION|1980/01/01|4712/12/31|K0HM01_Combat Arms|A
MERGE|JobFamily|JOFK0HM02|VISION|1980/01/01|4712/12/31|K0HM02_Land Operations and Support|A
Location.dat
METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|LocationCode|SetCode|LocationName|Description|ActiveStatus|Country|AddressLine1|AddressLine2|TownOrCity|Region1|Region2|PostalCode
MERGE|Location|VISION|33735_LOCATION|0001/01/01|4712/12/31|03-Sun Corporation Corporate HQ|COMMON|03-Sun Corporation Corporate HQ|03-Sun Corporation Corporate Head Quarters|A|US|Avenue beach heights|Dyckman Street|New York|New York|NY|10130
MERGE|Location|VISION|33736_LOCATION|0001/01/01|4712/12/31|03-Sun Corporation  R&D|COMMON|03-Sun Corporation  R&D|03-Sun Corporation  Research and Development centre|A|GB|18 High Street||Marlow||Buckinghamshire|
MERGE|Location|VISION|33737_LOCATION|0001/01/01|4712/12/31|03-Sun Corporation Sales|COMMON|03-Sun Corporation Sales|03-Sun Corporation Sales using User Key |A|GB|18 High Street||Marlow||Buckinghamshire|
Organization.dat
METADATA|Organization|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|Name|LocationId(SourceSystemId)
MERGE|Organization|VISION|10629_ORGANIZATION|1951/01/01|4712/12/31|03-Sun Corporation|
METADATA|OrgUnitClassification|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)|ClassificationCode|SetCode|Status
MERGE|OrgUnitClassification|VISION|10629_ORGANIZATION_CLASS|1951/01/01|4712/12/31|10629_ORGANIZATION|DEPARTMENT|COMMON|A
METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationName|LocationCode|LocationSetCode
MERGE|Organization|1951/01/01||Retail Sales& Marketing|DEPARTMENT||
MERGE|Organization|1951/01/01||BI-Stores|DEPARTMENT||
METADATA|OrgUnitClassification|EffectiveStartDate|EffectiveEndDate|OrganizationName|ClassificationName|SetCode|Status
MERGE|OrgUnitClassification|1951/01/01||Retail Sales& Marketing|DEPARTMENT|COMMON|A
MERGE|OrgUnitClassification|1951/01/01||BI-Stores|DEPARTMENT|COMMON|A
DepartmentTree.dat
METADATA|DepartmentTree|DepartmentTreeId|TreeStructureCode|TreeCode|TreeName|TreeDescription
MERGE|DepartmentTree||PER_DEPT_TREE_STRUCTURE|SM_Test_Tree_Code007|TestMJ007|Test of DepartmentTreeService
METADATA|DepartmentTreeVersion|DepartmentTreeVersionId|DepartmentTreeId|TreeStructureCode|TreeCode|TreeVersionName|TreeVersionDescription|TreeVersionStartDate|TreeVersionEndDate|TreeVersionNote
MERGE|DepartmentTreeVersion|||PER_DEPT_TREE_STRUCTURE|SM_Test_Tree_Code007|SM_Version2013|SM_Tree_VersionJan2Dec2013|2013/01/01|2013/12/31|No comments
MERGE|DepartmentTreeVersion|||PER_DEPT_TREE_STRUCTURE|SM_Test_Tree_Code007|SM_VersionJan14|SM_Tree_VersionJan2014|2014/01/01|2014/01/31|No comments
Position.dat
METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PositionCode|Name|BusinessUnitName|ActiveStatus|JobId(SourceSystemId)|DepartmentId(SourceSystemId)|HiringStatus|PositionType|FTE|HeadCount
MERGE|Position|VISION|92483_POSITION|1951/01/01|4712/12/31|03-MCR_POS_EXE|03-Executive|Sun Corporation Business Unit|A|93068_JOB|10633_ORGANIZATION|APPROVED|NONE|1|10
PositionHierarchy.dat
METADATA|PositionHierarchy|PositionCode|BusinessUnitName|ParentPositionCode|ParentBusinessUnitName|EffectiveStartDate|EffectiveEndDate|SourceSystemOwner|SourceSystemId
MERGE|PositionHierarchy|EDU1111|US LDG|EXEC8001|US LDG|1951/01/01|4712/12/31||
MERGE|PositionHierarchy|FIN1111|US LDG|FIN4000|US LDG|1951/01/01|4712/12/31||
Core HR Related Business Objects:
AreasOfResponsibility.dat
METADATA|AreasOfResponsibility|ResponsibilityName|ResponsibilityType|StartDate|Status|PersonNumber|AssignmentNumber|OrganizationName|WorkContactsFlag
MERGE|AreasOfResponsibility|EVP – Finance|EVP|2018/01/01|Active|1234567|E1234567|Finance|Y
Salary.dat
METADATA|Salary|SourceSystemOwner|SourceSystemId|AssignmentId(SourceSystemId)|DateFrom|DateTo|SalaryAmount|SalaryBasisId(SourceSystemId)|MultipleComponents|SalaryApproved|ActionCode|ActionReasonCode
MERGE|Salary|VISION|36253_SALARY_1|36253_EMP_ASSIGNMENT|1976/09/08|2013/12/31|400000|ANNUAL_SALARY_BASIS|N|Y|CHANGE_SALARY|
SalaryBasis.dat
METADATA|SalaryBasis|SourceSystemOwner|SourceSystemId|SalaryBasisCode|SalaryBasisName|ComponentUsage|Description|SalaryAnnualizationFactor|LegislativeDataGroupName|ElementName|InputValueName
MERGE|SalaryBasis|VISION|ANNUAL_SALARY_BASIS|ANNUAL|03-Annual Salary|USER_DECIDES_USAGE|03-Annual Salary|1|Sun Corporation LDG|Salary Element|Amount
PersonDisability.dat
METADATA|PersonDisability|DisabilityId|DisabilityCode|EffectiveStartDate|EffectiveEndDate|LegislationCode|PersonId|PersonNumber|OrganizationId|OrganizationName|OrganizationClassificationCode|RegistrationId|RegistrationDate|RegistrationExpDate|AssessmentDueDate|Category|Description|Degree|QuotaFTE|Reason|PreRegistrationJob|WorkRestriction|Status|SourceSystemOwner|SourceSystemId|GUID
MERGE|PersonDisability||PD_DC_001|2012/01/01|2016/01/01|FR||100010026711860||Travellers|HCM_DISABILITY_ORGANIZATION|||||SA_INT_DIS|Testing||1||New||Approved|VISION|PD000000001|
Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|WaiveDataProtectFlag|CategoryCode|ActionCode
MERGE|Worker|VISION|35208_PERSON|1976/09/08|4712/12/31|05-35208|1976/09/08|1952/05/21|N|PER_EIT|HIRE
METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|AddressType|PersonId(SourceSystemId)|Building|FloorNumber|TownOrCity|Country|PostalCode|LongPostalCode|TimezoneCode|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Region1|Region2
METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|AddressType|PersonId(SourceSystemId)|Building|FloorNumber|TownOrCity|Country|PostalCode|LongPostalCode|TimezoneCode|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Region1|Region2
METADATA|PersonCitizenship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|LegislationCode|CitizenshipStatus
MERGE|PersonCitizenship|VISION|35208_PERSON_CITIZENSHIP|35208_PERSON|1976/09/08|4712/12/31|AM|A
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|DateFrom|DateTo|PersonId(SourceSystemId)|EmailType|EmailAddress|PrimaryFlag
MERGE|PersonEmail|VISION|35208_PERSON_EMAIL|1976/09/08|4712/12/31|35208_PERSON|W1|[email protected]|Y
METADATA|PersonEthnicity|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|Ethnicity|PrimaryFlag
MERGE|PersonEthnicity|VISION|35208_ETHNICITY|35208_PERSON|US|1|Y
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|HighestEducationLevel|MaritalStatus|MaritalStatusDate|Sex
MERGE|PersonLegislativeData|VISION|35208_PERSON_LEGISLATIVE|1976/09/08|4712/12/31|35208_PERSON|US||M||M
METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title
MERGE|PersonName|VISION|35208_PERSON_NAME|1976/09/08|4712/12/31|35208_PERSON|US|GLOBAL|Bob||05-Meyers|MR.
METADATA|PersonNationalIdentifier|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|IssueDate|ExpirationDate|NationalIdentifierType|NationalIdentifierNumber|PrimaryFlag
MERGE|PersonNationalIdentifier|VISION|35208_PERSON_NATIONAL_IDENTIFIER|35208_PERSON|US|||SSN|123-99-0007|Y
METADATA|PersonPhone|SourceSystemOwner|SourceSystemId|PhoneType|DateFrom|DateTo|PersonId(SourceSystemId)|CountryCodeNumber|AreaCode|PhoneNumber|Extension|SpeedDialNumber|Validity|PrimaryFlag
MERGE|PersonPhone|VISION|3752_PHONE|W1|1976/09/08|4712/12/31|35208_PERSON|||807.343.0302||||Y
METADATA|WorkRelationship|ActualTerminationDate|LegalEmployerName|Comments|LastWorkingDate|DateStart|NotifiedTerminationDate|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|WorkerNumber|WorkerType|OnMilitaryServiceFlag|RehireRecommendationFlag
MERGE|WorkRelationship||Sun Corporation Legal Employer|||1976/09/08||VISION|325086_PERIOD_OF_SERVICE|35208_PERSON|Y||||||E|N|N
METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PositionOverrideFlag|PrimaryWorkTermsFlag|SystemPersonType|FreezeStartDate|FreezeUntilDate|BusinessUnitShortCode|LegalEmployerName
MERGE|WorkTerms|HIRE|VISION|36253_EMP_TERM|ET1|05-EMP_TERM_1||ET|4712/12/31|Y|1|1976/09/08|325086_PERIOD_OF_SERVICE|35208_PERSON|Y|Y|EMP|1901/01/01|4712/12/31|Sun Corporation Business Unit|Sun Corporation Legal Employer
METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|BillingTitle|BusinessUnitShortCode|JobId(SourceSystemId)|LabourUnionMemberFlag|LocationId(SourceSystemId)|LegalEmployerName|ManagerFlag|OrganizationId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|PositionId(SourceSystemId)|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|WorkTermsAssignmentId(SourceSystemId)|VendorId|FreezeStartDate|FreezeUntilDate
MERGE|Assignment|HIRE|VISION|36253_EMP_ASSIGNMENT|1976/09/08|4712/12/31|1|Y|E|E1|05-EMP_ASG_1|ACTIVE_PROCESS||Sun Corporation Business Unit|93079_JOB|N|33735_LOCATION|Sun Corporation Legal Employer|N|10629_ORGANIZATION|325086_PERIOD_OF_SERVICE|35208_PERSON|Employee||Y|Y||EMP|36253_EMP_TERM||1901/01/01|4712/12/31
Checklist.dat
METADATA|Checklist|SourceSystemOwner|SourceSystemId|ChecklistName|ChecklistCategory|ActionName|Description
MERGE|Checklist|VISION|VISION_CHKL_01|VISION Checklist1|Off Boarding|Termination|Checklist for Termination
MERGE|Checklist|||VISION Checklist2|On Boarding|Hire|Checklist for New Hire
METADATA|ChecklistTask|SourceSystemOwner|SourceSystemId|ChecklistId(SourceSystemId)|ChecklistName|ChecklistCategory|ChecklistTaskName|Description|EligibilityProfileId|TargetDuration|TargetDurationUOM|ResponsibilityType|MandatoryFlag|ActionURL
MERGE|ChecklistTask|VISION|VISION_CHKL01_Task1|VISION_CHKL_01|VISION Checklist1|Off Boarding|Exit Interview|Exit Interview||1|D|HR_REP|Y|www.oracle.com
MERGE|ChecklistTask|VISION|VISION_CHKL01_Task2|VISION_CHKL_01|VISION Checklist1|Off Boarding|Return Assets|Return Assets||1|D||Y|www.oracle.com
MERGE|ChecklistTask|VISION|VISION_CHKL01_Task3|VISION_CHKL_01|VISION Checklist1|Off Boarding|Security Clearance|Security Clearance||1|D||Y|www.oracle.com
MERGE|ChecklistTask||||VISION Checklist2|On Boarding|Assign Office Space|Office Space||1|D|ORA_LN_MGR|N|www.oracle.com
MERGE|ChecklistTask||||VISION Checklist2|On Boarding|Submit I9 Form|Submit I9 Form||3|D|ORA_WORKER|Y|www.oracle.com
AllocateChecklist.dat
METADATA|AllocateChecklist|SourceSystemOwner|SourceSystemId|PersonNumber|ChecklistId|ChecklistCategory|ChecklistInstance|LegislationCode
MERGE|AllocateChecklist|VISION|CARD-230885|123456|300000072879956|ONBOARD|230885|US
ScheduleAssignment.dat
METADATA|ScheduleAssignment|ScheduleName|StartDate|EndDate|ResourceType|PrimaryFlag|DepartmentName|LocationSetCode|InternalLocationCode|PositionCode|BusinessUnitName|JobSetCode|JobCode|LegalEmployerName|EnterpriseName|AssignmentNumber|WorkTermsAssignmentNumber|SourceSystemOwner|SourceSystemId
MERGE|ScheduleAssignment|40 Hour Salaried Work Schedule|2019/01/07|2029/01/07|ASSIGN|Y|10251|US|10251|||US|1071|LE||E12345|ET316662|VISION|ASG_SCH-E12345
Absence Related Business Objects:
PersonAccrualPlanEnrollment.dat
METADATA|PersonAccrualPlanEnrollment|PersonNumber|WorkTermAsgNum|PlanName|ManualEnrollment|RunAccruals|EnrtEndDt|EnrtStDt
MERGE|PersonAccrualPlanEnrollment|1480|ET1480|Annual Vacation_RA|Y|Y||2018/12/20
PersonAbsenceEntry.dat
METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceTypeId|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime|AbsenceType
MERGE|PersonAbsenceEntry|Sun Corporation Legal Employer|03-35208||SUBMITTED|APPROVED|2013/02/11|08:00|2013/02/13|16:30|Sick Leave
MERGE|PersonAbsenceEntry|Sun Corporation Legal Employer|03-35208||SUBMITTED|APPROVED|2014/03/11|08:00|2014/03/11|16:30|Vacation Leave
PersonEntitlementDetail.dat
METADATA|PersonEntitlementDetail|PersonNumber|PersonId|PlanName|PlanId|WorkTermsNumber|WorkTermsId|StartDate|EndDate|PayFactor|Value|PerPlanEntryDtlId|GUID|SourceSystemId|SourceSystemOwner
MERGE|PersonEntitlementDetail|195||SM Accrual Plan||ET195||2015/01/01|2015/12/31|1|40|||SMEntitlement1|VISION
Security Related Business Objects:
CountrySecurityProfile.dat
METADATA|CountrySecurityProfile|SourceSystemId|SourceSystemOwner|CountrySecurityProfileName|EnabledFlag
MERGE|CountrySecurityProfile|VISION_CNTRY_PR1|VISION|VISION_Country Profile 1|Y
METADATA|Country|SourceSystemId|SourceSystemOwner|CountrySecurityProfileId(SourceSystemId)|CountryCode|CountrySecurityProfileName|TerritoryShortName
MERGE|Country|VISION_CNTRY_PR1_C01|VISION|VISION_CNTRY_PR1|||United States
MERGE|Country|VISION_CNTRY_PR1_C02|VISION|VISION_CNTRY_PR1|||France
PersonSecurityProfile.dat
METADATA|PersonSecurityProfile|SourceSystemOwner|SourceSystemId|PersonSecurityProfileName|EnabledFlag|SecureByPersonTypeFlag|SecureByMgrHierarchyFlag|AccessToOwnRecordFlag|IncludeRelatedContactsFlag|SecureByGlobalNameRangeFlag|PersonOrAssignmentLevel|ManagerTypes|SecureByDepartmentFlag|SecureByBusinessUnitFlag|SecureByLegalEmployerFlag|SecureByPositionFlag|SecureByLDGFlag|SecureByPayrollFlag|SecureByCustomRestrictionFlag|CustomRestrictionText
MERGE|PersonSecurityProfile|VISION|VISION_SEC_PROF_1|25 EMPLOYEE ONLY ACCESS|Y|Y|Y|N|N|N|P|LINE_MGR|N|N|N|N|N|N|N|
MERGE|PersonSecurityProfile|VISION|VISION_SEC_PROF_2|25 BY AOR HRRep|Y|N|N|N|N|N|P|Line Manager|N|N|N|N|N|N|Y|EXISTS (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS,PER_ASG_RESPONSIBILITIES RES WHERE ASG.ASSIGNMENT_TYPE IN(‘E’,’C’,’N’,’P’) AND ASG.EFFECTIVE_LATEST_CHANGE=’Y’ AND SYSDATE BETWEEN LEAST(SYSDATE,ASG.EFFECTIVE_START_DATE) AND ASG.EFFECTIVE_END_DATE AND ASG.PERIOD_OF_SERVICE_ID=PS.PERIOD_OF_SERVICE_ID AND (ASG.ASSIGNMENT_STATUS_TYPE IN (‘ACTIVE’,’SUSPENDED’) OR (ASG.ASSIGNMENT_STATUS_TYPE  IN (‘INACTIVE’) AND NOT EXISTS  (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M EXASG WHERE EXASG.ASSIGNMENT_TYPE IN(‘E’,’C’,’N’,’P’) AND EXASG.EFFECTIVE_LATEST_CHANGE = ‘Y’ AND EXASG.PERSON_ID = ASG.PERSON_ID AND SYSDATE BETWEEN LEAST(SYSDATE,EXASG.EFFECTIVE_START_DATE) AND EXASG.EFFECTIVE_END_DATE AND EXASG.ASSIGNMENT_STATUS_TYPE IN (‘ACTIVE’,’SUSPENDED’)) AND PS.ACTUAL_TERMINATION_DATE = (SELECT MAX(ALLPS.ACTUAL_TERMINATION_DATE) FROM PER_PERIODS_OF_SERVICE ALLPS WHERE ALLPS.PERSON_ID = ASG.PERSON_ID AND ALLPS.ACTUAL_TERMINATION_DATE IS NOT NULL ))) AND SYSDATE BETWEEN RES.START_DATE AND NVL(RES.END_DATE,SYSDATE) AND ASG.PERSON_ID=&TABLE_ALIAS.PERSON_ID AND RES.PERSON_ID=(SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL) AND RES.RESPONSIBILITY_TYPE=’HR_REP’ AND ASG.LEGAL_ENTITY_ID=RES.LEGAL_ENTITY_ID )
MERGE|PersonSecurityProfile|VISION|VISION_SEC_PROF_3|25 CWK ONLY ACCESS|Y|Y|Y|N|N|N|P|LINE_MGR|N|N|N|N|N|N|N|
MERGE|PersonSecurityProfile|VISION|VISION_SEC_PROF_4|25 BY Person Number|Y|N|N|N|N|N|P|Line Manager|N|N|N|N|N|N|Y|&TABLE_ALIAS.PERSON_ID in (select PER2.PERSON_ID from PER_ALL_PEOPLE_F PER2 where PER2.PERSON_NUMBER like ‘VISION%’ and trunc(sysdate) between PER2.effective_start_date and PER2.effective_end_date)
METADATA|PersonType|PersonSecurityProfileId(SourceSystemId)|PersonTypeColumn|SystemPersonType|AccessTo|SourceSystemOwner|SourceSystemId
MERGE|PersonType|VISION_SEC_PROF_1|SPT|EMP|A|VISION|VISION_SEC_PROF1_PER1
MERGE|PersonType|VISION_SEC_PROF_3|SPT|CWK|A|VISION|VISION_SEC_PROF3_PER1
METADATA|ManagerType|PersonSecurityProfileName|ManagerTypeValue|SourceSystemOwner|SourceSystemId
MERGE|ManagerType|25 EMPLOYEE ONLY ACCESS|LINE_MANAGER|VISION|VISION_SEC_PROF1_MGR1
MERGE|ManagerType|25 CWK ONLY ACCESS|LINE_MANAGER|VISION|VISION_SEC_PROF3_MGR1
LdgSecurityProfile.dat
METADATA|LdgSecurityProfile|EnabledFlag|Name
MERGE|LdgSecurityProfile|Y|VISION_LDG Profile1
METADATA|LDG|LDGSecurityProfileName|LegislativeDataGroupName
MERGE|LDG|VISION_LDG Profile1|PB_US_LDG
OrganizationSecurityProfile.dat
METADATA|OrganizationSecurityProfile|EnabledFlag|IncludeTopOrganizationFlag|Name|SecureByOrgClassFlag|SecureByOrgHierarchyFlag|SecureByOrgListFlag
MERGE|OrganizationSecurityProfile|Y|N|VISION_Dept Profile 1|Y|N|Y
MERGE|OrganizationSecurityProfile|Y|N|VISION_Dept Profile 2|N|N|Y
METADATA|Classes|ClassificationName|OrgSecurityProfileName
MERGE|Classes|Department|VISION_Dept Profile 1
METADATA|Orgs|IncludeExcludeFlag|OrgSecurityProfileName|OrganizationName|OrgClassificationName
MERGE|Orgs|Exclude|VISION_Dept Profile 1|VISION Department1|Department
MERGE|Orgs|Include|VISION_Dept Profile 2|VISION Department1|Department
MERGE|Orgs|Include|VISION_Dept Profile 2|VISION Department3|Department
PositionSecurityProfile.dat
METADATA|PositionSecurityProfile|SourceSystemOwner|SourceSystemId|Name|EnabledFlag|SecureByBusinessUnitFlag|BUSecurityProfileName|SecureByDepartmentFlag|DepartmentSecurityProfileName|SecureByPositionHierarchyFlag|SecureByPositionListFlag|IncludeTopPositionFlag|TopPositionSelection
MERGE|PositionSecurityProfile|VISION|VISION_POSPROF_1|VISION Position Profile 1|Y|Y|View All Organizations|Y|View All Organizations|N|Y|Y|Specify top position
MERGE|PositionSecurityProfile|||VISION Position Profile 2|Y|Y|View All Organizations|Y|View All Organizations|N|Y|Y|Specify top position
METADATA|Position|SourceSystemOwner|SourceSystemId|IncludeExcludeFlag|PositionId(SourceSystemId)|PositionCode|PositionSecurityProfileId(SourceSystemId)|PositionSecurityProfileName|BusinessUnit
MERGE|Position|VISION|VISION_POSPROF1_POS1|Include|VISION_POSITION4||VISION_POSPROF_1||OracleFusion
MERGE|Position|||Include||VISION POS2||VISION Position Profile 2|OracleFusion
MERGE|Position|||Exclude||VISION POS3||VISION Position Profile 2|OracleFusion
MERGE|Position|||Include||VISION POS4||VISION Position Profile 2|OracleFusion
User.dat
METADATA|User|PersonNumber
MERGE|User|300100009779166
MERGE|User|300100009784598
METADATA|UserRole|PersonNumber|RoleCommonName|AddRemoveRole
MERGE|UserRole|300100009779166|FA_ASSET_ACCOUNTING_MANAGER_JOB|ADD
MERGE|UserRole|300100009784598|PER_EMPLOYEE_ABSTRACT|REMOVE
RoleMapping.dat
METADATA|RoleMapping|MappingName|DateFrom|DateTo|JobSetCode|JobCode|SystemPersonType|UserPersonType|AssignmentStatus
MERGE|RoleMapping|Custom Manager|1951/01/01||US|3150|EMP|Employee|ACTIVE
METADATA|Role|MappingName|RoleCommonName|RequestableFlag|SelfRequestableFlag|UseForAutoProvisioningFlag
MERGE|Role|Custom Manager|LCG_SC_PER_LINE_MANAGER_ABSTRACT_CUSTOM|N|N|Y
Payroll Related Business Objects:
Bank.dat
COMMENT Load Banks – Bank Name and Country Code are user keys
METADATA|Bank|BankName|BankNumber|CountryCode
MERGE|Bank|Vision Bank|100001A|CA
BankBranch.dat
COMMENT You must supply one of the following combinations of attributes to provide a unique reference to the bank branch and the associated bank:
COMMENT Bank Branch Name, Country Code, and either Bank Name or Bank Number
COMMENT Bank Branch Number, Country Code, and either Bank Name or Bank Number
COMMENT This example BankBranch.dat file creates a Bank Branch object using the Bank Branch Number, Bank Name, and Country Code user keys.
METADATA|BankBranch|BankBranchNumber|BankBranchName|BankName|CountryCode|EftSwiftCode
MERGE|BankBranch|111111A|Toronto 3|Vision Bank|CA|12345678
ExternalBankAccount.dat
COMMENT Create External Bank Account, user keys listed below
COMMENT Account Number, Country Code, Currency Code, Bank Name, and either Bank Branch Name or Bank Branch Number
COMMENT Account Number, Country Code, Currency Code, Bank Number, and either Bank Branch Name or Bank Branch Number
METADATA|ExternalBankAccount|BankNumber|BankBranchNumber|CountryCode|AccountNumber|IBAN|AccountName|AccountType|CurrencyCode
MERGE|ExternalBankAccount|100001A|111111A|CA|12345678|CA23 ANBK 3350 1234 5678 20|J and P Smith||USD
COMMENT user keys for External Bank Account Owner
COMMENT Account Number, Person Number, Country Code, Currency Code, Bank Name, and either Bank Branch Name or Bank Branch Number
COMMENT Account Number, Person Number, Country Code, Currency Code, Bank Number, and either Bank Branch Name or Bank Branch Number
METADATA|ExternalBankAccountOwner|BankNumber|BankBranchNumber|CountryCode|AccountNumber|CurrencyCode|PersonNumber|PrimaryFlag
MERGE|ExternalBankAccountOwner|100001A|111111A|CA|12345678|USD|121011|Y
MERGE|ExternalBankAccountOwner|100001A|111111A|CA|12345678|USD|126231|N
FastFormula.dat – Should be used along with ClobFiles folder with the actual files in it
METADATA|FastFormula|SourceSystemOwner|SourceSystemId|EffectiveStartDate|FormulaCode|FormulaTypeCode|FormulaName|FormulaText|LegislativeDataGroupId(SourceSystemId)
MERGE|FastFormula|VISION|MGR_SCHED_HRS|2000/01/01|MGR_RANGE_SCHD_HRS|Range of Scheduled Hours|Manager Range of Scheduled Hours|ManagerRangeScheduledHrs.txt|
FastFormulaGlobal.dat
METADATA|FastFormulaGlobal|SourceSystemOwner|SourceSystemId|EffectiveStartDate|GlobalCode|GlobalName|DataType|GlobalValue|LegislativeDataGroupId(SourceSystemId)
MERGE|FastFormulaGlobal|VISION|GBLMAXILLHEALTH|2000/01/01|MAX_ABS_DURATION_ILLHEALTH|Maximum Absence Duration for Ill Health|N|10|
MERGE|FastFormulaGlobal|VISION|GBLDATEEXAMPLE|2000/01/01|GLOBAL_DATE_EXAMPLE|Fast Formula Global Date Example|D|2012-01-01|LDG_VI_UK
Element.dat
METADATA|PayrollElementDefinition|ElementCode|ClosedForEntryFlag|EffectiveStartDate|EffectiveEndDate|ReportingName|LegislativeDataGroupName|InputCurrencyCode|MultipleEntriesAllowedFlag|ProcessOncePerPeriodFlag|ProcessInPayrollRunFlag|ProcessingType|AutomaticEntryFlag|AssignmentLevelFlag|RelationshipLevelFlag|TermLevelFlag|AdditionalEntryAllowedFlag|PrimaryClassificationCode|EarliestEntryDateCode|LatestEntryDateCode|SourceSystemOwner|SourceSystemId|ElementName|ProcessSeparateFlag|PaySeparateFlag|BalanceAdjustmentOnlyFlag|Priority|AllowFormulaResultsOnlyFlag|OutputCurrencyCode
MERGE|PayrollElementDefinition|TEST_HDL_ELEMENT|N|1951/01/01|4712/12/31|TEST_HDL_ELEMENT|US LDG|USD|N|Y|Y|N|N|N|Y|N|N|Supplemental Earnings|FSED|FINC|PEOPLESOFT|TEST_HDL_ELEMENT|Base System|N|N|N|100|N|US
AssignedPayroll.dat
COMMENT We need to provide assignmentid only.. it doesn’t work if we pass assignmentnumber
METADATA|AssignedPayroll|AssignmentId|PayrollDefinitionCode|LegislativeDataGroupName|EffectiveStartDate|EffectiveEndDate|SourceSystemOwner|SourceSystemId
MERGE|AssignedPayroll|300000260189147|US Biweekly Payroll|US Legislative Data Group|2018/05/03|4712/12/31|VISION|PR_E12345
ElementEntry.dat
COMMENT Example to load element entries. In this case, ontime payment i.e. non recurring payment is made to few employees for relocation or housing allowance.
COMMENT Demo database is using legislative data group PB_US_LDG and HOUSING_NONRECURRING_ELEMENT (eligble to all employees), input value name is RelocationBonus
COMMENT You must create an element in your application using FSM task- Manage Elements before attempting to load this data.
COMMENT You may also review the white paper 1589502.1 from MOS on Configuring Payroll Elements for Use in Oracle Fusion Compensation
METADATA|ElementEntry|SourceSystemOwner|SourceSystemId|ElementName|LegislativeDataGroupName|EntryType|EffectiveStartDate|EffectiveEndDate|AssignmentNumber|CreatorType
MERGE|ElementEntry|VISION|VISION_103_HSELMNT1|HOUSING_NONRECURRING_ELEMENT|PB_US_LDG|E|2015/11/11|2015/11/30|VISION_ASSIGN_NUM103|F
MERGE|ElementEntry|VISION|VISION_106_HSELMNT1|HOUSING_NONRECURRING_ELEMENT|PB_US_LDG|E|2015/11/11|2015/11/30|VISION_ASSIGN_NUM106|F
MERGE|ElementEntry|VISION|VISION_108_HSELMNT1|HOUSING_NONRECURRING_ELEMENT|PB_US_LDG|E|2015/11/11|2015/11/30|VISION_ASSIGN_NUM108|F
COMMENT Child object Element Entry Values – Specify information for InputValues
METADATA|ElementEntryValue|SourceSystemOwner|SourceSystemId|ElementEntryId(SourceSystemId)|LegislativeDataGroupName|ElementName|EffectiveStartDate|EffectiveEndDate|AssignmentNumber|InputValueName|ScreenEntryValue
MERGE|ElementEntryValue|VISION|VISION_103_HSELMNT_IV1|VISION_103_HSELMNT1|PB_US_LDG|HOUSING_NONRECURRING_ELEMENT|2015/11/11|2015/11/30|VISION_ASSIGN_NUM103|RelocationBonus|5000
MERGE|ElementEntryValue|VISION|VISION_106_HSELMNT_IV1|VISION_106_HSELMNT1|PB_US_LDG|HOUSING_NONRECURRING_ELEMENT|2015/11/11|2015/11/30|VISION_ASSIGN_NUM106|RelocationBonus|1750
MERGE|ElementEntryValue|VISION|VISION_108_HSELMNT_IV1|VISION_108_HSELMNT1|PB_US_LDG|HOUSING_NONRECURRING_ELEMENT|2015/11/11|2015/11/30|VISION_ASSIGN_NUM108|RelocationBonus|3500
CostAllocation.dat
METADATA|CostAllocation|EffectiveStartDate|EffectiveEndDate|SourceType|Name|PayrollRelationshipNumber|AssignmentNumber|TermNumber|MultipleEntryCount|ElementTypeName|LegislativeDataGroupName
MERGE|CostAllocation|2019/06/20|2019/06/20|EE|||E12345||24|Unpaid Absence Entitlement|Canada
MERGE|CostAllocation|2019/07/03|2019/07/03|EE|||E67890||6|Unpaid Absence Entitlement|Canada
CostAllocationAccount.dat
METADATA|CostAllocationAccount|SourceType|ElementLinkName|DepartmentName|JobCode|PositionName|SetCode|PaymentSourceName|PayrollName|Name|AssignmentNumber|PayrollRelationshipNumber|TermNumber|ElementTypeName|MultipleEntryCount|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3|Segment4|Segment5|GUID|SourceSystemId|SourceSystemOwner
MERGE|CostAllocationAccount|ORG||DDT_DEPT01|||COMMON|||||||||LDG US|2011/12/31|COST|0.8|1||3|330|1333||210|||
MERGE|CostAllocationAccount|JOB|||DDT_JOB01_CD||COMMON|||||||||LDG US|2011/12/31|COST|1|1||4|340|1100|1400|240|||
PayrollBalanceDefinition.dat
METADATA|PayrollBalanceDefinition|BalanceId|BalanceCode|BalanceName|LegislativeDataGroupId|ReportingName|CurrencyCode|RemunerationFlag|BalanceUOM|InputValueId|BalanceCategoryId|DeductionTypeId|BaseBalanceId|LegislativeDataGroupName|ElementCode|InputValueCode|BaseBalanceCode|BalanceCategoryCode|DeductionCode|CurrencyName|GUID|SourceSystemOwner|SourceSystemId
MERGE|PayrollBalanceDefinition||Custom Earnings|Custom Earnings||Custom Earnings Balance|USD||Money|||||US LDG||||Information|||||
METADATA|BalanceFeed|BalanceFeedId|EffectiveStartDate|EffectiveEndDate|BalanceId|ElementId|InputValueId|LegislativeDataGroupId|LegislativeDataGroupName|BalanceCode|ElementCode|InputValueCode|GUID|SourceSystemOwner|SourceSystemId|AddSubtract
MERGE|BalanceFeed||1951/01/01||||||US LDG|Custom Earnings|Accreditation Bonus Earnings Results|Earnings Calculated||||Add
MERGE|BalanceFeed||1951/01/01||||||US LDG|Custom Plan compensation|Accreditation Bonus Earnings Results|Earnings Calculated||||Add
PersonalPaymentMethod.dat
METADATA|PersonalPaymentMethod|LegislativeDataGroupName|AssignmentNumber|PersonalPaymentMethodCode|EffectiveStartDate|PaymentAmountType|Amount|ProcessingOrder|OrganizationPaymentMethodCode|Percentage|BankName|BankBranchName|BankCountryCode|BankAccountNumber
MERGE|PersonalPaymentMethod|US LDG|E12345-3|PPM_105067_C1_1|2019/07/02|P||1|Direct Deposit|100|FEDERAL CREDIT UNION|22323_C1|US|121212121
MERGE|PersonalPaymentMethod|US LDG|E67890-2|PPM_105812_C1_1|2019/07/02|P||1|Direct Deposit|100|METABANK|32323_C1|US|33253555435
Benefits Related Business Objects:
Contact.dat
METADATA|ContactName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|NameType|LegislationCode|FirstName|LastName|PersonNumber
MERGE|ContactName|VISION|EMPLOYEE_CONT_NAME_900015967|2019/01/24|4712/12/31|EMPLOYEE_CONT_900015967|GLOBAL|US|Colter|Gerrard|
METADATA|ContactPhone|SourceSystemOwner|SourceSystemId|DateFrom|DateTo|PersonId(SourceSystemId)|PhoneType|CountryCodeNumber|AreaCode|PhoneNumber|LegislationCode|PrimaryFlag|PersonNumber
MERGE|ContactPhone|VISION|EMPLOYEE_CONT_PHONE_H1_900015967|2019/01/24|4712/12/31|EMPLOYEE_CONT_900015967|H1|1|801|4990959|US|Y|
METADATA|Contact|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|StartDate|PersonNumber
MERGE|Contact|VISION|EMPLOYEE_CONT_900015967|2019/01/24|4712/12/31|2019/01/24|
METADATA|ContactRelationship|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|RelatedPersonId(SourceSystemId)|ContactType|BeneficiaryFlag|BondholderFlag|DependentFlag|EmergencyContactFlag|PersonalFlag|PrimaryContactFlag|ExistingPerson|RelatedPersonNumber
MERGE|ContactRelationship|VISION|EMPLOYEE_CONT_REL_20190124_900015967|2019/01/24|4712/12/31|EMPLOYEE_CONT_900015967||EMRG|Y|Y|Y|Y|N|Y|N|900015967
Talent Management Related Business Objects:
ContentItem.dat for loading Goals
METADATA|ContentItem|SourceSystemOwner|SourceSystemId|ContextName|ContentItemCode|Name|ItemDescription|DateFrom|RatingModelId(SourceSystemId)|CountryId|ContentSupplierCode|ItemDescrlong|ItemNumber1|ItemNumber2|ItemNumber3|ItemNumber4|ItemNumber5|ItemNumber6|ItemNumber7|ItemNumber8|ItemNumber9|ItemNumber10|ItemDate1|ItemDate2|ItemDate3|ItemDate4|ItemDate5|ItemDate6|ItemDate7|ItemDate8|ItemDate9|ItemDate10|ItemText1|ItemText2|ItemText3|ItemText4|ItemText5|ItemText6|ItemText7|ItemText8|ItemText9|ItemText10|ItemText11|ItemText12|ItemText13|ItemText14|ItemText15|ItemText16|ItemText17|ItemText18|ItemText19|ItemText20|ItemText21|ItemText22|ItemText23|ItemText24|ItemText25|ItemText26|ItemText27|ItemText28|ItemText29|ItemText30|ItemTextTl
MERGE|ContentItem|VISION|Goal_Library1|GOAL|Work Goal|Work Goal|Work Goal|1900/01/01||||Work Goal|||||||||||2016/04/01|2017/03/31|2016/04/01||||||||A|MEDIUM|TARGET||||||PERFORMANCE|ALL||Work Goal|||||||||||||||||||
PerfDocComplete.dat
METADATA|PerfDocComplete|AssignmentNumber|CustomaryName|Operation
MERGE|PerfDocComplete|E12345|TEST Annual Performance Template 2019 v3|ORA_ATTACH_PD
METADATA|Attachment|CustomaryName|AssignmentNumber|Title|DataTypeCode|URLorTextorFileName|MimeType|File|Description
MERGE|Attachment|TEST Annual Performance Template 2019 v3|E12345|Charan 2019 PMP|FILE|Charan_E12345.pdf|application/pdf|Charan_E12345.pdf|Charan 2019 PMP DESC
ProfileItem.dat – Certifications Load
METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItemId(SourceSystemId)|ContentTypeId|CountryId|DateFrom|DateTo
MERGE|ProfileItem|VISION|104938OCP|104938|CERTIFICATION|OCP|103||2012/07/31|
ProfileItem.dat – Competency Load
METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItemId(SourceSystemId)|ContentTypeId|CountryId|DateFrom|DateTo|RatingModelCode1|RatingLevelCode1|QualifierSetCode1|QualifierCode1
MERGE|ProfileItem|VISION|103984300027|103984|COMPETENCY|300027|104||2008/10/24||PSCM|2|EVAL_TYPE|R
ProfileItem.dat – Degrees Load
METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItemId(SourceSystemId)|ContentTypeId|CountryId|DateFrom|DateTo
MERGE|ProfileItem|VISION|103557BE|103557|DEGREE|BE|106||1992/05/31|
MERGE|ProfileItem|VISION|103558BE|103558|DEGREE|BE|106||2002/05/31|
ProfileItem.dat – Languages Load
METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItem|ContentTypeId|CountryId|DateFrom|DateTo|RatingModelCode1|RatingModelCode2|RatingModelCode3|RatingLevelCode1|RatingLevelCode2|RatingLevelCode3
MERGE|ProfileItem|VISION|103557EN|103557|LANGUAGE|English|109||1900/01/01||LANGUAGE|LANGUAGE|LANGUAGE|1|1|1
MERGE|ProfileItem|VISION|103557TE|103557|LANGUAGE|Telugu|109||1900/01/01||LANGUAGE|LANGUAGE|LANGUAGE|1|1|1
ProfileItem.dat – Memberships Load
METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|ContentType|ContentItemId(SourceSystemId)|ContentTypeId|CountryId|DateFrom|DateTo
MERGE|ProfileItem|VISION|105214PMI|105214|MEMBERSHIP|PMI|110||2009/12/20|
MERGE|ProfileItem|VISION|104916PMI|104916|MEMBERSHIP|PMI|110||2012/05/07|
Other Common Business Objects:
UserDefinedTable.dat
METADATA|UserDefinedTable|UserTableCode|LegislationCode|LegislativeDataGroupId|RangeOrMatch|UserKeyUnits|UserRowTitle|UserTableId|UserTableName|LegislativeDataGroupName
MERGE|UserDefinedTable|SM_V3_TABLE1|||R|N|Test Row1||SM_V3_TABLE1|USA LDG
METADATA|UserDefinedTableColumn|UserColumnCode|DataType|UserColumnName|UserTableCode|LegislativeDataGroupName
MERGE|UserDefinedTableColumn|COLUMN_1|T|Column_1|SM_V3_TABLE1|USA LDG
METADATA|UserDefinedTableRow|DisplaySequence|EffectiveEndDate|EffectiveStartDate|RowHighRange|RowLowRangeOrName|UserTableCode|LegislativeDataGroupName|RowName
MERGE|UserDefinedTableRow|1|4712/12/31|2011/01/01|4000|1000|SM_V3_TABLE1|USA LDG|Row_1
METADATA|UserDefinedTableColumnInstance|EffectiveEndDate|EffectiveStartDate|Value|LegislativeDataGroupName|UserColumnCode|RowLowRangeOrName|UserTableCode
MERGE|UserDefinedTableColumnInstance|4712/12/31|2011/01/01|8800|USA LDG|COLUMN_1|1000|SM_V3_TABLE1
Candidate.dat
METADATA|Candidate|CandidateNumber|CandPrefLanguageCode|StartDate|ConfirmedFlag|CountryOfBirth|DateOfBirth|RegionOfBirth|Source|SourceMedium|TownOfBirth|VisibleToCandidateFlag
MERGE|Candidate|12345|US|2019/03/20|Y||||direct source|||Y
METADATA|CandidateAddress|CandidateNumber|EffectiveStartDate|AddressLine1|AddressType|AddressLine2|Country|PostalCode|Region2|Region1|TownOrCity|EffectiveEndDate
MERGE|CandidateAddress|12345|2019/03/20|1257 BUCK SWAMP RD|HOME||US|12576|NC|Wayne|Pikeville|4712/12/31
METADATA|CandidateProfile|ProfileItemId|CandidateNumber|ContentType|ContentItem|DateFrom|ItemDate7|ItemText20001|ItemNumber8|ItemText2401|CountryGeographyCode|CountryCountryCode
MERGE|CandidateProfile|200001|12345|DEGREE|ASSOCIATE’S DEGREE|2018/01/01|2018/01/01|PIERCE COLLEGE|1993|EARLY CHILDHOOD EDUCATION|US|US
METADATA|CandidatePhone|CandidateNumber|DateFrom|PhoneType|PhoneNumber|CountryCodeNumber|AreaCode|DateTo|Extension|LegislationCode|SpeedDialNumber|Validity|GUID
MERGE|CandidatePhone|12345|2019/03/20|H1|9605806|1|262|4712/12/31||US|||
DocumentDeliveryPreference.dat
METADATA|DocumentDeliveryPreference|SourceSystemOwner|SourceSystemId|DocumentTypeId(SourceSystemId)|DocumentType|DocumentTypeLegislationCode|LegislationCode|Country|LevelCode|PersonNumber|OnlineEnabledFlag|PaperEnabledFlag|EmailEnabledFlag|AllowWorkerOverrideFlag|OnlineConsentRequiredFlag|InitialConsentFlag
MERGE|DocumentDeliveryPreference|VISION|VISION_DelvrPref_100_Doc1|VISION_DOCType_001|VISION_DocType1|US|||900_PERSON|VISION_PERSON100|Y|Y|Y|Y|N|Y
MERGE|DocumentDeliveryPreference|VISION|VISION_DelvrPref_101_Doc1|VISION_DOCType_001|VISION_DocType1|US|||900_PERSON|VISION_PERSON101|Y|Y|Y|Y|N|Y
DocumentsOfRecord.dat
METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DocumentCode|DocumentName
MERGE|DocumentsOfRecord|VISION_PERSON109|Return to Work||VISION_PER109 RTW|RTW Certificate from Dr
METADATA|DocumentAttachment|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|URLorTextorFileName|Title|File
MERGE|DocumentAttachment|VISION_PERSON109|Return to Work||VISION_PER109 RTW|FILE|RTW.pdf|Return to Work|109_RTW.pdf
EducationEstablishment.dat
METADATA|EducationEstablishment|SourceSystemOwner|SourceSystemId|Name|Location|SchoolCode|PartyId|Description|CountryId|StateProvinceId
MERGE|EducationEstablishment|VISION|1_ESTABLISHMENT|03-La Salle University|Philadelphia, PA|03-La Salle University||03-La Salle University||
MERGE|EducationEstablishment|VISION|2_ESTABLISHMENT|03-Georgetown University|Washington, DC|03-Georgetown University||03-Georgetown University||
ExtendedLookupCode.dat
METADATA|ExtendedLookupCode|SourceSystemOwner|SourceSystemId|LookupType|LookupCode|LegislationCode|ExtendedLookupCode|ExtendedLookupCodeName
MERGE|ExtendedLookupCode|VISION|VISION_EXTLOOKUP_1|ADDRESS_TYPE|MAIL|US|VISION_US_POSTAL|VISION US POSTAL
MERGE|ExtendedLookupCode|VISION|VISION_EXTLOOKUP_2|ADDRESS_TYPE|MAIL|FR|VISION_FR_POSTAL|VISION FR POSTAL
PersonType.dat
METADATA|PersonType|SourceSystemOwner|SourceSystemId|SystemPersonType|UserPersonType|ActiveFlag|DefaultFlag
MERGE|PersonType|VISION|VISION_PERTYPE_1|EMP|VISION Union Employee|Y|N
MERGE|PersonType|VISION|VISION_PERTYPE_2|CWK|VISION Contract to Hire|Y|N
SourceKey.dat
METADATA|SourceKey|BusinessObject|Component|OldSourceSystemId|OldSourceSystemOwner|NewSourceSystemId|NewSourceSystemOwner
MERGE|SourceKey|Worker|PersonAddress|2342|FUSION|1422-HOME|VISION
Passport and Driving License and Visa information load:
METADATA|PersonPassport|PersonNumber|LegislationCode|PassportType|PassportNumber|IssueDate|ExpirationDate|IssuingAuthority|IssuingCountry|IssuingLocation|Profession|SourceSystemOwner|SourceSystemId
MERGE|PersonPassport|703225760|IN|1|PS123|2020/04/15|2025/04/15|PAI|IN|#Null|#Null|EBS|PASSPORT_703225760
METADATA|PersonDriversLicence|PersonNumber|LegislationCode|LicenseType|LicenseNumber|DateFrom|DateTo|IssuingAuthority|IssuingCountry|IssuingLocation|LicenseSuspended|SuspendedFromDate|SuspendedToDate|NumberOfPoints|Violations|SourceSystemOwner|SourceSystemId
MERGE|PersonDriversLicence|703225760|IN|DL|DL1234|2020/05/01|2025/06/30|NHAI|IN|#Null|N|||2|1|EBS|LICENCE_703225760
METADATA|PersonVisa|EffectiveStartDate|EffectiveEndDate|VisaPermitType|PersonNumber|LegislationCode|EntryDate|ExpirationDate|CurrentVisaPermit|IssueDate|IssuingAuthority|IssuingCountry|IssuingLocation|Profession|VisaPermitCategory|VisaPermitNumber|VisaPermitStatus|VisaPermitStatusDate|SourceSystemOwner|SourceSystemId
MERGE|PersonVisa|2020/05/01|4712/12/31|J|703225760|US|2020/05/01|2020/06/30|Y|2020/04/15|Embassy|US|#Null|#Null|#Null|VPN123|A|2020/04/15|EBS|VISA_703225760

Updated 05/17: OrganizationTreeNode.dat

METADATA|OrganizationTreeNode|TreeStructureCode|TreeCode|TreeVersionName|OrganizationName|ClassificationCode|ParentOrganizationName|ParentClassificationCode
MERGE|OrganizationTreeNode|PER_ORG_TREE_STRUCTURE|ABC_Primary Org Hierarchy|10|Nashville Rail|DEPARTMENT|No Middle Tennessee|DEPARTMENT
MERGE|OrganizationTreeNode|PER_ORG_TREE_STRUCTURE|ABC_Primary Org Hierarchy|10|Little REO|DEPARTMENT|No Middle Tennessee|DEPARTMENT

Tip: You can use these Sample files and modify them as per your requirement instead of starting from scratch and trying to build the HDL file.

  • This would be the most useful and critical post for many projects in cloud hcm. Many thanks for this information. This is more useful.

  • Thanks Chetu. If you come across any new business objects in your project, you can remove client references and share it over here. It would help others who look for similar information.

  • Please add below as well in this repository.

    METADATA|PersonPassport|PersonNumber|LegislationCode|PassportType|PassportNumber|IssueDate|ExpirationDate|IssuingAuthority|IssuingCountry|IssuingLocation|Profession|SourceSystemOwner|SourceSystemId
    MERGE|PersonPassport|703225760|IN|1|PS123|2020/04/15|2025/04/15|PAI|IN|#Null|#Null|EBS|PASSPORT_703225760
    METADATA|PersonDriversLicence|PersonNumber|LegislationCode|LicenseType|LicenseNumber|DateFrom|DateTo|IssuingAuthority|IssuingCountry|IssuingLocation|LicenseSuspended|SuspendedFromDate|SuspendedToDate|NumberOfPoints|Violations|SourceSystemOwner|SourceSystemId
    MERGE|PersonDriversLicence|703225760|IN|DL|DL1234|2020/05/01|2025/06/30|NHAI|IN|#Null|N|||2|1|EBS|LICENCE_703225760
    METADATA|PersonVisa|EffectiveStartDate|EffectiveEndDate|VisaPermitType|PersonNumber|LegislationCode|EntryDate|ExpirationDate|CurrentVisaPermit|IssueDate|IssuingAuthority|IssuingCountry|IssuingLocation|Profession|VisaPermitCategory|VisaPermitNumber|VisaPermitStatus|VisaPermitStatusDate|SourceSystemOwner|SourceSystemId
    MERGE|PersonVisa|2020/05/01|4712/12/31|J|703225760|US|2020/05/01|2020/06/30|Y|2020/04/15|Embassy|US|#Null|#Null|#Null|VPN123|A|2020/04/15|EBS|VISA_703225760

  • Hi Sricharan,
    Thank you. It is very useful for all projects and consultants.

    And I would like to know can we create the user accounts through HDL. If yes can you please tell me.

  • Hi Anu,

    The user object does not support the creation of new users. Users are created when a worker is created. However roles can be added and the CredentialsEmailSent flag can be updated to send email to users with new passwords.

    Thanks,
    Sricharan

  • Finally found the place where i can get sample dat files almost for all BO’s. It will definitely saves lot of time.

    Thanks charan for the great idea and post.

  • Thanks Kanth for your Compliments. Keep following us on Telegram, LinkedIn pages to get updates. Also these articles will be updated whenever i come across new business objects. Keep checking when you have requirements.

  • In visible box by plugintheme