Change Log

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.