Skip to main content
Procore

Change Log

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

Recent Changes

Coming Soon  New Reportable Fields from Procore's Invoicing Tool

  • Added: New SQL table called DrawRequestLineItem that reports on schedule of value data for subcontractor invoices in the following columns:
    • 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  New Reportable Fields from Procore's Admin Tool

  • Added: New reportable field in the Project table based on user-defined custom fields for the 'Project' fieldset:
    • custom_fields_v2
 Important

custom_fields_v2 will replace Project.custom_fields. Any of your company's custom reports that use Project.custom_fields must be updated to use custom_fields_v2 to ensure full functionality of the reports by July 31, 2021. Contact analyticssupport@procore.com for more information.

 

Coming Soon  New SQL View from Procore's Admin Tool

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

Previous Changes