Activities Data Set Verb Descriptions: Submittals

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

submittals-item-add-attachment submittals-item-add-comment submittals-item-add-reference submittals-item-change-attribute	submittals-item-change-attribute-final-response submittals-item-change-attribute-review-response submittals-item-change-attribute-revision submittals-item-change-attribute-user	submittals-item-change-relation-package submittals-item-change-relation-spec submittals-item-commit-transition submittals-item-create	submittals-item-remove-attachment submittals-item-remove-reference submittals-step-change-attribute submittals-task-change-attribute

activity_verb	relevant_columns	related_tables
submittals-item-add-attachment	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_attachment_category ID of the attachment category object_created_by Autodesk ID of the user performing the activity action object_display_name The display name of the entity object_id id of the entity object_item_display_name The display name of the entity object_item_id The ID for the Submittal. object_object_type The object type of the entity [e.g.: attachment] object_revision Revision of the item object_urn URN of the attachment object_urn_type The type of the urn [e.g.: DM] target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-add-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_body Body of the comment object_display_name The display name of the entity object_id id of the entity object_item_assigned_to_field Indicator which field is ball in court object_item_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] object_item_custom_identifier The custom identifier of the item. object_item_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. object_item_description Description of the item object_item_display_name The display name of the entity object_item_id The ID for the Submittal. object_item_identifier Identifier of the item. Created automatically object_item_lead_time item's lead time object_item_object_type The object type of the entity [e.g.: item] object_item_priority The item priority object_item_required_approval_date item's required approval date object_item_required_date item's required date object_item_required_on_job_date Date and time for the item to be done on site object_item_response_comment Response comment of the item (in addition to response id) object_item_response_id ID of the response, if was added. object_item_revision Revision of the item object_item_state_id State of the item object_item_status_id Status ID object_item_submitter_due_date When the responsible contractor submission is due object_item_subsection Sub spec section object_item_title Title (name) of the item object_item_type_id ID for the item type object_object_type The object type of the entity [e.g.: comment] target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-add-reference	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_created_on The timestamp when the activity created object_display_name The display name of the entity object_entities_0_created_on The timestamp when the activity created object_entities_0_display_name The display name of the entity object_entities_0_domain The domain of the entity object_entities_0_id ID of the entity object_entities_0_type type of the entity [e.g.: asset, documentlineage, form, issue, package, sheetlineage, submittalitem] object_entities_1_created_on The timestamp when the activity created object_entities_1_display_name The display name of the entity object_entities_1_domain The domain of the entity object_entities_1_id id of the entity object_entities_1_type type of the entity [e.g.: activity, asset, documentlineage, form, issue, sheetlineage, submittalitem] object_entities_display_name The display name of the entity object_entities_id id of the entity object_id id of the entity target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-attribute	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_object_type The object type of the entity [e.g.: item] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-attribute-final-response	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-attribute-review-response	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_step_id ID of the parent step object_step_number The order of the step in the review workflow object_task_id ID of the task target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: reviewer] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-attribute-revision	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-attribute-user	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_attribute_object_type The object type of the entity [e.g.: entity] object_attribute_type The type of the attribute [e.g.: list] object_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_object_type The object type of the entity [e.g.: item] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-relation-package	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_attribute_object_type The object type of the entity [e.g.: package] object_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-change-relation-spec	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_attribute_object_type The object type of the entity [e.g.: spec] object_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-commit-transition	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_display_name The display name of the entity object_id id of the entity object_name_for_activity The name of the activity object_object_type The object type of the entity [e.g.: workflow_transition] object_state_from_display_name The display name of the entity object_state_from_id The old state of the item object_state_from_object_type The object type of the entity [e.g.: workflow_state] object_state_to_display_name The display name of the entity object_state_to_id The new state of the item object_state_to_object_type The object type of the entity [e.g.: workflow_state] target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-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_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) object_ball_in_court_type Indicator which field is ball in court [e.g.: manager] object_container_custom_identifier_sequence_type Project current sequence type [e.g.: 2] object_container_display_name The display name of the entity object_container_id ID of the container object_container_object_type The object type of the entity [e.g.: container] object_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. object_description Description of the item object_display_name The display name of the entity object_id id of the entity object_identifier identifier of the entity object_object_type The object type of the entity [e.g.: item] object_priority The priority of the item object_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 2] object_spec_container_display_name The display name of the entity object_spec_container_id Id of the container object_spec_container_object_type The object type of the entity [e.g.: container] object_spec_display_name The display name of the entity object_spec_id id of the spec object_spec_identifier Identifier of the spec object_spec_object_type The object type of the entity [e.g.: spec] object_state_id State of the item object_status_id Status ID object_steps Array of steps object_tasks Array of tasks object_title Title (name) of the item object_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 2] object_type_container_display_name The display name of the entity object_type_container_id Id of the container object_type_container_object_type The object type of the entity [e.g.: container] object_type_display_name The display name of the entity object_type_id ID for the type object_type_object_type The object type of the entity [e.g.: item-type] object_type_platform_id For default types object_type_value Value of the type object_type_identifier Identifier of the type object_watchers Watchers array
submittals-item-remove-attachment	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_attachment_category ID of the attachment category object_created_by Autodesk ID of the user performing the activity action object_display_name The display name of the entity object_id id of the entity object_item_display_name The display name of the entity object_item_id The ID for the Submittal. object_object_type The object type of the entity [e.g.: attachment] object_revision Revision of the item object_urn URN of the attachment object_urn_type The type of the urn [e.g.: DM] target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-item-remove-reference	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_display_name The display name of the entity object_entity_created_on The timestamp when the activity created object_entity_display_name The display name of the entity object_entity_domain The domain of the entity object_entity_id id of the entity object_entity_type type of the entity [e.g.: asset, documentlineage, form, issue, meetingitem, photo, submittalitem] object_id id of the entity target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-step-change-attribute	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value object_step_id ID of the parent step object_step_number The order of the step in the review workflow target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_package_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_package_container_display_name The display name of the entity target_package_container_id Id of the container target_package_container_object_type The object type of the entity [e.g.: container] target_package_display_name The display name of the entity target_package_id Id of the package target_package_identifier Identifier of the package target_package_is_deleted is the package deleted target_package_object_type The object type of the entity [e.g.: package] target_package_spec_display_name The display name of the entity target_package_spec_id Related spec id of the package target_package_spec_identifier Related spec identifier of the package target_package_spec_object_type The object type of the entity [e.g.: spec] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target
submittals-task-change-attribute	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_display_name The display name of the entity object_id id of the entity object_new_value The new value object_object_type The object type of the entity [e.g.: attribute_change] object_old_value The old value object_step_id ID of the parent step object_step_number The order of the step in the review workflow object_task_id ID of the task target_assigned_to_field Indicator which field is ball in court (Deprecated field, use ball in court fields instead) target_ball_in_court_type Indicator which field is ball in court [e.g.: manager, reviewer, subcontractor] target_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_container_display_name The display name of the entity target_container_id ID of the container target_container_object_type The object type of the entity [e.g.: container] target_custom_identifier The custom identifier of the item. target_custom_identifier_sort Same value as 'custom_identifier' but this column has db collation in order to enable sorting by the custom identifier value. target_description Description of the item target_display_name The display name of the entity target_id ID of the target target_identifier Identifier of the target target_lead_time item's lead time target_object_type The object type of the entity [e.g.: item] target_priority The priority of the item target_required_approval_date item's required approval date target_required_date item's required date target_required_on_job_date Date and time for the item to be done on site target_response_comment Response comment of the item (in addition to response id) target_response_id ID of the response, if was added. target_revision Revision of the item target_spec_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_spec_container_display_name The display name of the entity target_spec_container_id Id of the container target_spec_container_object_type The object type of the entity [e.g.: container] target_spec_display_name The display name of the entity target_spec_id Id of the spec target_spec_identifier Identifier of the spec target_spec_object_type The object type of the entity [e.g.: spec] target_state_id State of the item target_status_id Status ID target_submitter_due_date When the responsible contractor submission is due target_subsection Sub spec section target_title Title (name) of the item target_type_container_custom_identifier_sequence_type Project current sequence type [e.g.: 1, 2] target_type_container_display_name The display name of the entity target_type_container_id ID of the container target_type_container_object_type The object type of the entity [e.g.: container] target_type_display_name The display name of the entity target_type_id ID for the type target_type_object_type The object type of the entity [e.g.: item-type] target_type_platform_id For default types target_type_value Value of the type target_type_identifier Identifier of the target