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.
- How to load CostAllocationAccountV3.dat HDL file?
- Configuring HCM Data Loader Parameters
- Defining Source System Owner for HCM Data Loader
- SET Operations on HDL file in Fusion
- SQL Query to get Supervisor Change HDL for Assignment
- Cancel an existing Work Relationship using HDL for employees
- Sample HCM Data Loader (HDL) files for all Business Objects
- New Deadline for Payroll Batch Loader 20D Nov 2020
- Generate HDL file for failed business object Lines
- Resolving Assignment Name and Job Name not in sync issue
- Useful Excel to HDL DAT File Converter
- SQL Query to get Scheduled Process Job History
- Invoke HCM Data Loader using SOAP Service
- How to send/stop welcome email notifications to users using HDL
- Update Source Keys using HDL for business objects
- Top 50 HCM Data Loader Interview Questions
- How to ROLLBACK Element Entry HDL Load?
- Basics of HDL Transformation Formula Part 1
- How HDL Transformation Formula works with ElementEntry Sample
- How to use escape and new line characters in HDL file
- HDL transformation Formula Flow changes in 20C
- HDL Transformation Formula using HSDL Template for UDT Load
- HCM Data Loader Error Report
- Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
- How to load Global and Local Names using 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.
Thanks Srichatan. This would be handy and useful
Thank you karthik for your kind words. Keep following website for latest updates.
Wonderful information. Very helpful for many people.
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.
Thank you Sanjil. I have added to main post. Keep Reading.. Keep learing.. Keep Sharing.
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.
This is amazing. Thanks!