Data Source Description: Activity

1 Summary
2 Usage
3 Data Fields

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

Field Name	English Name	Description	Notes
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