Activity tables

In Microsoft Dataverse, activities are tasks that you or your teams perform when they contact customers, for example, sending letters or making telephone calls. You can create activities for yourselves, can assign them to someone else, or can share them with other users or teams. An activity is any action which can be entered on a calendar and has time dimensions (start time, stop time, due date, and duration) that help determine when the action occurred or is to occur. Activities has some basic properties that help determine what action the activity represents, for example, subject and description. An activity state can be opened, canceled, or completed. The completed status of an activity will have several sub status values associated with it to clarify the way that the activity was completed.

Activities involve one or more participants, called activity parties in Dataverse. For a meeting activity, the participants are those contacts or users attending the meeting. For a telephone call or fax activity, the parties are the caller and the person who is called. The following diagram shows the entity relationships for activities.

To support the communication needs of the modern-day business, such as instant messaging (IM) and SMS, you can create custom activities in Dataverse.

Note

Activities security is inherited through the Activity (ActivityPointer) table. Each activity record is represented by a single row in the ActivityPointer table, which helps manage permissions and security roles for all activities uniformly. Learn more about Activities data model and storage

See also

Activities data model and storage
Custom activities
E-mail activity table
Activity tables for tasks, faxes, phone calls, and letters
Activity Party table
Activity Pointer (Activity) table