Skip to main content
Procore

2020

  1. Last updated
  2. Save as PDF

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

New Reportable Field from Procore's Daily Log Tool (12/10/2020)
  • Added: New reportable field in the DailyLogNote table based on user-defined custom fields for the Notes Log in the project's Daily Log tool:
    • custom_fields
New SQL View for Procore's Daily Log Tool (12/10/2020)
  • Added: New SQL view called vwDailyLogNoteCustomField that reports on custom field data for the Notes Log in the project's Daily Log tool in the following columns:
    • DailyLogNoteID
    • 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 Tables and Reportable Fields from Procore's Correspondence Tool (12/7/2020)

Note: Reportable data from correspondence items that are marked 'Private' (where private = 'true') excludes identifiable information.

  • Added: New Correspondence table and reportable fields:
    • id
    • generic_tool_id
    • CompanyID
    • ProjectID
    • closed_at
    • created_at
    • updated_at
    • description
    • due_date
    • issued_at
    • position
    • full_position
    • private
    • schedule_impact_status
    • schedule_impact_value
    • cost_impact_status
    • cost_impact_value
    • status
    • title
    • created_by_name
    • created_by_company_id
    • created_by_contacts_company_name
    • created_by_login
    • received_from_name
    • received_from_company_id
    • received_from_contacts_company_name
    • received_from_login
    • location_id
    • location_name
    • location_node_name
    • location_parent_id
    • location_created_at
    • location_updated_at
    • cost_code_id
    • cost_code_full_code
    • cost_code_name
    • specification_section_id
    • specification_section_number
    • specification_section_description
    • specification_section_label
    • specification_section_current_revision_id
    • trade_id
    • trade_name
    • trade_active
    • trade_updated_at
    • generic_tool_abbreviation
    • DateUpdated
  • Added: New CorrespondenceAssignee table and reportable fields:
    • id
    • CorrespondenceID
    • CompanyID
    • ProjectID
    • created_at
    • updated_at
    • login
    • name
    • contacts_company_id
    • contacts_company_name
    • DateUpdated
  • Added: New CorrespondenceAttachment table and reportable fields:
    • id
    • CorrespondenceID
    • CompanyID
    • ProjectID
    • filename
    • created_at
    • updated_at
    • DateUpdated
  • Added: New CorrespondenceDistributionMember table and reportable fields:
    • id
    • CorrespondenceID
    • CompanyID
    • ProjectID
    • created_at
    • updated_at
    • login
    • name
    • contacts_company_id
    • contacts_company_name
    • DateUpdated
  • Added: New CorrespondenceResponse table and reportable fields:
    • id
    • CorrespondenceID
    • CompanyID
    • ProjectID
    • notes
    • created_at
    • updated_at
    • official
    • position
    • status
    • created_by_name
    • created_by_company_id
    • created_by_contacts_company_name
    • created_by_login
    • DateUpdated
  • Added: New CorrespondenceResponseAttachment table and reportable fields:
    • id
    • CorrespondenceID
    • CompanyID
    • ProjectID
    • CorrespondenceResponseID
    • filename
    • created_at
    • updated_at
    • DateUpdated
New Reportable Field from Procore's Inspections Tool (11/6/2020)
  • Added: New reportable field in the Checklist table based on user-defined custom fields for the Project level Inspections tool:
    • custom_fields
New SQL View for Procore's Inspections Tool (11/6/2020)
  • Added: New SQL view called vwChecklistCustomField that reports on custom field data for the Project level Inspections tool in the following columns:
    • ChecklistID
    • 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 Punch List Tool (11/6/2020)
  • Added: New reportable field in the PunchItem table based on user-defined custom fields for the project's Punch List tool:
    • custom_fields
New SQL View for Procore's Punch List Tool (11/6/2020)
  • Added: New SQL view called vwPunchItemCustomField that reports on custom field data for the project's Punch List tool in the following columns:
    • PunchItemID
    • 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 Daily Log Tool (11/6/2020)
  • Added: New reportable field in the DailyLogVisitor table based on user-defined custom fields for the Visitor's Log in the project's Daily Log tool:
    • custom_fields
New SQL View for Procore's Daily Log Tool (11/6/2020)
  • Added: New SQL view called vwDailyLogVisitorCustomField that reports on custom field data for the Visitor's Log in the project's Daily Log tool in the following columns:
    • DailyLogVisitorID
    • 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 Tables and Reportable Fields from Procore's Incidents Tool (10/29/2020)
  • Added: New reportable field in the Incident table:
    • custom_fields
  • Added: New reportable fields in the IncidentEnvironmental table:
    • custom_fields
    • recordable
  • Added: New reportable fields in the IncidentInjury table:
    • custom_fields
    • affliction_type_id
    • affliction_type_name
    • affliction_type_active
    • affliction_type_global
    • affliction_type_created_at
    • affliction_type_updated_at
  • Added: New reportable fields in the IncidentInjuryAffliction table:
    • affliction_type_active
    • affliction_type_created_at
    • affliction_type_updated_at
  • Added: New reportable fields in the IncidentNearMiss table:
    • custom_fields
    • affected_party_id
    • affected_party_name
    • recordable
    • updated_at
  • Added: New reportable fields in the IncidentPropertyDamage table:
    • custom_fields
    • recordable
  • Added: New reportable fields in the IncidentWitnessStatement table:
    • custom_fields
    • incident_id
  • Added: New IncidentAction table and reportable fields:
    • id
    • incident_id
    • action_type_id
    • action_type_name
    • action_type_active
    • action_type_global
    • action_type_created_at
    • action_type_updated_at
    • description
    • description_plain_text
    • created_at
    • deleted_at
    • updated_at
    • observation_id
    • custom_fields
    • IncidentID
    • ProjectID
    • CompanyID
    • DateUpdated
  • Added: New IncidentActionAttachment table and reportable fields:
    • id
    • url
    • thumbnail_url
    • name
    • content_type
    • IncidentActionID
    • IncidentID
    • ProjectID
    • CompanyID
    • DateUpdated
  • Added: New IncidentAttachment table and reportable fields:
    • id
    • url
    • thumbnail_url
    • name
    • content_type
    • IncidentID
    • ProjectID
    • CompanyID
    • DateUpdated
  • Added: New IncidentInjuryBodyPart table and reportable fields:
    • id
    • name
    • selectable
    • created_at
    • updated_at
    • parent_id
    • IncidentInjuryID
    • IncidentID
    • ProjectID
    • CompanyID
    • DateUpdated
  • Added: New IncidentWitnessStatementAttachment table and reportable fields:
    • id
    • url
    • thumbnail_url
    • name
    • content_type
    • IncidentWitnessID
    • IncidentID
    • ProjectID
    • CompanyID
    • DateUpdated
New SQL Views for Procore's Incidents Tool (10/29/2020)
  • Added: New SQL view called vwIncidentActionCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentActionID
    • 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 vwIncidentCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentID
    • 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 vwIncidentEnvironmentalCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentEnvironmentalID
    • 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 vwIncidentInjuryCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentInjuryID
    • 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 vwIncidentNearMissCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentNearMissID
    • 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 vwIncidentPropertyDamageCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentPropertyDamageID
    • 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 vwIncidentWitnessStatementCustomField that reports on custom field data for the project's Incidents tool in the following columns:
    • IncidentWitnessStatementID
    • 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 Submittals Tool (10/16/2020)
  • Added: New reportable field in the Submittal table based on user-defined custom fields for the project's Submittals tool:
    • custom_fields
New SQL Views for Procore's Submittals Tool (10/16/2020)
  • Added: New SQL view called vwSubmittalCustomField that reports on custom field data for the project's Submittals tool in the following columns:
    • SubmittalID
    • 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 Tools Supporting Custom Fields (9/24/2020)
New Reportable Field from Procore's Daily Log Tool (9/24/2020)
  • Added: New reportable field in the DLManpower table based on user-defined custom fields for the Manpower Log in the project's Daily Log tool:
    • custom_fields
New Reportable Field from Procore's Observations Tool (9/24/2020)
  • Added: New reportable field in the Observation table based on user-defined custom fields for the project's Observations tool:
    • custom_fields
New SQL Views for Procore's Daily Log and Observations Tools (9/24/2020)
  • Added: New SQL view called vwDailyLogManpowerCustomField that reports on custom field data for the project's Daily Log tool in the following columns:
    • DailyLogManpowerID
    • 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 vwObservationCustomField that reports on custom field data for the project's Observations tool in the following columns:
    • ObservationID
    • 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 New Reportable Fields from Procore's Change Events Tool (6/10/2020)
  • Added: New reportable fields in the ChangeEventRFQResponse table:
    • id
    • comment
    • created_at
    • deleted_at
    • updated_at
    • created_by_id
    • created_by_login
    • created_by_name
    • ChangeEventRFQID
    • ChangeEventID
    • ProjectID
    • DateUpdated
New Reportable Fields from Procore's Daily Log Tool (6/5/2020)
  • Added: New reportable fields in the DailyLogConstructionReport table:
    • local_city_hours
    • local_county_hours
    • minority_hours
    • first_year_hours
    • position
    • veteran_hours
    • women_hours
    • trade_is_active
    • trade_updated_at
New Table and New Reportable Fields from Procore's Punch List Tool (5/22/2020)
  • Added: New reportable fields in the PunchItemBallInCourt table:
    • id
    • name
    • login
    • locale
    • PunchItemID
    • ProjectID
    • DateUpdated
New Table and New Reportable Fields from Procore's Daily Log Tool (4/11/2020)
  • Added: New reportable fields in the DailyLogHeader table:
    • id
    • log_date
    • completed
    • completed_at
    • completed_by_id
    • completed_by_login
    • completed_by_name
    • completable
    • distributed_at
    • distributed
    • distributable
    • ProjectID
    • DateUpdated
Data Type Updated for Various Columns (3/28/2020)
  • Updated: The following columns have had their data type upgraded to bigint:
    • Bid.CompanyID
    • BudgetForecastLineItem.ProjectID
    • BudgetModification.ProjectID 
    • BudgetView.ProjectID 
    • BudgetViewDetail.ProjectID 
    • BudgetViewSnapshot.ProjectID 
    • BudgetViewSnapshotDetail.ProjectID 
    • BudgetViewSummary.ProjectID 
    • CBIBudgetViewDetailSnapshot.ProjectID 
    • CBIBudgetViewDetailSnapshot.CompanyID 
    • CBIDataCountHistory.ProjectID 
    • CBIKPI.CompanyID 
    • ChangeEvent.ProjectID 
    • ChangeEventLineItem.ProjectID 
    • ChangeEventRFQ.ProjectID 
    • ChangeEventRFQQuote.ProjectID 
    • ChangeOrderPackage.ProjectID 
    • ChangeOrderPackageLineItem.ProjectID 
    • ChangeOrderPackageLineItemMarkupLineItem.ProjectID 
    • ChangeOrderPotential.ProjectID 
    • ChangeOrderPotentialLineItem.ProjectID 
    • ChangeOrderRequest.ProjectID 
    • Checklist.ProjectID 
    • ChecklistDistributionMember.ProjectID 
    • ChecklistInspector.ProjectID 
    • ChecklistItem.ProjectID 
    • ChecklistItemComment.ProjectID 
    • ChecklistItemHistory.ProjectID 
    • ChecklistItemObservation.int 
    • ChecklistItemObservation.ProjectID 
    • ChecklistSignatureRequest.ProjectID 
    • Company.id 
    • CompanyChangeOrderReason.CompanyID 
    • CompanyUser.CompanyID 
    • CompanyVendor.CompanyID 
    • CompanyVendorInsurance.CompanyID 
    • CoordinationIssue.ProjectID 
    • CoordinationIssueLinkedProcoreItem.ProjectID 
    • CoordinationIssueViewpoint.ProjectID 
    • CostCode.CompanyID 
    • CostCodeList.CompanyID 
    • DailyLogAccident.ProjectID 
    • DailyLogCall.ProjectID 
    • DailyLogConstructionReport.ProjectID 
    • DailyLogConstructionReportAttachment.ProjectID 
    • DailyLogDelay.ProjectID 
    • DailyLogDelayAttachment.ProjectID 
    • DailyLogDelivery.ProjectID 
    • DailyLogDeliveryAttachment.ProjectID 
    • DailyLogDumpster.ProjectID 
    • DailyLogEquipment.ProjectID 
    • DailyLogInspection.ProjectID 
    • DailyLogManpower.ProjectID 
    • DailyLogManpowerAttachment.ProjectID 
    • DailyLogNote.ProjectID 
    • DailyLogNoteAttachment.ProjectID 
    • DailyLogPlanRevision.ProjectID 
    • DailyLogProductivity.ProjectID 
    • DailyLogQuantity.ProjectID 
    • DailyLogSafetyViolation.ProjectID 
    • DailyLogVisitor.ProjectID 
    • DailyLogWaste.ProjectID 
    • DailyLogWeather.ProjectID 
    • DailyLogWork.ProjectID 
    • DailyLogWorkScheduleTask.ProjectID 
    • DirectCost.ProjectID 
    • DirectCostLineItem.ProjectID 
    • DrawingRevision.ProjectID 
    • DrawRequest.ProjectID 
    • Form.ProjectID 
    • Incident.ProjectID 
    • IncidentDistributionMember.ProjectID 
    • IncidentEnvironmental.ProjectID 
    • IncidentInjury.ProjectID 
    • IncidentInjuryAffliction.ProjectID 
    • IncidentNearMiss.ProjectID 
    • IncidentPropertyDamage.ProjectID 
    • IncidentWitnessStatement.ProjectID 
    • Location.ProjectID 
    • Log.ProjectID
    • Meeting.ProjectID 
    • Observation.ProjectID 
    • ObservationDistributionMember.ProjectID 
    • ObservationDrawing.ProjectID 
    • ObservationDrawingRevision.ProjectID 
    • Photo.ProjectID 
    • PrimeContract.ProjectID 
    • PrimeContractLineItem.ProjectID 
    • PrimeContractPayApp.ProjectID 
    • PrimeContractPayAppLineItem.ProjectID 
    • PrimeContractPayment.ProjectID 
    • ProductionQuantityActual.projectID 
    • ProductionQuantityActualEmployee.ProjectID 
    • ProductionQuantityBudgeted.ProjectID 
    • ProductionReportSummary.ProjectID 
    • Project.id 
    • Project.parent_job_id
    • Project.company_id 
    • ProjectCostCode.ProjectID 
    • ProjectDate.ProjectID 
    • ProjectDepartment.ProjectID 
    • ProjectRole.ProjectID 
    • ProjectTask.ProjectID 
    • ProjectTool.ProjectID 
    • ProjectUser.ProjectID 
    • ProjectVendor.ProjectID 
    • ProjectVendorInsurance.ProjectID 
    • PunchItem.ProjectID 
    • PunchItemAssignee.ProjectID 
    • PunchItemAssignment.ProjectID 
    • PurchaseOrderContract.ProjectID 
    • PurchaseOrderContractChangeOrderPackage.ProjectID 
    • PurchaseOrderContractChangeOrderPackageLineItem.ProjectID 
    • PurchaseOrderContractChangeOrderPackageLineItemMarkupLineItem.ProjectID 
    • PurchaseOrderContractChangeOrderPotential.ProjectID 
    • PurchaseOrderContractChangeOrderRequest.ProjectID 
    • PurchaseOrderContractInvoiceContact.ProjectID 
    • PurchaseOrderContractLineItem.ProjectID 
    • PurchaseOrderContractPaymentIssued.ProjectID 
    • RFI.ProjectID 
    • RFIAssignee.ProjectID 
    • RFIBallInCourt.ProjectID 
    • RFIDistributionList.ProjectID 
    • RFIDrawing.ProjectID 
    • RFIQuestion.ProjectID 
    • RFIQuestionAnswer.ProjectID 
    • ScheduleTask.ProjectID 
    • ScheduleToDo.ProjectID 
    • SubJob.ProjectID 
    • Submittal.ProjectID 
    • SubmittalApprover.ProjectID 
    • SubmittalBallInCourt.ProjectID 
    • TimeCardEntry.ProjectID 
    • WorkflowCurrentActivity.CompanyID 
    • WorkflowInstance.CompanyID 
    • WorkOrderContract.ProjectID 
    • WorkOrderContractChangeOrderPackage.ProjectID
    • WorkOrderContractChangeOrderPackageLineItem.ProjectID 
    • WorkOrderContractChangeOrderPackageLineItemMarkupLineItem.ProjectID 
    • WorkOrderContractChangeOrderPotential.ProjectID
    • WorkOrderContractChangeOrderRequest.ProjectID
    • WorkOrderContractInvoiceContact.ProjectID 
    • WorkOrderContractLineItem.ProjectID 
    • WorkOrderContractPaymentIssued.ProjectID 
       
New Reportable Fields from Procore's Commitments Tool (2/23/2020)
  • Added: New reportable fields in the PurchaseOrderContract table:
    • approval_letter_date
    • contract_date
    • execution_date
    • issued_on_date
    • letter_of_intent_date
    • returned_date
  • Added: New reportable fields in the WorkOrderContract table:
    • approval_letter_date
    • contract_date
    • execution_date
    • issued_on_date
    • letter_of_intent_date
    • returned_date