Example of Loading a Tax Reporting Unit for a Worker
The Tax Reporting Unit (TRU) ID and TRU fields are added to the worker data (worker.dat) file when creating workers, work relationships, or assignments using HCM Data Loader.
You can pass the TRU ID or TRU name in the worker.dat file when loading workers in these scenarios:
Hire
METADATA|Worker|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|WaiveDataProtectFlag|SourceSystemOwner|SourceSystemId|ActionCode
MERGE|Worker|2000/01/01|4712/12/31||2000/01/01|1970/01/01|Y|HRC_SQLLOADER|SSI_0004A_0123_1|HIRE
METADATA|PersonName|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|NameType|FirstName|MiddleNames|LastName|CharSetContext|SourceSystemOwner|SourceSystemId
MERGE|PersonName|2000/01/01|4712/12/31|SSI_0004A_0123_1|US|GLOBAL|Worker_new_SSI_0004A_0123_1FName||Worker_new_SSI_0004A_0123_1LName|US|HRC_SQLLOADER|SSI_0004A_NAME_0123_1
METADATA|WorkRelationship|LegalEntityId|ActualTerminationDate|DateStart|PrimaryFlag|WorkerNumber|PersonId(SourceSystemId)|WorkerType|SourceSystemId|SourceSystemOwner
MERGE|WorkRelationship|40010||2000/01/01|Y||SSI_0004A_0123_1|E|SSI_0004A_WREL_0123_1|HRC_SQLLOADER
METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentType|BusinessUnitId|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|SystemPersonType|WorkerCategory|PeriodOfServiceId(SourceSystemId)|SourceSystemOwner|SourceSystemId
MERGE|WorkTerms|HIRE|ACTIVE_PROCESS|ET|202|4712/12/31|Y|1|2000/01/01|EMP|WC|SSI_0004A_WREL_0123_1|HRC_SQLLOADER|SSI_0004A_WTERM_0123_1
METADATA|Assignment|ActionCode|TaxReportingUnitId|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|SystemPersonType|BusinessUnitId|PeriodOfServiceId(SourceSystemId)|DateStart|PrimaryAssignmentFlag|WorkTermsAssignmentId(SourceSystemId)|SourceSystemId|SourceSystemOwner
MERGE|Assignment|HIRE|1017||2000/01/01|4712/12/31|1|Y|E|EMP|202|SSI_0004A_WREL_0123_1|2000/01/01|Y|SSI_0004A_WTERM_0123_1|SSI_0004A_WASGN_0123_1|HRC_SQLLOADERCreate Work Relationship
METADATA|WorkRelationship|LegalEmployerSeniorityDate|LegalEntityId|EnterpriseSeniorityDate|DateStart|OnMilitaryServiceFlag|PeriodOfServiceId|PersonId(SourceSystemId)|PrimaryFlag|PersonNumber|LegalEmployerName|WorkerType|GUID|SourceSystemId|SourceSystemOwner|NewStartDate|ActionCode
MERGE|WorkRelationship||||2011/01/01|Y||SSI_0004M_0123_1|N||Vision Corporation|C||SSI_0004M_0123_2|HRC_SQLLOADER||ADD_CWK_WORK_RELATION
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_WORK_RELATION||||ACTIVE_PROCESS||CT|||202|Vision Corporation Enterprise|||4712/12/31|Y|1|2011/01/01|WC|FR|Progress Master|||||||||||||||||||||||SSI_0004M_0123_2||||||||||||||||2040/12/12||||||||N||||||HRC_SQLLOADER|SSI_0004M_WTERM_0123_2||Contingent Worker
METADATA|Assignment|ActionCode|AssignmentId|TaxReportingUnitId|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_WORK_RELATION||300100201616314|||ACTIVE_PROCESS||C|||202|Vision Corporation Enterprise||4712/12/31|Y|1|2011/01/01|BC|FR|||||||||||||||||||||||||||||||Y||||||||||||||||SSI_0004M_WTERM_0123_2|||||HRC_SQLLOADER|SSI_0004M_WASGN_0123_2|Add Assignment
METADATA|Assignment|ActionCode|TaxReportingUnitId|AssignmentId|AssignmentStatusTypeCode|AssignmentType|BusinessUnitId|BusinessUnitShortCode|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|WorkerCategory|AssignmentCategory|JobCode|ManagerFlag|NormalHours|Frequency|DepartmentName|PrimaryAssignmentFlag|WorkAtHomeFlag|WorkTermsAssignmentId(SourceSystemId)|SourceSystemOwner|SourceSystemId|CategoryCode|PersonTypeCode
MERGE|Assignment|ADD_ASSIGN|1017||ACTIVE_PROCESS|E||Vision Corporation Enterprise|4712/12/31|Y|1|2010/01/01|WC|FR|JOBCD2320|N|40|W|Engineering R+D|Y|N|22334455|HRC_SQLLOADER|33445566_1||EmployeeGlobal Transfer
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|PrimaryFlag|GlobalTransferFlag|ActionCode
MERGE|WorkRelationship|HRC_SQLLOADER|WR-HDLWorker_111_1|HDLWorker_111_1|Vision Corporation|HDLWorker_111_1|1985/07/16|E|Y|Y|GLB_TRANSFER
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|ActionCode|ReasonCode|LegalEmployerName|AssignmentNumber|AssignmentName|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId(SourceSystemId)|PersonTypeCode|AssignmentStatusTypeCode|AssignmentType|BusinessUnitId|NoticePeriod|PrimaryWorkTermsFlag|FreezeStartDate|FreezeUntilDate
MERGE|WorkTerms|HRC_SQLLOADER|WT-HDLWorker_111_1|GLB_TRANSFER||Vision Corporation|WT-NU-HDLWorker_111_1|WT-NA-HDLWorker_111_1|1985/07/16|4712/12/31|N|1|WR-HDLWorker_111_1|Employee|ACTIVE_NO_PROCESS|ET|202|0|Y|4712/12/31|1950/01/01
METADATA|Assignment|SourceSystemOwner|SourceSystemId|ActionCode|TaxReportingUnitId|ReasonCode|LegalEmployerName|AssignmentNumber|AssignmentName|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|PersonTypeCode|AssignmentStatusTypeCode|AssignmentType|BusinessUnitId|NoticePeriod|PrimaryAssignmentFlag|FreezeStartDate|FreezeUntilDate
MERGE|Assignment|HRC_SQLLOADER|WA-HDLWorker_111_1|GLB_TRANSFER|1017||Vision Corporation|WA-NU-HDLWorker_111_1|WA-NA-HDLWorker_111_1|1985/07/16|4712/12/31|N|1|WR-HDLWorker_111_1|WT-HDLWorker_111_1|Employee|ACTIVE_NO_PROCESS|E|202|0|Y|4712/12/31|1950/01/01Note: