Data Change Log
Below are the notable changes to the Procore data and intelligence layer accessible via the Analytics 2.0 Cloud Connector.
Recent Changes
Analytics 2.0 Data Updates (12/16/2025)
Procore updated the following models (tables):
invoice_compliance:
Added vendor_id
subcontractor_invoices:
Added early_pay_fee_amount_company_currency
Added early_pay_fee_amount_project_currency
Added total_contract_amount_company_currency
Added total_contract_amount_project_currency
commitment_line_items:
Added allow_these_users_to_see_sov_items
Added contract_assignee_id
Added contract_created_by_id
Added contract_private
Added contract_user_id_list
prime_contract_line_items:
Added allow_these_users_to_see_sov_items
Added contract_assignee_id
Added contract_created_by_id
Added contract_private
Added contract_status
Added contract_type
Added contract_user_id_list
daily_log_accident:
Added area
daily_log_construction_reports:
Added area
daily_log_delay:
Added area
daily_log_delivery:
Added area
action_plan:
Added approver_party_id_list
coordination_issue_custom_fields:
Added audit_transaction_timestamp
Added company_id
Added coordination_issue_custom_field_id
Added coordination_issue_id
Added custom_field_data_type
Added custom_field_definitions_id
Added custom_field_name
Added custom_field_value
Added custom_field_value_id
Added project_id
daily_log_dumpster:
Added area
daily_log_equipment:
Added area
daily_log_inspection:
Added segment
daily_log_manpower:
Added area
daily_log_note:
Added area
daily_log_observed_weather_condition:
Added area
daily_log_phone_call:
Added area
daily_log_plan_revision:
Added area
daily_log_productivity:
Added area
daily_log_quantity:
Added area
daily_log_safety_violation:
Added area
daily_log_scheduled_work:
Added area
daily_log_visitor:
Added area
daily_log_waste:
Added area
equipment_telematic:
Added provider_name
Added provider_id
equipment_telematics_daily_summary:
Added active_regeneration_hours
Added date
Added distance
Added equipment_telematics_daily_summary_id
Added fuel_used
Added fuel_used_last_24
Added identification_number
Added idle_hours
Added idle_non_operating_hours
Added load_count
Added maximum_speed_last_24
Added operating_hours
Added power_take_off_hours
Added company_id
Added equipment_id
incident:
Added assignee_id_list
Added assignee_list
Added global_status
incident_assignee:
Added audit_transaction_timestamp
Added company_id
Added incident_assignee_id
Added incident_id
Added login
Added project_id
Added assignee_id
Added company_name
Added created_at
Added name
Added updated_at
commitments:
Added bid_id
Added bid_vendor_id
Added bid_package_id
Added bid_form_id
punch_item_activities:
Added audit_transaction_timestamp
Added company_id
Added created_by_id
Added created_by_login
Added project_id
Added punch_item_id
Added attachments_count
Added comment
Added created_at
Added created_by_name
Added punch_item_activity_id
Added status
Added updated_at
rfi_responses:
Added rfi_project_id
site_instruction_attentions:
Added user_id
Added name
incident_record:
Added equipment_identification_number
Added equipment_id
Added equipment_name
site_instruction_distribution_members:
Added user_id
Added name
specification_sections:
Added created_by_id
bid_package:
Added require_nda
labor_equipment_productivity:
Added cost_code
Added wbs_code_flat_code
Added labor_estimated_hours
Added labor_reported_hours
Added labor_reported_cost
Added labor_percent_completion
Added equipment_estimated_hours
Added equipment_reported_hours
Added equipment_reported_cost
Added equipment_percent_completion
Added total_estimated_hours
Added total_reported_hours
Added total_reported_cost
Added labor_equipment_productivity_id
Added company_id
Added project_id
Added cost_code_id
Added wbs_code_id
timecard_entries:
Added wp_people_id
labor_allocations:
Added labor_allocation_id
Added allocation_date
Added wbs_code_id
Added allocation_hours
Added company_id
Added project_id
Added created_by_id
prime_contract:
Added pending_change_orders
Added invoiced
Added approved_change_orders
Added pending_revised_contract_amount
Added remaining_balance
Added revised_contract_amount
Added draft_change_orders
Added pending_change_orders_project_currency
Added invoiced_project_currency
Added approved_change_orders_project_currency
Added pending_revised_contract_amount_project_currency
Added remaining_balance_project_currency
Added revised_contract_amount_project_currency
Added draft_change_orders_company_currency
Added pending_change_orders_company_currency
Added invoiced_company_currency
Added approved_change_orders_company_currency
Added pending_revised_contract_amount_company_currency
Added remaining_balance_company_currency
Added revised_contract_amount_company_currency
Added draft_change_orders_company_currency
rfis:
Added attachment_count
Analytics 2.0 Data Updates (11/18/2025)
Procore added the following models (tables):
budget_forecasts
Procore removed the following models (tables):
budget_change_custom_field_configs
change_event_custom_field_configs
commitment_co_custom_field_configs
commitment_custom_field_configs
commitment_pco_custom_field_configs
prime_contract_co_custom_field_configs
prime_contract_pco_custom_field_configs
prime_contract_custom_field_configs
subcontractor_invoice_custom_field_configs
action_plan_custom_field_configs
correspondence_custom_field_configs
daily_log_construction_report_custom_field_configs
daily_log_equipment_custom_field_configs
daily_log_manpower_custom_field_configs
inspection_custom_field_configs
observation_custom_field_configs
punch_item_custom_field_configs
rfi_custom_field_configs
submittal_custom_field_configs
time_and_material_entry_custom_field_configs
time_and_material_equipment_custom_field_configs:
time_and_material_labors_custom_field_configs:
time_and_material_material_custom_field_configs:
time_and_material_entry_subcontractor_field_configs:
timecard_entry_custom_field_configs:
bid_item:
Removed bidding_vendor_id
bid_vendor:
Removed bidding_vendor_id
bid:
Removed bidding_vendor_id
contracts:
Removed bidding_vendor_id
wp_people:
Removed tags
Removed tag_instance_id
Removed wp_people_project_tag_id
Removed wp_project_id
wp_projects:
Removed tags
Removed tag_instance_id
Removed wp_project_tag_id
Procore updated the data type for the following models (tables):
action_plan_custom_fields:
Changed custom_field_value_id from int to string
budget_change_custom_fields:
Changed custom_field_value_id from int to string
change_event_custom_fields:
Changed custom_field_value_id from int to string
commitment_co_custom_fields:
Changed custom_field_value_id from int to string
commitment_custom_fields
Changed custom_field_value_id from int to string
commitment_pco_custom_fields:
Changed custom_field_value_id from int to string
company_folder_documents_custom_fields:
Changed custom_field_value_id from int to string
correspondence_custom_fields:
Changed custom_field_value_id from int to string
daily_log_accident_custom_fields:
Changed custom_field_value_id from int to string
daily_log_construction_report_custom_fields:
Changed custom_field_value_id from int to string
daily_log_delay_custom_fields:
Changed custom_field_value_id from int to string
daily_log_delivery_custom_fields:
Changed custom_field_value_id from int to string
daily_log_dumpster_custom_fields:
Changed custom_field_value_id from int to string
daily_log_equipment_custom_fields:
Changed custom_field_value_id from int to string
daily_log_inspection_custom_fields:
Changed custom_field_value_id from int to string
daily_log_manpower_custom_fields:
Changed custom_field_value_id from int to string
daily_log_note_custom_fields:
Changed custom_field_value_id from int to string
daily_log_phone_call_custom_fields:
Changed custom_field_value_id from int to string
daily_log_plan_revision_custom_fields:
Changed custom_field_value_id from int to string
daily_log_productivity_custom_fields:
Changed custom_field_value_id from int to string
daily_log_quantity_custom_fields:
Changed custom_field_value_id from int to string
daily_log_safety_violation_custom_fields:
Changed custom_field_value_id from int to string
daily_log_scheduled_work_custom_fields:
Changed custom_field_value_id from int to string
daily_log_visitor_custom_fields:
Changed custom_field_value_id from int to string
daily_log_waste_custom_fields:
Changed custom_field_value_id from int to string
drawing_revision_custom_fields:
Changed custom_field_value_id from int to string
folder_documents_custom_fields:
Changed custom_field_value_id from int to string
incident_action_custom_fields:
Changed custom_field_value_id from int to string
incident_custom_fields:
Changed custom_field_value_id from int to string
incident_record_custom_fields:
Changed custom_field_value_id from int to string
incident_witness_statement_custom_fields:
Changed custom_field_value_id from int to string
inspection_custom_fields:
Changed custom_field_value_id from int to string
observation_custom_fields:
Changed custom_field_value_id from int to string
prime_contract_co_custom_fields:
Changed custom_field_value_id from int to string
prime_contract_custom_fields:
Changed custom_field_value_id from int to string
prime_contract_pco_custom_fields:
Changed custom_field_value_id from int to string
project_custom_fields:
Changed custom_field_value_id from int to string
punch_item_custom_fields:
Changed custom_field_value_id from int to string
rfi_custom_fields:
Changed custom_field_value_id from int to string
subcontractor_invoice_custom_fields:
Changed custom_field_value_id from int to string
submittal_custom_fields:
Changed custom_field_value_id from int to string
Procore updated the following models (tables):
submittal_approvers:
Added variance_at_end
Bid:
Added invitation_first_sent_at
projects:
Added budget_locked
Added actual_completion_date
form_template:
Added company_id
Added created_by_id
Added prostore_file_id
Added audit_transaction_timestamp
Added form_template_id
Added name
Added description
Added created_at
Added updated_at
Added archived_at
commitments:
Added draft_change_orders_company_currency
Added invoiced_company_currency
Added pending_change_orders_company_currency
Added pending_revised_contract_amount_company_currency
Added approved_change_orders_company_currency
Added approved_change_orders_project_currency
Added contract_user_id_list
Added draft_change_orders_project_currency
Added invoiced_project_currency
Added pending_change_orders_project_currency
Added pending_revised_contract_amount_project_currency
Added remaining_balance_project_currency
Added revised_contract_amount_project_currency
Added workflow_distribution_member_id_list
Added workflow_role_user_id_list
Added pending_revised_contract_amount_company_currency
commitment_change_order_workflow_responses:
Added current_step_response
commitment_pco_workflow_responses:
Added current_step_response
correspondence_workflow_responses:
Added current_step_response
drawing_revision:
Added current_revision
Added reviewed_by_id
Added status_id
prime_contracts:
Added contract_user_id_list
Added workflow_distribution_member_id_list
Added workflow_role_user_id_list
budget_change_workflow_responses:
Added current_step_response
Added remaining_balance_company_currency
Added revised_contract_amount_company_currency
bid_item:
Added bid_vendor_id
bid_vendor:
Added bid_form_id
estimate_adjustment:
Added procore_project_id
estimate_budget_item:
Added procore_project_id
estimate_budget_item_included_item:
Added procore_project_id
estimate_layer_groups:
Added procore_project_id
estimate_layers:
Added procore_project_id
estimates:
Added procore_project_id
estimating_project_custom_fields:
Added procore_project_id
action_plan:
Added assignee_party_id_list
Added completed_plan_receiver_party_id_list
correspondence_assignees:
Added user_id
correspondence_distributions:
Added user_id
correspondences:
Added assignee_id_list
Added composite_provider_key
Added distribution_member_id_list
daily_log_accident:
Added created_by_collaborator
Added raw_status
daily_log_construction_reports:
Added created_by_collaborator
Added raw_status
daily_log_delay:
Added created_by_collaborator
Added raw_status
daily_log_delivery:
Added created_by_collaborator
Added raw_status
daily_log_dumpster:
Added created_by_collaborator
Added raw_status
daily_log_equipment:
Added created_by_collaborator
Added raw_status
daily_log_inspection:
Added created_by_collaborator
Added raw_status
daily_log_manpower:
Added created_by_collaborator
Added raw_status
daily_log_note:
Added created_by_collaborator
Added raw_status
daily_log_observed_weather_condition:
Added created_by_collaborator
Added raw_status
daily_log_phone_call:
Added created_by_collaborator
Added raw_status
daily_log_plan_revision:
Added created_by_collaborator
Added raw_status
daily_log_productivity:
Added created_by_collaborator
Added raw_status
daily_log_quantity:
Added created_by_collaborator
Added raw_status
daily_log_safety_violation:
Added created_by_collaborator
Added raw_status
daily_log_scheduled_work:
Added created_by_collaborator
Added raw_status
daily_log_visitor:
Added created_by_collaborator
Added raw_status
daily_log_waste:
Added created_by_collaborator
Added raw_status
inspection_items:
Added date_value_timestamp
incident:
Added distribution_member_id_list
Added recipient_id_list
incident_alert:
Added permission_recipient_id
Added recipient_name
site_instruction_attentions:
Added member_name
Added audit_transaction_timestamp
Added company_id
Added site_instruction_attention_id
Added member_id
Added project_id
Added site_instruction_id
site_instruction_distribution_members:
Added member_name
Added site_instruction_distribution_member_id
Added audit_transaction_timestamp
Added company_id
Added member_id
Added project_id
Added site_instruction_id
site_instructions:
Added attention_user_id_list
Added distribution_member_id_list
inspections:
Added assignee_id_list
Added distribution_member_id_list
Added signature_id_list
meeting:
Added assignee_id_list
meeting_attendee:
Added person_id
observation:
Added distribution_member_ids
observation_distribution_member:
Added user_id
punch_item:
Added assignee_id_list
Added distribution_member_id_list
Added permission_workflow_status
rfi_responses:
Added assignee_id_list
Added distribution_member_id_list
Added rfi_created_by_id
Added rfi_draft
Added rfi_hidden
Added rfi_manager_id
Added rfi_private
rfis:
Added assignee_id_list
Added distribution_member_id_list
schedule_calendar_item:
Added assigned_id
schedule_lookahead:
Added created_by_id
schedule_lookahead_task:
Added created_by_id
schedule_task:
Added created_by_id
maintenance_record:
Added type
Added duration
Added start_date
Added issue
Added notes
Added maintenance_record_id
Added company_id
Added equipment_id
owner_invoice_workflow_responses:
Added current_step_response
task:
Added assignee_user_id_list
Added created_by_id
Added task_item_distribution_member_id_list
task_assignee:
Added assignee_id
task_distribution_member:
Added user_id
prime_contract_workflow_responses:
Added current_step_response
prime_contract_change_order_workflow_responses:
Added current_step_response
prime_contract_pco_workflow_responses:
Added current_step_response
submittals:
Added approvers_ids
Added distribution_id_list
specification_sections:
Added current_revision
Added issued_date
Added received_date
Added revision
Estimate:
Added include_in_primary_estimate
equipment_timecard_entry_custom_fields:
Added batch_id
Added partition_company_id
Added equipment_timecard_entry_id
Added equipment_timecard_entry_custom_field_id
Added custom_field_value
Added custom_field_value_id
Added custom_field_definitions_id
Added custom_field_name
Added custom_field_data_type
Added company_id
Added project_id
estimating_projects:
Added primary_contact_full_address
subcontractor_invoice_workflow_responses:
Added current_step_response
assignments:
Added percent_allocation
wp_wage_overrides:
Added wp_project_id
Added wp_wage_override_id
Added job_title_id
Added company_id
Added job_title
Added wage_override_rate
Added project_id
tags:
Added wp_people_id
Added wp_project_id
commitment_workflow_response_occurrences:
Added current_step_response
Analytics 2.0 Data Updates (10/28/2025)
Procore updated the following models (tables):
inspection_items:
Added attachment_count
correspondences_workflow_responses:
Added current_step_response
Analytics 2.0 Data Updates (10/21/2025)
Procore updated the following models (tables):
action_plan:
Added status_id
actual_production_quantities:
Added description
bid_vendor:
Added audit_transaction_timestamp
assembly_part:
Added difficulty_factor
Added labor_margin
Added total_cost
Added total_labor_sales
Added unit_labor_mins
Added unit_sales
bid_package:
Added require_
nda
bid_vendor:
Added bid_form_id
Added bid_id
Added bid_package_id
Added bid_vendor_id
Added company_id
Added created_at
Added jobsite_proximity_in_miles
Added project_id
Added updated_at
Added vendor_address
Added vendor_affirmative_action
Added vendor_african_american_business
Added vendor_asian_american_business
Added vendor_authorized_bidder
Added vendor_avg_company_rating
Added vendor_business_phone
Added vendor_certified_business_enterprise
Added vendor_city
Added vendor_country
Added vendor_disadvantaged_business
Added vendor_eight_a_business_enterprise
Added vendor_hispanic_business
Added vendor_historically_underutlized_business
Added vendor_id
Added vendor_minority_business_enterprise
Added vendor_name
Added vendor_native_american_business
Added vendor_service_disabled_veteran_owned_small_business
Added vendor_small_business
Added vendor_state
Added vendor_trades
Added vendor_womens_business
Added vendor_zip
bid:
Added bid_vendor_id
Added nda_activity
change_event_line_item_with_markups:
Added non_committed_cost
Added non_committed_cost_company_currency
Added non_committed_cost_project_currency
commitment_change_orders:
Added change_reason
company_granular_permissions:
Added audit_transaction_timestamp
Added company_granular_permission_id
Added company_id
Added login_information_id
Added tool_bid_board_can_access_projects_for_all_users
Added tool_bid_board_can_add_notes
Added tool_bid_board_can_edit_docs
Added tool_bid_board_can_edit_project_details
Added tool_bid_board_can_export_bid
Added tool_directory_add_user_to_project
Added tool_directory_assign_to_future_projects
Added tool_directory_create_users
Added tool_directory_create_vendors
Added tool_directory_remove_user_from_project
Added tool_directory_view_user_details
Added tool_directory_view_vendor_details
company_permissions:
Added permission_template_id
contract:
Added bid_vendor_id
daily_log_types:
Added audit_transaction_timestamp
Added company_id
Added created_at
Added daily_log_type_id
Added enabled
Added label
Added name
Added updated_at
equipment:
Added daily_logs_count_l7
Added engine_hours_changes_count_l7
Added inspections_count_l7
Added is_idle_last_7_days
Added last_activity
Added last_activity_date
Added last_daily_log_date
Added last_engine_hours_activity_date
Added last_inspection_date
Added last_location_activity_date
Added last_timecard_date
Added location_changes_count_l7
Added timecards_count_l7
form:
Added template_archived_date
inspections:
Added group
Added reinspected_by_id
Added reinspected_by_name
Added reinspected_from_id
Added reinspected_from_name
meeting:
Added distributed_at
Added distributed_by_id
Added distributed_by_name
Added last_distributed_event
observation:
Added group
project_granular_permissions:
Added audit_transaction_timestamp
Added company_id
Added login_information_id
Added pk_user_id
Added project_granular_permission_id
Added project_id
Added tool_action_plans_act_as_approver
Added tool_action_plans_act_as_receiver
Added tool_action_plans_create_and_edit_plan
Added tool_action_plans_create_test_records_as_assignee
Added tool_action_plans_delete_plan
Added tool_action_plans_edit_due_date
Added tool_action_plans_edit_item_notes_as_assignee
Added tool_action_plans_edit_item_status_as_assignee
Added tool_action_plans_edit_notifications
Added tool_action_plans_edit_project_templates
Added tool_action_plans_link_record
Added tool_action_plans_sign_as_any_assignee
Added tool_action_plans_sign_as_same_company_approver
Added tool_action_plans_sign_as_same_company_assignee
Added tool_action_plans_sign_as_same_company_receiver
Added tool_action_plans_sign_as_self_assignee
Added tool_action_plans_unlink_record
Added tool_admin_manage_locations
Added tool_admin_manage_wbs_codes
Added tool_admin_update_active_tabs
Added tool_admin_update_cost_codes
Added tool_admin_update_general_settings
Added tool_budget_create_edit_delete_budget_changes
Added tool_budget_delete_budget_line_items
Added tool_budget_import_line_items_from_csv
Added tool_budget_lock_budget
Added tool_budget_modify_original_budget_amount
Added tool_budget_send_and_retrieve_from_erp
Added tool_budget_view_budget_insights
Added tool_budget_view_direct_cost_details
Added tool_change_events_can_export_to_pdf_or_csv
Added tool_change_events_can_view_change_history
Added tool_commitments_create_purchase_order_contract
Added tool_commitments_create_work_order_contract
Added tool_commitments_select_out_of_scope_wbs_codes_on_commitment_change_orders
Added tool_commitments_update_contract_currency_exchange_rate
Added tool_commitments_update_purchase_order_contract
Added tool_commitments_update_work_order_contract
Added tool_commitments_view_private_purchase_order_contract
Added tool_commitments_view_private_work_order_contract
Added tool_daily_log_copy
Added tool_daily_log_log_restrictively
Added tool_daily_log_update_own_entries
Added tool_daily_log_view_company_entries
Added tool_data_extracts_can_create
Added tool_data_extracts_can_delete_drafts
Added tool_data_extracts_can_download
Added tool_data_extracts_can_edit_drafts
Added tool_data_extracts_can_extract_data
Added tool_data_extracts_can_view
Added tool_direct_costs_create_direct_cost
Added tool_direct_costs_delete_direct_cost
Added tool_direct_costs_update_direct_cost
Added tool_direct_costs_update_exchange_rate
Added tool_directory_add_user
Added tool_directory_assign_project_role
Added tool_directory_create_distribution_group
Added tool_directory_create_person
Added tool_directory_create_user
Added tool_directory_create_vendor
Added tool_directory_manage_permission_templates
Added tool_directory_manage_vendor_insurances
Added tool_directory_remove_user
Added tool_directory_remove_vendor
Added tool_directory_request_imports
Added tool_directory_see_vendor_insurances
Added tool_directory_update_person
Added tool_documents_access_private
Added tool_documents_destroy_files_and_folders
Added tool_documents_move_files_and_folders
Added tool_documents_rename_files_and_folders
Added tool_documents_see_recycle_bin
Added tool_documents_set_permissions
Added tool_drawings_upload_and_review_drawings
Added tool_drawings_upload_drawings
Added tool_inspections_can_bulk_create_inspections
Added tool_inspections_can_reinspect
Added tool_inspections_create_edit_inspection_schedules
Added tool_meetings_add_comment
Added tool_meetings_create
Added tool_meetings_delete_own_comment
Added tool_meetings_distribute
Added tool_meetings_edit
Added tool_meetings_manage_meeting_categories
Added tool_meetings_manage_meeting_items
Added tool_meetings_manage_related_items
Added tool_meetings_send_emails
Added tool_observations_assign_standard_user
Added tool_observations_respond_to_vendor_observation_items
Added tool_observations_view_vendor_observation_items
Added tool_photos_create_photo_album
Added tool_photos_delete_photo_album
Added tool_photos_reorder_photo_albums
Added tool_photos_view_private_photo_album
Added tool_prime_contracts_can_import_markups
Added tool_prime_contracts_create_prime_contract
Added tool_prime_contracts_delete_prime_contract
Added tool_prime_contracts_update_contract_currency_exchange_rate
Added tool_prime_contracts_update_prime_contract
Added tool_prime_contracts_view_payment_application_detail
Added tool_punch_list_respond_to_vendor_punch_items
Added tool_punch_list_view_vendor_punch_items
Added tool_rfis_act_as_rfi_manager
Added tool_rfis_mark_official_responses
Added tool_rfis_view_private_rfis
Added tool_rfis_view_project_rfi_insights
Added tool_schedule_lookahead_create
Added tool_schedule_lookahead_delete
Added tool_schedule_lookahead_task_create
Added tool_schedule_lookahead_task_delete
Added tool_schedule_lookahead_task_update
Added tool_schedule_lookahead_view
Added tool_schedule_lookahead_view_change_history
Added tool_schedule_task_update_percent_complete
Added tool_specifications_can_configure
Added tool_specifications_can_create
Added tool_specifications_can_create_specification_set
Added tool_specifications_can_delete_pending_specification_uploads
Added tool_specifications_can_destroy
Added tool_specifications_can_download_specification
Added tool_specifications_can_email
Added tool_specifications_can_export_specification
Added tool_specifications_can_manually_create_divisions
Added tool_specifications_can_manually_create_spec_sections
Added tool_specifications_can_publish
Added tool_specifications_can_relate_items
Added tool_specifications_can_review
Added tool_specifications_can_show
Added tool_specifications_can_show_uploads
Added tool_specifications_can_update
Added tool_specifications_can_view_all_revision
Added tool_specifications_can_view_change_history
Added tool_specifications_can_view_deleted_specifications
Added tool_submittals_apply_submittal_workflow_template
Added tool_submittals_create_submittal
Added tool_submittals_create_submittal_package
Added tool_submittals_view_private_submittals
Added tool_submittals_view_project_submittal_insights
Added tool_timesheets_review_timesheets
Added tool_transmittals_view_private_transmittals"
project_permissions:
Added permission_template_id
project_role_memberships:
Added updated_at
invoice_compliance:
Added invoice_compliance_id
Added name
Added type
Added status
Added notes
Added attachment_count
Added effective_date
Added expiration_date
Added last_modified_by
Added last_modified_date
observation_custom_field_configs:
Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)
observation_custom_fields:
Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)
Analytics 2.0 Bug Fix (09/02/2025)
Procore updated the following models (tables):
Estimate_budget_item_included_item:
Added wbs_code_id
Estimate_budget_item:
Added wbs_code_id
Analytics 2.0 Data Updates (08/19/2025)
Procore added the following models (tables):
Bid
Bid_form
Bid_item
Bid_package
company_permissions
contact
project_contacts
Project_note
project_permissions
Project_task
Project_document
assembly_part
estimating_project_custom_field_configs
Procore updated the following models (tables):
observation_custom_fields:
Changed type_id from int to bigint
payments_subtier_waivers:
Changed payment_subtier_waiver_id from bigint to string
incident_record:
Changed incident_environmental_type from boolean to string
commitment_change_order_line_items:
Added commitment_change_order_line_items.quantity
Added commitment_change_order_line_items.tax_code
Added commitment_change_order_line_items.uom
commitments:
Added commitments.approved_change_orders
Added commitments.draft_change_orders
Added commitments.invoiced
Added commitments.pending_change_orders
Added commitments.pending_revised_contract_amount
owner_invoice_line_item_with_markups:
Added owner_invoice_line_item_with_markups.materials_retainage_released_this_period
Added owner_invoice_line_item_with_markups.materials_retainage_released_this_period_company_currency
Added owner_invoice_line_item_with_markups.materials_retainage_released_this_period_project_currency
owner_invoice_line_items:
Added owner_invoice_line_items.materials_retainage_released_this_period
Added owner_invoice_line_items.materials_retainage_released_this_period_company_currency
Added owner_invoice_line_items.materials_retainage_released_this_period_project_currency
owner_invoice_markup_line_items:
Added owner_invoice_markup_line_items.materials_retainage_released_this_period
Added owner_invoice_markup_line_items.materials_retainage_released_this_period_company_currency
Added owner_invoice_markup_line_items.materials_retainage_released_this_period_project_currency
owner_invoices:
Added owner_invoices.created_by_id
payments_subtier_waivers:
Added payments_subtier_waivers.waiver_required
subcontractor_invoices:
Added subcontractor_invoices.created_by_id
Added subcontractor_invoices.total_contract_amount
photo:
Added photo.uploaded_by_id
assignments:
Added assignments.employee_id
time_and_material_equipments:
Added time_and_material_equipments.equipment_id
Added time_and_material_equipments.equipment_identification_number
Added time_and_material_equipments.equipment_name_legacy
time_off:
Added time_off.employee_id
timecard_entries:
Added timecard_entries.party_employee_id
Added timesheet_id
wp_people:
Added wp_people.party_id
wp_role:
Added wp_roles.audit_transaction_timestamp
Added wp_roles.employee_id
Vendor:
Added avg_company_rating
Estimating Project:
Added created_by_id
Added primary_contact_full_address
budget_snapshot_line_item_headers:
Added line_items
requests:
Added status
wp_people:
Added customer_employee_id
Added user_id
incident_records:
Added affected_user_id
Analytics 2.0 Data Updates (07/22/2025)
Procore added the following models (tables):
company_project_currency_configurations
assignment_custom_fields
request_custom_fields
wp_people_custom_fields
folder_documents_custom_field_configs
folder_documents_custom_fields
task_distribution_member
Procore updated the following models (tables):
project_vendors:
Added project_vendors.avg_company_rating
Added project_vendors.invoice_contact_email_address
Added project_vendors.invoice_contact_full_name
vendors:
Added vendors.avg_company_rating
Added vendors.invoice_contact_email_address
Added vendors.invoice_contact_full_name
direct_costs:
Added direct_costs.created_by_id
payments_subtiers:
Added payments_subtiers.hired_by_company_name
Added payments_subtiers.tier
Added payments_subtiers.tiering
subcontractor_invoices:
Added subcontractor_invoices.early_pay_fee_amount_calculated
incident_record:
Added incident_record.affected_party_id
Added incident_record.affected_party_name
inspection_items:
Added inspection_items.respondable
inspection_signature_requests:
Added inspection_signature_requests.requested
Added inspection_signature_requests.requested_login
submittals:
Added submittals.source_submittal_id
Added submittals.specification_area_name
actual_production_quantities:
Added actual_production_quantities.created_by_id
budgeted_production_quantities:
Added budgeted_production_quantities.created_by_id
equipment:
Added equipment.project_id
time_and_material_entries:
Added time_and_material_entries.created_by_id
timecard_entries:
Added timecard_entries.created_by_id
Analytics 2.0 Data Updates (06/17/2025)
Procore added the following models (tables):
Company_folder_documents
Folder_documents
Folder_watchers
Equipment_telematic
wp_project_custom_fields
estimating_project_custom_field_configs
Procore updated the following models (tables):
Changes in subcontractor_invoice_line_items:
Added subcontractor_invoice_line_items.adjusted_materials_previously_stored
Added subcontractor_invoice_line_items.adjusted_materials_previously_stored_company_currency
Added subcontractor_invoice_line_items.adjusted_materials_previously_stored_project_currency
Added subcontractor_invoice_line_items.adjusted_materials_retained_previously
Added subcontractor_invoice_line_items.adjusted_materials_retained_previously_company_currency
Added subcontractor_invoice_line_items.adjusted_materials_retained_previously_project_currency
Added subcontractor_invoice_line_items.gross_amount
Added subcontractor_invoice_line_items.gross_amount_company_currency
Added subcontractor_invoice_line_items.gross_amount_project_currency
Added subcontractor_invoice_line_items.net_amount
Added subcontractor_invoice_line_items.net_amount_company_currency
Added subcontractor_invoice_line_items.net_amount_project_currency
Added subcontractor_invoice_line_items.retainage_new_materials_from_percent
Added subcontractor_invoice_line_items.retainage_new_materials_from_percent_company_currency
Added subcontractor_invoice_line_items.retainage_new_materials_from_percent_project_currency
Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous
Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_company_currency
Added subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_project_currency
Added subcontractor_invoice_line_items.commitment_line_item_id
Added subcontractor_invoice_line_items.prime_contract_line_item_id
Changes in submittals:
Added submittals.anticipated_delivery_date_at_close
Added submittals.remaining_buffer_time_at_close
Added submittals.workflow_progress_at_close
Changes in wp_people:
Added wp_people.custom_fields
Changes in wp_projects:
Added wp_projects.custom_fields
Changes in budget_view_details:
Added budget_view_details.infojson_currency_conversion
Analytics 2.0 Data Updates (05/20/2025)
Procore added the following models (tables):
project_company_comments
tags
Procore updated the following models (tables):
Changes in company_comments:
Added company_comments.audit_transaction_timestamp
Added company_comments.rating
Changes in company_distribution_groups:
Added company_distribution_groups.audit_transaction_timestamp
Added company_distribution_groups.project_id
Changes in project_distribution_groups:
Added project_distribution_groups.audit_transaction_timestamp
Added project_distribution_groups.company_id
Changes in project_tools:
Added project_tools.audit_transaction_timestamp
Added project_tools.is_active
Changes in budget_codes:
Added budget_codes.production_quantity_code_description
Changes in drawing_attachment:
Added drawing_attachment.folder_document_id
Changes in inspections:
Added inspections.closed_at
Changes in equipment:
Added equipment.status_type
Changes in field_productivity:
Added field_productivity.hours_utilization_enrp
Added field_productivity.projected_hours_at_completion_enrp
Analytics 2.0 Data Updates (04/22/2025)
Procore added the following models (tables):
early_pay_program
early_pay_program_enrollment
task_distribution_member
wp_roles
estimate_budget_item
estimate_budget_item_WBS_value
estimate_budget_included_item
procore_analytics_metadata
Procore updated the following models (tables):
Changes in project_role_memberships:
Added: project_role_memberships.employee_id
Changes in project_vendors:
Added: project_vendors.cost_codes
Added: project_vendors.trades
Changes in projects:
Added: projects.schedule_last_updated
Added: projects.schedule_percent_completion
Changes in vendors:
Added: vendors.cost_codes
Added: vendors.trades
Changes in budget_change_adjustment_line_items:
Added: budget_change_adjustment_line_items.budget_changes_approved_amount
Added: budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency
Added: budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency
Added: budget_change_adjustment_line_items.budget_changes_draft_amount
Added: budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency
Added: budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency
Added: budget_change_adjustment_line_items.budget_changes_under_review_amount
Added: budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency
Added: budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency
Changes in budget_columns:
Added: budget_columns.budget_column_id
Changes in budget_snapshot_line_item_forecasts:
Added: budget_snapshot_line_item_forecasts.approval_status
Added: budget_snapshot_line_item_forecasts.snapshot_type
Changes in budget_snapshot_line_item_headers:
Added budget_snapshot_line_item_headers.approval_status
Added: budget_snapshot_line_item_headers.audit_transaction_timestamp
Added: budget_snapshot_line_item_headers.snapshot_type
Changes in budget_snapshot_line_items:
Added budget_snapshot_line_items.approval_status
Added: budget_snapshot_line_items.audit_transaction_timestamp
Added: budget_snapshot_line_items.snapshot_type
Changes in change_event_line_item_with_markups:
Added: change_event_line_item_with_markups.links_commitment_contract_cost
Added: change_event_line_item_with_markups.links_commitment_pco_cost
Added: change_event_line_item_with_markups.links_contract
Added: change_event_line_item_with_markups.links_edit
Added: change_event_line_item_with_markups.links_prime_pco_cost
Added: change_event_line_item_with_markups.links_rfq_amount
Added: change_event_line_item_with_markups.links_rom
Added: change_event_line_item_with_markups.links_view
Changes in commitment_line_items:
Added: commitment_line_items.contracts_approved_amount
Added: commitment_line_items.contracts_approved_amount_company_currency
Added: commitment_line_items.contracts_approved_amount_project_currency
Added: commitment_line_items.contracts_complete_amount
Added: commitment_line_items.contracts_complete_amount_company_currency
Added: commitment_line_items.contracts_complete_amount_project_currency
Added: commitment_line_items.contracts_draft_amount
Added: commitment_line_items.contracts_draft_amount_company_currency
Added: commitment_line_items.contracts_draft_amount_project_currency
Added: commitment_line_items.contracts_out_for_signature_amount
Added: commitment_line_items.contracts_out_for_signature_amount_company_currency
Added: commitment_line_items.contracts_out_for_signature_amount_project_currency
Changes in commitments:
Added: commitments.global_insurance_compliance
Added: commitments.project_insurance_compliance
Added: commitments.remaining_balance
Added: commitments.revised_contract_amount
Changes in payments_issued:
Added: payments_issued.early_pay_fee_amount
Changes in payments_project_controls:
Added payments_project_controls.assigned_early_pay_program
Added: payments_project_controls.audit_transaction_timestamp
Added: payments_project_controls.early_pay_program_id
Changes in payments_subtier_waivers:
Added: payments_subtier_waivers.joint_check_requisition
Changes in payments_subtiers:
Added payments_subtiers.additional_address_information
Added: payments_subtiers.address
Added: payments_subtiers.amount_billed_to_date
Added: payments_subtiers.city
Added: payments_subtiers.country
Added: payments_subtiers.joint_check_future_requisitions
Added: payments_subtiers.kind_of_work
Added: payments_subtiers.phone
Added: payments_subtiers.state
Added: payments_subtiers.subtier_type
Added: payments_subtiers.waiver_contact_email
Added: payments_subtiers.zip
Changes in prime_contract_change_order_requests:
Added: prime_contract_change_order_requests.schedule_impact_days
Changes in prime_contract_change_orders:
Added: prime_contract_change_orders.schedule_impact_days
Changes in prime_contract_potential_change_orders:
Added: prime_contract_potential_change_orders.schedule_impact_days
Changes in subcontractor_invoices:
Added: subcontractor_invoices.early_pay_fee_amount
Added: subcontractor_invoices.early_pay_fee_rate
Added: subcontractor_invoices.early_pay_status
Added: subcontractor_invoices.missed_payment_due_date
Added: subcontractor_invoices.original_payment_due
Added: subcontractor_invoices.original_payment_due_company_currency
Added: subcontractor_invoices.original_payment_due_project_currency
Added: subcontractor_invoices.payment_due_date
Changes in correspondence_types:
Added: correspondence_types.created_at
Changes in correspondence_workflow_steps:
Added: correspondence_workflow_steps.current_step_due_date
Changes in daily_log_accident_custom_fields:
Added: daily_log_accident_custom_fields.type_id
Changes in daily_log_completion:
Added: daily_log_completion.created_at
Changes in daily_log_construction_report_custom_fields:
Added: daily_log_construction_report_custom_fields.type_id
Changes in daily_log_delay_custom_fields:
Added: daily_log_delay_custom_fields.type_id
Changes in daily_log_delivery_custom_fields:
Added: daily_log_delivery_custom_fields.type_id
Changes in daily_log_dumpster_custom_fields:
Added: daily_log_dumpster_custom_fields.type_id
Changes in daily_log_equipment:
Added: daily_log_equipment.equipment_id
Added: daily_log_equipment.equipment_identification_number
Added: daily_log_equipment.equipment_name_beta
Changes in daily_log_equipment_custom_fields:
Added: daily_log_equipment_custom_fields.type_id
Changes in daily_log_inspection_custom_fields:
Added: daily_log_inspection_custom_fields.type_id
Changes in daily_log_manpower_custom_fields:
Added: daily_log_manpower_custom_fields.type_id
Changes in daily_log_plan_revision_custom_fields:
Added: daily_log_plan_revision_custom_fields.type_id
Changes in daily_log_productivity_custom_fields:
Added: daily_log_productivity_custom_fields.type_id
Changes in daily_log_scheduled_work_task:
Added: daily_log_scheduled_work_task.created_at
Changes in drawing_revision:
Added: drawing_revision.created_at
Changes in incident_alert:
Added: incident_alert.created_at
Added: incident_alert.updated_at
Changes in inspection_distribution_list:
Added: inspection_distribution_list.created_at
Added: inspection_distribution_list.updated_at
Changes in inspection_item_signature_requests:
Added: inspection_item_signature_requests.created_at
Added: inspection_item_signature_requests.updated_at
Changes in inspection_schedule_assignees:
Added: inspection_schedule_assignees.created_at
Added: inspection_schedule_assignees.updated_at
Changes in inspection_schedule_distribution_list:
Added: inspection_schedule_distribution_list.created_at
Added: inspection_schedule_distribution_list.updated_at
Changes in inspection_schedules:
Added: inspection_schedules.created_at
Added: inspection_schedules.equipment_id
Added: inspection_schedules.equipment_identification_number
Added: inspection_schedules.equipment_name
Added: inspection_schedules.updated_at
Changes in meeting_attendee:
Added: meeting_attendee.created_at
Added: meeting_attendee.updated_at
Changes in meeting_item_assignee:
Added: meeting_item_assignee.updated_at
Changes in observation_distribution_member:
Added: observation_distribution_member.created_at
Changes in punch_item:
Added: punch_item.audit_transaction_timestamp
Changes in punch_item_bic:
Added punch_item_bic.audit_transaction_timestamp
Added: punch_item_bic.ball_in_court_role
Changes in punch_item_custom_fields:
Added: punch_item_custom_fields.type_id
Changes in punch_item_distribution_member:
Added punch_item_distribution_member.audit_transaction_timestamp
Changes in rfi_assignees:
Added: rfi_assignees.audit_transaction_timestamp
Changes in rfi_distributions:
Added rfi_distributions.audit_transaction_timestamp
Changes in rfi_responses:
Added rfi_responses.audit_transaction_timestamp
Changes in rfis:
Added: rfis.audit_transaction_timestamp
Added: rfis.current_revision
Added: rfis.revision
Changes in rfis_bic:
Added rfis_bic.audit_transaction_timestamp
Added: rfis_bic.ball_in_court_role
Changes in schedule_calendar_item:
Added: schedule_calendar_item.audit_transaction_timestamp
Changes in schedule_lookahead:
Added schedule_lookahead.audit_transaction_timestamp
Changes in schedule_lookahead_task:
Added: schedule_lookahead_task.audit_transaction_timestamp
Changes in schedule_task:
Added: schedule_task.audit_transaction_timestamp
Changes in schedule_task_changes:
Added: schedule_task_changes.audit_transaction_timestamp
Changes in schedule_task_requests:
Added schedule_task_requests.audit_transaction_timestamp
Changes in site_instructions:
Added: site_instructions.audit_transaction_timestamp
Changes in specification_sections:
Added specification_sections.audit_transaction_timestamp
Changes in submittal_approvers:
Added submittal_approvers.audit_transaction_timestamp
Added: submittal_approvers.comments
Changes in submittal_ball_in_courts:
Added submittal_ball_in_courts.audit_transaction_timestamp
Added: submittal_ball_in_courts.response_required
Changes in submittal_distributions:
Added submittal_distributions.audit_transaction_timestamp
Changes in submittals:
Added: submittals.audit_transaction_timestamp
Added: submittals.closed_at
Changes in task:
Added: task.audit_transaction_timestamp
Changes in task_activity:
Added: task_activity.audit_transaction_timestamp
Changes in task_assignee:
Added: task_assignee.audit_transaction_timestamp
Changes in equipment:
Added: equipment.rental_end_date
Added: equipment.rental_start_date
Added: equipment.vendor_name
Changes in field_productivity:
Added: field_productivity.cost_code_id
Added: field_productivity.production_quantity_code
Analytics 2.0 Data Updates (03/18/2025)
Procore added the following models (tables):
Budget Code Segments
Layer WBS Values
Layer Group WBS Values
Estimate Adjustment
Procore updated the following models (tables):
Changes in correspondence_workflow_steps
Added current_step_due_date
Added current_step_name
Changes in payments_disbursements
Added owner_invoices.tax_applicable_to_this_payment_company_currency
Added owner_invoices.tax_applicable_to_this_payment_project_currency
Changes in subcontractor_invoice_line_items
Added payments_disbursements.number
Added subcontractor_invoice_line_items.total_retainage_company_currency
Added subcontractor_invoice_line_items.total_retainage_project_currency
Changes in action_plan
Added action_plan.audit_transaction_timestamp
Changes in action_plan_approver
Added action_plan_approver.audit_transaction_timestamp
Changes in action_plan_completed_receiver
Added action_plan_completed_receiver.audit_transaction_timestamp
Changes in action_plan_line_item
Added action_plan_line_item.audit_transaction_timestamp
Changes in action_plan_line_item_assignee
Added action_plan_line_item_assignee.audit_transaction_timestamp
Changes in action_plan_line_item_record
Added action_plan_line_item_record.audit_transaction_timestamp
Changes in action_plan_line_item_record_request
Added action_plan_line_item_record_request.audit_transaction_timestamp
Changes in action_plan_line_item_reference
Added action_plan_line_item_reference.audit_transaction_timestamp
Changes in drawing_revision
Added drawing_revision.is_connected_drawing
Changes in incident_record
Added incident_record.affected_person_id
Changes in observation
Added observation.created_by_company
Changes in rfi_responses
Added rfi_responses.is_most_recent
Changes in rfis_bic
Added rfis_bic.response_required
Changes in schedule_task
Added schedule_task.predecessor_wbs_list
Added schedule_task.successor_wbs_list
Changes in specification_sections
`Added specification_sections.specification_area_description
Added specification_sections.specification_area_name
Changes in submittal_approvers
Added submittal_approvers.previous_due_date
Added submittal_approvers.previous_returned_date
Added submittal_approvers.previous_sent_date
Changes in wp_projects
Added wp_projects.categories
Added users.audit_transaction_timestamp
Added estimate_layer_groups.profit
Analytics 2.0 Data Updates (02/18/2025)
Procore added the following models (tables):
Financial
payments_permissions
payments_disbursements
pay_requirement_settings
payments_project_controls
payments_invites
payments_agreements
payments_received
Project Management
connected_rfi_responses
connected_rfis
daily_log_accident_custom_field_configs
daily_log_accident_custom_fields
daily_log_delay_custom_field_configs
daily_log_delay_custom_fields
daily_log_delivery_custom_field_configs
daily_log_delivery_custom_fields
daily_log_dumpster_custom_field_configs
daily_log_dumpster_custom_fields
daily_log_inspection_custom_field_configs
daily_log_inspection_custom_fields
daily_log_phone_call_custom_field_configs
daily_log_phone_call_custom_fields
daily_log_plan_revision_custom_field_configs
daily_log_plan_revision_custom_fields
daily_log_productivity_custom_field_configs
daily_log_productivity_custom_fields
daily_log_quantity_custom_field_configs
daily_log_quantity_custom_fields
daily_log_safety_violation_custom_field_configs
daily_log_safety_violation_custom_fields
daily_log_scheduled_work_custom_field_configs
daily_log_scheduled_work_custom_fields
daily_log_waste_custom_field_configs
daily_log_waste_custom_fields
inspection_item_references
schedule_task_changes
Resource Planning
assignments
job titles
requests
time off
wp people
wp projects
groups
Equipment
equipment
equipment project log
equipment timecard entry
Estimating
estimating projects
estimate layers
estimate layer groups
estimating project custom fields
Procore updated the following models (tables):
Changes in project_vendor_insurances.sql:
Added project_vendor_insurances.external_origin_data
Added project_vendor_insurances.external_origin_id
Changes in projects.sql:
Added projects.code
Added projects.delivery_method
Added projects.external_origin_data
Added projects.external_origin_id
Added projects.sector
Added projects.work_scope
Changes in users.sql:
Added users.abbreviated_name
Added users.can_push_to_accounting
Added users.company_name
Added users.company_permission_template
Added users.external_origin_data
Added users.external_origin_id
Added users.login_information_id
Added users.origin_id
Added users.origin_name
Changes in budget_changes.sql:
Added budget_changes.external_origin_data
Added budget_changes.external_origin_id
Changes in budget_line_items.sql:
Added budget_line_items.budget_notes
Changes in change_events.sql:
Added change_events.external_origin_data
Added change_events.external_origin_id
Changes in commitment_change_orders.sql:
Added commitment_change_orders.external_origin_data
Added commitment_change_orders.external_origin_id
Changes in commitment_line_items.sql:
Added commitment_line_items.external_origin_data
Added commitment_line_items.external_origin_id
Changes in direct_cost_line_items.sql:
Added direct_cost_line_items.external_origin_data
Added direct_cost_line_items.external_origin_id
Changes in direct_costs.sql:
Added direct_costs.external_origin_data
Added direct_costs.external_origin_id
Changes in owner_invoice_line_item_with_markups.sql:
Added owner_invoice_line_item_with_markups.external_origin_data
Added owner_invoice_line_item_with_markups.external_origin_id
Added owner_invoice_line_item_with_markups.materials_presently_stored_qty
Added owner_invoice_line_item_with_markups.name
Added owner_invoice_line_item_with_markups.new_materials_stored_qty
Added owner_invoice_line_item_with_markups.previous_materials_stored_qty
Added owner_invoice_line_item_with_markups.prime_contract_id
Changes in owner_invoice_line_items.sql:
Added owner_invoice_line_items.external_origin_data
Added owner_invoice_line_items.external_origin_id
Added owner_invoice_line_items.line_type
Added owner_invoice_line_items.markup_id
Added owner_invoice_line_items.materials_presently_stored_qty
Added owner_invoice_line_items.name
Added owner_invoice_line_items.new_materials_stored_qty
Added owner_invoice_line_items.owner_invoice_line_item_with_markup_id
Added owner_invoice_line_items.owner_invoice_markup_line_item_id
Added owner_invoice_line_items.previous_materials_stored_qty
Changes in owner_invoice_markup_line_items.sql:
Added owner_invoice_markup_line_items.approved_changes
Added owner_invoice_markup_line_items.approved_changes_company_currency
Added owner_invoice_markup_line_items.approved_changes_project_currency
Added owner_invoice_markup_line_items.balance_to_finish
Added owner_invoice_markup_line_items.company_id_2
Added owner_invoice_markup_line_items.external_origin_data
Added owner_invoice_markup_line_items.external_origin_id
Added owner_invoice_markup_line_items.line_type
Added owner_invoice_markup_line_items.materials_presently_stored_qty
Added owner_invoice_markup_line_items.name
Added owner_invoice_markup_line_items.new_materials_stored_qty
Added owner_invoice_markup_line_items.owner_invoice_line_item_id
Added owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id
Added owner_invoice_markup_line_items.previous_materials_stored_qty
Added owner_invoice_markup_line_items.prime_contract_id
Changes in owner_invoices.sql:
Added owner_invoices.external_origin_data
Added owner_invoices.external_origin_id
Added owner_invoices.tax_applicable_to_this_payment
Changes in payments_issued.sql:
Added payments_issued.external_origin_data
Added payments_issued.external_origin_id
Changes in prime_contract_change_order_line_items.sql:
Added prime_contract_change_order_line_items.external_origin_data
Added prime_contract_change_order_line_items.external_origin_id
Changes in prime_contract_change_order_requests.sql:
Added prime_contract_change_order_requests.external_origin_data
Added prime_contract_change_order_requests.external_origin_id
Changes in prime_contract_change_orders.sql:
Added prime_contract_change_orders.external_origin_data
Added prime_contract_change_orders.external_origin_id
Changes in prime_contract_line_items.sql:
Added prime_contract_line_items.external_origin_data
Added prime_contract_line_items.external_origin_id
Added prime_contract_line_items.vendor_id
Changes in prime_contract_potential_change_orders.sql:
Added prime_contract_potential_change_orders.external_origin_data
Added prime_contract_potential_change_orders.external_origin_id
Changes in prime_contracts.sql:
Added prime_contracts.external_origin_data
Added prime_contracts.external_origin_id
Changes in subcontractor_invoice_line_items.sql:
Added subcontractor_invoice_line_items.materials_presently_stored_qty
Added subcontractor_invoice_line_items.materials_previously_stored_qty
Added subcontractor_invoice_line_items.new_materials_qty
Changes in subcontractor_invoices.sql:
Added subcontractor_invoices.external_origin_data
Added subcontractor_invoices.external_origin_id
Changes in inspections.sql:
Added inspections.equipment_identification_number
Changes in rfi_assignees.sql:
Added rfi_assignees.forwarded_by
Changes in submittal_approvers.sql:
Added submittal_approvers.is_last_step
Changes in equipment_timecard_entry.sql:
Added equipment_timecard_entry.equipment_identification_number
Added equipment_timecard_entry.equipment_name
Analytics 2.0 Data Updates (01/21/2025)
Procore has added the following models (tables):
inspection_item_references
schedule_task_changes
equipment
equipment_project_log
equipment_timecard_entry
payments_project_controls
payments_invites
payments_agreements
pay_requirement_settings
Procore has updated the following models (tables):
company_vendor_insurances:
Added company_vendor_insurances.template_name
project_role_memberships:
Added project_role_memberships.user_id
budget_change_workflow_steps:
Added budget_change_workflow_steps.current_step_due_date
budget_codes:
Deleted SELECT budget_codes.budget_code
Added SELECT budget_codes.attribute_1_line_item
Added budget_codes.attribute_1_name
Added budget_codes.attribute_2_line_item
Added budget_codes.attribute_2_name
Added budget_codes.attribute_3_line_item
Added budget_codes.attribute_3_name
Added budget_codes.budget_code
budget_columns:
Added budget_columns.created_at
Added budget_columns.updated_at
change_event_line_item_with_markups:
Deleted SELECT change_event_line_item_with_markups.budget_days_in_stage
Added SELECT change_event_line_item_with_markups.biller_id
Added change_event_line_item_with_markups.biller_model_name
Added change_event_line_item_with_markups.biller_name
Added change_event_line_item_with_markups.budget_days_in_stage
Added change_event_line_item_with_markups.change_event_events_id
Added change_event_line_item_with_markups.change_event_status
Added change_event_line_item_with_markups.change_event_title
Added change_event_line_item_with_markups.contract_id
Added change_event_line_item_with_markups.contract_number
Added change_event_line_item_with_markups.contract_title
Added change_event_line_item_with_markups.estimated_budget_amount
Added change_event_line_item_with_markups.estimated_budget_transfer_amount
Added change_event_line_item_with_markups.estimated_cost_amount
Added change_event_line_item_with_markups.estimated_cost_amount_company_currency
Added change_event_line_item_with_markups.estimated_cost_amount_project_currency
Added change_event_line_item_with_markups.event_scope
Added change_event_line_item_with_markups.proposed_contract_id
Added change_event_line_item_with_markups.proposed_vendor_id
Added change_event_line_item_with_markups.source
Added change_event_line_item_with_markups.vendor_name
Added change_event_line_item_with_markups.wbs_code_id
commitment_change_order_line_items:
Added commitment_change_order_line_items.commitment_change_order_request_id
Added commitment_change_order_line_items.commitment_potential_change_order_id
commitment_change_order_workflow_steps:
Added commitment_change_order_workflow_steps.current_step_due_date
commitment_custom_field_configs:
Added commitment_custom_field_configs.name
commitment_pco_workflow_steps:
Added commitment_pco_workflow_steps.current_step_due_date
commitment_workflow_step_occurrences:
Added commitment_workflow_step_occurrences.current_step_due_date
contract_compliance_documents:
Added contract_compliance_documents.template_name
owner_invoice_workflow_steps:
Added owner_invoice_workflow_steps.current_step_due_date
owner_invoices:
Added owner_invoices.erp_latest_status
Added owner_invoices.erp_updated_at
Added owner_invoices.erp_user_name
Added owner_invoices.synced_with_accounting
payments_beneficiaries:
Added payments_beneficiaries.early_pay_classification
prime_contract_change_order_line_items:
Added prime_contract_change_order_line_items.name
Added prime_contract_change_order_line_items.prime_contract_change_order_request_id
Added prime_contract_change_order_line_items.prime_contract_potential_change_order_id
prime_contract_change_order_workflow_steps:
Added prime_contract_change_order_workflow_steps.current_step_due_date
prime_contract_pco_workflow_steps:
Added prime_contract_pco_workflow_steps.current_step_due_date
prime_contract_workflow_steps:
Added prime_contract_workflow_steps.current_step_due_date
subcontractor_invoice_line_items:
Added subcontractor_invoice_line_items.total_retainage
subcontractor_invoice_workflow_steps:
Added subcontractor_invoice_workflow_steps.current_step_due_date
action_plan_custom_fields:
Added action_plan_custom_fields.type_id
action_plan_line_item_record:
Added action_plan_line_item_record.action_plan_line_item_record_resource_url
correspondence_custom_fields:
Added correspondence_custom_fields.type_id
correspondence_response_attachments:
Added correspondence_response_attachments.type_id
correspondence_schedule_tasks:
Added correspondence_schedule_tasks.type_id
correspondence_workflow_responses:
Added correspondence_workflow_responses.type_id
correspondence_workflow_steps:
Added correspondence_workflow_steps.type_id
daily_log_accident:
Added daily_log_accident.daily_log_completion_id
daily_log_construction_reports:
Added daily_log_construction_reports.daily_log_completion_id
daily_log_delay:
Added daily_log_delay.daily_log_completion_id
daily_log_delivery:
Added daily_log_delivery.daily_log_completion_id
daily_log_dumpster:
Added daily_log_dumpster.daily_log_completion_id
daily_log_equipment:
Added daily_log_equipment.daily_log_completion_id
daily_log_inspection:
Added daily_log_inspection.daily_log_completion_id
daily_log_manpower:
Added daily_log_manpower.daily_log_completion_id
daily_log_note:
Added daily_log_note.daily_log_completion_id
daily_log_observed_weather_condition:
Added daily_log_observed_weather_condition.daily_log_completion_id
daily_log_phone_call:
Added daily_log_phone_call.daily_log_completion_id
daily_log_plan_revision:
Added daily_log_plan_revision.daily_log_completion_id
daily_log_productivity:
Added daily_log_productivity.daily_log_completion_id
daily_log_quantity:
Added daily_log_quantity.daily_log_completion_id
daily_log_safety_violation:
Added daily_log_safety_violation.daily_log_completion_id
daily_log_scheduled_work:
Added daily_log_scheduled_work.daily_log_completion_id
daily_log_scheduled_work_task:
Added daily_log_scheduled_work_task.daily_log_completion_id
Added daily_log_scheduled_work_task.schedule_task_id
daily_log_visitor:
Added daily_log_visitor.daily_log_completion_id
daily_log_waste:
Added daily_log_waste.daily_log_completion_id
inspection_custom_fields:
Added inspection_custom_fields.type_id
inspection_item_signature_requests:
Added inspection_item_signature_requests.inspection_schedule_id
inspection_items:
Added inspection_items.position_number
inspection_schedules:
Added inspection_schedules.ends_at
Added inspection_schedules.starts_at
inspections:
Added inspections.equipment_id
Added inspections.equipment_name
observation_custom_field_configs:
Added observation_custom_field_configs.observation_type_id
Added observation_custom_field_configs.type_id
observation_custom_fields:
Added observation_custom_fields.type_id
punch_item_bic:
Added punch_item_bic.punch_item_bic_id
rfis_bic:
Added rfis_bic.rfi_bic_id
schedule_lookahead_task:
Added schedule_lookahead_task.task_id_comp
schedule_task:
Added schedule_task.task_id
submittal_ball_in_courts:
Added submittal_ball_in_courts.company_name
Added submittal_ball_in_courts.role
submittals:
Added submittals.ball_in_court_role
Added submittals.paused
actual_production_quantities:
Added actual_production_quantities.wbs_code_id
budget_change_production_quantities:
Deleted SELECT budget_change_production_quantities.budget_change_production_quantity_id
Added SELECT budget_change_production_quantities.budget_change_id
Added budget_change_production_quantities.budget_change_production_quantity_id
Added budget_change_production_quantities.wbs_code_id
prime_potential_change_order_production_quantities:
Added prime_potential_change_order_production_quantities.prime_contract_change_order_id
Added prime_potential_change_order_production_quantities.wbs_code_id
project:
Added project.code
owner_invoices:
Added owner_invoices.Tax_Applicable_To_This_Payment
timecard_entries:
Added timecard_entries.user_id
Analytics 2.0 Data Updates (12/17/2024)
Procore has added (current_step_due_date) to the following models (tables):
budget_change_workflow_steps
commitment_change_order_workflow_steps
commitment_pco_workflow_responses
commitment_workflow_step_occurrences
owner_invoice_workflow_steps
prime_contract_change_order_workflow_steps
prime_contract_pco_workflow_steps
prime_contract_workflow_steps
subcontractor_invoice_workflow_steps
Procore has added the following fields:
actual_production_quantities.wbs_code_id
timecard_entries.user_id