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 |
|---|---|---|---|---|
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 |
|
|
|