Change Log
Below are the notable changes to the Procore Data Extract integration.
Recent Changes
New SQL Views for Procore's Admin Tool(11/15/2021)
- Added: New table called WbsCode that reports on WBS data in the following columns:
- id
- wbs_code
- description
- segment_items
- created_at
- updated_at
- CompanyID
- ProjectID
- DateUpdated
- Added: New table called WbsSegment that reports on WBS data in the following columns:
- id
- segment_type
- name
- structure
- created_at
- updated_at
- CompanyID
- DateUpdated
- Added: New table called WbsSegmentItem that reports on WBS data in the following columns:
- id
- segment_type
- segment_id
- code
- name
- parent_id
- status
- extra_attrs
- created_at
- updated_at
- CompanyID
- ProjectID
- DateUpdated
- Added: New table called WbsSegmentItemHierarchy that reports on WBS data in the following columns:
- descendant_segment_item_id
- descendant_segment_item_type
- hierarchy
- tier
- CompanyID
- DateUpdated
- Added: New view called vwWbsSegmentItem that reports on WBS data in the following columns:
- descendant_segment_item_id
- descendant_segment_item_type
- hierarchy
- tier
- descendant_segment_item_code
- descendant_segment_item_name
- descendant_segment_item_parent_id
- descendant_segment_item_status
- descendant_segment_item_extra_attr
- descendant_segment_item_created_at
- descendant_segment_item_updated_at
- segment_name
- segment_structure
- segment_id
- segment_type
- wbs_code_id
- wbs_code
- CompanyID
- ProjectID
New SQL Views for Procore's Commitments Tool (09/21/2021)
- Added: New SQL view called vwWorkOrderContractCustomField that reports on subcontract custom field data for the project's Commitments tool in the following columns:
- WorkOrderContract_ID
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id
- Added: New SQL view called vwPurchaseOrderContractCustomField that reports on purchase order custom field data for the project's Commitments tool in the following columns:
- PurchaseOrderContractID
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id
New Reportable Fields from Procore's Commitments Tool (09/21/2021)
- Added: New reportable field in the WorkOrderContract and PurchaseOrderContract tables based on user-defined custom fields for the project's Commitments tool:
- custom_fields_v2
Important
custom_fields has been migrated to a new field. Any of your company's custom Procore Analytics reports using custom_fields with data from Procore's Commitments tool need to be updated. See the Purchase Orders and Subcontracts fieldset information in Update Custom Procore Analytics Reports Using Legacy Custom Fields.New SQL View for Procore's Prime Contracts Tool (09/21/2021)
- Added: New SQL view called vwPrimeContractCustomField that reports on custom field data for the project's Prime Contracts tool in the following columns:
- PrimeContract_ID
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id
New Reportable Field from Procore's Prime Contracts Tool (09/21/2021)
- To Be Added: New reportable field in the PrimeContract table based on user-defined custom fields for the project's Prime Contracts tool:
- custom_fields_v2
Important
custom_fields has been migrated to a new field. Any of your company's custom Procore Analytics reports using custom_fields with data from Procore's Prime Contracts tool need to be updated. See the Prime Contracts fieldset information in Update Custom Procore Analytics Reports Using Legacy Custom Fields.New Reportable Fields from Procore's Inspections Tool (08/19/2021)
- Added: New reportable fields in the Checklist table:
- closed_by_id
- closed_by_name
- closed_by_login
New Reportable Fields from Procore's Admin Tool (08/13/2021)
- Added: New reportable field in the Project table based on user-defined custom fields for the 'Project' fieldset:
- custom_fields_v2
Important
Project.custom_fields has been migrated to a new field. Any of your company's custom Procore Analytics reports using Project.custom_fields need to be updated. See Update Custom Procore Analytics Reports Using 'Project' Custom Fields.
New SQL View for Procore's Admin Tool (08/13/2021)
- Added: New SQL view called vwProjectCustomField that reports on custom field data for the 'Project' fieldset:
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id
New Table and Reportable Fields from Procore's Invoicing Tool (08/06/2021)
- Added: New table called DrawRequestLineItem and reportable fields that report on schedule of value data for subcontractor invoices:
- id
- amount
- company_id
- company_name
- cost_code_id
- cost_code_biller
- cost_code_biller_id
- cost_code_biller_type
- cost_code_code
- cost_code_created_at
- cost_code_deleted_at
- cost_code_full_code
- cost_code_name
- cost_code_origin_data
- cost_code_origin_id
- cost_code_parent_id
- cost_code_position
- cost_code_sortable_code
- cost_code_updated_at
- created_at
- description
- extended_type
- holder_id
- holder_type
- line_item_type_id
- line_item_type_name
- line_item_type_code
- line_item_type_base_type
- origin_data
- origin_id
- position
- quantity
- total_amount
- unit_cost
- uom
- updated_at
- infoJson
- DirectCostID
- ProjectID
- DateUpdated
New Reportable Fields from Procore's Timecard Tool (07/23/2021)
- Added: New reportable fields in the TimeCardEntry table:
- CompanyID
- daily_log_header_id
- line_item_type_id
- signed
- timecard_status
- location_full_name
- classification_id
- classification_name
- classification_abbreviation
New Reportable Field from Procore's RFIs Tool (06/30/2021)
- Added: New reportable fields in the RFI table:
- prefix
- full_number
New Reportable Field from Procore's RFIs Tool (06/04/2021)
- Added: New reportable field in the RFI table based on user-defined custom fields for the project's RFIs tool:
- custom_fields
New SQL View for Procore's RFIs Tool (06/04/2021)
- Added: New SQL view called vwRFICustomField that reports on custom field data for the project's RFIs tool in the following columns:
- RFIID
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id
New Reportable Fields from Procore's Submittals Tool (03/03/2021)
- Added: New reportable fields in the Submittal table:
- actual_delivery_date
- CompanyID
- confirmed_delivery_date
- custom_textarea_1
- custom_textfield_1
- description
- design_team_review_time
- internal_review_time
- lead_time
- required_on_site_date
- cost_code_id
- cost_code_name
- location_created_at
- location_updated_at
- task_id
- task_name
- task_key
- status_id
- open_date
- Added: New reportable field in the SubmittalBallInCourt table:
- CompanyID
- Added: New reportable fields in the SubmittalApprover table:
- CompanyID
- approval_sequence_number
- approver_days_to_respond
- created_at
- updated_at
- response_required
New Reportable Field from Procore's Correspondence Tool (02/17/2021)
- Added: New reportable field in the Correspondence table based on user-defined custom fields for the project's Correspondence tool:
- custom_fields
New SQL View for Procore's Correspondence Tool (02/17/2021)
- Added: New SQL view called vwCorrespondenceCustomField that reports on custom field data for the project's Correspondence tool in the following columns:
- CorrespondenceID
- ProjectID
- company_id
- custom_field_key
- custom_field_key_label
- custom_field_id
- custom_field_data_type
- custom_field_value
- custom_field_option_id