1. HCM Data Loading Business Objects
  2. Example of Updating an Activity Title and Completion Rule Using the CourseV3.dat File

Example of Updating an Activity Title and Completion Rule Using the CourseV3.dat File

Here's how you can update an activity title and change the completion rule from required to optional.

COMMENT - Include the parent OfferingV3 row for the OfferingActivitySectionV3 object even if 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 - Include the parent OfferingActivitySectionV3 row for the SelfPacedActivityV3 object even if you don't have any updates, otherwise the load process fails.
METADATA|OfferingActivitySectionV3|OfferingSectionId|EffectiveStartDate|EffectiveEndDate|OfferingSectionNumber|SectionPosition|OfferingId|OfferingNumber|Title|Description|DescriptionText|NumberOfActivitiesToComplete|CompletionRuleType|SequenceRuleSectionNumber|SequenceRuleType|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingActivitySectionV3||2021/04/28||OFF-SEC-04012122-HDL|2||OFFERING-202104280937-HDL|Title:OFF-SEC-04012122-HDL Updated||||ORA_COMPLETION_ACTIVITY|OFFERING-202104280937-HDL_SEC|ORA_SECTION_AFTER_COMPL|||

COMMENT - Update the activity title and completion rule.
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-ACT2-03282122-HDL|1|Title:SP ACT2 202103282122-HDL Updated||8|N|ORA_REQUIRED||ORA_ACTIVITY_ANYTIME||||OFF-SEC-04012122-HDL||||||