0
0
Update Document of Records - DocumentsOfRecord.dat
METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DateFrom|DateTo|IssuingAuthority|IssuedDate|IssuingCountryName|IssuingLocation|Comments|Publish|PublishDate|Status|LegislationCode|DocumentCode|SourceSystemId|SourceSystemOwner|FLEX:PER_DOCUMENTS_OF_RECORD_DFF
MERGE|DocumentsOfRecord|10030|Birth Certificate Details|AE|||||||||||AE||DOR_10030_Birth_Certificate_Details_AE|HDL
Create or Update Grade Ladder - GradeLadder.dat
METADATA|GradeLadder|GradeLadderName|GradeSetCode|EffectiveStartDate|EffectiveEndDate|GradeType|ActiveStatus|FLEX:PER_GRADE_LADDERS_DF|SourceSystemId|SourceSystemOwner
MERGE|GradeLadder|Teacher|COMMON|2013/09/25|4712/12/31|STEP|A||GRD_LDR_COMMON_TEACHER|ABCD
Update Grade Rate - GradeRate.dat
METADATA|StepRate|RateName|LegislativeDataGroup|EffectiveStartDate|EffectiveEndDate|GradeLadderName|GradeLadderId(SourceSystemId)|RateType|CurrencyCode|RateFrequency|LegislationCode|ActiveStatus|AnnualizationFactor|SourceSystemId|SourceSystemOwner
MERGE|StepRate|Teacher|ABC Camden|2013/09/25|4712/12/31|Teacher|GRD_LDR_COMMON_TEACHER|||ANNUAL|GB|A|1|STP_RATE_LBCCAMDEN_TEACHER|ABCD
Update Job Family - JobFamily.dat
METADATA|JobFamily|JobFamilyName|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ActionReasonCode|FLEX:PER_JOB_FAMILY_DFF|SourceSystemId|SourceSystemOwner
MERGE|JobFamily|ABC Job Family|I|1951/01/01|4712/12/31|||JOB_FAMILY_ABCJOBFAMILY|UN
Remove Position Synchronization Row and change it to Change Assignment - Assignment - Worker.dat
METADATA|Assignment|AssignmentId|ActionCode|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId|PrimaryFlag|PrimaryAssignmentFlag
MERGE|Assignment|300001261544132|ASG_CHANGE|300001261544129|8/11/2024|Y|Y|1||Y|Y
Remove Position Synchronization Row and change it to Change Assignment - WorkTerm Assignment - Worker.dat
METADATA|WorkTerms|AssignmentId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId|PrimaryWorkTermsFlag
MERGE|WorkTerms|300001261544129|ASG_CHANGE|8/11/2024|12/31/4712|Y|1|3.00001E+14|N
Terminate an employee - Worker.dat
METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId
MERGE|WorkRelationship|Vision|12345|9/20/2017|PER|PERFOR|Y|100000004535353
Adding a New Row as a Change Assignment Action on the assignment page - Assignment - Worker.dat
METADATA|Assignment|PersonNumber|AssignmentNumber|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|ActionCode|ReasonCode|EffectiveSequence|EffectiveLatestChange|AssignmentStatusTypeCode
MERGE|Assignment|391720|E391720|ET391720|1/21/2025|12/31/4712|ASG_CHANGE||1|Y|ACTIVE_PROCESS
Adding a New Row as a Change Assignment Action on the assignment page - WorkTerms Assignment - Worker.dat
METADATA|WorkTerms|AssignmentNumber|PersonNumber|DateStart|WorkerType|LegalEmployerName|EffectiveStartDate|EffectiveEndDate|ActionCode|ReasonCode|EffectiveSequence|EffectiveLatestChange
MERGE|WorkTerms|ET391720|391720|12/24/2024|E|ABC Private Limited|1/21/2025|12/31/4712|ASG_CHANGE||1|Y
Location Update on the assignment page - Assignment - Worker.dat
METADATA|Assignment|AssignmentId|ActionCode|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId|LocationCode|ReasonCode
MERGE|Assignment|30000414|LOCATION_CHANGE|0000414|2/16/2025|12/31/4712|Y|1|30000414|L02997|ABC_WORK_AT_HOME
Location Update on the assignment page - WorkTerms Assignment - Worker.dat
METADATA|WorkTerms|AssignmentId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PeriodOfServiceId
MERGE|WorkTerms|30000414|LOCATION_CHANGE|2/16/2025|12/31/4712|Y|1|30000414
Leave of Absence LOA Update on the assignment page - Assignment - Worker.dat
METADATA|Assignment|AssignmentId|WorkTermsAssignmentId|PeriodOfServiceId|EffectiveStartDate|EffectiveEndDate|ActionCode|ReasonCode|AssignmentStatusTypeCode|EffectiveSequence|EffectiveLatestChange
Assignment|300000064016997|300000064016821|300000064016797|300004123009586|12/31/4712|ABC_LEAVE_PAID|ABC_STD60_LEAVE|LEAVE_ACTIVE_PROCESS|LEAVE_ACTIVE_PROCESS|1|Y
Leave of Absence LOA Update on the assignment page - WorkTerms Assignment - Worker.dat
METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange
WorkTerms|WorkTerms|300000064016797|300004123009586|ABC_LEAVE_PAID|2/14/2025|12/31/4712|1|Y
Create Location - Location.dat
METADATA|Location|EffectiveStartDate|EffectiveEndDate|LocationCode|SetCode|ActiveStatus|LocationName|AddressLine1|AddressLine2|Country|PostalCode|TownOrCity|SourceSystemOwner|SourceSystemId
MERGE|Location|1950/01/01|4712/12/31|LOC001|SET0001|A|The Registry Office|368 London High Street|London|GB|HA1 1EH|London|HDL|HP_LOC001
Create Position - 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
MERGE|Position|1951/01/01|4712/12/31|UK BU|D00050|Councillors|ELECTORAL SERVICES|COMMON|JOB001|LOC001|CLLR|ACTIVE|55|APPROVED|55|Y|0|Weekly|FULL_TIME|SHARED|Global Data Elements|||HDL|D00050_POSITION
METADATA|PositionGrade|EffectiveStartDate|EffectiveEndDate|BusinessUnitName|PositionCode|GradeSetCode|GradeCode|SourceSystemOwner|SourceSystemId
MERGE|PositionGrade|1951/01/01|4712/12/31|UK BU|D00050|SET0001|CLLR|HDL|D00050_CLLR_POSITIONGRADE
Create an Organization - Organization.dat
METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationCode|LocationSetCode|SourceSystemOwner|SourceSystemId
MERGE|Organization|1951/01/01|4712/12/31|ELECTORAL SERVICES|DEPARTMENT|||HDL|ELECTIONS
METADATA|OrgUnitClassification|EffectiveStartDate|EffectiveEndDate|ClassificationCode|SetCode|Status|OrganizationId(SourceSystemId)|SourceSystemOwner|SourceSystemId
MERGE|OrgUnitClassification|1951/01/01|4712/12/31|DEPARTMENT|SET0001|A|ELECTIONS|HDL|ELECTIONS_class
Create an Organization Tree - OrganizationTree.dat
METADATA|OrganizationTree|TreeStructureCode|TreeCode|TreeName|TreeDescription
MERGE|OrganizationTree|PER_ORG_TREE_STRUCTURE|WILTSHIRE_ORG_TREE|Wiltshire Organisation Tree|Wiltshire Organisation Tree
METADATA|OrganizationTreeVersion|TreeStructureCode|TreeCode|TreeVersionStartDate|TreeVersionEndDate|TreeVersionName|TreeVersionDescription|TreeVersionNote|UpdatedTreeVersionName
MERGE|OrganizationTreeVersion|PER_ORG_TREE_STRUCTURE|ORG_TREE|1951/01/01|4712/12/31|WC_ORG_V1.0|ABC_ORG_V1.0||
Update Organization Template - 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)
MERGE|Organization|1/1/1951||ABC-US-CI-MFD-IND|G4S_SS_US|ORG_US_DPT_001|DEPARTMENT|Global Data Elements|US058-50-MFD-89011-72253099-000000-00000-0000-0000|US0582MFD8901101
Add an Organization Tree Node - OrganizationTreeNode.dat
METADATA|OrganizationTreeNode|TreeStructureCode|TreeCode|TreeVersionName|ParentOrganizationName|ParentClassificationCode|OrganizationName|ClassificationCode|ReferenceTreeCode|ReferenceTreeVersionName|DeleteChildNodesFlag
MERGE|OrganizationTreeNode|PER_ORG_TREE_STRUCTURE|ORC_ORG_TREE|ORC_ORG_V1.0|||Council|ENTERPRISE|||
School Effectiveness|HCM_DIVISION|||
Delete a job family - JobFamily.dat
METADATA|JobFamily|EffectiveStartDate|EffectiveEndDate|JobFamilyName
DELETE|JobFamily|2012/10/01|4712/12/31|Sales01
Delete an email for an employee - 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|||
Update the department of an Employee - Worker.dat
METADATA|WorkTerms|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|PeriodOfServiceId|PersonId|PrimaryWorkTermsFlag|ActionCode|ReasonCode|WorkTermsAssignmentId|JobCode|DepartmentName
MERGE|WorkTerms|999999999999999|2022/01/01|4712/12/31|1|Y|ET|1|999999999999999|999999999999999|999999999999999|N|ASG_CHANGE|||DUMMY-JOB-001|DUMMY-DEPARTMENT-001
METADATA|Assignment|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|PeriodOfServiceId|PersonId|PrimaryFlag|ActionCode|ReasonCode|WorkTermsAssignmentId|JobCode|DepartmentName
MERGE|Assignment|999999999999998|2022/01/01|4712/12/31|1|Y|E|1|999999999999999|999999999999999|999999999999999|Y|ASG_CHANGE||999999999999999|DUMMY-JOB-001|DUMMY-DEPARTMENT-001
Hire an Employee - Worker.dat
METADATA|Worker|SourceSystemOwner|SourceSystemId|PersonNumber|CategoryCode|EffectiveStartDate|EffectiveEndDate|StartDate|DateOfBirth|ActionCode|ReasonCode
MERGE|Worker|ABC_CONV|CONV_1001031|1001031|PER_EIT|2021/01/27|4712/12/31|2021/01/27|1984/07/15|HIRE|ABC_CONV
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|Sex|MaritalStatus
MERGE|PersonLegislativeData|ABC_CONV|CONV_PLD_1001031|2021/01/27|4712/12/31|CONV_1001031|US|M|M
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|KnownAs
MERGE|PersonName|ABC_CONV|CONV_NAMES_1001031|CONV_1001031|2021/01/27|4712/12/31|US|GLOBAL|John|R|Manager|
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|PrimaryFlag|WorkerType
MERGE|WorkRelationship|ABC_CONV|CONV_POS_1001031|CONV_1001031|Prospect CCMC, LLC|2021/01/27|2021/01/27|Y|E
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PrimaryWorkTermsFlag|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|PositionOverrideFlag|PositionCode|LocationCode|GradeCode|PeopleGroup|ProposedUserPersonType|ProjectedStartDate|ProjectedEndDate|ActionCode|ReasonCode
MERGE|WorkTerms|ABC_CONV|CONV_WRK_TERM_1001031|2021/01/27|4712/12/31|1|Y|ACTIVE_PROCESS|ET|CROZER|Y|CONV_POS_1001031|CONV_1001031|CCMC, LLC|Y|4200_7742_1916_80_1_02|HR_CKHS_001|||Employee|2021/01/27||HIRE|ABC_CONV
METADATA|Assignment|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PrimaryAssignmentFlag|PrimaryFlag|LegalEmployerName|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|NormalHours|Frequency|LocationCode|PeopleGroup|PositionOverrideFlag|PositionCode|FullPartTime|DateStart|ProposedUserPersonType|ProjectedStartDate|ActionCode|ReasonCode
MERGE|Assignment|ABC_CONV|CONV_ASG_1001031|2021/01/27|4712/12/31|1|Y|ACTIVE_PROCESS|E|CROZER|Y||Crozer, LLC|CONV_POS_1001031|CONV_1001031|CONV_WRK_TERM_1001031|FR|40|W|HR_CKHS_001||Y|4200_7742_1916_80_1_02|FULL_TIME|2021/01/27|Employee|2021/01/27|HIRE|ABC_CONV
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|DateFrom|DateTo|EmailType|EmailAddress|PersonId(SourceSystemId)
MERGE|PersonEmail|ABC_CONV|CONV_EMAIL_1001031|2021/01/27|4712/12/31|W1|JManager@oracle.com|CONV_1001031
METADATA|PersonAddress|PersonNumber|EffectiveStartDate|EffectiveEndDate|AddressType|AddressLine1|AddressLine2|TownOrCity|Region1|Region2|PostalCode|Country|PrimaryFlag
MERGE|PersonAddress|1001031|2021/01/27|4712/12/31|HOME|301 Somewhere Avenue||Doylestown||PA|18901|US|Y
METADATA|PersonNationalIdentifier|LegislationCode|NationalIdentifierNumber|NationalIdentifierType|PersonNumber|PrimaryFlag
MERGE|PersonNationalIdentifier|US|713-38-8434|SSN|1001031|Y
METADATA|PersonEthnicity|PersonNumber|Ethnicity|LegislationCode|PrimaryFlag
MERGE|PersonEthnicity|1001031|5|US|Y
METADATA|PersonPhone|PersonNumber|DateFrom|PhoneType|LegislationCode|AreaCode|PhoneNumber|PrimaryFlag
MERGE|PersonPhone|1001031|2021/01/27|H1|US|484|630-1254|Y
Oracle Cloud Talent Management HDL Templates
Performance Rating Section Template - TalentProfile.dat
METADATA|ProfileItem|FLEX:HRT_PROFILE_ITEMS|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingLevelId1|typeOfRating(HRT_PROFILE_ITEMS=PERSON_PERFORMANCE_RATING)|date1(HRT_PROFILE_ITEMS=PERSON_PERFORMANCE_RATING)|ItemClob1File|SourceSystemOwner|SourceSystemId
MERGE|ProfileItem|PERSON_PERFORMANCE_RATING|PERS_300000008487927|125|12501|2/20/2018|4|300000008607913|Common|2/25/2018|Mitesh.txt|TALEO_CA|TALEO2
License and Certification Template - ContentItem.dat
METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name
MERGE|ContentItem||LC063|Testing|1/1/1951|ABC_Licenses_Certifications|U|103|Supervision of Aerosols
Create Risk and Impact of Loss - TalentProfile.dat
METADATA|ProfileItem|ProfileItemId|ProfileCode|SectionId|ContentTypeId|DateFrom|DateTo|SourceSystemId|SourceSystemOwner|SourceType|SourceKey1|QualifierId1|RatingModelId1|RatingModelId1|RatingLevelId1|RatingLevelId2
MERGE|ProfileItem||PERS_300100037978548|1101|115|2021/10/12||PERS_300100037978548_ROL_01|HCMQA-001|HRTR|300100544783084|52|12||12003|
MERGE|ProfileItem||PERS_300100037978548|1101|115|2021/10/12||PERS_300100037978548_ROL_02|HCMQA-001|HRTR|300100544783084|52||13||13002
Add a Talent Profile - TalentProfile.dat
METADATA|TalentProfile|ProfileCode|ProfileTypeCode|ProfileStatusCode|ProfileUsageCode|Description|OwnerPersonNumber|PersonNumber|Summary|SourceSystemId|SourceSystemOwner
MERGE|TalentProfile|TEST_PROFILE|PERSON|A|P||1234|5678|||
Add an Items Catelog for a specific content section - ContentItem.dat
METADATA|ContentItem|ContentItemValueSetName|ContextName|ContentItemCode|Name|DateFrom|CountryCountryCode|CountryGeographyCode|DateTo|ContentItemValueSetId
MERGE|ContentItem|Degree|DEGREE|1|High School Diploma/GED|1901/01/01|||4712/12/31|106
Oracle Cloud Learning Cloud HDL Templates
Delete a learning assignment - LearningRecord.dat
METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignmentSourceType|AssignmentSourceId|AssignmentSourceInfo|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordSourceType|LearningRecordSourceId|LearningRecordSourceInfo|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM
DELETE|LearningRecord||2019/07/31|4712/12/31|OLC279397|OLC279396|ORA_COURSE|OLC164212 |ORA_JOIN_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||8153756|ORA_SPECIALIST|8153756|ORA_SELF |HDLWorker_190417_116|ORA_ASSN_REC_DELETED||||2019/07/31|||||||0|ORA_DUR_HOUR
Delete the learning course - LearningRecord.dat
METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignmentSourceType|AssignmentSourceId|AssignmentSourceInfo|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordSourceType|LearningRecordSourceId|LearningRecordSourceInfo|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM|LearningRecordReasonCode|
LearningRecordComments
DELETE|LearningRecord||2022/06/30|4712/12/31|CLRS_LRN38832|
CLRS_AN38832|ORA_CLASS|OFF7417|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||
223660|ORA_SPECIALIST|223660|ORA_SELF|812239|ORA_ASSN_REC_DELETED||||2022/06/15|
2022/06/15||2023/07/24||||5|ORA_DUR_HOUR|ORA_SPEC_DEL|test
Load Learning Record - LearningRecord.dat
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
Update the learning assignment - LearningRecord.dat
METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordReasonCode|LearningRecordComments|ActualScore|LearningRecordPurgeFlag
MERGE|LearningRecord||2023/06/07||LRN-060720211-HDL|ASN-060720211-HDL|ORA_COURSE|OLC199059|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_MANAGER|300100010473116|ORA_PERSON|300100010473116||300100010473118|ORA_ASSN_REC_ACTIVE|2023/06/07|2023/06/30|||||||Course Req Active Asgn||
Create a Classroom - ClassroomResource.dat
METADATA|ClassroomResource|ClassroomResourceNumber|Capacity|ContactNumber|Description|SourceId|SourceType|LocationCode|SetCode|OwnedByPersonNumber|Title|SourceSystemId|SourceSystemOwner
MERGE|ClassroomResource|MTHGF.001|||Classroom Resource|||6800|COMMON|9800|MTHGF.001|CLASS_RES_MTHGF_001|ITRENT
Add a course - CourseV3.dat
METADATA|Course|CourseNumber|Title|EffectiveStartDate|EffectiveEndDate|OwnedByPersonNumber|SourceInfo|SourceType|CurrencyCode|MinimumExpectedEffort|MaximumExpectedEffort|MinimumPrice|MaximumPrice|PublishStartDate|PublishEndDate|ShortDescription|CoverArtFileName|CoverArtFile|Syllabus|TrailerLiNumber|SourceSystemId|SourceSystemOwner|FLEX:WLF_LI_COURSE
MERGE|Course|COURSE_00003|Course_Test3|1951/01/01|4712/12/31|101517||||||||2015/01/01|||||||HDL_COURSE_00003|HDL|Global Data Elements
Add an Instructor - InstructorResource.dat
MATADATA|InstructorResource|InstructorResourceNumber|OwnedByPersonNumber|PersonNumber|SourceId|SourceType|SourceSystemId|SourceSystemOwner
MERGE|InstructorResource|IRN_8153762|153760|153762|||HDL_IR_IRN_8153762_153760_153762|HDL
Add a Legacy Learning Item to a learner in the History Transcript - LegacyLearningItem.dat
METADATA|LegacyLearningItem|LearningItemNumber|EffectiveStartDate|EffectiveEndDate|SourceInfo|SourceType|OwnedByPersonNumber|ShortDescription|Title|SourceSystemId|SourceSystemOwner
MERGE|LegacyLearningItem|SAFEAUDIT|2014/09/03|4712/12/31|||8||RESCUE PROCEDURES|SAFEAUDIT _2014/09/03_8_RESCUE PROCEDURES|HDL
Oracle Recruiting Cloud HDL Templates
Absence Management HDL Templates
Adjust Absence Balance Template - PersonAccrualDetail.dat
METADATA|PersonAccrualPlanEnrollment|PersonNumber|WorkTermAsgNum|PlanName|ManualEnrollment|RunAccruals|EnrtStDt|EnrtEndDt|SourceSystemId|SourceSystemOwner
MERGE|PersonAccrualPlanEnrollment|081008|ET081008|MA Sick Leave|Y||2017/01/01||PAPE_MA Sick Leave_ET081008|HDL
Add Person Maternity Absence Entry - PersonAbsenceEntry.dat
METADATA|PersonAbsenceEntry|Employer|PersonNumber|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|StartDate|EndDate|Duration|StartTime|EndTime|StartDatetime|StartDateDuration|EndDatetime|EndDateDuration|PlannedEndDate|SubmittedDate|NotificationDate|ConditionStartDate|ConfirmedDate|Comments|BlockedLeaveCandidate|SourceSystemId|SourceSystemOwner
MERGE|PersonAbsenceEntry|Vision Corporation|00110|Sick Leave|Personal Reason|SUBMITTED|APPROVED|2014/04/01|2018/01/01|2||||1||1|||||||NA|PAE_Vision Corporation_00110_Sick Leave_Personal Reason|HDL
Compensation Management HDL Templates
Update Salary Details - Salary.dat
METADATA|Salary|AssignmentNumber|DateFrom|DateTo|SalaryAmount|SalaryBasisName|ActionCode|ActionReasonCode|MultipleComponents|SalaryApproved
MERGE|Salary|E084425|2025/02/01|4712/12/31|32|ABC US Hourly|CHANGE_SALARY|CMP_DISS|N|Y
Update User Define Table (UDT) for Columns - UserDefinedTable.dat
METADATA|UserDefinedTableColumn|UserColumnCode|DataType|UserColumnName|UserTableCode|LegislativeDataGroupName
MERGE|UserDefinedTableColumn|EMP_017163_1|T|EMP_017163_1|ABC_ERP_F_063_COMP_EXCEPTION_DATA_UDT|USA LDG
Update User Define Table (UDT) for Rows - UserDefinedTable.dat
METADATA|UserDefinedTableColumnInstance|EffectiveEndDate|EffectiveStartDate|Value|LegislativeDataGroupName|UserColumnCode|RowLowRangeOrName|UserTableCode
MERGE|UserDefinedTableColumnInstance|12/31/4712|1/1/1951|17163|USA LDG|EMP_017163_1|EMPLOYEE NUMBER|ABC_ERP_F_063_COMP_EXCEPTION_DATA_UDT
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.