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.

