ACC Data Schema Changes

This document details changes made to the ACC Data Schema. The changes are listed chronologically in descending order so changes that are listed first are the most recent. The following describes the columns included for each schema change and the meanings of tag values for the changes:

October, 2024

The following changes were made to the ACC Data Schema during the month of October, 2024

costchange_orderssource_typeADDEDColumn added to the change_orders table in the schema.1729864636
costmain_contractsschedule_changeADDEDColumn added to the main_contracts table in the schema.1729018055
costmain_contractsrevised_completion_dateADDEDColumn added to the main_contracts table in the schema.1729018055
costchange_ordersproposed_revised_completion_dateADDEDColumn added to the change_orders table in the schema.1729018055

September, 2024

The following changes were made to the ACC Data Schema during the month of September, 2024

rfisrfi_transitionsADDEDrfi_transitions table added to the schema.1727363823
formsnative_form_section_item_attachmentsADDEDnative_form_section_item_attachments table added to the schema.1725993657
formsform_field_attachmentsADDEDform_field_attachments table added to the schema.1725993657
packagespackage_associationspackage_idADDEDColumn added to the package_associations table in the schema.1725457146
rfisacc_attachmentsADDEDacc_attachments table added to the schema.1725457146
costcost_paymentslast_sync_timeADDEDColumn added to the cost_payments table in the schema.1725457146
costcost_paymentsmessageADDEDColumn added to the cost_payments table in the schema.1725457146
costcost_paymentsexternal_systemADDEDColumn added to the cost_payments table in the schema.1725457146
costcost_paymentsexternal_idADDEDColumn added to the cost_payments table in the schema.1725457146
costcost_paymentsintegration_state_changed_atADDEDColumn added to the cost_payments table in the schema.1725457146
costcost_paymentsintegration_stateADDEDColumn added to the cost_payments table in the schema.1725457146
costbudget_paymentslast_sync_timeADDEDColumn added to the budget_payments table in the schema.1725457146
costbudget_paymentsmessageADDEDColumn added to the budget_payments table in the schema.1725457146
costbudget_paymentsexternal_systemADDEDColumn added to the budget_payments table in the schema.1725457146
costbudget_paymentsexternal_idADDEDColumn added to the budget_payments table in the schema.1725457146
costbudget_paymentsintegration_state_changed_atADDEDColumn added to the budget_payments table in the schema.1725457146
costbudget_paymentsintegration_stateADDEDColumn added to the budget_payments table in the schema.1725457146

August, 2024

The following changes were made to the ACC Data Schema during the month of August, 2024

activitiesassets_activitiesobject_after_category_idMODIFIEDData type fix for documentation1722357095
costsub_distribution_itemsADDEDsub_distribution_items table added to the schema.1722357095
costdistribution_itemsADDEDdistribution_items table added to the schema.1722357095
costdistribution_item_curvesADDEDdistribution_item_curves table added to the schema.1722357095
costmain_contract_itemsADDEDmain_contract_items table added to the schema.1722357095
costexpenseslast_sync_timeADDEDColumn added to the expenses table in the schema.1722357095
costexpensesmessageADDEDColumn added to the expenses table in the schema.1722357095
costexpensesexternal_systemADDEDColumn added to the expenses table in the schema.1722357095
costexpensesexternal_idADDEDColumn added to the expenses table in the schema.1722357095
costexpensesintegration_state_changed_atADDEDColumn added to the expenses table in the schema.1722357095
costexpensesintegration_state_changed_byADDEDColumn added to the expenses table in the schema.1722357095
costexpensesintegration_stateADDEDColumn added to the expenses table in the schema.1722357095
costcontractslast_sync_timeADDEDColumn added to the contracts table in the schema.1722357095
costcontractsmessageADDEDColumn added to the contracts table in the schema.1722357095
costcontractsexternal_systemADDEDColumn added to the contracts table in the schema.1722357095
costcontractsexternal_idADDEDColumn added to the contracts table in the schema.1722357095
costcontractsintegration_state_changed_atADDEDColumn added to the contracts table in the schema.1722357095
costcontractsintegration_state_changed_byADDEDColumn added to the contracts table in the schema.1722357095
costcontractsintegration_stateADDEDColumn added to the contracts table in the schema.1722357095
costchange_orderslast_sync_timeADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersmessageADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersexternal_systemADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersexternal_idADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersintegration_state_changed_atADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersintegration_state_changed_byADDEDColumn added to the change_orders table in the schema.1722357095
costchange_ordersintegration_stateADDEDColumn added to the change_orders table in the schema.1722357095
costbudgetslast_sync_timeADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsmessageADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsexternal_systemADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsexternal_idADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsintegration_state_changed_atADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsintegration_state_changed_byADDEDColumn added to the budgets table in the schema.1722357095
costbudgetsintegration_stateADDEDColumn added to the budgets table in the schema.1722357095

July, 2024

The following changes were made to the ACC Data Schema during the month of July, 2024

assetssystemsADDEDsystems table added to the schema.1721766926
assetssystem_membershipsADDEDsystem_memberships table added to the schema.1721766926
assetscategory_status_set_assignmentscategory_typeADDEDColumn added to the category_status_set_assignments table in the schema.1721766926
assetscategoriescategory_typeADDEDColumn added to the categories table in the schema.1721766926
assetscategoriesuidADDEDColumn added to the categories table in the schema.1721766926
transmittalstransmittal_recipientsdownloaded_atADDEDColumn added to the transmittal_recipients table in the schema.1721766926
transmittalstransmittal_recipientsviewed_atADDEDColumn added to the transmittal_recipients table in the schema.1721766926
costpermissionsADDEDpermissions table added to the schema.1721766926
formsformsnameADDEDColumn added to the forms table in the schema.1719585181
submittalsaccattachmentsurnADDEDColumn added to the attachments table in the schema.1719427442

June, 2024

The following changes were made to the ACC Data Schema during the month of June, 2024

costchange_ordersschedule_changeADDEDColumn added to the change_orders table in the schema.1718126192
reviewsreviewstotal_stepsADDEDColumn added to the reviews table in the schema.1718126192
reviewsreviewscurrent_stepADDEDColumn added to the reviews table in the schema.1718126192

May, 2024

The following changes were made to the ACC Data Schema during the month of May, 2024

costcontractsexchange_rateADDEDColumn added to the contracts table in the schema.1715086269
costcontractscurrencyADDEDColumn added to the contracts table in the schema.1715086269
issuesroot_causesis_activeMODIFIEDColumn changed to always returns TRUE, regardless of the real value. Will be deprecated in the future.1714668701
issuesroot_cause_categoriesis_activeMODIFIEDColumn changed to always returns TRUE, regardless of the real value. Will be deprecated in the future.1714668701

April, 2024

The following changes were made to the ACC Data Schema during the month of April, 2024

checklistschecklist_sections_signaturesADDEDchecklist_sections_signatures table added to the schema.1713209433
rfisrfisrfi_typeADDEDColumn added to the rfis table in the schema.1712926111
reviewsreview_stepsstep_display_nameADDEDColumn added to the review_steps table in the schema.1712243795

March, 2024

The following changes were made to the ACC Data Schema during the month of March, 2024

formsformsstatusMODIFIED"submitted" status is now reported as "closed", "draft" is now reported as "in_progress"1711394933
transmittalsworkflow_transmittalscreate_user_company_nameADDEDColumn added to the workflow_transmittals table in the schema.1710765628
transmittalsworkflow_transmittalscreate_user_company_idADDEDColumn added to the workflow_transmittals table in the schema.1710765628
transmittalstransmittal_recipientscompany_nameADDEDColumn added to the transmittal_recipients table in the schema.1710765628
markupsplacementplacement_textMODIFIEDSemantic Update: Text content for the given markup-placement. THIS WILL OVERRIDE TEXT IN MARKUP.MARKUP_TEXT. If there is text present in this column, it is the current text of the given placement. If this field is blank, check the markup_text column by merging with the markup table to get text (if there is any for this placement). NOTE: if the markup is a feature bound markup (feature_bound_type is present), the text here is inaccurate and should be ignored.1710430398
markupsmarkupmarkup_textMODIFIEDSemantic Update: Text content for the given markup. This is the initial text that the markup was created with, THIS MAY BE OVERRIDDEN BY TEXT ON THE PLACEMENT OF THIS MARKUP. Merge with the placement table and check placement_text to identify the text of a given placement of this markup. if placement_text is blank, then markup_text holds the current text content. NOTE: if the markup is a feature bound markup (feature_bound_type is present), the text here is inaccurate and should be ignored.1710430398
rfisrfi_custom_attributesADDEDrfi_custom_attributes table added to the schema.1710430398
rfisproject_custom_attributes_enumsADDEDproject_custom_attributes_enums table added to the schema.1710430398
rfisproject_custom_attributesADDEDproject_custom_attributes table added to the schema.1710430398
rfisrfi_typesADDEDrfi_types table added to the schema.1710430398
activitiessubmittals_target_watchersADDEDsubmittals_target_watchers table added to the schema.1710430398
activitiessubmittals_target_transition_attachmentsADDEDsubmittals_target_transition_attachments table added to the schema.1710430398
activitiessubmittals_target_tasksADDEDsubmittals_target_tasks table added to the schema.1710430398
activitiessubmittals_target_stepsADDEDsubmittals_target_steps table added to the schema.1710430398
activitiessubmittals_target_ball_in_court_usersADDEDsubmittals_target_ball_in_court_users table added to the schema.1710430398
activitiessubmittals_target_ball_in_court_rolesADDEDsubmittals_target_ball_in_court_roles table added to the schema.1710430398
activitiessubmittals_target_ball_in_court_companiesADDEDsubmittals_target_ball_in_court_companies table added to the schema.1710430398
activitiessubmittals_object_ball_in_court_usersADDEDsubmittals_object_ball_in_court_users table added to the schema.1710430398
activitiessubmittals_object_ball_in_court_rolesADDEDsubmittals_object_ball_in_court_roles table added to the schema.1710430398
activitiessubmittals_object_ball_in_court_companiesADDEDsubmittals_object_ball_in_court_companies table added to the schema.1710430398
activitiessubmittals_activitiesADDEDsubmittals_activities table added to the schema.1710430398

February, 2024

The following changes were made to the ACC Data Schema during the month of February, 2024

formslayout_sectionsdisplay_indexADDEDColumn added to the layout_sections table in the schema.1707252074
formslayout_section_itemsdisplay_indexADDEDColumn added to the layout_section_items table in the schema.1707252074
reviewsworkflow_notesround_numADDEDColumn added to the workflow_notes table in the schema.1707252074
reviewsreviewscurrent_round_numADDEDColumn added to the reviews table in the schema.1707252074
reviewsreview_documentsround_numADDEDColumn added to the review_documents table in the schema.1707252074
reviewsreview_commentsround_numADDEDColumn added to the review_comments table in the schema.1707252074
clashesADDEDNew service group added to the ACC Data Schema.1706631943
packagesADDEDNew service group added to the ACC Data Schema.1706631943

December, 2023

The following changes were made to the ACC Data Schema during the month of December, 2023

activitiesdocs_activitiesobject_version_set_issuance_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiesdocs_activitiesobject_old_issuance_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiesdocs_activitiesobject_new_issuance_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiesdocs_activitiesobject_issuance_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiescost_activitiesobject_billing_period_start_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiescost_activitiesobject_billing_period_end_dateMODIFIEDCorrected documentation from [timestamp: SQL] to [date: string]1702494972
activitiessheets_activitiestarget_issuance_dateMODIFIEDtimestamp formatting corrected1702494972
activitiessheets_activitiesobject_version_set_issuance_dateMODIFIEDtimestamp formatting corrected1702494972
activitiessheets_activitiesobject_issuance_dateMODIFIEDtimestamp formatting corrected1702494972
activitiesissues_activitiesobject_updated_atMODIFIEDtimestamp formatting corrected1702494972
activitiesissues_activitiesobject_created_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_patch_entity_updated_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_deleted_entity_updated_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_deleted_entity_deleted_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_deleted_entity_created_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_created_entity_updated_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_created_entity_created_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_before_entity_updated_atMODIFIEDtimestamp formatting corrected1702494972
activitiesassets_activitiesobject_before_entity_created_atMODIFIEDtimestamp formatting corrected1702494972
issuesissuesdeleted_byADDEDColumn added to the issues table in the schema.1701795966
submittalsacctasksupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacctasksstarted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacctasksresponded_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacctaskscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacctaskscompleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccstepsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccstepsstarted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccstepscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccstepscompleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccspecsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccspecscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccpackagesupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccpackagescreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemtypeupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemtypecreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemssent_to_submitterMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemssent_to_reviewMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemsresponded_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemsreceived_from_submitterMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemsreceived_from_reviewMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemspublished_dateMODIFIEDtimestamp formatting corrected1701717685
submittalsaccitemscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacccustom_identifier_settingsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacccommentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsacccommentscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccattachmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsaccattachmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsspecsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsspecsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsspecscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalspackagesupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalspackagesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalspackagescreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsitemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsitemssent_to_submitterMODIFIEDtimestamp formatting corrected1701717685
submittalsitemssent_to_reviewerMODIFIEDtimestamp formatting corrected1701717685
submittalsitemsresponded_atMODIFIEDtimestamp formatting corrected1701717685
submittalsitemsreceived_from_submitterMODIFIEDtimestamp formatting corrected1701717685
submittalsitemsreceived_from_reviewerMODIFIEDtimestamp formatting corrected1701717685
submittalsitemspublished_dateMODIFIEDtimestamp formatting corrected1701717685
submittalsitemscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalscommentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalscommentsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalscommentscreated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsattachmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
submittalsattachmentsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
submittalsattachmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
sheetssheetsupdated_atMODIFIEDtimestamp formatting corrected1701717685
sheetssheetsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
sheetssheetscreated_atMODIFIEDtimestamp formatting corrected1701717685
sheetssetsupdated_atMODIFIEDtimestamp formatting corrected1701717685
sheetssetsissuance_dateMODIFIEDtimestamp formatting corrected1701717685
sheetssetscreated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleschedulesupdated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleschedulescreated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleresourcesupdated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleresourcescreated_atMODIFIEDtimestamp formatting corrected1701717685
scheduledependenciesupdated_atMODIFIEDtimestamp formatting corrected1701717685
scheduledependenciescreated_atMODIFIEDtimestamp formatting corrected1701717685
schedulecommentscreated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleactivity_codesupdated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleactivity_codescreated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleactivitiesupdated_atMODIFIEDtimestamp formatting corrected1701717685
scheduleactivitiescreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutestopicsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutestopicsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutestopicscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesparticipantsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesparticipantsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesparticipantscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesnon_member_participantsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesnon_member_participantsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesnon_member_participantscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesmeetingsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesmeetingsstarts_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesmeetingsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesmeetingscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesitemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesitemsdue_dateMODIFIEDtimestamp formatting corrected1701717685
meetingminutesitemsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesitemscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesattachmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesattachmentsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesattachmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesassigneesupdated_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesassigneesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
meetingminutesassigneescreated_atMODIFIEDtimestamp formatting corrected1701717685
locationstreesupdated_atMODIFIEDtimestamp formatting corrected1701717685
locationstreescreated_atMODIFIEDtimestamp formatting corrected1701717685
locationsnodesupdated_atMODIFIEDtimestamp formatting corrected1701717685
locationsnodescreated_atMODIFIEDtimestamp formatting corrected1701717685
costpayment_referencesupdated_atMODIFIEDtimestamp formatting corrected1701717685
costpayment_referencespaid_atMODIFIEDtimestamp formatting corrected1701717685
costpayment_referencescreated_atMODIFIEDtimestamp formatting corrected1701717685
costmain_contractsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costmain_contractscreated_atMODIFIEDtimestamp formatting corrected1701717685
costexpensesupdated_atMODIFIEDtimestamp formatting corrected1701717685
costexpensesreceived_atMODIFIEDtimestamp formatting corrected1701717685
costexpensespaid_atMODIFIEDtimestamp formatting corrected1701717685
costexpensesissued_atMODIFIEDtimestamp formatting corrected1701717685
costexpensescreated_atMODIFIEDtimestamp formatting corrected1701717685
costexpensesapproved_atMODIFIEDtimestamp formatting corrected1701717685
costexpense_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costexpense_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_paymentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_paymentssubmitted_atMODIFIEDtimestamp formatting corrected1701717685
costcost_paymentspaid_atMODIFIEDtimestamp formatting corrected1701717685
costcost_paymentscreated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_paymentsapproved_atMODIFIEDtimestamp formatting corrected1701717685
costcost_payment_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_payment_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costcost_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsstatus_changed_atMODIFIEDtimestamp formatting corrected1701717685
costcontractssent_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsreturned_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsresponded_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsprocured_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsonsite_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsoffsite_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsexecuted_atMODIFIEDtimestamp formatting corrected1701717685
costcontractscreated_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsawarded_atMODIFIEDtimestamp formatting corrected1701717685
costcontractsapproved_atMODIFIEDtimestamp formatting corrected1701717685
costchange_ordersupdated_atMODIFIEDtimestamp formatting corrected1701717685
costchange_orderscreated_atMODIFIEDtimestamp formatting corrected1701717685
costchange_ordersapplied_atMODIFIEDtimestamp formatting corrected1701717685
costbudgetsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costbudgetscreated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_paymentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_paymentssubmitted_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_paymentspaid_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_paymentscreated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_paymentsapproved_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_payment_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_payment_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_code_segmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_code_segmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_code_segment_codesupdated_atMODIFIEDtimestamp formatting corrected1701717685
costbudget_code_segment_codescreated_atMODIFIEDtimestamp formatting corrected1701717685
costapproval_workflowscurrent_due_dateMODIFIEDtimestamp formatting corrected1701717685
costapproval_workflowsupdated_atMODIFIEDtimestamp formatting corrected1701717685
costapproval_workflowscreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplates_versionsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplates_versionsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplates_versionscreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplatesupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplatesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplatescreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_signatures_allupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_signatures_allcreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_signaturesupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_signaturescreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_sections_allupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_sections_allcreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_sectionsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_sectionscreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_items_allupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_items_allcreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_item_instructionsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checkliststemplate_item_instructionscreated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistsstarted_onMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistsscheduled_dateMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistscreated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistscompleted_onMODIFIEDtimestamp formatting corrected1701717685
checklistschecklistsarchived_onMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_sectionsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_sectionscreated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_section_assigneesupdated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_section_assigneesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_section_assigneescreated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_itemsupdated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_itemscreated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_assigneesupdated_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_assigneesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
checklistschecklist_assigneescreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsstatus_setsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsstatus_setsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetsstatus_setscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsmodel_sync_containersupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsmodel_sync_containersdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetsmodel_sync_containerscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attributesupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attributesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attributescreated_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attribute_selection_valuesupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attribute_selection_valuesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetscustom_attribute_selection_valuescreated_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_status_set_assignmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_status_set_assignmentsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_status_set_assignmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_custom_attribute_assignmentsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_custom_attribute_assignmentsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetscategory_custom_attribute_assignmentscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_statusesupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_statusesdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_statusescreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_permissionsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_permissionsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_permissionscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_model_sync_recordsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_model_sync_recordsdeleted_atMODIFIEDtimestamp formatting corrected1701717685
assetsasset_model_sync_recordscreated_atMODIFIEDtimestamp formatting corrected1701717685
assetscategoriescreated_atMODIFIEDtimestamp formatting corrected1701717685
assetsassetsupdated_atMODIFIEDtimestamp formatting corrected1701717685
assetsassetscreated_atMODIFIEDtimestamp formatting corrected1701717685
issueschangesetsDELETED1701092668

November, 2023

The following changes were made to the ACC Data Schema during the month of November, 2023

formsnative_formslayout_uidADDEDColumn added to the native_forms table in the schema.1699452795
formslayoutsADDEDlayouts table added to the schema.1699452795
formslayout_table_columnsADDEDlayout_table_columns table added to the schema.1699452795
formslayout_sectionsADDEDlayout_sections table added to the schema.1699452795
formslayout_section_itemsADDEDlayout_section_items table added to the schema.1699452795

October, 2023

The following changes were made to the ACC Data Schema during the month of October, 2023

formsform_sectionsADDEDform_sections table added to the schema.1698700370
submittalsacccustom_identifier_settingsADDEDcustom_identifier_settings table added to the schema. Added support for custom identifiers1696529432
submittalsaccitemscustom_identifier_human_readableADDEDColumn added to the items table in the schema. Added support for custom identifiers1696529432
submittalsaccitemscustom_identifier_sortADDEDColumn added to the items table in the schema. Added support for custom identifiers1696529432
submittalsaccitemscustom_identifierADDEDColumn added to the items table in the schema. Added support for custom identifiers1696529432
activitiesassets_activitiesobject_before_category_pathADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_is_validADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_is_missingADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_is_activeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_idADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_entity_typeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_category_display_nameADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_is_validADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_is_missingADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_is_activeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_idADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_entity_typeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_display_nameADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_before_asset_status_colorADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_is_validADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_is_missingADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_is_activeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_idADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_entity_typeADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_display_nameADDEDColumn added to the assets_activities table in the schema.1696529432
activitiesassets_activitiesobject_asset_status_colorADDEDColumn added to the assets_activities table in the schema.1696529432

September, 2023

The following changes were made to the ACC Data Schema during the month of September, 2023

rfisrfislocation_idADDEDColumn added to the rfis table in the schema.1695408731
rfisrfisopened_atADDEDColumn added to the rfis table in the schema.1695408731
reviewsreviewsnext_action_claimed_byADDEDColumn added to the reviews table in the schema.1695408731
reviewsreviewsnext_action_candidates_companiesADDEDColumn added to the reviews table in the schema.1695408731
reviewsreviewsnext_action_candidates_rolesADDEDColumn added to the reviews table in the schema.1695408731
reviewsreviewsnext_action_candidates_usersADDEDColumn added to the reviews table in the schema.1695408731

August, 2023

The following changes were made to the ACC Data Schema during the month of August, 2023

issuescustom_attributesattribute_valueMODIFIEDQuotations may be added if the attribute value contains a comma (,)1695408731
reviewsreviewsnext_action_claimed_byADDEDColumn added to the reviews table in the schema. List of strings1695408731
reviewsreviewsnext_action_candidates_companiesADDEDColumn added to the reviews table in the schema. List of strings1695408731
reviewsreviewsnext_action_candidates_rolesADDEDColumn added to the reviews table in the schema. List of strings1695408731
reviewsreviewsnext_action_candidates_usersADDEDColumn added to the reviews table in the schema. List of strings1695408731

July, 2023

The following changes were made to the ACC Data Schema during the month of July, 2023

costcost_paymentsmaterials_retentionADDEDColumn added to the cost_payments table in the schema.1695408731
costcost_paymentsmaterials_billedADDEDColumn added to the cost_payments table in the schema.1695408731
issuesissuesgps_coordinatesADDEDColumn added to the issues table in the schema.1695408731
submittalsacctasksassigned_to_typeADDEDColumn added to the tasks table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new column1695408731
submittalsaccitemsball_in_court_companiesADDEDColumn added to the items table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new list field, list of companies1695408731
submittalsaccitemsball_in_court_rolesADDEDColumn added to the items table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new list field, list of roles1695408731
submittalsaccitemsball_in_court_usersADDEDColumn added to the items table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new list field, list of users1695408731
submittalsaccitemsball_in_courtDEPRECATEDOn July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a deprecated field, will be replaced by ball_in_court_users1695408731
submittalsaccitemssubcontractor_typeADDEDColumn added to the items table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new enum field1695408731
submittalsaccitemsmanager_typeADDEDColumn added to the items table in the schema. On July 14, 2023, the submittalsacc schema has been updated to support multiple reviewers. This is a new enum field1695408731
costmain_contract_propertiesADDEDmain_contract_properties table added to the schema.1695408731
costmain_contractsADDEDmain_contracts table added to the schema.1695408731

June, 2023

The following changes were made to the ACC Data Schema during the month of June, 2023

formsformsassignee_typeADDEDColumn added to the forms table in the schema.1695408731
formsformsassignee_type_idADDEDColumn added to the forms table in the schema.1695408731
formsformslast_submitted_atADDEDColumn added to the forms table in the schema.1695408731
formsformscreated_atADDEDColumn added to the forms table in the schema.1695408731
formsformsdue_dateADDEDColumn added to the forms table in the schema.1695408731
markupsplacementplacement_textADDEDColumn added to the placement table in the schema.1695408731
markupslayerbase_entity_uidADDEDColumn added to the layer table in the schema.1695408731
markupslayerbase_entity_urnADDEDColumn added to the layer table in the schema.1695408731
markupslayersurface_typeADDEDColumn added to the layer table in the schema.1695408731
markupsmarkupmarkup_textADDEDColumn added to the markup table in the schema.1695408731
checkliststemplate_signatures_allADDEDtemplate_signatures_all table added to the schema. This table will return ALL data versions instead of latest versions of the table items. This is only available for project level extracts.1695408731
checkliststemplate_items_allADDEDtemplate_items_all table added to the schema. This table will return ALL data versions instead of latest versions of the table items. This is only available for project level extracts.1695408731
checkliststemplate_sections_allADDEDtemplate_sections_all table added to the schema. This table will return ALL data versions instead of latest versions of the table items. This is only available for project level extracts.1695408731
rfisMODIFIEDOn June 18, 2023, the RFIs schema has been updated to support multiple reviewers for an RFI1695408731
adminprojectsclassificationADDEDColumn added to the projects table in the schema.1695408731
costbudgetscompoundedADDEDColumn added to the budgets table in the schema.1695408731

May, 2023

The following changes were made to the ACC Data Schema during the month of May, 2023

issuesissuesstatusMODIFIED4 additional statuses have been added: pending, in_progress, completed, in_review1695408731
progresstrackingDELETEDOn May 12, 2023, the Progress Tracking Beta has ending and the Progress Tracking dataset is no longer be available for download from Data Connector. Progress tracking functionality is available now in the Assets tool. Learn more about why we merged Progress Tracking functionality into Assets here. More details of this change can be seen on the Autodesk Build Help Site.1695408731

April, 2023

The following changes were made to the ACC Data Schema during the month of April, 2023

costapproval_workflowscurrent_due_dateADDEDColumn added to the approval_workflows table in the schema.1695408731
adminprojectstotal_company_sizeADDEDColumn added to the projects table in the schema.1695408731
adminprojectstotal_member_sizeADDEDColumn added to the projects table in the schema.1695408731
submittalsattachmentsupload_urnADDEDColumn added to the attachments table in the schema.1695408731
costMODIFIEDA recent update was made to the data extractions to be more consistent with the UI behavior. The result of this change is that nulls/empty string will be returned in cost values instead of zeros. In general, null / empty / should all be treated in the same manner1695408731

March, 2023

The following changes were made to the ACC Data Schema during the month of March, 2023

activitiescost_changesADDEDcost_changes table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiescost_activitiesADDEDcost_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiessheets_activitiesADDEDsheets_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesrfis_changesADDEDrfis_changes table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesrfis_activitiesADDEDrfis_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesissues_changesADDEDissues_changes table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesissues_activitiesADDEDissues_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_standard_attributesADDEDdocs_standard_attributes table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_permissionsADDEDdocs_permissions table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_naming_standardsADDEDdocs_naming_standards table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_custom_attribute_constraintsADDEDdocs_custom_attribute_constraints table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_custom_attributesADDEDdocs_custom_attributes table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesdocs_activitiesADDEDdocs_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesassets_activitiesADDEDassets_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
activitiesadmin_activitiesADDEDadmin_activities table added to the schema. A beta release of the activities service group is available via API extracts. This is be a Beta release and is subject to change.1695408731
costcost_paymentsMODIFIEDBudget calculation changes and new columns (submitted_at, note)1695408731
costbudget_paymentsMODIFIEDBudget calculation changes and new columns (submitted_at, note)1695408731
adminproject_user_rolescreated_atMODIFIEDData correction for column to report the proper date1695408731
adminproject_usersADDEDproject_users table added to the schema.1695408731
costapproval_workflowsADDEDapproval_workflows table added to the schema.1695408731
costcost_payment_propertiesADDEDcost_payment_properties table added to the schema.1695408731
costbudget_payment_propertiesADDEDbudget_payment_properties table added to the schema.1695408731
costexpense_propertiesADDEDexpense_properties table added to the schema.1695408731
costpayment_referencesADDEDpayment_references table added to the schema.1695408731

January, 2023

The following changes were made to the ACC Data Schema during the month of January, 2023

adminproject_user_servicesMODIFIEDOn January 24, 2023 a change was made to a service identifier column being reported by Data Connector in the Admin schema. This change was made to bring the actual data extracted in compliance with the documentation. The service identifier for Document Management should have been documentManagement, but was being reported as doc_manager. This was fixed on the 24th, but was not communicated in our product documentation as per our standard practice and for this, we apologize.1695408731
adminproject_servicesMODIFIEDOn January 24, 2023 a change was made to a service identifier column being reported by Data Connector in the Admin schema. This change was made to bring the actual data extracted in compliance with the documentation. The service identifier for Document Management should have been documentManagement, but was being reported as doc_manager. This was fixed on the 24th, but was not communicated in our product documentation as per our standard practice and for this, we apologize.1695408731
adminaccount_servicesMODIFIEDOn January 24, 2023 a change was made to a service identifier column being reported by Data Connector in the Admin schema. This change was made to bring the actual data extracted in compliance with the documentation. The service identifier for Document Management should have been documentManagement, but was being reported as doc_manager. This was fixed on the 24th, but was not communicated in our product documentation as per our standard practice and for this, we apologize.1695408731
assetsassets_permissionsMODIFIEDThe new assets permissions schema will accommodate both project-wide and per-category permissions. The resource_type and resource_id columns indicate the resource to which a permission applies (the project or a category). All existing permissions in ACC Build and BIM 360 will be present in the new permissions schema and will have a resource_type equal to project. The permission_policy_type column replaces the notion of permission levels. It is an enum that can take on the values view, edit, create, create_only, or manage. It no longer results in repeated rows. This enum corresponds to the available options on the Assets Permissions page in the web application. Note that create_only is only available in BIM 360 and manage is only available in ACC Build.1695408731
adminproject_user_productscreated_atADDEDColumn added to the project_user_products table in the schema.1695408731
formsnative_form_valuesADDEDnative_form_values table added to the schema.1695408731