BEH_UPDATE_LEARNING_PLAN_DATES

Owned by Mike Feimster
Last updated: Apr 19, 2023 by Scott Reed
1 min read

This is a standard Behavior Stored Procedure that is packaged with the LearningBuilder Source Code.
https://bitbucket.org/heuristic-solutions/learningbuilder/src/master/src/db/procedures/BEH_UPDATE_LEARNING_PLAN_DATES.sql

BEH_UPDATE_LEARNING_PLAN_DATES should only be called from a Complete Learning Plan Workflow. It can be used to update 1 of 4 dates on the Learning Plan Instance from any attribute that the behavior can reference.

  • Cycle Start Date

  • Cycle End Date

  • Reporting Start Date

  • Reporting End Date

The procedure should throw an error if the date updates puts the Learning Plan Instance into an invalid state. Reporting End Date must come after the Reporting Start Date and the Cycle End Date must come after the Cycle Start Date.

Example

The example below will update the Reporting End Date from the Role End Date Attribute and the Cycle End Date with the Role End Date Attribute