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