Skip to main content
Procore

Change Log

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

Recent Changes

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

 

  • Was this article helpful?