METADATA|DepartmentTreeNode|TreeStructureCode|TreeCode|TreeVersionName|DepartmentName|ParentDepartmentName MERGE|DepartmentTreeNode|PER_DEPT_TREE_STRUCTURE|XYZ Department Tree|XYZ Tree of Departments|XYZ-IND-GG-NorthRegion|XYZ-IND-GG-NorthRegion-A&B-North
Dat File Name: Organization.dat METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode|FLEX:PER_ORGANIZATION_UNIT_DFF|ExpenseAccount(PER_ORGANIZATION_UNIT_DFF=Global Data Elements)|ProjectCode(PER_ORGANIZATION_UNIT_DFF=Global Data Elements)
Dat File Name: DocumentsOfRecord METADATA|DocumentsOfRecord|DocumentType|DocumentTypeId|PersonNumber|FLEX:PER_DOCUMENTS_OF_RECORD_DFF|dateOfAmendedDutiesNote(PER_DOCUMENTS_OF_RECORD_DFF=GB_DUTIES_NOTE)|SourceSystemOwner|SourceSystemId
Dat File Name: Course.dat METADATA|Course|EffectiveStartDate|CourseNumber|Title|ShortDescription|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|TrailerLiNumber|OwnedByPersonNumber|SourceType|SourceId|SourceInfo
METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|ActionCode MERGE|WorkTerms|300000004558914|300000004558906|Y|1|2022/01/01|ASG_CHANGE
METADATA|TalentProfile|ProfileTypeCode|PersonNumber|ProfileId|ProfileUsageCode|ProfileStatusCode|ProfileCode MERGE|TalentProfile|PERSON|020250|300000030849224|P|A|TPROF_020250
Update Action and Action Reason for a terminated employee, use Worker.dat file, WorkTerms and Assignment. METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|PersonId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|ReasonCode MERGE|WorkTerms|300000020344247|300000020344240|300000020344238|2018/05/10|4712/12/31|1|Y|INVOLUNTARY_TERMINATION|DISMISSAL
METADATA|LegacyLearningItem|Title|LearningItemNumber|EffectiveStartDate|EffectiveEndDate|OwnedByPersonNumber|SourceType|SourceInfo MERGE|LegacyLearningItem|Legacy Test|Legacy Test_101|1951/01/01||2002|FUSION_HCM_LEARNING|LegacyLearningSystemSourceInfo
METADATA|LearningRecord|LearnerNumber|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordExpiryDate|LearningRecordReasonCode|LearningRecordComments|LearningRecordValidFromDate MERGE|LearningRecord|2002|2021/01/01||Legacy Test_101|E2002|ORA_LEGACY|Legacy Test_101|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|2002|ORA_PERSON|2002|ORA_SELF|ORA_ASSN_REC_COMPLETE|2021/01/01|2021/01/01|||2021/01/05||ORA_WLF_COMPLT_RSN_SPEC||2021/01/05
Dat file name - Worker.dat METADATA|PersonEmail|EmailAddressId|PersonId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId DELETE|PersonEmail|300000006217503|300000013568485|100|1951/01/01|4712/12/31|H1|HOMEEMAIL@oracle.com|N|||
1. Â Â Create TalentProfile.dat file and zip. COMMENT PERS_300100037978548 (Employee02) Loading ProfileItem Risk/Impact Of Loss METADATA|ProfileItem|ProfileItemId|ProfileCode|SectionId|ContentTypeId|DateFrom|DateTo|
Dat File Name: LearningRecord.dat METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate| LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|
METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate| LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber| LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|
METADATA|JobFamily|EffectiveStartDate|EffectiveEndDate|JobFamilyName DELETE|JobFamily|2012/10/01|4712/12/31|Sales01
Dat file name - Organization.dat METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationCode| LocationSetCode|SourceSystemOwner|SourceSystemId
Dat file name - Position.dat METADATA|Position|EffectiveStartDate|EffectiveEndDate|BusinessUnitName|PositionCode|Name| DepartmentName|JobSetCode|JobCode|LocationCode|EntryGradeCode|ActiveStatus|FTE|HiringStatus| HeadCount|OverlapAllowedFlag|WorkingHours|Frequency|FullPartTime|PositionType|FLEX:PER_POSITIONS_DFF| dbsCheckRequired(PER_POSITIONS_DFF=Global Data Elements)|dbsFrequency(PER_POSITIONS_DFF=Global Data Elements)|SourceSystemOwner|SourceSystemId
Dat file name - Location.dat METADATA|Location|EffectiveStartDate|EffectiveEndDate|LocationCode|SetCode|ActiveStatus| LocationName|AddressLine1|AddressLine2|Country|PostalCode|TownOrCity|SourceSystemOwner| SourceSystemId
Dat file name - Job.dat METADATA|Job|EffectiveStartDate|EffectiveEndDate|JobCode|SetCode|Name|JobFamilyName| ActiveStatus|SourceSystemOwner|SourceSystemId|ApprovalAuthority