Activities Data Set Verb Descriptions: Assets

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 11 Activity Verbs for the Assets Schema along with their relevant columns and any related tables.

asset-create asset-delete asset-update	system-create system-delete system-membership-asset-parent-system-add	system-membership-asset-parent-system-remove system-membership-system-child-entities-modify system-membership-system-parent-system-add	system-membership-system-parent-system-remove system-update

activity_verb	relevant_columns	related_tables
asset-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_created_entity_category_id Object Created Entity Category Id object_created_entity_client_asset_id Object Created Entity Client Asset Id object_created_entity_created_at Object Created Entity Created At object_created_entity_created_by Object Created Entity Created By object_created_entity_id Object Created Entity Id object_created_entity_is_active Object Created Entity Is Active object_created_entity_status_id Object Created Entity Status Id object_created_entity_updated_at Object Created Entity Updated At object_created_entity_updated_by Object Created Entity Updated By object_created_entity_version Object Created Entity Version object_display_name Object Display Name object_id Object Id object_location_display_name Object Location Display Name object_location_entity_type Object Location Entity Type [e.g.: location_summary] object_location_id Object Location Id object_location_is_active Object Location Is Active object_location_is_missing Object Location Is Missing object_location_is_valid Object Location Is Valid object_location_path Object Location Path
asset-delete	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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_deleted_entity_category_id Object Deleted Entity Category Id object_deleted_entity_client_asset_id Object Deleted Entity Client Asset Id object_deleted_entity_created_at Object Deleted Entity Created At object_deleted_entity_created_by Object Deleted Entity Created By object_deleted_entity_deleted_at Object Deleted Entity Deleted At object_deleted_entity_deleted_by Object Deleted Entity Deleted By object_deleted_entity_id Object Deleted Entity Id object_deleted_entity_is_active Object Deleted Entity Is Active object_deleted_entity_location_id Object Deleted Entity Location Id object_deleted_entity_status_id Object Deleted Entity Status Id object_deleted_entity_updated_at Object Deleted Entity Updated At object_deleted_entity_updated_by Object Deleted Entity Updated By object_deleted_entity_version Object Deleted Entity Version object_display_name Object Display Name object_id Object Id object_location_display_name Object Location Display Name object_location_entity_type Object Location Entity Type [e.g.: location_summary] object_location_id Object Location Id object_location_is_active Object Location Is Active object_location_is_missing Object Location Is Missing object_location_is_valid Object Location Is Valid object_location_path Object Location Path
asset-update	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_activity_source Object Activity Source object_after_asset_status_color Object After Asset Status Color object_after_asset_status_display_name Object After Asset Status Display Name object_after_asset_status_entity_type Object After Asset Status Entity Type [e.g.: asset_status_summary] object_after_asset_status_id Object After Asset Status ID object_after_asset_status_is_active Object After Status Is Active object_after_asset_status_is_missing Object After Asset Status is Missing object_after_asset_status_is_valid Object After Asset Status is Valid object_after_location_display_name Object After Location Display Name object_after_location_entity_type Object After Location Entity Type [e.g.: location_summary] object_after_location_id Object After Location ID object_after_location_is_active Object After Location Is Active object_after_location_is_missing Object After Location Is Missing object_after_location_is_valid Object After Location Is Valid object_after_location_path Object After Location Path object_before_asset_status_color Object before asset status color object_before_asset_status_display_name Object before asset status display name object_before_asset_status_entity_type Object before asset status entity type [e.g.: asset_status_summary] object_before_asset_status_id Object before asset status id object_before_asset_status_is_active Object before asset status is active object_before_asset_status_is_missing Object before asset status is missing object_before_asset_status_is_valid Object before asset status is valid object_before_category_display_name Object before category display name object_before_category_entity_type Object before category entity type [e.g.: category_summary] object_before_category_id Object before category id object_before_category_is_active Object before category is active object_before_category_is_missing Object before category is missing object_before_category_is_valid Object before category is valid object_before_category_path Object before category path object_before_entity_category_id Object Before Entity Category Id object_before_entity_client_asset_id Object Before Entity Client Asset Id object_before_entity_created_at Object Before Entity Created At object_before_entity_created_by Object Before Entity Created By object_before_entity_custom_attributes Object Before Entity Custom Attributes object_before_entity_id Object Before Entity Id object_before_entity_is_active Object Before Entity Is Active object_before_entity_location_id Object Before Entity Location Id object_before_entity_status_id Object Before Entity Status Id object_before_entity_updated_at Object Before Entity Updated At object_before_entity_updated_by Object Before Entity Updated By object_before_entity_version Object Before Entity Version object_before_location_display_name Object Before Location Display Name object_before_location_entity_type Object Before Location Entity Type [e.g.: location_summary] object_before_location_id Object Before Location Id object_before_location_is_active Object Before Location Is Active object_before_location_is_missing Object Before Location Is Missing object_before_location_is_valid Object Before Location Is Valid object_before_location_path Object Before Location Path object_display_name Object Display Name object_id Object Id object_patch_entity_custom_attributes Object Patch Entity Custom Attributes object_patch_entity_updated_at Object Patch Entity Updated At object_patch_entity_updated_by Object Patch Entity Updated By
system-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_created_entity_category_id Object Created Entity Category Id object_created_entity_created_at Object Created Entity Created At object_created_entity_created_by Object Created Entity Created By object_created_entity_id Object Created Entity Id object_created_entity_is_active Object Created Entity Is Active object_created_entity_status_id Object Created Entity Status Id object_created_entity_updated_at Object Created Entity Updated At object_created_entity_updated_by Object Created Entity Updated By object_created_entity_version Object Created Entity Version object_display_name Object Display Name object_id Object Id
system-delete	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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_deleted_entity_category_id Object Deleted Entity Category Id object_deleted_entity_created_at Object Deleted Entity Created At object_deleted_entity_created_by Object Deleted Entity Created By object_deleted_entity_deleted_at Object Deleted Entity Deleted At object_deleted_entity_deleted_by Object Deleted Entity Deleted By object_deleted_entity_id Object Deleted Entity Id object_deleted_entity_is_active Object Deleted Entity Is Active object_deleted_entity_status_id Object Deleted Entity Status Id object_deleted_entity_updated_at Object Deleted Entity Updated At object_deleted_entity_updated_by Object Deleted Entity Updated By object_deleted_entity_version Object Deleted Entity Version object_display_name Object Display Name object_id Object Id
system-membership-asset-parent-system-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_display_name Object Display Name object_id Object Id
system-membership-asset-parent-system-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_display_name Object Display Name object_id Object Id
system-membership-system-child-entities-modify	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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_display_name Object Display Name object_id Object Id
system-membership-system-parent-system-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_display_name Object Display Name object_id Object Id
system-membership-system-parent-system-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_activity_source Object Activity Source object_asset_status_color Object asset status color object_asset_status_display_name Object asset status display name object_asset_status_entity_type Object asset status entity type [e.g.: asset_status_summary] object_asset_status_id Object asset status ID object_asset_status_is_active Object asset status is active object_asset_status_is_missing Object asset status is missing object_asset_status_is_valid Object asset status is valid object_category_display_name Object Category Display Name object_category_entity_type Object Category Entity Type [e.g.: category_v3_summary] object_category_id Object Category Id object_category_is_active Object Category Is Active object_category_is_missing Object Category Is Missing object_category_is_valid Object Category Is Valid object_category_path Object Category Path object_display_name Object Display Name object_id Object Id
system-update	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_activity_source Object Activity Source object_after_asset_status_color Object After Asset Status Color object_after_asset_status_display_name Object After Asset Status Display Name object_after_asset_status_entity_type Object After Asset Status Entity Type [e.g.: asset_status_summary] object_after_asset_status_id Object After Asset Status ID object_after_asset_status_is_active Object After Status Is Active object_after_asset_status_is_missing Object After Asset Status is Missing object_after_asset_status_is_valid Object After Asset Status is Valid object_after_category_display_name Object After Category Display Name object_after_category_entity_type Object After Category Entity Type [e.g.: category_v3_summary] object_after_category_id Object After Category ID object_after_category_is_active Object After Category Is Active object_after_category_is_missing Object After Category Is Missing object_after_category_is_valid Object After Category Is Valid object_after_category_path Object After Category Path object_before_asset_status_color Object before asset status color object_before_asset_status_display_name Object before asset status display name object_before_asset_status_entity_type Object before asset status entity type [e.g.: asset_status_summary] object_before_asset_status_id Object before asset status id object_before_asset_status_is_active Object before asset status is active object_before_asset_status_is_missing Object before asset status is missing object_before_asset_status_is_valid Object before asset status is valid object_before_category_display_name Object before category display name object_before_category_entity_type Object before category entity type [e.g.: category_v3_summary] object_before_category_id Object before category id object_before_category_is_active Object before category is active object_before_category_is_missing Object before category is missing object_before_category_is_valid Object before category is valid object_before_category_path Object before category path object_before_entity_category_id Object Before Entity Category Id object_before_entity_created_at Object Before Entity Created At object_before_entity_created_by Object Before Entity Created By object_before_entity_id Object Before Entity Id object_before_entity_is_active Object Before Entity Is Active object_before_entity_status_id Object Before Entity Status Id object_before_entity_updated_at Object Before Entity Updated At object_before_entity_updated_by Object Before Entity Updated By object_before_entity_version Object Before Entity Version object_display_name Object Display Name object_id Object Id object_patch_entity_updated_at Object Patch Entity Updated At object_patch_entity_updated_by Object Patch Entity Updated By