Analytics - Data Change Log
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 (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