Skip to main content
Procore

Change Log

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

Recent Changes

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 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

Upcoming Changes

Limited Release

The following changes are releasing in phases but may already be available in your company's Procore Data Extract experience. These changes may not yet be reflected in Procore Analytics templates.

New Table and Reportable Fields from Procore's Invoicing Tool

  • 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

Coming Soon

The following changes are in development and will be available in your company's Procore Data Extract experience and reflected in Procore Analytics templates in the future.

New SQL Views for Procore's Commitments Tool

  • To be 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
  • To be 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

  • To Be 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 will be migrated to a new field starting mid to late September. After the migration is complete, any of your company's custom Procore Analytics reports using custom_fields will need to be updated. Contact analyticssupport@procore.com for more information.

New SQL View for Procore's Prime Contracts Tool

  • To Be 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

  • 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 will be migrated to a new field starting mid to late September. After the migration is complete, any of your company's custom Procore Analytics reports using custom_fields will need to be updated. Contact analyticssupport@procore.com for more information.

New SQL Views for Procore's Admin Tool

  • To Be Added: New SQL view called WbsCode that reports on WBS data in the following columns:
    •  id
    • wbs_code
    • description
    • segment_items
    • created_at
    • updated_at
    • CompanyID
    • ProjectID
    • DateUpdated
  • To Be Added: New SQL view called WbsSegment that reports on WBS data in the following columns:
    • id
    • segment_type
    • name
    • structure
    • created_at
    • updated_at
    • CompanyID
    • DateUpdated
  • To Be Added: New SQL view 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

Previous Changes