Change Log

Below are the notable changes to the Procore Data Extract integration.

Recent Changes

Procore Analytics: New Reportable Fields Added Across Existing tables (04/26/2024)

Procore has added CompanyID to the following tables:

  • BudgetViewSnapshot
  • WorkOrderContract
  • WorkOrderContractChangeOrderPackage
  • WorkOrderContractChangeOrderPotential
  • WorkOrderContractChangeOrderRequest
  • WorkOrderContractInvoiceContact
  • WorkOrderContractPaymentIssued

PROCORE ANALYTICS: New additions and updates to existing tables (11/22/2023)

Procore is adding the following column to the ChangeEventLineItems table:

  • budget_change_adjustment_id

Procore has made the following data type changes:

  • Upgraded [amount] to DECIMAL(30,12) on ChangeOrderPackageLineItemMarkupLineItem table
  • Upgraded [amount] to DECIMAL(18,2) on BudgetForecastLineItem table
  • Upgraded [unit_cost] to DECIMAL(18,2) on BudgetForecastLineItem table
  • Upgraded [quantity] to DECIMAL(18,2) on BudgetForecastLineItem table

PROCORE ANALYTICS: NEW REPORTABLE FIELDS ADDED ACROSS EXISTING TABLES (10/13/2023)

Procore is adding the following column to the Observations table: 

  • closed_at

PROCORE ANALYTICS: NEW REPORTABLE FIELDS ADDED ACROSS EXISTING TABLES (10/06/2023)

Procore is adding the following columns to the ChangeEventLineItem table:

  • revenue_rom
  • budget_rom
  • prime_potential_change_order_line_item_id
  • commitment_contract_line_item_id
  • commitment_potential_change_order_line_item_id

Procore Analytics: New Reportable Fields Added Across Existing tables (08/01/2023)

Procore has added CompanyID BIGINT NOT NULL to the following tables:

  • RFI
  • RFIDrawing
  • RFIQuestion
  • RFIBallInCourt
  • RFIQuestionAnswer
  • RFIAssignee
  • RFIDistributionList
  • PunchItem
  • PunchItemAssignee
  • PunchItemAssignment
  • PunchItemBallInCourt
  • Observation
  • ObservationDistributionMember
  • ObservationDrawing
  • ObservationDrawingRevision
  • Checklist
  • ChecklistDistributionMember
  • ChecklistInspector
  • ChecklistItem
  • ChecklistItemComment
  • ChecklistItemHistory
  • ChecklistItemObservation
  • ChecklistSignatureRequest
  • DailyLogNote
  • DailyLogNoteAttachment
  • DailyLogManpowerAttachment

Procore Analytics: New Reportable Fields Added Across Existing tables (04/20/2023)

Procore has added the following line items:

  • BudgetViewDetail table:
    • approved_budget_changes
  • ChangeEvent table:
    • CompanyID
  • ChangeEventLineItem table:
    • created_at
    • updated_at
    • CompanyID
  • ChangeEventRFQ table:
    • CompanyID
  • ChangeEventRFQQuote table:
    • CompanyID
  • ChangeEventRFQResponse table:
    • CompanyID
  • Company table:
    • is_demo
  • Correspondence table:
    • sub_job_id
  • DailyLogManpower table:
    • trade_name
  • DailyLogManpowerAttachment table:
    • created_at
    • updated_at
    • CompanyID
  • Project table:
    • accounting_project_number
    • is_demo
    • dictionary_type
  • PurchaseOrderContractChangeOrderPackageLineItem table:
    • ChangeEventLineItemID
    • tax_code
  • WorkOrderContractChangeOrderPackageLineItem table:
    • ChangeEventLineItemID
    • tax_code

Procore Analytics: Budget Snapshot Detail Table (03/17/2023)

Procore Analytics is no longer updating the CBIBudgetSnapshotDetail table.