In this article we will look into the minimum business objects that are required to get the Worker business object loaded.
Worker, PersonName, WorkRelationship, WorkTerms and Assignment are the minimum business objects required on the Worker.dat to get the person data loaded. Depending on the legislation, other business objects might be required to be added.
Within these METADATA also, only some of the fields are required to be populated and the rest of the fields can be left blank.
Sample Worker.dat to load the person information: We are not passing the Person Number and it will be generated automatically based on the Enterprise configuration.
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|ActionCode
MERGE|Worker|HRC_SQLLOADER|PER_456|2023/01/01|||2023/01/01|HIRE
METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|NameType|LegislationCode|LastName|FirstName
MERGE|PersonName|HRC_SQLLOADER|PER_456_GLOBAL|2023/01/01||PER_456|GLOBAL|US|Potter|Harry
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag
MERGE|WorkRelationship|HRC_SQLLOADER|PER_456_POS|PER_456|Fusion HCM Knowledgebase LLC|2023/01/01|E|Y
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|PrimaryWorkTermsFlag|PersonId(SourceSystemId)|BusinessUnitShortCode|AssignmentStatusTypeCode
MERGE|WorkTerms|HRC_SQLLOADER|PER_456_TERM|PER_456_POS|HIRE|2023/01/01||1|Y|Y|PER_456|FusionHCMKB BU|ACTIVE_PROCESS
METADATA|Assignment|SourceSystemOwner|SourceSystemId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|WorkTermsAssignmentId(SourceSystemId)|AssignmentStatusTypeCode|PersonTypeCode|BusinessUnitShortCode|PrimaryAssignmentFlag
MERGE|Assignment|HRC_SQLLOADER|PER_456_ASG|HIRE|2023/01/01||1|Y|PER_456_TERM|ACTIVE_PROCESS|Employee|FusionHCMKB BU|YThis would be mostly used when the client is using ERP/Procurement and want to just create the users along with person records.
For HCM purpose, we need to populate lot of other fields which are required by the HCM application.
