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