Data Source Description: Application (Learning Plan) Definition

Summary

View Type

Reporting

English Name

Application Definition

Description

List of all learning plan definitions.

Content

This view provides a list of all Application / Learning Plan Definitions in the LearningBuilder instance. It contains configuration and content information, including workflow status, whether it is legacy or version two display, starting requirements, availability and reporting requirements, and information about the status of a user role upon start and completion

Usage

Suggested uses for this view include:

  • Reporting on the change of available learning plans over time

  • Viewing the applications that can be automatically started and the requirements for that functionality

  • Reviewing all applications that could be tracked in the system based on application type

Data Fields

Field Name

English Name

Description

Notes

Available in LearningBuilder Version

Field Name

English Name

Description

Notes

Available in LearningBuilder Version

WorklfowInstanceId

Workflow Instance ID

Foreign Key to Workflow Instance

 

 

LearningPlanId (ITEM_ID)

Learning Plan ID

Foreign Key to Learning Plan Definition

 

 

CreatedOn

Created On

 

Pulled from ITEM table entry

 

IsDeleted

Is Deleted

 

Pulled from ITEM table entry

New Request

Status

Status

Status of LP Defintion

Pulled from ITEM table WF_STATUS_ID (New (1001), Published (1002), Archived (1003?))

New Request

VersionTwoPlanView (USE_VERSION_TWO_LEARNING_PLAN_VIEW)

Version Two Plan View

 

 

 

TenantID

Tenant ID

 

 

 

LearningPlanTitle

Learning Plan Title

 

 

 

MinimumUnits

Minimum Units

 

 

 

WorkflowInstanceModifiedOn

Workflow Modified On

 

 

 

WorkflowId

Workflow ID

Foreign Key to Workflow

 

 

Description

Learning Plan Description

 

 

 

RoleToStartId

Role Needed to Start ID

ID of role needed to start an LPI of this definition

 

 

RoleToStart

Role Needed to Start

 

 

 

StatusToStart

Status Needed to Start

 

 

 

SortOrder

Sort Order

 

 

 

MemberStatusUponCompletionId

Member Status Upon Completion ID

 

 

 

MemberStatusUponCompletion

Member Status Upon Completion

 

 

 

MemberStatusUponExpirationId

Member Status Upon Expiration ID

 

 

 

MemberStatusUponExpiration

Member Status Upon Expiration

Title from Custom List Item

 

 

CycleId

Cycle Interval ID

Foreign Key to Interval

 

 

AvailabilityId

Availability Interval ID

Foreign Key to Interval

 

 

ReportingId

Reporting Interval ID

Foreign Key to Interval

 

 

AppelateLearningPlanId

Appellate Learning Plan ID

Foreign Key to Learning Plan Def

 

 

AppelateLearningPlan

Appellate Learning Plan

Title from Item

 

 

LearningPlanTypeId

Learning Plan Type ID

 

 

 

LearningPlanType

Learning Plan Type

 

 

 

AutoUpdateStatusUponCompletion

Auto Update Status Upon Completion

 

 

 

AutoUpdateStatusUponExpiration

Auto Update Status Upon Expiration

 

 

 

CycleSeedAttributeID (CYCLE_SEED_ITEM_ID)

Cycle Seed Attribute ID

 

 

 

CycleSeedAttribute

Cycle Seed Attribute

From ITEM_ATTRIBUTE

 

 

AllowUpdateAnyStatus

Allow Update In Any Status

 

 

 

BeginAutomatically

Begin Automatically

 

 

 

DatesDontApply

Dates Don't Apply

 

 

 

SeedDateStrategy

Seed Date Strategy

 

 

 

BulkTriggerButtonText

Bulk Trigger Button Text

 

 

 

BulkPopupTitle

Bulk Popup Title

 

 

 

BulkShowClearSelectedActivities

Bulk Show Clear Selected Activities

 

 

 

BulkAssignmentCustomDatabaseObjectId

Bulk Assignment Custom Database Object ID

 

 

 

BulkAssignmentCustomDatabaseObject

Bulk Assignment Custom Database Object

 

 

 

BulkAssignToLearningPlanId

Bulk Assign To Learning Plan ID

 

 

 

BulkAssignToLearningPlan

Bulk Assign To Learning Plan

 

 

 

BulkAssignmentInstructions

Bulk Assignment Instructions

 

 

 

PractitionerAccessWhenId

Practitioner Access When Comparison Rule ID

 

 

 

LockedMessage

Locked Message

 

 

 

HideReportingDatesFromPractitioner

Hide Reporting Dates From Practitioner

 

 

 

ShowBeginButtonForGrantableRole

Show Begin Button For Grantable Role

 

 

 

StartOnStepId

Start On Step ID

Foreign Key to Workflow Step table

 

 

StartOnStep

Start On Step

From WorkflowStep table

 

 

OnStartExecuteActionId

On Start Execute Action ID

Foreign Key to Workflow Step Action table

 

 

OnStartExecuteAction

On Start Execute Action

From Workflow Step Action table

 

 

CompentencyModelId

Competency Model ID

 

 

 

CompetencyModel

Competency Model

 

 

 

ShowBeginButtonForRequiredRoleAndStatus

Show Begin Button For Required Role and Status

 

 

 

PostCreateHookObjectId

Post Create Hook Database Object ID

 

 

 

PostCreateHookObject

Post Create Hook Database Object

 

 

 

CanStartNewInstanceWhen

Can Start New Instance When

 

 

 

ShowWorkflowFooter

Show Workflow Footer