Worker Upload with Multiple Assignments

 

We can use below dat file to upload Worker with multiple Assignments. Few field values might change based on the client configuration

File name: Worker.dat

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|DateOfDeath|CategoryCode|ActionCode

MERGE|Worker|LEGACY|4989|2021/07/12||2021/07/12|1989/12/29|||HIRE

METADATA|PersonName|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|NameType|FirstName|MiddleNames|LastName|KnownAs|Suffix|CharSetContext

MERGE|PersonName|LEGACY|PP_NM_001|2021/07/12||4989||GLOBAL|Dinesh1||Neredu1|DN||

METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|DateFrom|DateTo|PersonId(SourceSystemId)|EmailType|EmailAddress|PrimaryFlag

MERGE|PersonEmail|LEGACY|PP_EM_001|2021/07/12||4989|W1|Dinu1@gmail.com|Y

METADATA|WorkRelationship|DateStart|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PrimaryFlag|LegalEmployerName|WorkerType

MERGE|WorkRelationship|2021/07/12|LEGACY|PP_WREL_001|4989|Y|France SAS|E

METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|ActionCode|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|PositionOverrideFlag|PrimaryWorkTermsFlag|AssignmentCategory|GradeCode|HourlySalariedCode|InternalMailstop|InternalOfficeNumber|JobCode|LocationCode|NormalHours|Frequency|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|SystemPersonType|FreezeStartDate|FreezeUntilDate|FullPartTime|PermanentTemporary

MERGE|WorkTerms|LEGACY|PP_WT_001|HIRE|||ACTIVE_PROCESS|ET|France|2021/12/31|Y|1|2021/07/12||Y|||H|||FIN-05-0011|C.IT.1.0001|37.50|W|PP_WREL_001|4989|France SAS|EMP|||FULL_TIME|R

MERGE|WorkTerms|LEGACY|PP_WT_001|WOOD_DATA_CONV|||ACTIVE_PROCESS|ET|France|4712/12/31|Y|1|2022/01/01||Y|||H|||FIN-05-0011|C.IT.1.0001|37.50|W|PP_WREL_001|4989|France SAS|EMP|||FULL_TIME|R

METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|BusinessUnitShortCode|AssignmentCategory|GradeCode|HourlySalariedCode|InternalMailstop|InternalOfficeNumber|JobCode|LocationCode|NormalHours|Frequency|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|PersonTypeCode|PrimaryAssignmentFlag|PrimaryFlag|ReasonCode|SystemPersonType|WorkTermsAssignmentId(SourceSystemId)|FreezeStartDate|FreezeUntilDate|FullPartTime|PermanentTemporary|DepartmentName

MERGE|Assignment|HIRE|LEGACY|ET4989|2021/07/12|2021/12/31|1|Y|E|||ACTIVE_PROCESS|France|||H|||FIN-05-0011|C.IT.1.0001|37.50|W|PP_WREL_001|4989|France SAS|Employee|Y|Y||EMP|PP_WT_001|||FULL_TIME|R|

MERGE|Assignment|WOOD_DATA_CONV|LEGACY|ET4989|2022/01/01|4712/12/31|1|Y|E|||ACTIVE_PROCESS|France|||H|||FIN-05-0011|C.IT.1.0001|37.50|W|PP_WREL_001|4989|France SAS|Employee|Y|Y||EMP|PP_WT_001|||FULL_TIME|R|

METADATA|Contract|AssignmentId(SourceSystemId)|ContractId|ContractType|Description|Duration|DurationUnits|EffectiveStartDate|EffectiveEndDate|ExtensionPeriod|ExtensionPeriodUnits|ExtensionReason|PersonId(SourceSystemId)|AssignmentNumber|PersonNumber|GUID|SourceSystemId|SourceSystemOwner|ContractNumber

MERGE|Contract|PP_WT_001||||||2021/07/12|2021/12/31||||4989||||4989_CT|LEGACY|

MERGE|Contract|PP_WT_001||||||2022/01/01|4712/12/31||||4989||||4989_CT|LEGACY|