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