Ready to use Worker Sample HDL files for multiple scenarios

0 Shares

In this article, we will look into how to prepare the Worker HDL file for multiple scenarios like hire, terminate, cancel work relationship, pending worker, email delete, eff load, dff load, global transfer, line manager load, name update, person image load, DOB update, Assignment Correction, prepone hire date, etc.

As a technical developer, worker.dat is the most frequently used business object that we will have to work on during any implementation or support project to make changes to existing employees or hire new employees/ transfer/ promote employees.

Here are the sample files that can be used as a ready reference (of course you will have to modify them to fit your requirement). Atleast these samples would serve you as a base to get started with your requirement.

Table of Contents

Load Worker with Minimum Business Objects

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|ActionCode
MERGE|Worker|HRC_SQLLOADER|PER_111|2019/02/18|||2019/02/18|HIRE
METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|NameType|LegislationCode|LastName|FirstName
MERGE|PersonName|HRC_SQLLOADER|PER_111_GLOBAL|2019/02/18||PER_111|GLOBAL|US|Robin|Hood
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag
MERGE|WorkRelationship|HRC_SQLLOADER|PER_111_POS|PER_111|HCM11 Legal Entity|2019/02/18|E|Y
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|PrimaryWorkTermsFlag|PersonId(SourceSystemId)|BusinessUnitShortCode|AssignmentStatusTypeCode
MERGE|WorkTerms|HRC_SQLLOADER|PER_111_TERM|PER_111_POS|HIRE|2019/02/18||1|Y||ETPER_111|Y|PER_111|FUSIONHCMKB Services|ACTIVE_PROCESS
METADATA|Assignment|SourceSystemOwner|SourceSystemId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|WorkTermsAssignmentId(SourceSystemId)|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|PersonTypeCode|BusinessUnitShortCode|PrimaryAssignmentFlag
MERGE|Assignment|HRC_SQLLOADER|PER_111_ASG|HIRE|2019/02/18||1|Y|PER_111_TERM||EPER_111|ACTIVE_PROCESS|Employee|FUSIONHCMKB Services|Y

Load Person Local Name

METADATA|PersonName|EffectiveEndDate|EffectiveStartDate|LegislationCode|PersonId|NameType|FirstName|MiddleNames|LastName|Honors|KnownAs|PreNameAdjunct|PreviousLastName|Suffix|Title|MilitaryRank|CharSetContext
MERGE|PersonName|4712/12/31|2019/09/20|TW|3000001811111|TW|||XYZ||TestFirst||||||TH

Load Pending Worker

COMMENT Save this file as Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|BloodType|StartDate|DateOfBirth|DateOfDeath|CountryOfBirth|RegionOfBirth|TownOfBirth|ApplicantNumber|ActionCode|ReasonCode
MERGE|Worker|HRC_SQLLOADER|1111111|2018/11/12|4712/12/31|||2018/11/12|||||||ADD_PEN_WKR|
METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|AddressType|PersonId(SourceSystemId)|Building|FloorNumber|TownOrCity|Country|PostalCode|LongPostalCode|TimezoneCode|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Region1|Region2
MERGE|PersonAddress|HRC_SQLLOADER|1111111-ADR-01|2018/11/12|4712/12/31||HOME|1111111|||Odessa|US|79765|||3403 Seguin|||||TX
METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|PersonId(SourceSystemId)|LegislationCode|NameType|FirstName|MiddleNames|LastName|Honors|KnownAs|PreNameAdjunct|MilitaryRank|PreviousLastName|Suffix|Title
MERGE|PersonName|HRC_SQLLOADER|1111111-NAME-01|2018/11/12|4712/12/31||1111111|US|GLOBAL|Test1|Test2||||||||
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|PersonId(SourceSystemId)
MERGE|PersonEmail|HRC_SQLLOADER|1111111-EMAIL-01||2018/11/12|4712/12/31|H1|[email protected]|Y|1111111
METADATA|PersonPhone|SourceSystemOwner|SourceSystemId|PersonNumber|PhoneType|DateFrom|DateTo|CountryCodeNumber|AreaCode|PhoneNumber|Extension|LegislationCode|SpeedDialNumber|Validity|PrimaryFlag|PersonId(SourceSystemId)
MERGE|PersonPhone|HRC_SQLLOADER|1111111-PHONE-01||HM|2018/11/12|4712/12/31|||(217) 111-1111|||||Y|1111111
METADATA|PersonEthnicity|SourceSystemOwner|SourceSystemId|PersonNumber|LegislationCode|Ethnicity|PrimaryFlag|PersonId(SourceSystemId)
MERGE|PersonEthnicity|HRC_SQLLOADER|1111111-ETH-01||US|1|Y|1111111
METADATA|PersonNationalIdentifier|SourceSystemOwner|SourceSystemId|PersonNumber|LegislationCode|IssueDate|ExpirationDate|PlaceOfIssue|NationalIdentifierType|NationalIdentifierNumber|PrimaryFlag|PersonId(SourceSystemId)
MERGE|PersonNationalIdentifier|HRC_SQLLOADER|1111111-NID-01||US||||SSN|111111111|Y|1111111
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|HighestEducationLevel|MaritalStatus|MaritalStatusDate|Sex
MERGE|PersonLegislativeData|HRC_SQLLOADER|1111111-PER-LEG-01|2018/11/12|4712/12/31|1111111|US||||F
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonNumber|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|EnterpriseSeniorityDate|LastWorkingDate|NotifiedTerminationDate|OnMilitaryServiceFlag|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|RevokeUserAccess|WorkerNumber|RehireRecommendationFlag|NewStartDate|ActionCode|ReasonCode|DateOfDeath|HideUntilDate|DateForPrimaryFlagChange|CancelWorkRelationshipFlag|TerminateWorkRelationshipFlag|ReverseTerminationFlag|CorrectTerminationFlag
MERGE|WorkRelationship|HRC_SQLLOADER|1111111-WR-01||1111111|Fusion HCM KB Corp|2018/11/12|P|2018/11/12|||2018/11/12|||||||||||||ADD_PEN_WKR||||||||
METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|PersonNumber|DateStart|WorkerType|LegalEmployerName|BusinessUnitShortCode|SystemPersonType|EffectiveStartDate|EffectiveEndDate|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|EffectiveLatestChange|EffectiveSequence|PositionOverrideFlag|PrimaryWorkTermsFlag|ProposedUserPersonType|ProjectedStartDate|PersonTypeCode
MERGE|WorkTerms|ADD_PEN_WKR|HRC_SQLLOADER|1111111-WT-01|1111111|1111111-WR-01||2018/11/12||Fusion HCM KB Corp|C01|PWK|2018/11/12|4712/12/31|||ACTIVE_PROCESS|PT|Y|1|Y|Y|Employee|2018/11/12|Pending Worker
METADATA|Assignment|SourceSystemOwner|SourceSystemId|PersonNumber|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|WorkTermsNumber|AssignmentType|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|BargainingUnitCode|BillingTitle|BusinessUnitShortCode|DateProbationEnd|WorkerCategory|AssignmentCategory|ReportingEstablishment|ExpenseCheckSendToAddress|GradeCode|GradeLadderPgmName|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobCode|LabourUnionMemberFlag|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|DepartmentName|DateStart|WorkerType|LegalEmployerName|PersonTypeCode|SystemPersonType|PositionCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|ProbationPeriod|ProbationUnit|ProjectTitle|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ProposedUserPersonType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStep|EndTime|StartTime|WorkAtHomeFlag|CollectiveAgreementIdCode|FullPartTime|PermanentTemporary|FLEX:PER_ASG_DF|Profile(PER_ASG_DF=Global Data Elements)|BadgeNumber(PER_ASG_DF=Global Data Elements)|ClockNumber(PER_ASG_DF=Global Data Elements)|BenefitProgram(PER_ASG_DF=Global Data Elements)|FLEX:PER_ASG_LEG_DDF|ACAFullTime(PER_ASG_LEG_DDF=US)
MERGE|Assignment|HRC_SQLLOADER|1111111-ASG-01||1111111|1111111-WR-01|1111111-WT-01|ADD_PEN_WKR|2018/11/12|4712/12/31|1|Y||P|||ACTIVE_PROCESS|||C01|||FR|Fusion HCM KB Corp||||H||||||||||40|W||||2018/11/12|P|Fusion HCM KB Corp|Pending Worker|PWK||Y|||||||2018/11/12||Employee|||||||||FULL_TIME|R|Global Data Elements|||||US|Y

Address update using surrogate keys

METADATA|PersonAddress|PersonNumber|AddressId|PersonAddrUsageId|AddressType|EffectiveStartDate|EffectiveEndDate|AddressLine1|AddressLine2|AddressLine3|AddressLine4|TownOrCity|Region1|Region2|Region3|Country|PostalCode|PrimaryFlag
MERGE|PersonAddress|12345|300000328265160|300000328265159|HOME|2018/10/09||84 LINDEN CRES||||MONCTON|||NB|CA|E1G 2B2|Y

Load Assignment Descriptive Flex Fields (DFF)

METADATA|WorkTerms|FLEX:PER_ASG_DF|WorkerType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|ActionCode|EffectiveStartDate|AssignmentNumber|LegalEmployerName|DateStart|PersonNumber|benefitGroup(PER_ASG_DF=Global Data Elements)
MERGE|WorkTerms|Global Data Elements|E||Y|1|TRANSFER|2019/12/02|ET111111|Fusion HCM KB|2019/07/09|111111|ABC
METADATA|Assignment|FLEX:PER_ASG_DF|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|EffectiveStartDate|AssignmentNumber|WorkTermsNumber|DateStart|PersonNumber|benefitGroup(PER_ASG_DF=Global Data Elements)
MERGE|Assignment|Global Data Elements||1|Y|TRANSFER|2019/12/02|E111111|ET111111|2019/07/09|111111|ABC

Perform Global Transfer for an employee

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|DateStart|WorkerType|PrimaryFlag|GlobalTransferFlag|ActionCode|RevokeUserAccess|EnterpriseSeniorityDate|LegalEmployerSeniorityDate
MERGE|WorkRelationship|Fusion HCM KB Inc|1111111|2018/09/11|E|Y|Y|GLB_TRANSFER|I|2018/09/11|2018/09/11
METADATA|WorkTerms|ActionCode|ReasonCode|LegalEmployerName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PersonTypeCode|AssignmentStatusTypeCode|AssignmentType|PrimaryWorkTermsFlag|PersonNumber|WorkerType|DateStart|BusinessUnitShortCode
MERGE|WorkTerms|GLB_TRANSFER||Fusion HCM KB Inc|ET1111111-2|2018/09/11||N|1|Employee|ACTIVE_PROCESS|ET|Y|1111111|E|2018/09/11|FUSIONHCMKB
METADATA|Assignment|ActionCode|ReasonCode|LegalEmployerName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|WorkTermsNumber|PersonTypeCode|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PrimaryAssignmentFlag|JobCode|LocationCode|ManagerFlag|DepartmentName|AssignmentCategory|HourlySalariedCode|FullPartTime|PermanentTemporary|NormalHours|Frequency|StartTime|EndTime|WorkAtHomeFlag
MERGE|Assignment|GLB_TRANSFER||Fusion HCM KB Inc|E1111111-2|2018/09/11||N|1|ET1111111-2|Employee|ACTIVE_PROCESS|E|FUSIONHCMKB|Y|701449|Office_Irving|N|HR Operations|FR|S|FULL_TIME|R|20|W|08:00||N

Load Line Manager details

METADATA|AssignmentSupervisor|AssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|ManagerAssignmentId(SourceSystemId)|ManagerId(SourceSystemId)|ManagerType|PersonId(SourceSystemId)|PrimaryFlag
MERGE|AssignmentSupervisor|STUDENT25_ASSIGN_ID101|STUDENT25|STUDENT25_MANAGER1_101|2013/01/15|4712/12/31|STUDENT25_ASSIGN_ID100|STUDENT25_PER100|LINE_MANAGER|STUDENT25_PER101|Y

Terminate an Active Employee

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|PeriodOfServiceId|DateStart|WorkerType|ActionCode|TerminateWorkRelationshipFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ProjectedTerminationDate|Comments
MERGE|WorkRelationship|VISION US|11111|300000014089267|2014/06/28|Employee|INVOLUNTARY_TERMINATION|Y|2016/06/29|2016/06/28|2016/06/29|2016/06/29|Sample Termination

Load Terminated employees

COMMENT ##############################################################################
COMMENT Business Entity : WorkRelationship
COMMENT ##############################################################################
METADATA|WorkRelationship|ActualTerminationDate|LegalEmployerName|Comments|LastWorkingDate|DateStart|NotifiedTerminationDate|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|WorkerNumber|WorkerType|OnMilitaryServiceFlag|RehireRecommendationFlag
MERGE|WorkRelationship|2015/08/31|Fusion HCM KB Inc||2015/08/31|2012/02/02|2015/08/31|HRC_SQLLOADER|325091_PERIOD_OF_SERVICE|35213_PERSON|Y|2015/08/31|||||E|N|N
COMMENT ##############################################################################
COMMENT Business Entity : WorkTerms
COMMENT ##############################################################################
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|HRC_SQLLOADER|36258_EMP_TERM|ET6|03-EMP_TERM_6||ET|2015/08/31|Y|1|2012/02/02|325091_PERIOD_OF_SERVICE|35213_PERSON|Y|Y|EMP|1901/01/01|4712/12/31|FusionHCMKB|Fusion HCM KB Inc
MERGE|WorkTerms|TERMINATION|HRC_SQLLOADER|36258_EMP_TERM|ET6|03-EMP_TERM_6||ET|4712/12/31|Y|1|2015/09/01|325091_PERIOD_OF_SERVICE|35213_PERSON|Y|Y|EMP|1901/01/01|4712/12/31|FusionHCMKB|Fusion HCM KB Inc
COMMENT ##############################################################################
COMMENT Business Entity : Assignment
COMMENT ##############################################################################
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|HRC_SQLLOADER|36258_EMP_ASSIGNMENT|2012/02/02|2015/08/31|1|Y|E|E6|03-EMP_ASG_6|ACTIVE_PROCESS||FusionHCMKB|93068_JOB|N|33735_LOCATION|Fusion HCM KB Inc|N|10633_ORGANIZATION|325091_PERIOD_OF_SERVICE|35213_PERSON|Employee|92483_POSITION|Y|Y||EMP|36258_EMP_TERM||1901/01/01|4712/12/31
MERGE|Assignment|TERMINATION|HRC_SQLLOADER|36258_EMP_ASSIGNMENT|2015/09/01|4712/12/31|1|Y|E|E6|03-EMP_ASG_6|INACTIVE_NO_PROCESS||FusionHCMKB|93068_JOB|N|33735_LOCATION|Fusion HCM KB Inc|N|10633_ORGANIZATION|325091_PERIOD_OF_SERVICE|35213_PERSON|Employee|92483_POSITION|Y|Y||EMP|36258_EMP_TERM||1901/01/01|4712/12/31

Update Job, Department and Location to Blank/ Null

METADATA|WorkTerms|AssignmentId|EffectiveStartDate|EffectiveEndDate|ActionCode|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|JobCode|LocationCode|DepartmentName|PeriodOfServiceId
MERGE|WorkTerms|300000008568170|2007/01/02|2017/09/29|HIRE|1|Y|ET|1|300000001613070|#NULL|#NULL|#NULL|300000008568167
METADATA|Assignment|AssignmentId|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|ActionCode|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|JobCode|LocationCode|DepartmentName|PeriodOfServiceId
MERGE|Assignment|300000008694232|300000008568170|2007/01/02|2017/09/29|HIRE|1|Y|E|1|300000001613070|#NULL|#NULL|#NULL|300000008568167

Load Worker Extensible Flex Fields (EFF)

METADATA|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|EFF_CATEGORY_CODE| ReviewDate(PER_PERSON_EIT_EFF=PERFORMANCE_EVALS)|REVIEWTYPES(PER_PERSON_EIT_EFF=PERFORMANCE_EVALS)|ReviewRatings(PER_PERSON_EIT_EFF=PERFORMANCE_EVALS)|ReviewReviewer(PER_PERSON_EIT_EFF=PERFORMANCE_EVALS)|ReviewNotes(PER_PERSON_EIT_EFF=PERFORMANCE_EVALS)|PersonExtraInfoId| EffectiveStartDate|EffectiveEndDate|PersonNumber 
MERGE|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|PER_EIT|2008-12-05|Performance Review| Meets Expectations|||HISTRVW_8316|2008-12-05|4712-12-31|11111 
MERGE|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|PER_EIT|2009-06-05|Performance Review| Exceeds Expectations||Review data from history table|HISTRVW_8317|2009-06-05|4712-12-31|11111 
MERGE|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|PER_EIT|2011-06-10|Off Cycle Evaluations| Exceeds Expectations||Restore performance rating to |HISTRVW_8318|2011-06-10|4712-12-31|11111 
MERGE|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|PER_EIT|2010-06-07|Performance Review| Exceeds Expectations||Review data from history table|HISTRVW_12002|2010-06-07|4712-12-31|11111

Load Person Images

METADATA|PersonImage|SourceSystemOwner|SourceSystemId|PersonNumber|ImageName|Image|PrimaryFlag
MERGE|PersonImage|HRC_SQLLOADER|35208_PERSON_IMG|03-35208|Bob|imgage.jpg|Y

Modify the person number after data load

COMMENT 11111-Sprint1 is the new person number
METADATA|Worker|PersonId|PersonNumber|EffectiveStartDate|EffectiveEndDate|StartDate
MERGE|Worker|300000008551111|11111-Sprint1|2011/06/18|4712/12/31|2014/06/18

Load Person Extensible Flex Field (EFF)

METADATA|WorkerExtraInfo|FLEX:PER_PERSON_EIT_EFF|EFF_CATEGORY_CODE|acqCode(PER_PERSON_EIT_EFF=Acq_Det)|acqDate(PER_PERSON_EIT_EFF=Acq_Det)|a401kVestedDate(PER_PERSON_EIT_EFF=Acq_Det)|EffectiveStartDate|EffectiveEndDate|PersonNumber|PeiInformationCategory|InformationType
MERGE|WorkerExtraInfo|Acq_Det|PER_EIT|Y|2019/01/01|2019/01/01|2019/01/01||11111|Acq_Det|Acq_Det

Hire, Terminate and Rehire of an employee using Source Keys

Hiring of employee effective 2017/08/16
Termination of worker effective 2018/01/01
Rehire of worker effective 2018/08/16

Initial Worker Load:
Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth|CountryOfBirth
MERGE|Worker|HRC_SQLLOADER|HRC_SQL_WRK_900|2017/08/16|4712/12/31|HRC_SQL_WRK_900|HIRE|2017/08/16|1975/01/01|US
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title
MERGE|PersonName|HRC_SQLLOADER|HRC_SQL_PERNAM_900|HRC_SQL_WRK_900|2017/08/16|4712/12/31|US|GLOBAL|Wendy||HDL_Lastname900|MR.
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|PrimaryFlag|WorkerNumber|WorkerType|RehireRecommendationFlag
MERGE|WorkRelationship|HRC_SQLLOADER|HRC_SQL_WR_900|HRC_SQL_WRK_900|WK_LE|2017/08/16|||||Y|HRC_SQL_WR_900|E|Y
METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PrimaryWorkTermsFlag|SystemPersonType|BusinessUnitShortCode|LegalEmployerName|PositionOverrideFlag|FreezeStartDate|FreezeUntilDate|PositionCode
MERGE|WorkTerms|HIRE|HRC_SQLLOADER|HRC_SQL_WT_900|HRC_SQLLOADER WT 900|HRC_SQL_WT_900|ACTIVE_PROCESS|ET|2017/08/16|4712/12/31|Y|1|HRC_SQL_WR_900|HRC_SQL_WRK_900|Y|EMP|WK_BU|WK_LE|Y|1901/01/01|4712/12/31|WK_IT_Analyst_2
METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|LegalEmployerName|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|ManagerFlag|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|Frequency|NormalHours|ReasonCode|PositionCode
MERGE|Assignment|HIRE|HRC_SQLLOADER|HRC_SQL_ASG_900|2017/08/16|4712/12/31|1|Y|WK Source Asgn 900|HRC_SQL_ASG_900|ACTIVE_PROCESS|E|WK_BU|Y|Y|Y|EMP|WK_LE|HRC_SQL_WR_900|HRC_SQL_WRK_900|Employee|Y|HRC_SQL_WT_900|FR|W|40|NEWHIRE|WK_IT_Analyst_2
 
Termination of worker effective 2018/01/01
Worker.dat
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|ActionCode|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|PrimaryFlag|WorkerNumber|WorkerType|RehireRecommendationFlag|TerminateWorkRelationshipFlag
MERGE|WorkRelationship|HRC_SQLLOADER|HRC_SQL_WR_900|TERMINATION|HRC_SQL_WRK_900|WK_LE|2017/08/16|||2018/01/01||Y|HRC_SQL_WR_900|E|Y|Y
 
Rehire of worker effective 2018/08/16
Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth|CountryOfBirth
MERGE|Worker|HRC_SQLLOADER|HRC_SQL_WRK_900|2017/08/16|4712/12/31|HRC_SQL_WRK_900||2017/08/16|1975/01/01|US
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|PrimaryFlag|WorkerNumber|WorkerType|RehireRecommendationFlag|ActionCode
MERGE|WorkRelationship|HRC_SQLLOADER|HRC_SQL_WR2_900|HRC_SQL_WRK_900|WK_LE|2018/08/16|||||Y|HRC_SQL_WR2_900|E|Y|
METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PrimaryWorkTermsFlag|SystemPersonType|BusinessUnitShortCode|LegalEmployerName|PositionOverrideFlag|FreezeStartDate|FreezeUntilDate|PositionCode
MERGE|WorkTerms|HIRE|HRC_SQLLOADER|HRC_SQL_WT2_900|HRC_SQLLOADER WT 900|HRC_SQL_WT2_900|ACTIVE_PROCESS|ET|2018/08/16|4712/12/31|Y|1|HRC_SQL_WR2_900|HRC_SQL_WRK_900|Y|EMP|WK_BU|WK_LE|Y|1901/01/01|4712/12/31|WK_IT_Analyst_2
METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|LegalEmployerName|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|ManagerFlag|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|Frequency|NormalHours|ReasonCode|PositionCode
MERGE|Assignment|HIRE|HRC_SQLLOADER|HRC_SQL_ASG2_900|2018/08/16|4712/12/31|1|Y|WK Source Asgn 900|HRC_SQL_ASG2_900|ACTIVE_PROCESS|E|WK_BU|Y|Y|Y|EMP|WK_LE|HRC_SQL_WR2_900|HRC_SQL_WRK_900|Employee|Y|HRC_SQL_WT2_900|FR|W|40||WK_IT_Analyst_2

Reverse Termination of an employee

METADATA|WorkRelationship|LegalEmployerSeniorityDate|LegalEntityId|EnterpriseSeniorityDate|DateStart|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId(SourceSystemId)|PrimaryFlag|PersonNumber|LegalEmployerName|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate|ActionCode|TerminateWorkRelationshipFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ReverseTerminationFlag
MERGE|WorkRelationship|||||||123456789_1||||||1122334455|HRC_SQLLOADER|||||||Y

Correct the Assignment Work Measure

METADATA|AssignmentWorkMeasure|AssignWorkMeasureId|AssignmentId(SourceSystemId)|EffectiveEndDate|EffectiveStartDate|Unit|Value|AssignmentNumber|SourceSystemOwner|SourceSystemId|GUID|NewUnit|ActionCode|ReasonCode
MERGE|AssignmentWorkMeasure||ASSIGNMENT_1|4712/12/31|2010/01/01|FTE|1||HRC_SQLLOADER|ASGWM_1||HEAD|HIRE|

Loading Non-Workers

COMMENT Data for Business Object: Worker Version: V2 Created on: 02-08-2013 
METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|BloodType|CorrespondenceLanguage|StartDate|DateOfBirth|DateOfDeath|CountryOfBirth|RegionOfBirth|TownOfBirth|ApplicantNumber|WaiveDataProtectFlag|CategoryCode|SourceSystemOwner|SourceSystemId|GUID|ActionCode|ReasonCode
MERGE|Worker||2012/01/01|4712/12/31||O+|US|2012/01/01|1980/01/01||US|||12345|N||HRC_SQLLOADER|111111111_678||ADD_NON_WKR|
METADATA|PersonName|PersonNameId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|PersonNumber|LegislationCode|NameType|FirstName|MiddleNames|LastName|Honors|KnownAs|PreNameAdjunct|MilitaryRank|PreviousLastName|Suffix|Title|CharSetContext|SourceSystemOwner|SourceSystemId|GUID|NameInformation1|NameInformation2|NameInformation3|NameInformation4|NameInformation5|NameInformation6|NameInformation7|NameInformation8|NameInformation9|NameInformation10|NameInformation11|NameInformation12|NameInformation13|NameInformation14|NameInformation15|NameInformation16|NameInformation17|NameInformation18|NameInformation19|NameInformation20|NameInformation21|NameInformation22|NameInformation23|NameInformation24|NameInformation25|NameInformation26|NameInformation27|NameInformation28|NameInformation29|NameInformation30|SourceRefTableName=PER_PERSON_NAMES_F|SourceRef001=PERSON_ID|SourceRef002=PERSON_NUMBER|SourceRef003=NAME_TYPE|SourceRef004=LAST_NAME
MERGE|PersonName||2012/01/01|4712/12/31|111111111_678||US|GLOBAL|FName|MN|LName|Doctor|||12|Prev LName|Suffix|Mr.|US|HRC_SQLLOADER|SSI_678234123_5||NI1|NI2|NI3|NI4|NI5|NI6|NI7|NI8|NI9|NI10|NI11|NI12|NI13|NI14|NI15|NI16|NI17|NI18|NI19|NI20|NI21|NI22|NI23|NI24|NI25|NI26|NI27|NI28|NI29|NI30|||Contact_DL001|GLOBAL|Contact_DL001 LName
METADATA|WorkRelationship|LegalEmployerSeniorityDate|LegalEntityId|EnterpriseSeniorityDate|DateStart|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId(SourceSystemId)|PrimaryFlag|PersonNumber|LegalEmployerName|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate|ActionCode
MERGE|WorkRelationship||||2012/01/01|Y||111111111_678|Y||Vision Corporation|N||1122334455_678|HRC_SQLLOADER||ADD_NON_WKR
METADATA|WorkTerms|ActionCode|AssignmentId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|AssignmentType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|ContractId|DateProbationEnd|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|ReportingEstablishment|EstablishmentId|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|DepartmentName|PeriodOfServiceId(SourceSystemId)|PersonId|PersonNumber|LegalEmployerName|DateStart|WorkerType|PositionCode|PositionOverrideFlag|PrimaryWorkTermsFlag|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|StepEntryDate|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsAssignmentId|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemOwner|SourceSystemId|CategoryCode|PersonTypeCode
MERGE|WorkTerms|ADD_NON_WKR||||ACTIVE_PROCESS||NT||||Fusion HCM KB Inc|||4712/12/31|Y|1|2012/01/01|WC|FR|Progress Master||||GRDCD_23||H|||||||JOBCD2318||84HOUSTON_0_2454201114730|N|40|W|90|D||Engineering R+D|1122334455_678||||||POSCD1551|||9|M|||||60|2040/12/12|||||17:00|09:00||N||||||HRC_SQLLOADER|22334455_678||Non Worker
METADATA|Assignment|ActionCode|AssignmentId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|AssignmentType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|DateProbationEnd|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|EstablishmentId|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|DepartmentName|PeriodOfServiceId|PersonId|PersonNumber|LegalEmployerName|DateStart|WorkerType|PositionCode|PositionOverrideFlag|PrimaryAssignmentFlag|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsAssignmentId(SourceSystemId)|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemOwner|SourceSystemId|CategoryCode
MERGE|Assignment|ADD_NON_WKR||||ACTIVE_PROCESS||N||||Fusion HCM KB Inc||4712/12/31|Y|1|2012/01/01|BC|FR|||||||||||||||||||||||||||||||Y||||||||||||||||22334455_678|||||HRC_SQLLOADER|33445566_678|

Loading Contingent Workers

COMMENT Data for Business Object: Worker Version: V2 Created on: 02-08-2013 
METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|BloodType|CorrespondenceLanguage|StartDate|DateOfBirth|DateOfDeath|CountryOfBirth|RegionOfBirth|TownOfBirth|ApplicantNumber|WaiveDataProtectFlag|CategoryCode|SourceSystemOwner|SourceSystemId|GUID|ActionCode|ReasonCode
MERGE|Worker||2012/01/01|4712/12/31||O+|US|2012/01/01|1980/01/01||US|||12345|N||HRC_SQLLOADER|111111111_1||ADD_CWK|
METADATA|PersonName|PersonNameId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|PersonNumber|LegislationCode|NameType|FirstName|MiddleNames|LastName|Honors|KnownAs|PreNameAdjunct|MilitaryRank|PreviousLastName|Suffix|Title|CharSetContext|SourceSystemOwner|SourceSystemId|GUID|NameInformation1|NameInformation2|NameInformation3|NameInformation4|NameInformation5|NameInformation6|NameInformation7|NameInformation8|NameInformation9|NameInformation10|NameInformation11|NameInformation12|NameInformation13|NameInformation14|NameInformation15|NameInformation16|NameInformation17|NameInformation18|NameInformation19|NameInformation20|NameInformation21|NameInformation22|NameInformation23|NameInformation24|NameInformation25|NameInformation26|NameInformation27|NameInformation28|NameInformation29|NameInformation30|SourceRefTableName=PER_PERSON_NAMES_F|SourceRef001=PERSON_ID|SourceRef002=PERSON_NUMBER|SourceRef003=NAME_TYPE|SourceRef004=LAST_NAME
MERGE|PersonName||2012/01/01|4712/12/31|111111111_1||US|GLOBAL|FName|MN|LName|Doctor|||12|Prev LName|Suffix|Mr.|US|HRC_SQLLOADER|SSI_1234123_5||NI1|NI2|NI3|NI4|NI5|NI6|NI7|NI8|NI9|NI10|NI11|NI12|NI13|NI14|NI15|NI16|NI17|NI18|NI19|NI20|NI21|NI22|NI23|NI24|NI25|NI26|NI27|NI28|NI29|NI30|||Contact_DL001|GLOBAL|Contact_DL001 LName
METADATA|WorkRelationship|LegalEmployerSeniorityDate|LegalEntityId|EnterpriseSeniorityDate|DateStart|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId(SourceSystemId)|PrimaryFlag|PersonNumber|LegalEmployerName|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate|ActionCode
MERGE|WorkRelationship||||2012/01/01|Y||111111111_1|Y||Vision Corporation|C||1122334455_1|HRC_SQLLOADER||ADD_CWK
METADATA|WorkTerms|ActionCode|AssignmentId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|AssignmentType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|ContractId|DateProbationEnd|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|ReportingEstablishment|EstablishmentId|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|DepartmentName|PeriodOfServiceId(SourceSystemId)|PersonId|PersonNumber|LegalEmployerName|DateStart|WorkerType|PositionCode|PositionOverrideFlag|PrimaryWorkTermsFlag|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|StepEntryDate|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsAssignmentId|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemOwner|SourceSystemId|CategoryCode|PersonTypeCode
MERGE|WorkTerms|ADD_CWK||||ACTIVE_PROCESS||CT||||Fusion HCM KB Inc|||4712/12/31|Y|1|2012/01/01|WC|FR|Progress Master||||GRDCD_23||H|||||||JOBCD2318||84HOUSTON_0_2454201114730|N|40|W|90|D||Engineering R+D|1122334455_1||||||POSCD1551|||9|M|||||60|2040/12/12|||||17:00|09:00||N||||||HRC_SQLLOADER|22334455_1||Contingent Worker
METADATA|Assignment|ActionCode|AssignmentId|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentStatusTypeId|AssignmentType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|DateProbationEnd|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|EstablishmentId|ExpenseCheckSendToAddress|GradeId|GradeCode|GradeLadderPgmId|HourlySalariedCode|InternalBuilding|InternalFloor|InternalLocation|InternalMailstop|InternalOfficeNumber|JobId|JobCode|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriod|NoticePeriodUOM|OrganizationId|DepartmentName|PeriodOfServiceId|PersonId|PersonNumber|LegalEmployerName|DateStart|WorkerType|PositionCode|PositionOverrideFlag|PrimaryAssignmentFlag|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsAssignmentId(SourceSystemId)|VendorId|FreezeStartDate|FreezeUntilDate|GUID|SourceSystemOwner|SourceSystemId|CategoryCode
MERGE|Assignment|ADD_CWK||||ACTIVE_PROCESS||C||||Fusion HCM KB Inc||4712/12/31|Y|1|2012/01/01|BC|FR|||||||||||||||||||||||||||||||Y||||||||||||||||22334455_1|||||HRC_SQLLOADER|33445566_1|

Change the Hire date of an employee

METADATA|WorkRelationship|LegalEmployerSeniorityDate|LegalEntityId|EnterpriseSeniorityDate|DateStart|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId(SourceSystemId)|PrimaryFlag|PersonNumber|LegalEmployerName|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate
MERGE|WorkRelationship||||2010/01/01|Y||123456789_1|Y||Fusion HCM KB Inc|E||1122334455|HRC_SQLLOADER|2012/01/01

If you guys have come across any further samples that you want to share, please comment and I will update the post with details.