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