Saturday, June 16, 2018

Oracle Fusion: sample datafile .dat file to upload HR Person Record



METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonId|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|PersonNumber|ApplicantNumber|CategoryCode|ActionCode|ReasonCode|SourceRefTableName=PERSON|SourceRef001=EMPLID
MERGE|Worker|HRC_SQLLOADER|00915NTYI_ID||2015/08/31|4712/12/31|2015/08/31|1958/07/27|00915NTYI|||HIRE|||00915NTYI_ID
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|Sex|MaritalStatus|SourceRefTableName=legislation_data|SourceRef001=legalentityid
MERGE|PersonLegislativeData|HRC_SQLLOADER|00915NTYI_LEGIS|2015/08/31|4712/12/31|00915NTYI_ID|US|M|M||00915NTYI_LEGIS
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonNameId|EffectiveStartDate|EffectiveEndDate|LegislationCode|PersonId(SourceSystemId)|PersonNumber|NameType|FirstName|MiddleNames|LastName|SourceRefTableName=PER_NAME|SourceRef001=NID
MERGE|PersonName|HRC_SQLLOADER|00915NTYI_NAME||2015/08/31|4712/12/31|US|00915NTYI_ID|00915NTYI|GLOBAL|AAatricia||LNicon||00915NTYI_NAME
METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|PersonNumber|AddressType|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode|LongPostalCode|TimezoneCode|PrimaryFlag|SourceRefTableName=ADDRESSES|SourceRef001=ADDRESS_ID
MERGE|PersonAddress|HRC_SQLLOADER|00915NTYI_ADD|2015/08/31|4712/12/31|00915NTYI_ID|00915NTYI|HOME|2901 Jasmine Street||||||San Francisco||California||US|94123|||||00915NTYI_ADD
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerNumber|WorkerType|PrimaryFlag
MERGE|WorkRelationship|HRC_SQLLOADER|00915NTYI_AWR|00915NTYI_ID|US1 Legal Entity|2015/08/31|HA1|E|Y
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeId|AssignmentStatusTypeCode|PersonTypeId|PersonTypeCode|SystemPersonType|BargainingUnitCode|BillingTitle|BusinessUnitId|BusinessUnitShortCode|ContractId|DateProbationEnd|WorkerCategory|AssignmentCategory|EstablishmentId|ReportingEstablishment|ExpenseCheckSendToAddress|GradeId|GradeCode|HourlySalariedCode|InternalBuilding|InternalLocation|InternalOfficeNumber|JobId|JobCode|LabourUnionMemberFlag|LocationId|LocationCode|ManagerFlag|NormalHours|Frequency|NoticePeriodUOM|NoticePeriod|OrganizationId|DepartmentName|PersonNumber|DateStart|WorkerType|PositionId|PositionCode|ProbationPeriod|ProbationUnit|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ProposedUserPersonType|ReasonCode|RetirementAge|RetirementDate|SpecialCeilingStep|StepEntryDate|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|VendorId|FreezeStartDate|FreezeUntilDate|CategoryCode|TaxReportingUnitId|TaxReportingUnit|PeopleGroup|FullPartTime|PermanentTemporary|AssignmentType|PositionOverrideFlag|PrimaryWorkTermsFlag|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|ActionCode|AssignmentId|CollectiveAgreementId|GradeLadderPgmId|GradeLadderPgmName|InternalFloor|SpecialCeilingStepId|WorkTermsAssignmentId|CollectiveAgreementIdCode|SourceRefTableName=WTBL|SourceRef001=WTID
MERGE|WorkTerms|HRC_SQLLOADER|00915NTYI_AWT|2015/08/31|4712/12/31|1|Y|||||||||||US1 Business Unit||||Full-Time Regular||||||S|||||||||N|40|W|||||00915NTYI|2015/08/31|E||||||2015/08/31||||||||||||||||||||Full Time|Regular|ET|||00915NTYI_AWR|00915NTYI_ID|US1 Legal Entity|HIRE||||||||||00915NTYI_AWT
METADATA|Assignment|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|ActionCode|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeId|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|LegalEmployerName|OrganizationId(SourceSystemId)|PositionId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|ManagerFlag|LabourUnionMemberFlag|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|Frequency|HourlySalariedCode|NormalHours|NoticePeriod|NoticePeriodUOM|ProbationPeriod|ProbationUnit|ReasonCode|BargainingUnitCode|BillingTitle|BusinessUnitId|DateProbationEnd|WorkerCategory|EstablishmentId|ReportingEstablishment|ExpenseCheckSendToAddress|GradeId(SourceSystemId)|GradeCode|InternalBuilding|InternalFloor|InternalLocation|InternalOfficeNumber|JobId(SourceSystemId)|JobCode|LocationId(SourceSystemId)|LocationCode|DepartmentName|PersonNumber|DateStart|WorkerType|PersonTypeId|PositionCode|ProjectTitle|ProjectedEndDate|ProjectedStartDate|ProposedWorkerType|ProposedUserPersonType|RetirementAge|RetirementDate|SpecialCeilingStepId|SpecialCeilingStep|TaxAddressId|EndTime|StartTime|VendorSiteId|WorkAtHomeFlag|WorkTermsNumber|VendorId|FreezeStartDate|FreezeUntilDate|CategoryCode|PeopleGroup|FullPartTime|PermanentTemporary|CollectiveAgreementIdCode|AssignmentId|GradeLadderPgmId|GradeLadderPgmName|InternalMailstop|SourceRefTableName=ASSTBL|SourceRef001=ASSID
MERGE|Assignment|HRC_SQLLOADER|00915NTYI_ASS|2015/08/31|4712/12/31|HIRE|1|Y|||||E|US1 Business Unit||Y|Y||US1 Legal Entity||||00915NTYI_ID||N||00915NTYI_AWT|Full-Time Regular|W|S|40|||||||||||||||Prof06||||||JOB033||ComGlobOps||00915NTYI|2015/08/31|E||POS033|||2015/08/31||||||||||||||||||Full Time|Regular|||||||00915NTYI_ASS

No comments: