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)
- Added: New reportable fields in the CustomField table based on user-defined custom fields for supported tools (see What are custom fields and which Procore tools support them?)
- id
- label
- active
- data_type
- variant
- description
- CompanyID
- DateUpdated
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