Analytics - Data Change Log

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