1. HCM Data Loading Business Objects
  2. Example of Loading Baseline, Adjusted, and Actual Workload Plans for Workforce Scheduling

Example of Loading Baseline, Adjusted, and Actual Workload Plans for Workforce Scheduling

Here's how you can import baseline, adjusted, and actual workload requirements using the WorkloadPlan object.

METADATA|WorkloadPlan|WorkloadPlanCode|DepartmentId(SourceSystemId)|DepartmentName|LocationId(SourceSystemId)|LocationCode|LocationSetCode|JobProfileType|JobId(SourceSystemId)|JobCode|JobSetCode|JobFamilyId(SourceSystemId)|JobFamilyCode|PositionId(SourceSystemId)|PositionCode|BusinessUnitName|ShiftTypeCode|ShiftTypeExtendedCode|OtherQualificationType|OtherQualifications|StartDate|EndDate|StartTime|EndTime|EndAfterMidNight|WorkloadType|WorkloadUom|WorkloadValue
MERGE|WorkloadPlan|WLC110||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:00|19:00|N|Baseline|Workers|10
MERGE|WorkloadPlan|WLC111||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|19:00|03:00|Y|Baseline|Workers|11
MERGE|WorkloadPlan|WLC112||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|03:00|07:00|N|Baseline|Workers|12
MERGE|WorkloadPlan|WLC113||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:00|19:00|N|Adjusted|Workers|13
MERGE|WorkloadPlan|WLC114||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|19:00|03:00|Y|Adjusted|Workers|14
MERGE|WorkloadPlan|WLC115||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|03:00|07:00|N|Adjusted|Workers|15
MERGE|WorkloadPlan|WLC116||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:00|07:15|N|Actual|Workers|16
MERGE|WorkloadPlan|WLC117||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:15|07:30|N|Actual|Workers|17
MERGE|WorkloadPlan|WLC118||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:30|07:45|N|Actual|Workers|18
MERGE|WorkloadPlan|WLC119||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|07:45|08:00|N|Actual|Workers|19
MERGE|WorkloadPlan|WLC120||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|08:00|08:15|N|Actual|Workers|20
MERGE|WorkloadPlan|WLC121||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|08:15|08:30|N|Actual|Workers|21
MERGE|WorkloadPlan|WLC122||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|08:30|08:45|N|Actual|Workers|22
MERGE|WorkloadPlan|WLC123||HCM US||||Job||HCM-HCJob101|HCM-HCJob_Set ||||||||||2023/01/01|2023/06/30|08:45|09:00|N|Actual|Workers|23