Data Source Description: Activity
- Mallory Bucell
- Christopher Butcher
- Steve Ross
Summary
View Type | Reporting |
|---|---|
English Name | Activity |
Description | List of all Activities with Provider Member Role and Workflow data. |
Content | This view provides a list of all Activity Definition information, including description, provider and contact person information, and the status of the activity within its creation or acceptance workflow. An Activity Definition may be a Course Description, a Task Description, a specific Exam (such as the SAT or LSAT), or other task that must be completed by the user. (This is general description of the task tracked by the provider or your organization, not the individual user’s completion of it.) For more information on Activity Definitions, see Activities. |
Usage
Suggested uses for this view include:
Tracking the number and status of all activities from a given Provider over time
Creating a Contact Information report to easily find information for the contact person and provider of each activity that is part of your process
Reviewing your accepted and in-review activities for similarities
Grouping and viewing all activities of a given type.
Data Fields
Field Name | English Name | Description | Notes | Available in LearningBuilder Version |
|---|---|---|---|---|
ActivityItemId | Activity Item ID |
|
|
|
Core information about the Activity | ||||
ActivityTitle | Activity Title |
|
|
|
ActivityDescription | Activity Description |
|
|
|
Units | Units |
|
|
|
StartDate | Start Date |
|
|
|
EndDate | End Date |
|
|
|
ContactLength | Contact Length |
|
|
|
SubmissionDate | Submission Date |
|
|
|
ActivityId | Activity ID |
|
|
|
ActivityTypeId | Activity Type ID |
|
|
|
ActivityType | Activity Type |
|
|
|
IsLookup | Is Lookup |
|
|
|
Information about the Provider | ||||
ProviderId | Provider ID |
|
|
|
ProviderName | Provider Name |
|
|
|
ProviderDescription | Provider Description |
|
|
|
ProviderWebSite | Provider Web Site |
|
|
|
ProviderMemberRoleId | Provider Member Role ID | Owner Member Role ID |
|
|
ProviderUniqueId | Provider Unique ID |
|
|
|
ProviderBeginDate | Provider Begin Date |
|
|
|
ProviderEndDate | Provider End Date |
|
|
|
ContactId | Contact ID |
|
|
|
ContactFirstName | Contact First Name |
|
|
|
ContactLastName | Contact Last Name |
|
|
|
ContactmemberName | Contact Member Name |
|
|
|
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. |
|
Information about the Create Activity workflow | ||||
WorkflowInstanceId | Workflow Instance 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 |
|
|
|
StepExecuteOrder | Step Execute Order |
|
|
|
WorkflowCompletionStatusId | Workflow Completion Status ID | 0, 1, 2 |
|
|
WorkflowCompletionStatus | Workflow Completion Status | Incomplete, Completed Successfully, Completed Unsuccessfully |
|
|
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 |
|
WorkflowId | Workflow ID | Foreign Key to Workflow |
|
|
CurrentStepIsMarkedOwnerComplete | Step Owner Complete |
|
|
|
WorkflowModifiedOn | Workflow Modified On |
|
|
|