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
METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|ProcdDate|Value|AdjustmentReason|SourceSystemId|SourceSystemOwnerMERGE|PersonAccrualDetail|081008|ET081008|MA Sick Leave|INIT|2017/01/01|6.578513||PAB_LEV_BAL_INITIAL_ET081008_MA Sick Leave|HDL
File Name - 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
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
In this blog you will learn how to update the learning assignment as a manager using the Learning Record object and HCM Data Loader.
My Client Groups > Profiles > Profile Rating Models > create or check your profile rating model that you are going to use. Profile Types > Person > go to “Profile Talent Ratings” > click on Performance Rating > select Rating Model = Performance Rating Model (see screenshot)
File Name: Worker.dat METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth|CountryOfBirth|WaiveDataProtectFlag|CategoryCode MERGE|Worker|Vision|Test_123456789|01-08-2022||0140870390|NEW HIRE_EMP|01-08-2022|06-05-1992|LK|N|PER_EIT
Dat File Name: Job.dat METADATA|Job|JobCode|ActiveStatus|FullPartTime|EffectiveStartDate|Name|SetCode|JobFamilyName|SourceSystemOwner|SourceSystemId MERGE|Job|ABC-JB-010-2D|A||1951/01/01|Systems Administrator|ABCSUS|Security Systems Service, Maintenance & Repair|ABC_SS_US|ABC-JB-010-2D
Dat File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|ABC_Licenses_Certifications|U|103|Supervision of Aerosols
ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||LC063||1951/01/01|CERTIFICATION|U|103|Supervision of Aerosols
Dat File Name: METADATA|Goal|GoalId|GoalName|Description|StartDate|TargetCompletionDate|AssignmentId|OrganizationId|PersonId|WorkerPersonNumber|StatusCode|GoalSourceCode|AllowKeyAttrUpdateFlag|AssignedByPersonId|PublishedFlag MERGE|Goal|300000000000000|Strengthen and model a Culture of Accountability, Agility and Business Acuity and the Rewards and Consequences required to support it||2018/01/01|2018/12/31|400000000000000||100000000000000|20000000|NOT_STARTED|HR|N|500000000000000|
Dat File Name: TalentProfile.dat METADATA|ProfileItem|ProfileCode|ContentTypeId|SectionId|DateFrom|RatingModelId1|RatingLevelId1|SourceSystemOwner|SourceSystemId
Dat File Name: METADATA|AreasOfResponsibility|AsgResponsibilityId|ResponsibilityName|ResponsibilityType|StartDate|EndDate|Status|PersonId|PersonNumber|AssignmentId|AssignmentNumber|LocationCode|LocationSetCode
Dat File Name: Worker.dat METADATA|WorkRelationship|LegalEmployerName|PersonNumber|ActualTerminationDate|ActionCode|ReasonCode|TerminateWorkRelationshipFlag|PeriodOfServiceId
METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|SourceSystemOwner|SourceSystemId|ClassificationCode MERGE|Organization|1951/01/01||ABC-AT-SS|ABC_SS_AT|ORG_AT_DPT_001|DEPARTMENT
Dat File Name: PersonAccrualDetail.dat METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|AccrualType|Value|ProcdDate|AdjustmentReason|SourceSystemId|SourceSystemOwner MERGE|PersonAccrualDetail|1000|ET1000|Annual Leave Plan|INIT|10|2022/12/31||ABR_1000|HRC_SQLLOADER
METADATA|DocumentsOfRecord|DocumentType|DocumentTypeId|PersonNumber|FLEX:PER_DOCUMENTS_OF_RECORD_DFF|dateOfAmendedDutiesNote(PER_DOCUMENTS_OF_RECORD_DFF=GB_MEDICAL___AMENDED_DUTIES_NOTE)|SourceSystemOwner|SourceSystemId MERGE|DocumentsOfRecord|Medical - Amended Duties Note|300000000000000|1000|US_MEDICAL_AMENDED_DUTIES_NOTE|2021/12/31|HDL|Medical1
Once a user has been terminated, however, the user accounts are still active then follow the steps below to inactivate their user account using HDL. Step 1 – Get a list of all terminated employees Step 2 – Prepare the .dat file METADATA|User|PersonNumber|Suspended
METADATA|Job|Name|JobId|JobCode|ActiveStatus|ApprovalAuthority|EffectiveStartDate|SourceSystemOwner|SourceSystemId|GUID MERGE|Job|HR Specialist|0101010|ABC-KB-0799-51B|A|0|1951/01/01|ABC_SSES_US|12121212|
Dat File Name - Worker.dat METADATA|WorkTerms|AssignmentId|PeriodOfServiceId|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|ActionCode