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.