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