1. HCM Data Loading Business Objects
  2. Example of Loading an Entire New Course Hierarchy with a Self-Paced Offering Using the CourseV3.dat File

Example of Loading an Entire New Course Hierarchy with a Self-Paced Offering Using the CourseV3.dat File

First you load only the CourseV3 and OfferingV3 objects using the CourseV3.dat file. After that process successfully completes, you load the corresponding sections and activities using the V3 objects and the CourseV3.dat file.

1. Load Only CourseV3 and Self-Paced OfferingV3 Objects

METADATA|CourseV3|CourseId|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|CoverArtFile|CoverArtFileName|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
MERGE|CourseV3||2021/04/28||COURSE-202104280937-HDL|Title:COURSE 202104280937-HDL|ShortDesc:COURSE 202104280937-HDL||2021/04/28|2023/03/01|0|1|USD|0|0||||4|FUSION_HCM_LEARNING|2021042809371|HCM Learning Source Info for 202104280937|||

METADATA|OfferingV3|OfferingId|EffectiveStartDate|EffectiveEndDate|OfferingNumber|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OfferingStartDate|OfferingEndDate|PrimaryInstructorId|FacilitatorType|PrimaryLocationId|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|CourseId|CourseNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingV3||2021/04/28||OFFERING-202104280937-HDL|Title:Offering 202104280937-HDL||ORA_SP|2021/04/28|2023/03/10||||||4|US|5|30||COURSE-202104280937-HDL||4|FUSION_HCM_LEARNING|2021042809372|HCM Learning Source Info for 202104280937|Y|||

2. Load V3 Section and Activities Object

COMMENT - Include the parent OfferingV3 row even you don't have any updates, otherwise the load process fails.
METADATA|OfferingV3|OfferingId|EffectiveStartDate|EffectiveEndDate|OfferingNumber|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OfferingStartDate|OfferingEndDate|PrimaryInstructorId|FacilitatorType|PrimaryLocationId|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|CourseId|CourseNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingV3||2021/04/28||OFFERING-202104280937-HDL|Title:Offering 202104280937-HDL||ORA_SP|2021/04/28|2023/03/10||||||4|US|5|30||COURSE-202104280937-HDL||4|FUSION_HCM_LEARNING|2021042809372|HCM Learning Source Info for 202104280937|Y|||

COMMENT - Edit the default section.
METADATA|OfferingActivitySectionV3|OfferingSectionId|EffectiveStartDate|EffectiveEndDate|OfferingSectionNumber|SectionPosition|OfferingId|OfferingNumber|Title|Description|DescriptionText|NumberOfActivitiesToComplete|CompletionRuleType|SequenceRuleSectionNumber|SequenceRuleType|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingActivitySectionV3||2021/04/28||OFFERING-202104280937-HDL_SEC|1||OFFERING-202104280937-HDL||||-1|ORA_COMPLETION_SECTION||ORA_SECTION_ANYTIME|||

COMMENT - Add a self-paced activity to the default section.
METADATA|SelfPacedActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|ActivityPosition|Title|Description|ExpectedEffort|SelfCompleteFlag|CompletionRuleType|SequenceRuleActivityNumber|SequenceRuleType|ContentId|ContentNumber|OfferingSectionId|OfferingSectionNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
MERGE|SelfPacedActivityV3||2021/04/28||SP-ACT1-03282122-HDL|1|Title:SP ACT1 202103282122-HDL||8|Y|||ORA_ACTIVITY_ANYTIME||||OFFERING-202104280937-HDL_SEC||||||

COMMENT - Add a second self-paced activity to the default section.
MERGE|OfferingActivitySectionV3||2021/04/28||OFF-SEC-04012122-HDL|2||OFFERING-202104280937-HDL|Title:OFF-SEC-04012122-HDL||||ORA_COMPLETION_ACTIVITY||ORA_SECTION_PREVIOUS|||
MERGE|SelfPacedActivityV3||2021/04/28||SP-ACT2-03282122-HDL|1|Title:SP ACT2 202103282122-HDL||8|N|||ORA_ACTIVITY_ANYTIME||||OFF-SEC-04012122-HDL||||||

COMMENT - Add an evaluation activity to the offering.
METADATA|EvaluationActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|Title|OfferingId|OfferingNumber|QuestionnaireCode|QstnrRequiredForCompletion|SourceSystemOwner|SourceSystemId|GUID