Data Source Description: Learning Plan Activity Instance

Summary

View Type

Reporting

English Name

Activity Instances with Applications

Description

List of all activity instances on learning plan instances based on the ACTIVITY_INSTANCE and LEARNING_PLAN_INSTANCE tables.

Content

This view provides a list of all instances of all activities in the LearningBuilder instance. It contains information about the activity instance, such as units, completion date, and status, its parent activity, the user who is completing the activity, and provider and provider contact for the activity.

Usage

Suggested uses for this view include:

  • Track the status of all in progress instances of a specific activity

  • Review historical completion rates and dates for all instances of a set of activities to view user patterns

  • Review all open or completed activity instances for a specific user

Data Fields

Field Name

English Name

Description

Notes

Available in LearningBuilder Version

Field Name

English Name

Description

Notes

Available in LearningBuilder Version

ActivityInstanceId

Activity Instance ID

 

 

 

Activity Instance details

WorkflowId

Workflow ID

Foreign Key to Workflow from AI

 

 

CompletionDate

Completion Date

 

 

 

RequestedUnits

Requested Units

 

 

 

GrantedUnits

Granted Units

 

 

 

IsProviderVerified

Is Provider Verified

 

 

 

AssignedByUserId

Assigned By User ID

The Member ID of the person who assigned this Activity Instance to this person.

 

 

Activity Details

ActivityItemId

Activity Item ID

 

 

 

ActivityTitle

Activity Title

 

 

 

ActivityId

Activity ID

 

 

 

ActivityType

Activity Type

 

 

 

ActivityTypeId

Activity Type ID

 

 

 

ProviderId

Provider ID

 

 

 

ProviderName

Provider Name

 

MEMBER_NAME of Owning Member

 

ContactEmail

Contact Email

 

 

 

ContactPhoneNumber

Contact Phone Number

The phone number the activity contact has flagged as IsPrimary in LearningBuilder.

The LearningBuilder Core code displays the activity contact’s Work phone in the site UI. If the contact has more than one Work phone, it chooses one at random.

In this view, we are displaying the phone number the activity contact has flagged as IsPrimary. This allows the activity contact to change the contact phone by simply flagging a different number as IsPrimary. It also provides performance benefits over cases where an activity contact may have had multiple business phone numbers.

 

Learning Plan Details

LearningPlanId

Learning Plan ID

From LPI

 

 

LearningPlanTitle

Learning Plan Title

From LPI

 

 

LearningPlanGroupId

Learning Plan Group ID

Task Group ID within the LPI that contains the Activity

 

 

LearningPlanGroupTitle

Learning Plan Group Title

Task Group Name within the LPI that contains the Activity

 

 

Member Details

MemberId

Member ID

 

 

 

FirstName

First Name

 

 

 

LastName

Last Name

 

 

 

MemberName

Member Name

 

 

 

Email

Email

 

 

 

Member Role Details

MemberRoleId

Member Role ID

From LPI

 

 

RoleBeginDate

Role Begin Date

From Person Role of LPI

 

 

RoleEndDate

Role End Date

From Person Role of LPI

 

 

UniqueId

Unique ID

From LPI

 

 

RoleId

Role ID

ID of Role associated with LPI’s member role ID

 

 

RoleName

Role

Name of Role associated with LPI’s member role ID

 

 

Learning Plan Instance Details

CycleStartDate

Cycle Start Date

From LPI

 

 

CycleEndDate

Cycle End Date

From LPI

 

 

ReportingBeginDate

Reporting Begin Date

From LPI

 

 

ReportingEndDate

Reporting End Date

From LPI

 

 

Activity Instance Workflow Forensics

 

WorkflowInstanceId

Workflow Instance ID

Foreign Key to Workflow Instance

 

 

StepToBeCompletedById

Step To Be Completed By User ID

 

 

 

StepToBeCompletedBy

Step To Be Completed By

Role Name of Role in TO_BE_COMPLETED_BY_ID or “Owner” if To_BE_COMPLETED_BY is 1

 

 

CurrentStep

Current Step

 

 

 

CurrentStepId

Current Step ID

 

 

 

WorkflowCompletionStatusId

Workflow Completion Status ID

0, 1, or 2

 

 

WorkflowCompletionStatus

Workflow Completion Status

Incomplete, Completed Successfully, or Completed Unsuccessfully

 

 

StepExecuteOrder

Step Execute Order

The order of the current step in the Activity Instance Complete Workflow

 

 

CurrentStepIsMarkedOwnerComplete

Step Owner Complete

Whether the current step of the Activity Instance Complete Workflow is considered Owner / Practitioner complete.

 

 

WorkflowModifiedOn

Workflow Modified On

When the Activity Instance was last acted upon.

 

 

WorkflowStatus

Workflow or Step Status

Status of Current Workflow Step

If the workflow instance is incomplete, shows the current workflow step status.

If it is completed successfully, it show’s the workflow definition’s final successful status.

If it is completed unsuccessfully, it show’s the workflow definition’s final unsuccessful status.

New Field:

Phase 1: Change to match the Intrinsic Definition and showed the Completion Status text when Workflow Completion Status was 1 or 2.

Phase 2: Add support for multiple Completion Status sub-status for Completed Successfully and Completed Unsuccessfully.

 

See also: https://heuristicsolutions.atlassian.net/wiki/spaces/I7IPM/pages/1215856996

 

Learning Plan Instance Details used for forensic investigations into what happened to the Learning Plan or Activity Instance

LearningPlanInstanceId

Learning Plan Instance ID

From LPI

 

 

LearningPlanInstanceWorkflowInstanceId

Learning Plan Instance Workflow Instance ID

From LPI

 

 

LearningPlanInstanceWorkflowInstanceModifiedOn

Learning Plan Instance Workflow Modified On

From LPI

 

 

LearningPlanInstanceWorkflowStatus

Learning Plan Instance Workflow or Step Status

From LPI

 

 

LearningPlanInstanceWorkflowCompletionStatus

Learning Plan Instance Workflow Completion Status

From LPI

 

 

LearningPlanInstanceWorkflowCompletionStatusId

Learning Plan Instance Workflow Completion Status ID

From LPI

 

 

LearningPlanGroupInstanceId

Learning Plan Group Instance ID

From LPI

 

 

LearningPlanTaskItemInstanceId

Learning Plan Task Item Instance ID

From LPI