Skip to main content
Procore

Change Log

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

Recent Changes

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. 

Procore Analytics: New Reportable Fields for Commitment Change Order Line Items (11/30/2022)

As a follow-up to the Procore Analytics: Q4 2022 Release, Procore has added these new reportable table data for commitment change order line items:

  • Added: New reportable table PurchaseOrderContractChangeOrderPackageLineItem with fields below:
    • id
    • position
    • description
    • quantity
    • uom
    • total_amount
    • extended_amount
    • unit_cost
    • created_at
    • updated_at
    • holder_id
    • holder_holder_type
    • infoJson
    • PurchaseOrderContractChangeOrderPackageID
    • PurchaseOrderContractID
    • ProjectID
    • CompanyID
    • DateUpdated
    • wbs_code_id
    • HashID
    • ChangeEventLineItemID
    • tax_code
  • Added: New reportable table PurchaseOrderContractChangeOrderPackageLineItemMarkupLineItem with fields below:
    • id
    • amount
    • created_at
    • updated_at
    • markup_id
    • markup_position
    • markup_markup_set
    • markup_name
    • markup_percentage
    • markup_compounds_markups_above
    • markup_created_at
    • markup_updated_at
    • infoJson
    • PurchaseOrderContractChangeOrderPackageLineItemID
    • PurchaseOrderContractChangeOrderPackageID
    • PurchaseOrderContractID
    • ProjectID
    • CompanyID
    • DateUpdated
    • HashID
  • Added: New reportable table WorkOrderContractChangeOrderPackageLineItem with fields below:
    • id
    • position
    • description
    • quantity
    • uom
    • total_amount
    • extended_amount
    • unit_cost
    • created_at
    • updated_at
    • holder_id
    • holder_holder_type
    • infoJson
    • WorkOrderContractChangeOrderPackageID
    • WorkOrderContractID
    • ProjectID
    • CompanyID
    • DateUpdated
    • wbs_code_id
    • HashID
    • ChangeEventLineItemID
    • tax_code
  • Added: New reportable table WorkOrderContractChangeOrderPackageLineItemMarkupLineItem with fields below:
    • id
    • amount
    • created_at
    • updated_at
    • markup_id
    • markup_position
    • markup_markup_set
    • markup_name
    • markup_percentage
    • markup_compounds_markups_above
    • markup_created_at
    • markup_updated_at
    • infoJson
    • WorkOrderContractChangeOrderPackageLineItemID
    • WorkOrderContractChangeOrderPackageID
    • WorkOrderContractID
    • ProjectID
    • CompanyID
    • DateUpdated
    • HashID

Correspondence Tool: Trades Data (10/27/2022)

Procore Data Extract now receives multiple concatenated values in the 'Correspondence' table fields named below:

Field Description Delimiter Ordered By
trade_name Expands the field to the varchar(max) format. Contains concatenated trade names.  Pipe (|) Trade Name
trade_updated_at Contains the date of the last updated trade.   Trade Name

In addition to the Trades data detailed above, Procore has also released an update for Procore Analytics. This update includes a new Action Plan Report and an updated Financials Budget Report to support custom budget views. To learn more, see Procore Analytics: Q4 2022 Release

NEW REPORTABLE FIELDS FROM PROCORE'S BUDGET TOOL (09/27/2022)

  • Added: New reportable fields in the BudgetChange table:
    • id
    • created_at
    • updated_at
    • created_by_id
    • created_by_login
    • created_by_name
    • number
    • title
    • status
    • description
    • last_write_from
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the BudgetChangeAdjustmentLineItem table:
    • id
    • created_at
    • updated_at
    • adjustment_id
    • adjustment_number
    • adjustment_description
    • adjustment_comment
    • adjustment_quantity
    • adjustment_amount
    • adjustment_unit_cost
    • adjustment_uom
    • adjustment_calculation_strategy
    • budget_change_id
    • description
    • comment
    • quantity
    • amount
    • unit_cost
    • uom
    • calculation_strategy
    • wbs_code_id
    • change_event_line_item_id
    • type
    • ProjectID
    • DateUpdated

NEW REPORTABLE FIELDS FROM PROCORE'S ACTION PLANS TOOL (09/27/2022)

  • Added: New reportable fields in the ActionPlan table:
    • id
    • created_at
    • updated_at
    • title
    • description
    • description_plain_text
    • number
    • manager_id
    • manager_name
    • manager_login
    • manager_email_address
    • location_id
    • location_name
    • location_full_name
    • status_name
    • type_name
    • created_by_id
    • created_by_login
    • created_by_email
    • created_by_name
    • template_id
    • template_name
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanApprover table:
    • id
    • created_at
    • updated_at
    • ActionPlanId
    • party_id
    • approver_name
    • approver_login
    • approver_email_address
    • signed_by_id
    • signed_by_login
    • signed_at
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanAssignee table:
    • id
    • created_at
    • updated_at
    • party_id
    • assignee_name
    • assignee_login
    • assignee_email_address
    • role_name
    • captured_by_id
    • captured_by_login
    • verification_method_id
    • verification_method_name
    • is_locked
    • is_holding
    • ActionPlanItemId
    • ProjectID
    • DateUpdated
    • captured_at
  • Added: New reportable fields in the ActionPlanChangeHistory table:
    • id
    • created_at
    • updated_at
    • ActionPlanId
    • event_type
    • event_data
    • created_by_id
    • created_by_login
    • created_by_name
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanItem table:
    • id
    • created_at
    • updated_at
    • title
    • description
    • position
    • ActionPlanId
    • section_id
    • section_name
    • section_position
    • due_at
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanItemRecord table:
    • id
    • created_at
    • updated_at
    • ActionPlanRecordRequestId
    • ActionPlanItemId
    • record_type_name
    • checklist_id
    • prostore_file_id
    • generic_tool_item_id
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanItemRecordRequest table:
    • id
    • created_at
    • updated_at
    • ActionPlanItemId
    • record_type_name
    • prostore_file_id
    • generic_tool_item_id
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanItemReference table:
    • id
    • created_at
    • updated_at
    • ActionPlanItemId
    • specification_section_id
    • drawing_id
    • drawing_title
    • drawing_number
    • drawing_revision_id
    • drawing_revision
    • submittal_log_id
    • prostore_file_id
    • file_name
    • file_url
    • ProjectID
    • DateUpdated
  • Added: New reportable fields in the ActionPlanReceiver table:
    • id
    • created_at
    • updated_at
    • ActionPlanId
    • party_id
    • receiver_name
    • receiver_login
    • receiver_email_address
    • signed_by_id
    • signed_by_login
    • signed_at
    • ProjectID
    • DateUpdated

New Reportable FielDs (06/22/2022)

  • Added: New reportable fields in the PurchaseOrderContractChangeOrderPackageLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the PrimeContractPayAppLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the PurchaseOrderContractLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the ChangeEventLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the ChangeOrderPackageLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the ChangeOrderPackageLineItemMarkupLineItem table:
    • wbs_code_id

New Reportable FielDs (03/29/2022)

  • Added: New reportable fields in the BudgetViewDetail table:
    • wbs_code_id
  • Added: New reportable fields in the BudgetViewSnapshotDetail table:
    • wbs_code_id
  • Added: New reportable fields in the ChangeOrderPotentialLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the DirectCostLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the DrawRequestLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the PrimeContractLineItem table:
    • wbs_code_id
  • Added: New reportable fields in the WorkOrderContractLineItem table:
    • wbs_code_id

Previous Changes