就業者の税レポート・ユニットのロードの例

HCMデータ・ローダーを使用して就業者、雇用関係またはアサイメントを作成するときに、税レポート・ユニット(TRU) IDとTRUのフィールドが就業者データ(worker.dat)ファイルに追加されます。

次のシナリオで就業者をロードするときに、worker.datファイルでTRU IDまたはTRU名を渡すことができます。

採用

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_SQLLOADER

雇用関係の作成

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|

アサイメントの追加

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||Employee

グローバル異動

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/01

ノート: