Activities Data Set Verb Descriptions: Issues

The Activities data set is more complex than the average ACC Data Schema data set due to the variable nature of payloads associated with the various "Activity Verbs" which define the particular activity taken in the system. For the Activities schema, there are several tables defined (one for each service) and for each of these table definitions, there are common columns and then many unique columns based on the particular service. The common columns included for all tables are:

• activity_id: Activity ID for this event
• bim360_account_id: BIM 360 HQ Account ID
• bim360_project_id: BIM 360 HQ Project ID
• activity_verb: Activity performed by the user
• created_by: Autodesk ID of the user performing the activity action
• created_at: The timestamp when the activity created

After these standard columns there are many service specific columns for the table definition. Columns may or many not contain data depending on the Activity Verb in question. The following summary details the particular columns applicable for an Activity Verb. Also, for certain Activity Verbs there are Related Tables (in a SQL relational sense) that can be associated with the verb. These tables use the activity_id as the foreign key for lookups and when there is an applicable foreign table, they are noted in the details below.

This description information is also made available programatically in the format of JSON files (one for each Activities table) in the "schemas" directory as part of every extract archive. The naming convention for this file is:

• activities_<service_group>_verb_column_details.json
  

The description file is an array of JSON objects with two primary fields:

• columns: Relevant columns for the verb
• related_tables: any tables with additional information on the verb in question

The following is an example JSON snippet from the Docs description file.

 {
   "activate-approval-workflow" : {
      "columns" : [
         "activity_id",
         "bim360_account_id",
         "bim360_project_id",
         "created_by",
         "created_at",
         "activity_verb",
         "object_display_name",
         "object_id",
         "object_object_type"
      ]
   },
   "add-attribute-to-namingstandard" : {
      "columns" : [
         "activity_id",
         "bim360_account_id",
         "bim360_project_id",
         "created_by",
         "created_at",
         "activity_verb",
         "object_display_name",
         "object_id",
         "object_object_type"
      ],
      "related_tables" : [
         "docs_naming_standards"
      ]
   },
   ...

Activity Verbs

Now that we have reviewed the data description for Activities data, the following is a detailed summary of 32 Activity Verbs for the Issues Schema along with their relevant columns and any related tables.

issue-answered issue-assign issue-attach issue-attachment-add issue-attachment-remove issue-closed issue-comment issue-completed	issue-create issue-deleted issue-detach issue-draft issue-due-date issue-edit issue-in-dispute issue-in-progress	issue-in-review issue-link-added issue-link-removed issue-not-approved issue-open issue-pending issue-placement-add issue-placement-remove	issue-placement-reposition issue-ready-to-inspect issue-respond issue-restored issue-snapshot-edit issue-view issue-void issue-work-completed

activity_verb	relevant_columns	related_tables
issue-answered	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-assign	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-attach	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_attachment_attachment_type Attachement type for the issue [e.g.: document, photo] object_attachment_display_name Attachment Display name for the issue object_attachment_id Attachement id for the issue object_attachment_name Attachment name for the issue object_attachment_urn Attachement urn type for the issue object_attachment_urn_type Attachement urn for the issue [e.g.: dm, oss] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-attachment-add	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_attachment_display_name Attachment Display name for the issue object_attachment_id Attachement id for the issue object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-attachment-remove	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_attachment_display_name Attachment Display name for the issue object_attachment_id Attachement id for the issue object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-closed	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-comment	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_comment_id Comment ID for the issue object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-completed	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-create	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-deleted	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-detach	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_attachment_attachment_type Attachement type for the issue [e.g.: document, photo] object_attachment_display_name Attachment Display name for the issue object_attachment_id Attachement id for the issue object_attachment_name Attachment name for the issue object_attachment_urn Attachement urn type for the issue object_attachment_urn_type Attachement urn for the issue [e.g.: dm, oss] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-draft	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-due-date	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-edit	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-in-dispute	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-in-progress	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-in-review	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-link-added	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-link-removed	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-not-approved	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-open	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-pending	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-placement-add	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-placement-remove	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-placement-reposition	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-ready-to-inspect	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-respond	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-restored	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-snapshot-edit	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-view	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue
issue-void	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes
issue-work-completed	activity_id Activity ID for this event bim360_account_id BIM 360 HQ Account ID. bim360_project_id BIM 360 HQ Project ID. created_by Autodesk ID of the user performing the activity action created_at The timestamp when the activity created activity_verb Activity performed by the user object_answer Answer of the issue object_assigned_to Assigned to user for the issue object_assigned_to_type Assigned to type for the issue [e.g.: company, role, user] object_created_at Created at timestamp for the issue object_display_name Display name for the issue object_id ID of the issue object_status Status of the issue object_title Title for the issue object_updated_at Updated timestamp for the issue	issues_changes