Skip to main content
Procore

Change Log

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

Recent Changes

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

All Changes