Analytics 2.0

Below are the notable changes to the Procore data and intelligence layer accessible via the Procore Analytics 2.0 Cloud Connector.

Recent Changes

Procore Analytics 2.0 Data Updates (Coming Soon)

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

  • Removed sql

• time_and_material_equipment_custom_field_configs:

  • Removed sql

• time_and_material_labors_custom_field_configs:

  • Removed sql

• time_and_material_material_custom_field_configs:

  • Removed sql

• time_and_material_entry_subcontractor_field_configs:

  • Removed sql

• timecard_entry_custom_field_configs:

  • Removed sql

• 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

• budget_change_custom_fields:

  • Changed custom_field_value_id

• change_event_custom_fields:

  • Changed custom_field_value_id

• commitment_co_custom_fields:

  • Changed custom_field_value_id

• commitment_custom_fields

  • Changed custom_field_value_id

• commitment_pco_custom_fields:

  • Changed custom_field_value_id

• company_folder_documents_custom_fields:

  • Changed custom_field_value_id

• correspondence_custom_fields:

  • Changed custom_field_value_id

• daily_log_accident_custom_fields:

  • Changed custom_field_value_id

• daily_log_construction_report_custom_fields:

  • Changed custom_field_value_id

• daily_log_delay_custom_fields:

  • Changed custom_field_value_id

• daily_log_delivery_custom_fields:

  • Changed custom_field_value_id

• daily_log_dumpster_custom_fields:

  • Changed custom_field_value_id

• daily_log_equipment_custom_fields:

  • Changed custom_field_value_id

• daily_log_inspection_custom_fields:

  • Changed custom_field_value_id

• daily_log_manpower_custom_fields:

  • Changed custom_field_value_id

• daily_log_note_custom_fields:

  • Changed custom_field_value_id

• daily_log_phone_call_custom_fields:

  • Changed custom_field_value_id

• daily_log_plan_revision_custom_fields:

  • Changed custom_field_value_id

• daily_log_productivity_custom_fields:

  • Changed custom_field_value_id

• daily_log_quantity_custom_fields:

  • Changed custom_field_value_id

• daily_log_safety_violation_custom_fields:

  • Changed custom_field_value_id

• daily_log_scheduled_work_custom_fields:

  • Changed custom_field_value_id

• daily_log_visitor_custom_fields:

  • Changed custom_field_value_id

• daily_log_waste_custom_fields:

  • Changed custom_field_value_id

• drawing_revision_custom_fields:

  • Changed custom_field_value_id

• folder_documents_custom_fields:

  • Changed custom_field_value_id

• incident_action_custom_fields:

  • Changed custom_field_value_id

• incident_custom_fields:

  • Changed custom_field_value_id

• incident_record_custom_fields:

  • Changed custom_field_value_id

• incident_witness_statement_custom_fields:

  • Changed custom_field_value_id

• inspection_custom_fields:

  • Changed custom_field_value_id

• observation_custom_fields:

  • Changed custom_field_value_id

• prime_contract_co_custom_fields:

  • Changed custom_field_value_id

• prime_contract_custom_fields:

  • Changed custom_field_value_id

• prime_contract_pco_custom_fields:

  • Changed custom_field_value_id

• project_custom_fields:

  • Changed custom_field_value_id

• punch_item_custom_fields:

  • Changed custom_field_value_id

• rfi_custom_fields:

  • Changed custom_field_value_id

• subcontractor_invoice_custom_fields:

  • Changed custom_field_value_id

• submittal_custom_fields:

  • Changed custom_field_value_id

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 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

• wage_override:

  • Added company_id

  • Added id

  • Added position_id

  • Added rate

  • Added wp_project_id

• commitment_workflow_response_occurrences:

  • Added current_step_response

Procore 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

Procore 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)

Procore 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

Procore 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

Procore 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

Procore 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

Procore 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

Procore Analytics 2.0 Data Updates (04/22/2025)

Procore added the following models (tables):

• budget_forecasts

• 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

Procore 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

Procore 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

Procore 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

Procore 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