Skip to main content
Procore

Change Log

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

Recent Changes

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?