New Worker upload

 

We can use below .dat file to create new worker in oracle fusion application. Few fields might change based on the client environment

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|Dinesh||Neredu|PP||

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

MERGE|PersonEmail|LEGACY|PP_EM_001|2021/07/12||4989|W1|Dinu@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||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

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||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|4712/12/31||||4989||||4989_CT|LEGACY|