Skip to main content
Procore

Analytics - Data Change Log

  1. Last updated
    Apr 22, 2025
  2. Save as PDF

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