Analytics 2.0 has 3 guiding pillars of value today and in the future to make a user-friendly product that gives access to all of your data, with business intelligence included. Ultimately, this allows you to quickly access any Procore data you need and gain value from it to make informed, data-driven decisions. See Getting Started With Analytics 2.0 to begin your journey today.
User-Friendly
Self-Serviceable - Manage Analytics like any other Procore tool.
Cross Company Access - Easily tie together multiple Procore instances of data with one password.
New Onboarding - A guided onboarding experience that helps you connect to and use Analytics.
Easy Data Exploration - Learn about the data that’s available and interact with it live.
Integrated with Procore - A unified experience in Procore for managing Analytics.
All Your Data
Connectability - Connect to your data across multiple sources, with out of the box PA connectors.
Data Availability (Coming Soon) - Everything you have in Procore, you can pull out of Procore.
Purpose Built Model - A business semantic model built by domain for reporting and analytics.
Bulk Data Extract - All your data is extracted quickly, you choose when you pull it.
Data Reliability - Your data is monitored for accuracy and completeness.
Cloud Connector - Offers real-time data access and integration, enhanced data control and security, advanced analytics capabilities, and operational efficiency and scalability.
Business Intelligence
Intelligence Included - New data tables and fields that turn data into information you can act on.
Predictive Analytics Included - Understand what is likely to happen in the future.
Power BI Reports Included - Power BI Reports with data relationships, KPIs, measures, and visuals.
| Analytics 1.0/Data Extract | Analytics 2.0 | |
| Underlying Technology | Azure SQL | DataBricks |
| Data Refresh | Daily | Hourly |
| Procore Data Availability | Limited | All data from Analytics 1.0 plus new datasets |
| Data Model | Analytics data models are different than Procore's | Analytics data models are the same as Procore's native reporting |
| Authentication | Need separate access token for each company | Only one token is needed for data across all companies |
| Permissions | All or nothing | All or nothing |
| Support Documentation | Limited | Detailed, step-by-step guidance |
There are no items that match your search query.
Using Analytics 2.0, you can view and interact with Analytics data using our out-of-the-box Power BI reports. You do this either within your own environment or using the Analytics embedded app. Analytics reports integrate your company's Procore data using Power BI, providing you with deep insights on various statistics and trends within and across your Procore projects.
For a list of all the available Analytics 2.0 reports, see Analytics 2.0 Report Pages.
Learn which user permissions are required to take the described actions in this tool.
| | The action is available on Procore's Web, iOS, and/or Android application.
Users can take the action with this permission level.
Users can take this action with this permission level AND one or more additional requirements, like granular permissions.
|
Analytics Tutorials |
None |
Read Only |
Standard |
Admin |
Notes |
|---|---|---|---|---|---|
|
Download an Analytics Report |
|
||||
|
Add Custom Views |
|
||||
|
Configure A Custom Budget Report |
|
||||
|
Generate An Access Token |
|
'Admin' level permissions give users access to data for all tools and projects (except certain data marked as private, such as correspondences). |
|||
|
View a Table in Data Explorer |
|
||||
|
View a Field in Data Explorer |
|
||||
|
Enable Public Links for Photos in Analytics Reports |
|
||||
|
Disable Public Links for Photos in Analytics Reports |
|
||||
|
Refresh Photo Links in Analytics Reports |
|
Below are the notable changes to Analytics 2.0.
Procore has introduced a new "certificates" data model (table) within the Analytics database, allowing you to report on Procore certifications across your company directory without checking individual user accounts. You can use the Analytics Cloud Connector to access certification data and leverage it in reporting tools such as Power BI or in your own data warehouse. This new table enables you to track who holds specific certifications, monitor their progress, and view completion statuses. With these insights, you can quickly audit employees and vendors to verify compliance and ensure all required courses are completed. You can view the fields and corresponding metadata for the new table using the Data Explorer. See About Data Explorer.
Procore now supports public access for all photo links in out-of-the-box Analytics reports, allowing users to view or download photos without a Procore login. This feature simplifies sharing project visuals with external partners and enables seamless integration of Procore photos with third-party reporting tools that do not support authenticated links. Additionally, you can refresh all photo links (public and private) in Analytics reports to automatically generate new and unique links. This functionality allows you to revoke access to old public links that may have been shared with external stakeholders. See Enable or Disable Public Links for Photos in Analytics Reports and Refresh Photo Links in Analytics Reports.
Procore has enhanced the Resource Management report by introducing the Planned vs. Actuals page, enabling users to visually compare planned resource hours and costs against actuals over time. The Planned vs. Actuals report page empowers project teams to identify variances early, track cumulative trends, and analyze productivity by cost code for improved labor cost control. To learn more, see the Resource Management Report.
Procore has introduced the Building Safety Act (BSA) Compliance Scorecard (UK) Report Template, an out-of-the-box Power BI report for UK residential projects. This report provides Dutyholders with an auditable digital record to manage and demonstrate compliance with the BSA 2022. It converts project data into clear, actionable metrics from portfolio-level risk status to task-level tracking. This supports Golden Thread best practices and efficient Gateway 2 submissions while reducing regulatory risk, liability, and approval delays. To learn more, see BSA Compliance Scorecard (UK) Report Template.
Procore has renamed the Procore Analytics 2.0 tool to Analytics 2.0, aligning its name with other Procore solutions. This name change reflects a more streamlined and consistent brand identity across the Procore platform. To learn more, see Analytics 2.0 - Overview.
Procore has implemented a maximum expiration period of 365 days for all Delta Share tokens to improve security adherence. Any active tokens with more than 365 days remaining have been automatically adjusted to expire in 365 days.
Procore has enhanced the Specialty Contractor Report by introducing the Resource Management Overview page. The Resource Management Overview report page provides a comprehensive, 360-degree view of your workforce resources, enabling you to make smarter staffing decisions across your entire project portfolio. To learn more, see Specialty Contractor Report.
Procore has introduced the Data Explorer feature in the Procore Analytics tool, enabling users to access tables, fields, and their associated metadata. Users can use the Data Explorer to discover and understand their data easily. It provides an interactive data dictionary that simplifies the navigation of large data volumes by making metadata more accessible and enhancing the overall experience of data exploration. To learn more, see About Data Explorer.
Procore has made minor UI improvements to the Procore Analytics tool for easier navigation and added descriptions to Power BI reports for enhanced clarity.
Procore Zones offers significant advantages for data storage and analysis in the construction industry by providing a globally available, secure, and scalable platform. It helps ensure optimal performance and continuous access to data, even for large multinational companies, by hosting applications and storing data across multiple data centers with major cloud providers. This robust infrastructure protects against disruptions, maintains compliance with global standards, and facilitates real-time decision-making through AI-powered insights. For more details, see What are Procore Zones?.
Procore has introduced the ability to select multiple budget views in Procore Analytics, streamlining the budgeting process for construction stakeholders. This feature allows users to select multiple budget views simultaneously, reducing manual entry time and improving data accuracy. To learn more, see Add Custom Views for Procore Analytics.
Procore has introduced an enhanced version of the Speciality Contractor Report using our new Power BI design system.
Procore Analytics 2.0 has launched an incremental refresh feature, which significantly enhances data processing efficiency by only updating changed data. This optimization leads to substantial improvements in performance and significant reductions in resource consumption.
Procore's new Delta Lake time travel feature allows users to query the previous 7 days of table history for all Procore Analytics 2.0 tables, enabling them to recreate past analyses, construct temporal queries, and rectify data errors.
Procore has introduced enhanced versions of existing report templates, as well as new templates, in an open beta for Analytics 2.0. Reports offerings include:
Procore has expanded the capabilities of Procore Analytics by adding user activity data access, enabling Project and Company Admins to gain a comprehensive view of user actions across various tools. The User Activity Data feature allows customers to pull raw user activity from a rolling seven day dataset, facilitating the creation of searchable datasets and aggregations.
Procore has introduced the 'Last Updated' timestamp feature in Procore Analytics 2.0, enhancing data transparency and ensuring stakeholders have access to the most current information. This feature benefits Procore Analytics users by providing clear visibility into data changes, improving collaboration and decision-making.
Procore has introduced a new in-app Procore Analytics Data Connector experience in the Getting Started area of Procore Analytics. This new in-app experience allows customers to select from a menu of connection options to connect to Procore Analytics 2.0. The Procore Analytics Data Connector user experience enables customers to choose their preferred data connection method and access resources like documentation, videos, and executable files to facilitate their connection to Procore Analytics data. See Getting Started With Procore Analytics to learn more.
The Procore Analytics 2.0 Financials Budget Report is now available for customers. This report integrates various financial aspects of project management, helping users track and analyze budget performance in detail. See About Procore Analytics 2.0 to learn more.
Analytics 2.0 is designed to provide deeper insights into project performance and outcomes. Analytics 2.0 introduces several enhancements and new features aimed at improving data accessibility, accuracy, and usability. See About Procore Analytics 2.0 to learn more.
Existing Procore Analytics customers can now join the open beta for Analytics 2.0. Analytics 2.0 is our new and improved Analytics solution offering many enhancements customers have requested. See About Procore Analytics 2.0 to learn more.
Below are the notable changes to the Procore data and intelligence layer accessible via the Analytics 2.0 Cloud Connector.
Procore added the following models (tables) and fields:
Show/Hide
asset:
parent_asset
timecard_entries:
clock_in_onsite
clock_out_onsite
lunch_clock_in_onsite
lunch_clock_out_onsite
document_management_placeholder:
audit_transaction_timestamp
company_id
created_at
created_by
deleted_at
deleted_by
discipline
document_management_placeholder_id
document_management_revision_id
document_management_upload_id
name
originator
overdue_by
partition_company_id
placeholder_assignee
placeholder_due_date
placeholder_overdue
placeholder_status
placeholder_type
project_id
reason_for_deletion
recycled
revision
submitted_at
equipment_rate:
audit_transaction_timestamp
column_type
company_id
created_at
created_by
created_by_id
description
equipment_category
equipment_rate_id
equipment_type
name
rate_category
rate_table_id
rate_value
resource_category
unit_of_measure
updated_at
updated_by
updated_by_id
equipment_timecard_entry_with_rates:
audit_transaction_timestamp
company_id
created_at
currency_iso_code
deleted_at
equipment_cost
equipment_timecard_entry_id
equipment_timecard_entry_with_rates_id
is_deleted
project_id
quantity
rate
rate_value_id
updated_at
incident_root_cause_analysis_custom_fields:
audit_transaction_timestamp
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
incident_root_cause_analysis_custom_field_id
incident_root_cause_analysis_id
project_id
incident_root_cause_analysis:
attachment_count
audit_transaction_timestamp
company_id
contributing_behavior
contributing_condition
created_at
hazard
incident_assignee_ids
incident_created_by_id
incident_id
incident_is_private
incident_root_cause_analysis_id
investigation_details
location_id
project_id
root_cause_analysis_description
updated_at
work_activity
labor_rate:
audit_transaction_timestamp
class_code
classification
column_type
company_id
created_at
created_by
created_by_id
description
labor_rate_id
name
rate_category
rate_table_id
rate_value
resource_category
unit_of_measure
updated_at
updated_by
updated_by_id
value
rate_table:
audit_transaction_timestamp
company_id
created_at
created_by
created_by_id
description
effective_date
expiration_date
is_active
name
project_id
rate_table_id
resource_category
updated_at
updated_by
updated_by_id
timecard_entry_with_rates:
audit_transaction_timestamp
company_id
created_at
currency_iso_code
deleted_at
is_deleted
labor_cost
project_id
rate
rate_value_id
timecard_entry_id
timecard_entry_with_rates_id
updated_at
locations:
geo_json
geo_json_wkt
direct_cost_line_items:
is_billable
prefilled_to_owner_invoice_id
prefilled_to_owner_invoice_line_item_id
owner_invoice_adjustments:
owner_invoice_adjustment_id
work_completed_this_period
description
created_at
updated_at
company_id
project id
owner_invoice_custom_fields:
audit_transaction_timestamp
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
owner_invoice_custom_field_id
owner_invoice_id
project_id
owner_invoice_line_item_with_markups_relations:
owner_invoice_custom_field_id
subcontractor_invoice_line_items:
is_billable
prefilled_to_owner_invoice_id
prefilled_to_owner_invoice_line_item_id
subcontractor_invoice_line_items_relations:
owner_invoice_id
owner_invoice_line_item_id
incident_witness_statement:
signature_captured_at
signature_captured_by
signature_captured_by_id
signed
materials_receipt:
commitment_change_order_id
commitment_change_order_line_item_id
commitment_id
commitment_line_item_id
Procore added the following models (tables) and fields:
Show/Hide
incident:
type_id
type
inspection_templates:
inspection_template_id
company_id
project_id
origin_id
name
origin_template_name
description
inspection_type_id
inspection_type
inspection_type_group
trade_id
trade
alternative_response_set_id
created_by_id
created_by_name
is_project_level
is_synced_from_company
is_active
project_count
assigned_projects
created_at
updated_at
inspection_template_items:
inspection_template_item_id
inspection_template_id
company_id
project_id
section_id
section_name
section_position
name
position
position_number
response_set_id
response_set_name
response_type
has_observation_requirement
has_photo_requirement
created_at
updated_at
inspection_response_sets:
inspection_response_set_id
company_id
name
is_custom
created_at
updated_at
inspection_template_projects:
inspection_template_project_id
company_id
project_id
inspection_template_id
created_at
updated_at
subcontractor_invoices:
early_pay_fee_amount_calculated_company_currency
early_pay_fee_amount_calculated_project_currency
early_pay_fee_rate_calculated
bid:
distribution_member_id_list
bid_item:
bid_item_description
bid_package:
distribution_member_id_list
manager_id
asset_attachment:
asset_type_id
scheduling_activity:
parent_activity_name
equipment_rate:
audit_transaction_timestamp
column_type (Deferred)
company_id
created_at (Deferred)
created_by (Deferred)
created_by_id
description (Deferred)
equipment_category (Deferred)
equipment_rate_id (Deferred)
equipment_type (Deferred)
name (Deferred)
rate_category (Deferred)
rate_table_id
resource_category (Deferred)
unit_of_measure (Deferred)
updated_at (Deferred)
updated_by (Deferred)
updated_by_id
value (Deferred)
labor_rate:
audit_transaction_timestamp
class_code (Deferred)
classification (Deferred)
column_type (Deferred)
company_id
created_at (Deferred)
created_by (Deferred)
created_by_id
description (Deferred)
labor_rate_id (Deferred)
name (Deferred)
rate_category (Deferred)
rate_table_id
resource_category (Deferred)
unit_of_measure (Deferred)
updated_at (Deferred)
updated_by (Deferred)
updated_by_id
value (Deferred)
rate_table:
audit_transaction_timestamp
company_id
created_at (Deferred)
created_by (Deferred)
created_by_id
description (Deferred)
effective_date (Deferred)
expiration_date (Deferred)
is_active (Deferred)
name (Deferred)
project_id
rate_table_id (Deferred)
resource_category (Deferred)
updated_at (Deferred)
updated_by (Deferred)
updated_by_id
time_and_material_labors:
employee_system_id
worker_certification_gaps:
active_projects
days_until_expiry
full_name
app_activity:
activity_type
api_call_count
app_activity_id
app_type
application_id
application_name
company_id
date
day_id
embedded_usage
http_method
project_id
tool_category
pay_requirement_settings:
first_tier_unconditional_lien_waiver_previous_invoice_signed
payments_requirements:
unconditional_lien_waiver_previous_invoice_signed
owner_invoice_custom_fields:
audit_transaction_timestamp
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
owner_invoice_custom_field_id
owner_invoice_id
project_id
user_adoption_metrics:
snapshot_date
company_id
project_id
user_adoption_metric_id
created_by_id
created_by
created_by_login
tool
metric_name
metric_value
created_at
metric_definition
coordination_issue:
is_private
Procore removed the following models (tables) and fields:
Show/Hide
subcontractor_invoice_line_items:
materials_previously_stored
estimates:
discount
discount_percentage
bonding
bonding_percentage
overhead
overhead_percentage
Procore updated the data type for the following models (tables) and fields:
Show/Hide
observation_custom_fields:
type_id from int to bigint
observation_type_id from int to bigint
observation_custom_field_configs:
type_id from int to bigint
observation_type_id from int to bigint
commitments:
approved_date from Date to Timestamp
prime_contracts:
approved_date from Date to Timestamp
commitment_potential_change_orders:
approved_date from Date to Timestamp
commitment_change_orders:
approved_date from Date to Timestamp
prime_contract_change_orders:
approved_date from Date to Timestamp
prime_contract_potential_change_orders:
approved_date from Date to Timestamp
Procore added the following models (tables) and fields:
Show/Hide
assembly_part:
procore_project_id
asset:
asset_code
asset_id
asset_name
asset_status_id
asset_system_state_id
asset_type_code
asset_type_id
asset_type_name
audit_transaction_timestamp
company_id
created_at
created_by
description
latitude
location
location_id
longitude
note
project_id
scope
status
trade
trade_id
updated_at
updated_by
asset_attachment:
asset_attachment_id
asset_attachment_type
asset_id
attachment_source
attachment_type_id
audit_transaction_timestamp
company_id
created_at
created_by
description
file_name
project_id
updated_at
updated_by
asset_custom_fields:
asset_custom_field_id
asset_id
audit_transaction_timestamp
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
project_id
crew_memberships:
wp_people_id
crew_memberships_equipment:
company_id
created_at
crew_id
crew_lead_name
crew_name
equipment_crew_membership_id
equipment_id
equipment_identification_number
equipment_name
project_id
updated_at
equipment_project_association:
audit_transaction_timestamp
company_id
created_by
created_by_id
created_date
deleted_by
deleted_by_id
deleted_date
equipment_id
equipment_identification_number
equipment_project_association_id
project_id
project_name
equipment_timecard_entry:
operator_id
materials_purchase_order:
material_id
materials_receipt:
material_id
materials_shipment:
material_id
time_and_material_labors:
user_id
wp_people_id
planned_vs_actual_summary:
planned_vs_actual_summary_id
company_id
project_id
wbs_code_id
cost_code_id
project
cost_code
week_start_date
week_end_date
work_week
total_actual_hours
total_planned_hours
variance_hours
variance_pct
timecard_entry_count
contributing_employee_count
materials:
material_project_id
materials_shipment:
material_project_id
materials_receipt:
material_project_id
materials_purchase_order:
material_project_id
direct_costs:
wp_people_id
direct_costs_line_items:
wp_people_id
worker_certification_gaps:
worker_certification_id
wp_people_id
tag_id
tag_name
effective_date
expire_date
gap_type
company_id
workflow_instances:
workflow_instance_id
company_id
project_id
workflows_templates_version_id
current_step_occurrence_id
item_tool
workflowable_object_id
workflowable_object_identifier
template_name
template_version
status
duration
created_by_id
created_by
updated_by_id
updated_by
started_at
date_completed
created_at
updated_at
audit_transaction_timestamp
workflow_steps:
workflow_step_id
company_id
project_id
workflowable_object_id
workflowable_object_identifier
name
due_date
created_at
updated_at
date_completed
completion_duration
decision
decision_type
is_current_step
is_overdue
condition_value
condition_actual_value
workflow_instance_id
selected_response_option_id
step_uuid
selected_response_uuid
audit_transaction_timestamp
step_type
workflow_step_assignees:
workflow_step_assignee_id
company_id
project_id
workflow_instance_id
workflows_instances_step_occurrence_id
workflow_step_id
workflowable_object_id
workflowable_object_identifier
assignee_id
aligned_to_decision
completion_duration
created_at
invited_by
required_to_respond
response
response_comment
response_submitted_date
role
updated_at
audit_transaction_timestamp
name
created_by
created_by_id
item_tool
original_assignee_name
reason_for_invitation
responded_on_behalf_of
updated_by
updated_by_id
commitment_change_order_workflow_responses:
name
vendor_id
commitment_change_order_workflow_steps:
name
source
vendor_id
prime_contracts:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
subcontractor_invoice_line_items:
materials_retainage_retained_this_period
materials_retainage_retained_this_period_company_currency
materials_retainage_retained_this_period_project_currency
subcontractor_invoice_line_items_relations:
tax_bridge_id
tax_id
subcontractor_sov:
vendor_id
connected_rfis:
rfi_header_id
incident_action:
incident_root_cause_analysis_id
incident_alert:
incident_root_cause_analysis_id
incident_assignee:
incident_root_cause_analysis_id
incident_distribution_member:
incident_root_cause_analysis_id
incident_injury_body_part:
incident_root_cause_analysis_id
incident_record:
incident_root_cause_analysis_id
incident_witness_statement:
incident_root_cause_analysis_id
rfi_external_rfis:
audit_transaction_timestamp
company_id
connected_rfi_id
created_at
external_rfi_subject
project_id
rfi_external_rfi_id
rfi_header_id
updated_at
commitment_change_orders:
contract_private
contract_created_by_id
contract_user_id_list
commitment_change_order_requests:
contract_private
contract_created_by_id
contract_user_id_list
commitment_potential_change_orders:
contract_private
contract_created_by_id
contract_user_id_list
designated_reviewer_id
prime_contract_change_orders:
contract_private
contract_created_by_id
contract_user_id_list
prime_contract_change_order_requests:
contract_private
contract_created_by_id
contract_user_id_list
prime_contract_potential_change_orders:
contract_type
contract_private
contract_created_by_id
contract_user_id_list
owner_invoices:
contract_type
contract_private
contract_created_by_id
contract_user_id_list
owner_invoice_line_item_with_markups:
contract_type
contract_private
contract_created_by_id
allow_these_users_to_see_sov_items
contract_user_id_list
subcontractor_invoices:
contract_private
contract_created_by_id
contract_user_id_list
payments_received:
prime_contract_id
payments_requirements:
subcontractor_invoice_id
app_activity:
app_activity_id
day_id
date
application_id
application_name
activity_type
app_type
tool_category
http_method
api_call_count
embedded_usage
company_id
project_id
Procore added the following models (tables) and fields:
Show/Hide
commitment_change_order_workflow_steps:
commitment_id
commitment_change_order_id
commitment_potential_change_order_id
commitment_change_order_workflow_responses:
commitment_id
commitment_change_order_id
commitment_potential_change_order_id
Procore added the following models (tables) and fields:
Show/Hide
projects:
estimated_budget
estimated_budget_project_currency
estimated_budget_company_currency
priority
prime_contract_change_order_line_items:
vendor_id
subcontractor_invoice_line_items_relations:
subcontractor_sov_id
document_management:
audit_transaction_timestamp
authored_by
authored_by_id
classification
company_id
created_at
date_authored
description
discipline
document_management_id
document_stage
file_size
format
in_active_workflow
location
location_id
name
number
original_filename
originator
originator_id
project_id
project_stage
recycled
recycled_at
recycled_by
recycled_reason
revision
status
submitted_into_drawings
submitted_into_drawings_at
submitted_into_drawings_by
type
updated_at
updated_by
updated_by_id
uploaded_at
uploaded_by
uploaded_by_id
version
volume
document_management_custom_fields:
audit_transaction_timestamp
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
document_management_custom_field_id
document_management_id
project_id
observation_assignees:
assignee_company_name
assignee_login
assignee_name
assignee_user_id
audit_transaction_timestamp
company_id
created_at
location_id
observation_assignee_id
observation_id
project_id
updated_at
task:
is_origin
meeting_item_id
daily_timecards_and_assignments:
assignments
employee_name
party_id
project
work_week
equipment_project_log:
deleted_by_id
ended_by
equipment_identification_number
project_name
started_by
rfis:
company_name
rfis_bic:
company_name
subcontractor_invoices:
payments_beneficiary_id
payments_project_control_id
document_management_workflow_steps:
audit_transaction_timestamp
workflows_instance_id
company_id
project_id
workflowable_object_type
workflowable_object_id
document_management_workflow_step_id
current_step_name
current_step_due_date
document_management_workflow_responses:
audit_transaction_timestamp
workflows_instance_id
company_id
project_id
workflowable_object_type
workflowable_object_id
document_management_workflow_step_id
document_management_workflow_response_id
assignee
assignment_duration
current_step_response
wp_person_groups_relations:
group_people_project_id
group_id
company_id
wp_people_id
wp_project_id
project_id
employee_id
audit_transaction_timestamp
direct_costs:
accounting_date
payment_due_date
discount_date
payment_status
billed_amount
billed_amount_project_currency
billed_amount_company_currency
erp_latest_status
erp_updated_at
erp_user_name
tool_origin
Procore added the following models (tables) and fields:
Show/Hide
commitment_change_order_line_items:
estimated_tax
estimated_tax_company_currency
estimated_tax_project_currency
finance_object_id
tax_codes
commitment_change_order_requests:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
commitment_change_orders:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
commitment_line_items:
estimated_tax
estimated_tax_company_currency
estimated_tax_project_currency
finance_object_id
tax_codes
commitment_potential_change_orders:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
commitments:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
owner_invoice_line_item_with_markups:
finance_object_id
gross_amount_plus_tax
gross_amount_plus_tax_company_currency
gross_amount_plus_tax_project_currency
net_amount_plus_tax
net_amount_plus_tax_company_currency
net_amount_plus_tax_project_currency
tax_amount
tax_amount_company_currency
tax_amount_project_currency
tax_codes
owner_invoice_line_item_with_markups_relations:
rel_owner_invoice_line_item_id
tax_bridge_id
tax_id
owner_invoice_line_items:
finance_object_id
gross_amount_plus_tax
gross_amount_plus_tax_company_currency
gross_amount_plus_tax_project_currency
net_amount_plus_tax
net_amount_plus_tax_company_currency
net_amount_plus_tax_project_currency
tax_amount
tax_amount_company_currency
tax_amount_project_currency
tax_codes
owner_invoices:
gross_amount_plus_tax
gross_amount_plus_tax_company_currency
gross_amount_plus_tax_project_currency
net_amount_plus_tax
net_amount_plus_tax_company_currency
net_amount_plus_tax_project_currency
tax_total
tax_total_company_currency
tax_total_project_currency
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
prime_contract_change_order_line_items:
estimated_tax
estimated_tax_company_currency
estimated_tax_project_currency
finance_object_id
tax_codes
prime_contract_change_order_requests:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
prime_contract_change_orders:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
prime_contract_line_items:
estimated_tax
estimated_tax_company_currency
estimated_tax_project_currency
finance_object_id
tax_codes
prime_contract_potential_change_orders:
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
total_estimated_tax
total_estimated_tax_company_currency
total_estimated_tax_project_currency
subcontractor_invoice_line_items:
finance_object_id
gross_amount_plus_tax
gross_amount_plus_tax_company_currency
gross_amount_plus_tax_project_currency
net_amount_plus_tax
net_amount_plus_tax_company_currency
net_amount_plus_tax_project_currency
subcontractor_sov_id
tax_amount
tax_amount_company_currency
tax_amount_project_currency
tax_codes
subcontractor_invoices:
gross_amount_plus_tax
gross_amount_plus_tax_company_currency
gross_amount_plus_tax_project_currency
net_amount_plus_tax
net_amount_plus_tax_company_currency
net_amount_plus_tax_project_currency
tax_total
tax_total_company_currency
tax_total_project_currency
taxable_amount
taxable_amount_company_currency
taxable_amount_project_currency
subcontractor_sov:
amount
amount_company_currency
amount_project_currency
audit_transaction_timestamp
commitment_id
commitment_line_item_id
company_id
created_at
description
project_id
sov_position_number
subcontractor_sov_id
updated_at
wbs_code_id
tax:
active_date_range
audit_transaction_timestamp
company_id
created_by
created_by_id
created_on
description
invoice_tax_application
rate
status
tax_code
tax_code_id
tax_code_rate_id
tax_id
estimate_layer_groups:
group_multiplier
total_quantity
unit_of_measure
estimate_layers:
catalog_number
cost_catalog_item
manufacturer
supplier
total_cost_per_square_feet
total_equipment_cost
total_material_cost
total_quantity
total_subcontractor_cost
total_travel_cost
uom_labor_time
uom_quantity
coordination_issue_watcher:
audit_transaction_timestamp
company_id
company_name
coordination_issue_id
coordination_issue_watcher_id
created_at
login_information_id
name
project_id
incident_action:
incident_created_by
incident_created_by_login
incident_private
incident_alert:
incident_created_by
incident_created_by_login
incident_private
incident_injury_body_part:
incident_created_by
incident_created_by_login
incident_private
incident_record:
incident_created_by
incident_created_by_login
incident_private
incident_witness_statement:
incident_created_by
incident_created_by_login
incident_private
observation:
assignee_user_id_list
scheduling_activity:
activity_id
scheduling_relationship:
updated_by
scheduling_type:
updated_by
assignments:
created_by_id
daily_timecards_and_assignments:
assignment_count
company_id
daily_assignment_hours
daily_timecard_hours
daily_timecards_and_assignments_id
date
employee_id
is_current_week
is_missing_timecards
missing_hours
project_id
week_end_date
week_number
week_start_date
labor_equipment_productivity:
total_percent_completion
maintenance_record:
start_date_iso
timecard_entries:
employee_name
pay_requirement_settings:
invoice_signed
payments_requirements:
invoice_signed
materials:
company_id
project_id
item_name
item_description
item_uom
total_required_quantity
total_shipped_quantity
total_ordered_quantity
total_received_quantity
total_available_quantity
total_issued_quantity
material_id
audit_transaction_timestamp
created_at
updated_by
materials_shipment:
company_id
project_id
shipment_number
shipment_line_number
shipped_quantity
shipment_line_uom
shipment_forecast_delivery_date
shipment_state
shipment_final_date
materials_shipment_id
shipment_line_item_uuid
materials_shipment_id
shipment_line_link
shipment_refdoc_link
audit_transaction_timestamp
created_at
updated_by
materials_receipt:
company_id
project_id
receipt_number
receipt_line_number
receipt_line_condition
received_date
received_quantity
receipt_line_uom
receipt_document_status
receipt_posted_date
receipt_location
receipt_uuid
materials_receipt_id
receipt_line_item_uuid
receipt_line_link
receipt_refdoc_link
audit_transaction_timestamp
created_at
updated_by
materials_purchase_order:
company_id
project_id
po_number
vendor
po_line_number
po_line_ordered_quantity
po_line_uom
po_final_date
po_document_state
contract_delivery_date
estimated_delivery_date
materials_purchase_order_id
po_line_item_uuid
po_line_link
audit_transaction_timestamp
created_at
updated_by
project_dates:
actual_date
audit_transaction_timestamp
Procore added the following models (tables) and fields:
Show/Hide
contacts:
job_title
project_contacts:
job_title
projects:
store_number
commitments:
invoice_contacts_list
payments_manual_holds:
vendor_id
daily_log_accident:
location_id
vendor_id
daily_log_construction_reports:
location_id
daily_log_delay:
vendor_id
vendor_name
daily_log_delivery:
location_id
vendor_id
vendor_name
daily_log_dumpster:
location_id
daily_log_equipment:
vendor_id
vendor_name
daily_log_inspection:
vendor_id
vendor_name
daily_log_note:
vendor_id
vendor_name
daily_log_observed_weather_condition:
location_id
vendor_id
vendor_name
daily_log_phone_call:
location_id
vendor_id
vendor_name
daily_log_plan_revision:
location_id
vendor_id
vendor_name
daily_log_productivity:
location_id
daily_log_quantity:
vendor_id
vendor_name
daily_log_safety_violation:
location_id
vendor_id
daily_log_scheduled_work:
location_id
vendor_id
vendor_name
daily_log_visitor:
location_id
vendor_id
vendor_name
daily_log_waste:
location_id
scheduling_activity:
audit_transaction_timestamp
calendar_id
calendar_name
category_data
company_id
constraint_date
constraint_type
created_at
created_by
deadline_date
deadline_variance
duration
duration_display_unit
duration_unit
finish_date
is_actual_finish
is_actual_start
is_critical
is_placeholder
note
sibling_position
parent_id
percent_done
project_id
resource_data
crew_size
schedule_activity_id
schedule_id
start_date
activity_name
total_float
updated_at
vendor_id
vendor_name
scheduling_activity_custom_fields:
activity_category_assignment_id
alias_project_custom_field_id
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
project_id
schedule_activity_id
schedule_id
scheduling_activity_custom_field_id
scheduling_relationship:
audit_transaction_timestamp
company_id
created_at
created_by
dependency_type
from_activity
is_active
lag
lag_display_unit
project_id
schedule_id
schedule_relationship_id
to_activity
updated_at
scheduling_type:
audit_transaction_timestamp
calendar_id
company_id
created_at
created_by
imported_data_date
is_active
name
parent_schedule_id
project_id
schedule_id
start_date
type
updated_at
employees:
contact_id
labor_allocations:
audit_transaction_timestamp
created_by
scheduling_activity:
display_id
budget_view_standard_columns:
original_budget_amount_project_currency
original_budget_amount_company_currency
budget_modifications_project_currency
budget_modifications_company_currency
forecast_to_complete_automatic_sum_project_currency
forecast_to_complete_automatic_sum_company_currency
forecast_to_complete_manual_sum_project_currency
forecast_to_complete_manual_sum_company_currency
forecast_to_complete_aggregate_sum_project_currency
forecast_to_complete_aggregate_sum_company_currency
approved_co_amount_sum_project_currency
approved_co_amount_sum_company_currency
approved_budget_changes_amount_sum_project_currency
approved_budget_changes_amount_sum_company_currency
committed_costs_sum_project_currency
committed_costs_sum_company_currency
direct_cost_total_amount_sum_project_currency
direct_cost_total_amount_sum_company_currency
pending_cost_changes_sum_project_currency
pending_cost_changes_sum_company_currency
subcontractor_invoice_sum_project_currency
subcontractor_invoice_sum_company_currency
projected_costs_sum_project_currency
projected_costs_sum_company_currency
estimated_cost_at_completion_project_currency
estimated_cost_at_completion_company_currency
job_to_date_costs_sum_project_currency
job_to_date_costs_sum_company_currency
pending_co_sum_project_currency
pending_co_sum_company_currency
revised_budget_sum_project_currency
revised_budget_sum_company_currency
projected_budget_sum_project_currency
projected_budget_sum_company_currency
projected_over_under_sum_project_currency
projected_over_under_sum_company_currency
Procore removed the following models (tables) and fields:
Show/Hide
contract
Estimates:
other_adjustment1
other_adjustment1_amount
other_adjustment1_name
other_adjustment1_percentage
other_adjustment2
other_adjustment2_amount
other_adjustment2_name
other_adjustment2_percentage
other_adjustment3
other_adjustment3_amount
other_adjustment3_name
other_adjustment3_percentage
other_adjustment4
other_adjustment4_amount
other_adjustment4_name
other_adjustment4_percentage
field_productivity:
is_budgeted
requests:
job_title_id_2
Procore updated the data type for the following models (tables) and fields:
Show/Hide
incident_record_custom_fields:
custom_field_definitions_id from bigint to string
incident_record_custom_field_configs:
custom_field_definition_id from bigint to string
budget_change_adjustment_line_items:
unit_cost_project_currency from decimal(23,4) to decimal(38,5)
unit_cost_company_currency from decimal(30,4) to decimal(38,5)
amount_project_currency from decimal(21,2) to decimal(38,5)
amount_company_currency from decimal(28,2) to decimal(38,5)
budget_changes_approved_amount_project_currency from decimal(21,2) to decimal(38,5)
budget_changes_approved_amount_company_currency from decimal(28,2) to decimal(38,5)
budget_changes_under_review_amount_project_currency from decimal(21,2) to decimal(38,5)
budget_changes_under_review_amount_company_currency from decimal(28,2) to decimal(38,5)
budget_changes_draft_amount_project_currency from decimal(21,2) to decimal(38,5)
budget_changes_draft_amount_company_currency from decimal(28,2) to decimal(38,5)
changes_to_budgeted_amount_project_currency from decimal(21,2) to decimal(38,5)
changes_to_budgeted_amount_company_currency from decimal(28,2) to decimal(38,5)
pending_changes_to_budgeted_amount_project_currency from decimal(21,2) to decimal(38,5)
pending_changes_to_budgeted_amount_company_currency from decimal(28,2) to decimal(38,5)
budget_forecast_line_items:
amount_project_currency from decimal(21,2) to decimal(38,5)
amount_company_currency from decimal(28,2) to decimal(38,5)
unit_cost_project_currency from decimal(21,2) to decimal(38,5)
unit_cost_company_currency from decimal(28,2) to decimal(38,5)
forecast_to_complete_project_currency from decimal(21,2) to decimal(38,5)
forecast_to_complete_company_currency from decimal(28,2) to decimal(38,5)
budget_line_items:
original_budget_amount_project_currency from decimal(21,2) to decimal(38,5)
original_budget_amount_company_currency from decimal(28,2) to decimal(38,5)
unit_cost_project_currency from decimal(23,4) to decimal(38,5)
unit_cost_company_currency from decimal(30,4) to decimal(38,5)
budget_modifications:
transfer_amount_project_currency from decimal(23,2) to decimal(38,5)
transfer_amount_company_currency from decimal(30,2) to decimal(38,5)
change_event_line_item_with_markups:
cost_rom_project_currency from decimal(22,2) to decimal(38,5)
cost_rom_company_currency from decimal(28,2) to decimal(38,5)
cost_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)
cost_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)
revenue_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)
revenue_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)
change_event_line_items:
cost_rom_project_currency from decimal(22,2) to decimal(38,5)
cost_rom_company_currency from decimal(28,2) to decimal(38,5)
cost_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)
cost_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)
revenue_rom_unit_cost_project_currency from decimal(24,4) to decimal(38,5)
revenue_rom_unit_cost_company_currency from decimal(30,4) to decimal(38,5)
commitment_change_order_line_items:
unit_cost_project_currency from decimal(29,4) to decimal(38,5)
unit_cost_company_currency from decimal(36,4) to decimal(38,5)
manual_amount_project_currency from decimal(27,2) to decimal(38,5)
manual_amount_company_currency from decimal(34,2) to decimal(38,5)
total_amount_project_currency from decimal(27,2) to decimal(38,5)
total_amount_company_currency from decimal(34,2) to decimal(38,5)
approximate_bottom_line_amount_project_currency from decimal(27,2) to decimal(38,5)
approximate_bottom_line_amount_company_currency from decimal(34,2) to decimal(38,5)
extended_amount_project_currency from decimal(27,2) to decimal(38,5)
extended_amount_company_currency from decimal(34,2) to decimal(38,5)
amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
change_order_committed_amount_project_currency from decimal(27,2) to decimal(38,5)
change_order_committed_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pendings_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pendings_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_approved_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_approved_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_draft_amount_project_currency from decimal(27,2) to decimal(38,5)>>>
potential_change_order_draft_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_not_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_not_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pending_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pending_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_revised_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_revised_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_no_charge_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_no_charge_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_rejected_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_rejected_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_void_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_void_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pending_billable_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pending_billable_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pendings_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pendings_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_approved_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_approved_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_draft_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_draft_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_not_pricing_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_not_pricing_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pricing_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pricing_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pending_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pending_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_revised_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_revised_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_proceeding_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_proceeding_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_no_charge_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_no_charge_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_rejected_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_rejected_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_void_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_void_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pending_billable_amount_including_markup_project_currency from decimal(36,2) to decimal(38,5)
potential_change_order_pending_billable_amount_including_markup_company_currency from decimal(36,2) to decimal(38,5)
commitment_change_order_requests:
amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)
amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)
grand_total_project_currency from decimal(37,2) to decimal(38,5)
grand_total_company_currency from decimal(38,2) to decimal(38,5)
commitment_change_orders:
amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)
amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)
grand_total_project_currency from decimal(37,2) to decimal(38,5)
grand_total_company_currency from decimal(38,2) to decimal(38,5)
commitment_line_items:
unit_cost_project_currency from decimal(29,4) to decimal(38,5)
unit_cost_company_currency from decimal(36,4) to decimal(38,5)
manual_amount_project_currency from decimal(27,2) to decimal(38,5)
manual_amount_company_currency from decimal(34,2) to decimal(38,5)
total_amount_project_currency from decimal(27,2) to decimal(38,5)
total_amount_company_currency from decimal(34,2) to decimal(38,5)
approximate_bottom_line_amount_project_currency from decimal(27,2) to decimal(38,5)
approximate_bottom_line_amount_company_currency from decimal(34,2) to decimal(38,5)
extended_amount_project_currency from decimal(27,2) to decimal(38,5)
extended_amount_company_currency from decimal(34,2) to decimal(38,5)
contracts_approved_amount_project_currency from decimal(27,2) to decimal(38,5)
contracts_approved_amount_company_currency from decimal(34,2) to decimal(38,5)
contracts_draft_amount_project_currency from decimal(27,2) to decimal(38,5)
contracts_draft_amount_company_currency from decimal(34,2) to decimal(38,5)
contracts_out_for_signature_amount_project_currency from decimal(27,2) to decimal(38,5)
contracts_out_for_signature_amount_company_currency from decimal(34,2) to decimal(38,5)
contracts_complete_amount_project_currency from decimal(27,2) to decimal(38,5)
contracts_complete_amount_company_currency from decimal(34,2) to decimal(38,5)
commitment_potential_change_orders:
extended_total_project_currency from decimal(27,2) to decimal(38,5)
extended_total_company_currency from decimal(34,2) to decimal(38,5)
grand_total_project_currency from decimal(27,2) to decimal(38,5)
grand_total_company_currency from decimal(34,2) to decimal(38,5)
commitments:
total_payments_project_currency from decimal(27,2) to decimal(38,5)
total_payments_company_currency from decimal(34,2) to decimal(38,5)
line_items_total_project_currency from decimal(27,2) to decimal(38,5)
line_items_total_company_currency from decimal(34,2) to decimal(38,5)
line_items_extended_total_project_currency from decimal(27,2) to decimal(38,5)
line_items_extended_total_company_currency from decimal(34,2) to decimal(38,5)
grand_total_project_currency from decimal(27,2) to decimal(38,5)
grand_total_company_currency from decimal(34,2) to decimal(38,5)
revised_contract_amount_project_currency from decimal(35,2) to decimal(38,5)
revised_contract_amount_company_currency from decimal(35,2) to decimal(38,5)
remaining_balance_project_currency from decimal(35,2) to decimal(38,5)
remaining_balance_company_currency from decimal(35,2) to decimal(38,5)
pending_change_orders_project_currency from decimal(35,2) to decimal(38,5)
pending_change_orders_company_currency from decimal(35,2) to decimal(38,5)
approved_change_orders_project_currency from decimal(35,2) to decimal(38,5)
approved_change_orders_company_currency from decimal(35,2) to decimal(38,5)
draft_change_orders_project_currency from decimal(35,2) to decimal(38,5)
draft_change_orders_company_currency from decimal(35,2) to decimal(38,5)
invoiced_project_currency from decimal(29,2) to decimal(38,5)
invoiced_company_currency from decimal(35,2) to decimal(38,5)
pending_revised_contract_amount_project_currency from decimal(35,2) to decimal(38,5)
pending_revised_contract_amount_company_currency from decimal(35,2) to decimal(38,5)
direct_cost_line_items:
unit_cost_project_currency from decimal(29,4) to decimal(38,5)
unit_cost_company_currency from decimal(36,4) to decimal(38,5)
manual_amount_project_currency from decimal(27,2) to decimal(38,5)
manual_amount_company_currency from decimal(34,2) to decimal(38,5)
extended_amount_project_currency from decimal(27,2) to decimal(38,5)
extended_amount_company_currency from decimal(34,2) to decimal(38,5)
approved_total_amount_project_currency from decimal(27,2) to decimal(38,5)
approved_total_amount_company_currency from decimal(34,2) to decimal(38,5)
payroll_unit_cost_project_currency from decimal(29,4) to decimal(38,5)
payroll_unit_cost_company_currency from decimal(36,4) to decimal(38,5)
amount_total_project_currency from decimal(27,2) to decimal(38,5)
amount_total_company_currency from decimal(34,2) to decimal(38,5)
amount_grand_total_project_currency from decimal(27,2) to decimal(38,5)
amount_grand_total_company_currency from decimal(34,2) to decimal(38,5)
erp_job_costs:
job_to_date_cost_project_currency from decimal(19,2) to decimal(38,5)
job_to_date_cost_company_currency from decimal(26,2) to decimal(38,5)
commitment_invoiced_project_currency from decimal(19,2) to decimal(38,5)
commitment_invoiced_company_currency from decimal(26,2) to decimal(38,5)
direct_costs:
amount_total_project_currency from decimal(27,2) to decimal(38,5)
amount_total_company_currency from decimal(34,2) to decimal(38,5)
amount_grand_total_project_currency from decimal(27,2) to decimal(38,5)
amount_grand_total_company_currency from decimal(34,2) to decimal(38,5)
monitoring_resources:
unit_cost_project_currency from decimal(23,4) to decimal(38,5)
unit_cost_company_currency from decimal(30,4) to decimal(38,5)
owner_invoice_line_item_with_markups:
previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)
scheduled_value_project_currency from decimal(27,2) to decimal(38,5)
scheduled_value_company_currency from decimal(34,2) to decimal(38,5)
approved_changes from decimal(20,2) to decimal(38,5)
approved_changes_project_currency from decimal(27,2) to decimal(38,5)
approved_changes_company_currency from decimal(34,2) to decimal(38,5)
unit_price_project_currency from decimal(29,4) to decimal(38,5)
unit_price_company_currency from decimal(36,4) to decimal(38,5)
previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)
previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)
work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)
gross_amount_project_currency from decimal(29,2) to decimal(38,5)
gross_amount_company_currency from decimal(35,2) to decimal(38,5)
materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)
materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)
total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)
total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)
balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)
balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)
work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)
work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)
materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)
materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)
work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)
from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)
work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)
work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)
materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)
materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)
new_materials_project_currency from decimal(27,2) to decimal(38,5)
new_materials_company_currency from decimal(34,2) to decimal(38,5)
owner_invoice_line_items:
previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)
scheduled_value_project_currency from decimal(27,2) to decimal(38,5)
scheduled_value_company_currency from decimal(34,2) to decimal(38,5)
approved_changes from decimal(20,2) to decimal(38,5)
approved_changes_project_currency from decimal(27,2) to decimal(38,5)
approved_changes_company_currency from decimal(34,2) to decimal(38,5)
unit_price_project_currency from decimal(29,4) to decimal(38,5)
unit_price_company_currency from decimal(36,4) to decimal(38,5)
previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)
previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)
work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)
gross_amount_project_currency from decimal(29,2) to decimal(38,5)
gross_amount_company_currency from decimal(35,2) to decimal(38,5)
materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)
materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)
total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)
total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)
balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)
balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)
work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_from_previous_application_company_currency from decimal(35,2)>>> to decimal(38,5)
work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)
work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)
materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)
materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)
work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)
from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)
work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)
work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)
materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)
materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)
new_materials_project_currency from decimal(27,2) to decimal(38,5)
new_materials_company_currency from decimal(34,2) to decimal(38,5)
owner_invoice_markup_line_items:
previous_materials_retainage_project_currency from decimal(38,2) to decimal(38,5)
scheduled_value_project_currency from decimal(27,2) to decimal(38,5)
scheduled_value_company_currency from decimal(34,2) to decimal(38,5)
approved_changes from decimal(20,2) to decimal(38,5)
approved_changes_project_currency from decimal(27,2) to decimal(38,5)
approved_changes_company_currency from decimal(34,2) to decimal(38,5)
unit_price_project_currency from decimal(29,4) to decimal(38,5)
unit_price_company_currency from decimal(36,4) to decimal(38,5)
previous_work_completed_value_project_currency from decimal(38,2) to decimal(38,5)
previous_work_completed_value_company_currency from decimal(35,2) to decimal(38,5)
work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_completed_this_period_company_currency from decimal(35,2) to decimal(38,5)
gross_amount_project_currency from decimal(29,2) to decimal(38,5)
gross_amount_company_currency from decimal(35,2) to decimal(38,5)
materials_presently_stored_project_currency from decimal(28,2) to decimal(38,5)
materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)
total_completed_and_stored_to_date_project_currency from decimal(37,2) to decimal(38,5)
total_completed_and_stored_to_date_company_currency from decimal(35,2) to decimal(38,5)
balance_to_finish_project_currency from decimal(38,2) to decimal(38,5)
balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)
work_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
work_retainage_retained_this_period_project_currency from decimal(35,2) to decimal(38,5)
work_retainage_retained_this_period_company_currency from decimal(36,2) to decimal(38,5)
materials_retainage_retained_this_period_project_currency from decimal(20,2) to decimal(38,5)
materials_retainage_retained_this_period_company_currency from decimal(28,2) to decimal(38,5)
work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
total_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
total_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
work_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
work_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
materials_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_currently_retained_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_currently_retained_project_currency from decimal(38,2) to decimal(38,5)
total_retainage_currently_retained_company_currency from decimal(37,2) to decimal(38,5)
from_previous_application_total_project_currency from decimal(38,2) to decimal(38,5)
from_previous_application_total_company_currency from decimal(35,2) to decimal(38,5)
work_retainage_this_period_project_currency from decimal(34,2) to decimal(38,5)
work_retainage_this_period_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_from_previous_application_project_currency from decimal(38,2) to decimal(38,5)
materials_retainage_from_previous_application_company_currency from decimal(35,2) to decimal(38,5)
materials_previously_stored_project_currency from decimal(29,2) to decimal(38,5)
materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)
materials_retainage_released_this_period_project_currency from decimal(10,0) to decimal(38,5)
materials_retainage_released_this_period_company_currency from decimal(10,0) to decimal(38,5)
new_materials_project_currency from decimal(27,2) to decimal(38,5)
new_materials_company_currency from decimal(34,2) to decimal(38,5)
owner_invoices:
tax_applicable_to_this_payment_project_currency from decimal(36,2) to decimal(38,5)
tax_applicable_to_this_payment_company_currency from decimal(36,2) to decimal(38,5)
taxable_amount_project_currency from decimal(35,2) to decimal(38,5)
taxable_amount_company_currency from decimal(35,2) to decimal(38,5)
net_change_by_change_orders_project_currency from decimal(37,2) to decimal(38,5)
net_change_by_change_orders_company_currency from decimal(38,2) to decimal(38,5)
contract_sum_to_date_project_currency from decimal(37,2) to decimal(38,5)
contract_sum_to_date_company_currency from decimal(38,2) to decimal(38,5)
total_completed_and_stored_to_date_project_currency from decimal(38,2) to decimal(38,5)
total_completed_and_stored_to_date_company_currency from decimal(38,2) to decimal(38,5)
total_retainage_project_currency from decimal(38,2) to decimal(38,5)
less_previous_certificates_for_payment_project_currency from decimal(38,2) to decimal(38,5)
less_previous_certificates_for_payment_company_currency from decimal(38,2) to decimal(38,5)
net_amount_project_currency from decimal(38,2) to decimal(38,5)
net_amount_company_currency from decimal(38,2) to decimal(38,5)
gross_amount_project_currency from decimal(38,2) to decimal(38,5)
gross_amount_company_currency from decimal(38,2) to decimal(38,5)
total_changes_approved_previous_months_by_owner_client_additions_project_currency from decimal(36,2) to decimal(38,5)
total_changes_approved_previous_months_by_owner_client_additions_company_currency from decimal(36,2) to decimal(38,5)
total_changes_approved_previous_months_by_owner_client_deductions_project_currency from decimal(36,2) to decimal(38,5)
total_changes_approved_previous_months_by_owner_client_deductions_company_currency from decimal(36,2) to decimal(38,5)
total_approved_this_month_additions_project_currency from decimal(37,2) to decimal(38,5)
total_approved_this_month_additions_company_currency from decimal(38,2) to decimal(38,5)
total_approved_this_month_deductions_project_currency from decimal(37,2) to decimal(38,5)
total_approved_this_month_deductions_company_currency from decimal(38,2) to decimal(38,5)
total_changes_approved_additions_project_currency from decimal(37,2) to decimal(38,5)
total_changes_approved_additions_company_currency from decimal(38,2) to decimal(38,5)
total_changes_approved_deductions_project_currency from decimal(37,2) to decimal(38,5)
total_changes_approved_deductions_company_currency from decimal(38,2) to decimal(38,5)
retainage_work_completed_to_date_project_currency from decimal(38,2) to decimal(38,5)
retainage_work_completed_to_date_company_currency from decimal(38,2) to decimal(38,5)
retainage_materials_presently_stored_project_currency from decimal(38,2) to decimal(38,5)
retainage_materials_presently_stored_company_currency from decimal(38,2) to decimal(38,5)
materials_presently_stored_project_currency from decimal(30,2) to decimal(38,5)
materials_presently_stored_company_currency from decimal(38,2) to decimal(38,5)
paid_amount_project_currency from decimal(35,2) to decimal(38,5)
paid_amount_company_currency from decimal(35,2) to decimal(38,5)
payments_issued:
amount_project_currency from decimal(27,2) to decimal(38,5)
amount_company_currency from decimal(34,2) to decimal(38,5)
payments_received:
amount_project_currency from decimal(27,2) to decimal(38,5)
amount_company_currency from decimal(34,2) to decimal(38,5)
prime_contract_change_order_line_items:
unit_cost_project_currency from decimal(29,4) to decimal(38,5)
unit_cost_company_currency from decimal(36,4) to decimal(38,5)
manual_amount_project_currency from decimal(27,2) to decimal(38,5)
manual_amount_company_currency from decimal(34,2) to decimal(38,5)
extended_amount_project_currency from decimal(27,2) to decimal(38,5)
extended_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_approved_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_approved_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_draft_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_draft_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_not_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_not_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pricing_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pricing_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pending_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pending_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_revised_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_revised_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_not_proceeding_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_no_charge_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_no_charge_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_rejected_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_rejected_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_void_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_void_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pending_billable_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pending_billable_amount_company_currency from decimal(34,2) to decimal(38,5)
potential_change_order_pendings_amount_project_currency from decimal(27,2) to decimal(38,5)
potential_change_order_pendings_amount_company_currency from decimal(34,2) to decimal(38,5)
prime_contract_change_order_requests:
amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)
amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)
grand_total_project_currency from decimal(37,2) to decimal(38,5)
grand_total_company_currency from decimal(38,2) to decimal(38,5)
prime_contract_change_orders:
amount_without_markup_project_currency from decimal(37,2) to decimal(38,5)
amount_without_markup_company_currency from decimal(38,2) to decimal(38,5)
grand_total_project_currency from decimal(37,2) to decimal(38,5)
grand_total_company_currency from decimal(38,2) to decimal(38,5)
prime_contract_line_items:
unit_cost_project_currency from decimal(29,4) to decimal(38,5)
unit_cost_company_currency from decimal(36,4) to decimal(38,5)
amount_project_currency from decimal(27,2) to decimal(38,5)
amount_company_currency from decimal(34,2) to decimal(38,5)
prime_contract_potential_change_orders:
extended_total_project_currency from decimal(27,2) to decimal(38,5)
extended_total_company_currency from decimal(34,2) to decimal(38,5)
grand_total_project_currency from decimal(27,2) to decimal(38,5)
grand_total_company_currency from decimal(34,2) to decimal(38,5)
prime_contracts:
line_items_total_project_currency from decimal(27,2) to decimal(38,5)
line_items_total_company_currency from decimal(34,2) to decimal(38,5)
line_item_amount_project_currency from decimal(27,2) to decimal(38,5)
line_item_amount_company_currency from decimal(34,2) to decimal(38,5)
total_payments_project_currency from decimal(27,2) to decimal(38,5)
total_payments_company_currency from decimal(34,2) to decimal(38,5)
grand_total_project_currency from decimal(27,2) to decimal(38,5)
grand_total_company_currency from decimal(34,2) to decimal(38,5)
approved_change_orders_grand_total_project_currency from decimal(37,2) to decimal(38,5)
approved_change_orders_grand_total_company_currency from decimal(38,2) to decimal(38,5)
request_for_quote_quotes:
cost_project_currency from decimal(35,2) to decimal(38,5)
cost_company_currency from decimal(35,2) to decimal(38,5)
request_for_quotes:
estimated_amount_project_currency from decimal(27,2) to decimal(38,5)
estimated_amount_company_currency from decimal(34,2) to decimal(38,5)
original_quote_project_currency from decimal(27,2) to decimal(38,5)
original_quote_company_currency from decimal(34,2) to decimal(38,5)
subcontractor_invoice_line_items:
unit_price_project_currency from decimal(29,4) to decimal(38,5)
unit_price_company_currency from decimal(36,4) to decimal(38,5)
scheduled_value_project_currency from decimal(27,2) to decimal(38,5)
scheduled_value_company_currency from decimal(34,2) to decimal(38,5)
work_completed_from_previous_application_project_currency from decimal(20,2) to decimal(38,5)
work_completed_from_previous_application_company_currency from decimal(28,2) to decimal(38,5)
work_completed_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_completed_this_period_company_currency from decimal(34,2) to decimal(38,5)
total_completed_and_stored_to_date_value_project_currency from decimal(29,2) to decimal(38,5)
total_completed_and_stored_to_date_value_company_currency from decimal(36,2) to decimal(38,5)
balance_to_finish_project_currency from decimal(30,2) to decimal(38,5)
balance_to_finish_company_currency from decimal(37,2) to decimal(38,5)
work_retainage_currently_retained_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_currently_retained_company_currency from decimal(34,2) to decimal(38,5)
materials_retainage_currently_retained_project_currency from decimal(20,2) to decimal(38,5)
materials_retainage_currently_retained_company_currency from decimal(28,2) to decimal(38,5)
total_currently_retained_project_currency from decimal(28,2) to decimal(38,5)
total_currently_retained_company_currency from decimal(35,2) to decimal(38,5)
total_retainage_project_currency from decimal(32,2) to decimal(38,5)
total_retainage_company_currency from decimal(35,2) to decimal(38,5)
proposed_this_period_project_currency from decimal(27,2) to decimal(38,5)
proposed_this_period_company_currency from decimal(34,2) to decimal(38,5)
materials_presently_stored_project_currency from decimal(20,2) to decimal(38,5)
materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)
materials_previously_stored_project_currency from decimal(20,2) to decimal(38,5)
materials_previously_stored_company_currency from decimal(28,2) to decimal(38,5)
materials_previously_stored_from_project_currency from decimal(20,2) to decimal(38,5)
materials_previously_stored_from_company_currency from decimal(28,2) to decimal(38,5)
work_retainage_amount_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_amount_company_currency from decimal(34,2) to decimal(38,5)
work_retainage_previous_application_amount_project_currency from decimal(20,2) to decimal(38,5)
work_retainage_previous_application_amount_company_currency from decimal(28,2) to decimal(38,5)
materials_retainage_previous_application_amount_project_currency from decimal(20,2) to decimal(38,5)
materials_retainage_previous_application_amount_company_currency from decimal(28,2) to decimal(38,5)
total_retainage_previous_application_amount_project_currency from decimal(21,2) to decimal(38,5)
total_retainage_previous_application_amount_company_currency from decimal(29,2) to decimal(38,5)
work_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
work_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
materials_retainage_released_this_period_project_currency from decimal(27,2) to decimal(38,5)
materials_retainage_released_this_period_company_currency from decimal(34,2) to decimal(38,5)
new_materials_project_currency from decimal(27,2) to decimal(38,5)
new_materials_company_currency from decimal(34,2) to decimal(38,5)
total_completed_and_stored_to_date_from_previous_project_currency from decimal(29,2) to decimal(38,5)
total_completed_and_stored_to_date_from_previous_company_currency from decimal(35,2) to decimal(38,5)
net_amount_project_currency from decimal(32,2) to decimal(38,5)
net_amount_company_currency from decimal(35,2) to decimal(38,5)
gross_amount_project_currency from decimal(28,2) to decimal(38,5)
gross_amount_company_currency from decimal(35,2) to decimal(38,5)
retainage_new_materials_from_percent_project_currency from decimal(34,2) to decimal(38,5)
retainage_new_materials_from_percent_company_currency from decimal(35,2) to decimal(38,5)
adjusted_materials_retained_previously_project_currency from decimal(28,2) to decimal(38,5)
adjusted_materials_retained_previously_company_currency from decimal(35,2) to decimal(38,5)
adjusted_materials_previously_stored_project_currency from decimal(28,2) to decimal(38,5)
adjusted_materials_previously_stored_company_currency from decimal(35,2) to decimal(38,5)
subcontractor_invoices:
total_proposed_amount_project_currency from decimal(27,2) to decimal(38,5)
total_proposed_amount_company_currency from decimal(34,2) to decimal(38,5)
total_retainage_project_currency from decimal(21,2) to decimal(38,5)
total_retainage_company_currency from decimal(29,2) to decimal(38,5)
total_earned_less_retainage_project_currency from decimal(22,2) to decimal(38,5)
total_earned_less_retainage_company_currency from decimal(30,2) to decimal(38,5)
current_payment_due_project_currency from decimal(23,2) to decimal(38,5)
current_payment_due_company_currency from decimal(31,2) to decimal(38,5)
original_payment_due_project_currency from decimal(23,2) to decimal(38,5)
original_payment_due_company_currency from decimal(31,2) to decimal(38,5)
balance_to_finish_project_currency from decimal(29,2) to decimal(38,5)
balance_to_finish_company_currency from decimal(36,2) to decimal(38,5)
net_change_by_change_orders_project_currency from decimal(38,2) to decimal(38,5)
net_change_by_change_orders_company_currency from decimal(28,2) to decimal(38,5)
contract_sum_to_date_project_currency from decimal(38,2) to decimal(38,5)
contract_sum_to_date_company_currency from decimal(35,2) to decimal(38,5)
total_contract_amount_project_currency from decimal(38,2) to decimal(38,5)
total_contract_amount_company_currency from decimal(35,2) to decimal(38,5)
total_completed_and_stored_to_date_project_currency from decimal(20,2) to decimal(38,5)
total_completed_and_stored_to_date_company_currency from decimal(28,2) to decimal(38,5)
retainage_work_completed_to_date_project_currency from decimal(38,2) to decimal(38,5)
retainage_work_completed_to_date_company_currency from decimal(28,2) to decimal(38,5)
retainage_materials_presently_stored_project_currency from decimal(20,2) to decimal(38,5)
retainage_materials_presently_stored_company_currency from decimal(28,2) to decimal(38,5)
total_changes_approved_in_previous_months_by_owner_client_additions_project_currency from decimal(37,2) to decimal(38,5)
total_changes_approved_in_previous_months_by_owner_client_additions_company_currency from decimal(35,2) to decimal(38,5)
total_changes_approved_in_previous_months_by_owner_client_deductions_project_currency from decimal(37,2) to decimal(38,5)
total_changes_approved_in_previous_months_by_owner_client_deductions_company_currency from decimal(35,2) to decimal(38,5)
total_changes_approved_this_month_additions_project_currency from decimal(27,2) to decimal(38,5)
total_changes_approved_this_month_additions_company_currency from decimal(34,2) to decimal(38,5)
total_changes_approved_this_month_deductions_project_currency from decimal(27,2) to decimal(38,5)
total_changes_approved_this_month_deductions_company_currency from decimal(34,2) to decimal(38,5)
total_changes_approved_additions_project_currency from decimal(27,2) to decimal(38,5)
total_changes_approved_additions_company_currency from decimal(34,2) to decimal(38,5)
total_changes_approved_deductions_project_currency from decimal(27,2) to decimal(38,5)
total_changes_approved_deductions_company_currency from decimal(34,2) to decimal(38,5)
less_certificates_for_payment_project_currency from decimal(20,2) to decimal(38,5)
less_certificates_for_payment_company_currency from decimal(28,2) to decimal(38,5)
completed_work_retainage_amount_project_currency from decimal(38,2) to decimal(38,5)
completed_work_retainage_amount_company_currency from decimal(28,2) to decimal(38,5)
gross_amount_project_currency from decimal(21,2) to decimal(38,5)
gross_amount_company_currency from decimal(29,2) to decimal(38,5)
net_amount_project_currency from decimal(23,2) to decimal(38,5)
net_amount_company_currency from decimal(31,2) to decimal(38,5)
paid_amount_project_currency from decimal(35,2) to decimal(38,5)
paid_amount_company_currency from decimal(35,2) to decimal(38,5)
total_tax_project_currency from decimal(27,2) to decimal(38,5)
total_tax_company_currency from decimal(34,2) to decimal(38,5)
total_payments_amount_project_currency from decimal(35,2) to decimal(38,5)
total_payments_amount_company_currency from decimal(35,2) to decimal(38,5)
early_pay_fee_amount_company_currency from decimal(26,2) to decimal(38,5)
wp_roles:
company_id from string to bigint
project_id from string to bigint
Procore added the following models (tables) and fields:
Show/Hide
bid_Package:
bid_Manager
bid_submission_notifications
timecard_entries:
clock_in_gps_onsite
clock_out_gps_onsite
lunch_clock_in_gps_onsite
lunch_clock_out_gps_onsite
equipment_timecard_entry:
idle_hours
labor_allocations:
created_at
updated_at
budget_change_adjustment_line_items:
change_event_line_item_id
vendor_id
budget_change_custom_fields:
audit_transaction_timestamp
budget_change_custom_field_id
budget_change_id
company_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
project_id
budget_forecast_line_items:
wbs_code_id
commitment_change_order_line_items:
vendor_id
commitment_line_items:
prime_contract_line_item_id
vendor_id
contract_compliance_documents:
vendor_id
direct_cost_line_items:
employee_id
vendor_id
owner_invoices:
vendor_id
payments_issued:
disbursement_id
vendor_id
payments_lien_waivers:
commitment_id
vendor_id
payments_received:
vendor_id
payments_requirements:
commitment_id
prime_contract_workflow_responses:
vendor_id
prime_contract_workflow_steps:
vendor_id
wbs_codes:
wbs_code_status
submittal_approver_attachments:
submittal_approver_attachment_id
company_id
company_type
content_type
submittal_approver_id
submittal_id
created_at
created_by
created_by_id
created_by_login
filename
name
project_id
prostore_file_id
updated_at
viewable_type
inspection_item_attachments:
inspection_item_attachment_id
company_id
company_type
content_type
inspection_item_id
created_at
created_by
created_by_id
created_by_login
filename
name
project_id
prostore_file_id
updated_at
viewable_type
Procore added the following models (tables) and fields:
Show/Hide
invoice_compliance:
vendor_id
subcontractor_invoices:
early_pay_fee_amount_company_currency
early_pay_fee_amount_project_currency
total_contract_amount_company_currency
total_contract_amount_project_currency
commitment_line_items:
allow_these_users_to_see_sov_items
contract_assignee_id
contract_created_by_id
contract_private
contract_user_id_list
prime_contract_line_items:
allow_these_users_to_see_sov_items
contract_assignee_id
contract_created_by_id
contract_private
contract_status
contract_type
contract_user_id_list
daily_log_accident:
area
daily_log_construction_reports:
area
daily_log_delay:
area
daily_log_delivery:
area
action_plan:
approver_party_id_list
coordination_issue_custom_fields:
audit_transaction_timestamp
company_id
coordination_issue_custom_field_id
coordination_issue_id
custom_field_data_type
custom_field_definitions_id
custom_field_name
custom_field_value
custom_field_value_id
project_id
daily_log_dumpster:
area
daily_log_equipment:
area
daily_log_inspection:
segment
daily_log_manpower:
area
daily_log_note:
area
daily_log_observed_weather_condition:
area
daily_log_phone_call:
area
daily_log_plan_revision:
area
daily_log_productivity:
area
daily_log_quantity:
area
daily_log_safety_violation:
area
daily_log_scheduled_work:
area
daily_log_visitor:
area
daily_log_waste:
area
equipment_telematic:
provider_name
provider_id
equipment_telematics_daily_summary:
active_regeneration_hours
date
distance
equipment_telematics_daily_summary_id
fuel_used
fuel_used_last_24
identification_number
idle_hours
idle_non_operating_hours
load_count
maximum_speed_last_24
operating_hours
power_take_off_hours
company_id
equipment_id
incident:
assignee_id_list
assignee_list
global_status
incident_assignee:
audit_transaction_timestamp
company_id
incident_assignee_id
incident_id
login
project_id
assignee_id
company_name
created_at
name
updated_at
commitments:
bid_id
bid_vendor_id
bid_package_id
bid_form_id
punch_item_activities:
audit_transaction_timestamp
company_id
created_by_id
created_by_login
project_id
punch_item_id
attachments_count
comment
created_at
created_by_name
punch_item_activity_id
status
updated_at
rfi_responses:
rfi_project_id
site_instruction_attentions:
user_id
name
incident_record:
equipment_identification_number
equipment_id
equipment_name
site_instruction_distribution_members:
user_id
name
specification_sections:
created_by_id
bid_package:
require_nda
labor_equipment_productivity:
cost_code
wbs_code_flat_code
labor_estimated_hours
labor_reported_hours
labor_reported_cost
labor_percent_completion
equipment_estimated_hours
equipment_reported_hours
equipment_reported_cost
equipment_percent_completion
total_estimated_hours
total_reported_hours
total_reported_cost
labor_equipment_productivity_id
company_id
project_id
cost_code_id
wbs_code_id
timecard_entries:
wp_people_id
labor_allocations:
labor_allocation_id
allocation_date
wbs_code_id
allocation_hours
company_id
project_id
created_by_id
prime_contract:
pending_change_orders
invoiced
approved_change_orders
pending_revised_contract_amount
remaining_balance
revised_contract_amount
draft_change_orders
pending_change_orders_project_currency
invoiced_project_currency
approved_change_orders_project_currency
pending_revised_contract_amount_project_currency
remaining_balance_project_currency
revised_contract_amount_project_currency
draft_change_orders_company_currency
pending_change_orders_company_currency
invoiced_company_currency
approved_change_orders_company_currency
pending_revised_contract_amount_company_currency
remaining_balance_company_currency
revised_contract_amount_company_currency
draft_change_orders_company_currency
rfis:
attachment_count
Procore added the following models (tables) and fields:
Show/Hide
budget_forecasts
submittal_approvers:
variance_at_end
Bid:
invitation_first_sent_at
projects:
budget_locked
actual_completion_date
form_template:
company_id
created_by_id
prostore_file_id
audit_transaction_timestamp
form_template_id
name
description
created_at
updated_at
archived_at
commitments:
draft_change_orders_company_currency
invoiced_company_currency
pending_change_orders_company_currency
pending_revised_contract_amount_company_currency
approved_change_orders_company_currency
approved_change_orders_project_currency
contract_user_id_list
draft_change_orders_project_currency
invoiced_project_currency
pending_change_orders_project_currency
pending_revised_contract_amount_project_currency
remaining_balance_project_currency
revised_contract_amount_project_currency
workflow_distribution_member_id_list
workflow_role_user_id_list
pending_revised_contract_amount_company_currency
commitment_change_order_workflow_responses:
current_step_response
commitment_pco_workflow_responses:
current_step_response
correspondence_workflow_responses:
current_step_response
drawing_revision:
current_revision
reviewed_by_id
status_id
prime_contracts:
contract_user_id_list
workflow_distribution_member_id_list
workflow_role_user_id_list
budget_change_workflow_responses:
current_step_response
remaining_balance_company_currency
revised_contract_amount_company_currency
bid_item:
bid_vendor_id
bid_vendor:
bid_form_id
estimate_adjustment:
procore_project_id
estimate_budget_item:
procore_project_id
estimate_budget_item_included_item:
procore_project_id
estimate_layer_groups:
procore_project_id
estimate_layers:
procore_project_id
estimates:
procore_project_id
estimating_project_custom_fields:
procore_project_id
action_plan:
assignee_party_id_list
completed_plan_receiver_party_id_list
correspondence_assignees:
user_id
correspondence_distributions:
user_id
correspondences:
assignee_id_list
composite_provider_key
distribution_member_id_list
daily_log_accident:
created_by_collaborator
raw_status
daily_log_construction_reports:
created_by_collaborator
raw_status
daily_log_delay:
created_by_collaborator
raw_status
daily_log_delivery:
created_by_collaborator
raw_status
daily_log_dumpster:
created_by_collaborator
raw_status
daily_log_equipment:
created_by_collaborator
raw_status
daily_log_inspection:
created_by_collaborator
raw_status
daily_log_manpower:
created_by_collaborator
raw_status
daily_log_note:
created_by_collaborator
raw_status
daily_log_observed_weather_condition:
created_by_collaborator
raw_status
daily_log_phone_call:
created_by_collaborator
raw_status
daily_log_plan_revision:
created_by_collaborator
raw_status
daily_log_productivity:
created_by_collaborator
raw_status
daily_log_quantity:
created_by_collaborator
raw_status
daily_log_safety_violation:
created_by_collaborator
raw_status
daily_log_scheduled_work:
created_by_collaborator
raw_status
daily_log_visitor:
created_by_collaborator
raw_status
daily_log_waste:
created_by_collaborator
raw_status
inspection_items:
date_value_timestamp
incident:
distribution_member_id_list
recipient_id_list
incident_alert:
permission_recipient_id
recipient_name
site_instruction_attentions:
member_name
audit_transaction_timestamp
company_id
site_instruction_attention_id
member_id
project_id
site_instruction_id
site_instruction_distribution_members:
member_name
site_instruction_distribution_member_id
audit_transaction_timestamp
company_id
member_id
project_id
site_instruction_id
site_instructions:
attention_user_id_list
distribution_member_id_list
inspections:
assignee_id_list
distribution_member_id_list
signature_id_list
meeting:
assignee_id_list
meeting_attendee:
person_id
observation:
distribution_member_ids
observation_distribution_member:
user_id
punch_item:
assignee_id_list
distribution_member_id_list
permission_workflow_status
rfi_responses:
assignee_id_list
distribution_member_id_list
rfi_created_by_id
rfi_draft
rfi_hidden
rfi_manager_id
rfi_private
rfis:
assignee_id_list
distribution_member_id_list
schedule_calendar_item:
assigned_id
schedule_lookahead:
created_by_id
schedule_lookahead_task:
created_by_id
schedule_task:
created_by_id
maintenance_record:
type
duration
start_date
issue
notes
maintenance_record_id
company_id
equipment_id
owner_invoice_workflow_responses:
current_step_response
task:
assignee_user_id_list
created_by_id
task_item_distribution_member_id_list
task_assignee:
assignee_id
task_distribution_member:
user_id
prime_contract_workflow_responses:
current_step_response
prime_contract_change_order_workflow_responses:
current_step_response
prime_contract_pco_workflow_responses:
current_step_response
submittals:
approvers_ids
distribution_id_list
specification_sections:
current_revision
issued_date
received_date
revision
Estimate:
include_in_primary_estimate
equipment_timecard_entry_custom_fields:
batch_id
partition_company_id
equipment_timecard_entry_id
equipment_timecard_entry_custom_field_id
custom_field_value
custom_field_value_id
custom_field_definitions_id
custom_field_name
custom_field_data_type
company_id
project_id
estimating_projects:
primary_contact_full_address
subcontractor_invoice_workflow_responses:
current_step_response
assignments:
percent_allocation
wp_wage_overrides:
wp_project_id
wp_wage_override_id
job_title_id
company_id
job_title
wage_override_rate
project_id
tags:
wp_people_id
wp_project_id
commitment_workflow_response_occurrences:
current_step_response
Procore removed the following models (tables) and fields:
Show/Hide
budget_change_custom_field_configs
change_event_custom_field_configs
commitment_co_custom_field_configs
commitment_custom_field_configs
commitment_pco_custom_field_configs
prime_contract_co_custom_field_configs
prime_contract_pco_custom_field_configs
prime_contract_custom_field_configs
subcontractor_invoice_custom_field_configs
action_plan_custom_field_configs
correspondence_custom_field_configs
daily_log_construction_report_custom_field_configs
daily_log_equipment_custom_field_configs
daily_log_manpower_custom_field_configs
inspection_custom_field_configs
observation_custom_field_configs
punch_item_custom_field_configs
rfi_custom_field_configs
submittal_custom_field_configs
time_and_material_entry_custom_field_configs
time_and_material_equipment_custom_field_configs
time_and_material_labors_custom_field_configs
time_and_material_material_custom_field_configs
time_and_material_entry_subcontractor_field_configs
timecard_entry_custom_field_configs
bid_item:
bidding_vendor_id
bid_vendor:
bidding_vendor_id
bid:
bidding_vendor_id
contracts:
bidding_vendor_id
wp_people:
tags
tag_instance_id
wp_people_project_tag_id
wp_project_id
wp_projects:
tags
tag_instance_id
wp_project_tag_id
Procore updated the data type for the following models (tables) and fields:
Show/Hide
action_plan_custom_fields:
custom_field_value_id from int to string
budget_change_custom_fields:
custom_field_value_id from int to string
change_event_custom_fields:
custom_field_value_id from int to string
commitment_co_custom_fields:
custom_field_value_id from int to string
commitment_custom_fields:
custom_field_value_id from int to string
commitment_pco_custom_fields:
custom_field_value_id from int to string
company_folder_documents_custom_fields:
custom_field_value_id from int to string
correspondence_custom_fields:
custom_field_value_id from int to string
daily_log_accident_custom_fields:
custom_field_value_id from int to string
daily_log_construction_report_custom_fields:
custom_field_value_id from int to string
daily_log_delay_custom_fields:
custom_field_value_id from int to string
daily_log_delivery_custom_fields:
custom_field_value_id from int to string
daily_log_dumpster_custom_fields:
custom_field_value_id from int to string
daily_log_equipment_custom_fields:
custom_field_value_id from int to string
daily_log_inspection_custom_fields:
custom_field_value_id from int to string
daily_log_manpower_custom_fields:
custom_field_value_id from int to string
daily_log_note_custom_fields:
custom_field_value_id from int to string
daily_log_phone_call_custom_fields:
custom_field_value_id from int to string
daily_log_plan_revision_custom_fields:
custom_field_value_id from int to string
daily_log_productivity_custom_fields:
custom_field_value_id from int to string
daily_log_quantity_custom_fields:
custom_field_value_id from int to string
daily_log_safety_violation_custom_fields:
custom_field_value_id from int to string
daily_log_scheduled_work_custom_fields:
custom_field_value_id from int to string
daily_log_visitor_custom_fields:
custom_field_value_id from int to string
daily_log_waste_custom_fields:
custom_field_value_id from int to string
drawing_revision_custom_fields:
custom_field_value_id from int to string
folder_documents_custom_fields:
custom_field_value_id from int to string
incident_action_custom_fields:
custom_field_value_id from int to string
incident_custom_fields:
custom_field_value_id from int to string
incident_record_custom_fields:
custom_field_value_id from int to string
incident_witness_statement_custom_fields:
custom_field_value_id from int to string
inspection_custom_fields:
custom_field_value_id from int to string
observation_custom_fields:
custom_field_value_id from int to string
prime_contract_co_custom_fields:
custom_field_value_id from int to string
prime_contract_custom_fields:
custom_field_value_id from int to string
prime_contract_pco_custom_fields:
custom_field_value_id from int to string
project_custom_fields:
custom_field_value_id from int to string
punch_item_custom_fields:
custom_field_value_id from int to string
rfi_custom_fields:
custom_field_value_id from int to string
subcontractor_invoice_custom_fields:
custom_field_value_id from int to string
submittal_custom_fields:
custom_field_value_id from int to string
Procore added the following models (tables) and fields:
Show/Hide
inspection_items:
attachment_count
correspondences_workflow_responses:
current_step_response
Procore added the following models (tables) and fields:
Show/Hide
action_plan:
status_id
actual_production_quantities:
description
bid_vendor:
audit_transaction_timestamp
assembly_part:
difficulty_factor
labor_margin
total_cost
total_labor_sales
unit_labor_mins
unit_sales
bid_package:
require_nda
bid_vendor:
bid_form_id
bid_id
bid_package_id
bid_vendor_id
company_id
created_at
jobsite_proximity_in_miles
project_id
updated_at
vendor_address
vendor_affirmative_action
vendor_african_american_business
vendor_asian_american_business
vendor_authorized_bidder
vendor_avg_company_rating
vendor_business_phone
vendor_certified_business_enterprise
vendor_city
vendor_country
vendor_disadvantaged_business
vendor_eight_a_business_enterprise
vendor_hispanic_business
vendor_historically_underutlized_business
vendor_id
vendor_minority_business_enterprise
vendor_name
vendor_native_american_business
vendor_service_disabled_veteran_owned_small_business
vendor_small_business
vendor_state
vendor_trades
vendor_womens_business
vendor_zip
bid:
bid_vendor_id
nda_activity
change_event_line_item_with_markups:
non_committed_cost
non_committed_cost_company_currency
non_committed_cost_project_currency
commitment_change_orders:
change_reason
company_granular_permissions:
audit_transaction_timestamp
company_granular_permission_id
company_id
login_information_id
tool_bid_board_can_access_projects_for_all_users
tool_bid_board_can_add_notes
tool_bid_board_can_edit_docs
tool_bid_board_can_edit_project_details
tool_bid_board_can_export_bid
tool_directory_add_user_to_project
tool_directory_assign_to_future_projects
tool_directory_create_users
tool_directory_create_vendors
tool_directory_remove_user_from_project
tool_directory_view_user_details
tool_directory_view_vendor_details
company_permissions:
permission_template_id
contract:
bid_vendor_id
daily_log_types:
audit_transaction_timestamp
company_id
created_at
daily_log_type_id
enabled
label
name
updated_at
equipment:
daily_logs_count_l7
engine_hours_changes_count_l7
inspections_count_l7
is_idle_last_7_days
last_activity
last_activity_date
last_daily_log_date
last_engine_hours_activity_date
last_inspection_date
last_location_activity_date
last_timecard_date
location_changes_count_l7
timecards_count_l7
form:
template_archived_date
inspections:
group
reinspected_by_id
reinspected_by_name
reinspected_from_id
reinspected_from_name
meeting:
distributed_at
distributed_by_id
distributed_by_name
last_distributed_event
observation:
group
project_granular_permissions:
audit_transaction_timestamp
company_id
login_information_id
pk_user_id
project_granular_permission_id
project_id
tool_action_plans_act_as_approver
tool_action_plans_act_as_receiver
tool_action_plans_create_and_edit_plan
tool_action_plans_create_test_records_as_assignee
tool_action_plans_delete_plan
tool_action_plans_edit_due_date
tool_action_plans_edit_item_notes_as_assignee
tool_action_plans_edit_item_status_as_assignee
tool_action_plans_edit_notifications
tool_action_plans_edit_project_templates
tool_action_plans_link_record
tool_action_plans_sign_as_any_assignee
tool_action_plans_sign_as_same_company_approver
tool_action_plans_sign_as_same_company_assignee
tool_action_plans_sign_as_same_company_receiver
tool_action_plans_sign_as_self_assignee
tool_action_plans_unlink_record
tool_admin_manage_locations
tool_admin_manage_wbs_codes
tool_admin_update_active_tabs
tool_admin_update_cost_codes
tool_admin_update_general_settings
tool_budget_create_edit_delete_budget_changes
tool_budget_delete_budget_line_items
tool_budget_import_line_items_from_csv
tool_budget_lock_budget
tool_budget_modify_original_budget_amount
tool_budget_send_and_retrieve_from_erp
tool_budget_view_budget_insights
tool_budget_view_direct_cost_details
tool_change_events_can_export_to_pdf_or_csv
tool_change_events_can_view_change_history
tool_commitments_create_purchase_order_contract
tool_commitments_create_work_order_contract
tool_commitments_select_out_of_scope_wbs_codes_on_commitment_change_orders
tool_commitments_update_contract_currency_exchange_rate
tool_commitments_update_purchase_order_contract
tool_commitments_update_work_order_contract
tool_commitments_view_private_purchase_order_contract
tool_commitments_view_private_work_order_contract
tool_daily_log_copy
tool_daily_log_log_restrictively
tool_daily_log_update_own_entries
tool_daily_log_view_company_entries
tool_data_extracts_can_create
tool_data_extracts_can_delete_drafts
tool_data_extracts_can_download
tool_data_extracts_can_edit_drafts
tool_data_extracts_can_extract_data
tool_data_extracts_can_view
tool_direct_costs_create_direct_cost
tool_direct_costs_delete_direct_cost
tool_direct_costs_update_direct_cost
tool_direct_costs_update_exchange_rate
tool_directory_add_user
tool_directory_assign_project_role
tool_directory_create_distribution_group
tool_directory_create_person
tool_directory_create_user
tool_directory_create_vendor
tool_directory_manage_permission_templates
tool_directory_manage_vendor_insurances
tool_directory_remove_user
tool_directory_remove_vendor
tool_directory_request_imports
tool_directory_see_vendor_insurances
tool_directory_update_person
tool_documents_access_private
tool_documents_destroy_files_and_folders
tool_documents_move_files_and_folders
tool_documents_rename_files_and_folders
tool_documents_see_recycle_bin
tool_documents_set_permissions
tool_drawings_upload_and_review_drawings
tool_drawings_upload_drawings
tool_inspections_can_bulk_create_inspections
tool_inspections_can_reinspect
tool_inspections_create_edit_inspection_schedules
tool_meetings_add_comment
tool_meetings_create
tool_meetings_delete_own_comment
tool_meetings_distribute
tool_meetings_edit
tool_meetings_manage_meeting_categories
tool_meetings_manage_meeting_items
tool_meetings_manage_related_items
tool_meetings_send_emails
tool_observations_assign_standard_user
tool_observations_respond_to_vendor_observation_items
tool_observations_view_vendor_observation_items
tool_photos_create_photo_album
tool_photos_delete_photo_album
tool_photos_reorder_photo_albums
tool_photos_view_private_photo_album
tool_prime_contracts_can_import_markups
tool_prime_contracts_create_prime_contract
tool_prime_contracts_delete_prime_contract
tool_prime_contracts_update_contract_currency_exchange_rate
tool_prime_contracts_update_prime_contract
tool_prime_contracts_view_payment_application_detail
tool_punch_list_respond_to_vendor_punch_items
tool_punch_list_view_vendor_punch_items
tool_rfis_act_as_rfi_manager
tool_rfis_mark_official_responses
tool_rfis_view_private_rfis
tool_rfis_view_project_rfi_insights
tool_schedule_lookahead_create
tool_schedule_lookahead_delete
tool_schedule_lookahead_task_create
tool_schedule_lookahead_task_delete
tool_schedule_lookahead_task_update
tool_schedule_lookahead_view
tool_schedule_lookahead_view_change_history
tool_schedule_task_update_percent_complete
tool_specifications_can_configure
tool_specifications_can_create
tool_specifications_can_create_specification_set
tool_specifications_can_delete_pending_specification_uploads
tool_specifications_can_destroy
tool_specifications_can_download_specification
tool_specifications_can_email
tool_specifications_can_export_specification
tool_specifications_can_manually_create_divisions
tool_specifications_can_manually_create_spec_sections
tool_specifications_can_publish
tool_specifications_can_relate_items
tool_specifications_can_review
tool_specifications_can_show
tool_specifications_can_show_uploads
tool_specifications_can_update
tool_specifications_can_view_all_revision
tool_specifications_can_view_change_history
tool_specifications_can_view_deleted_specifications
tool_submittals_apply_submittal_workflow_template
tool_submittals_create_submittal
tool_submittals_create_submittal_package
tool_submittals_view_private_submittals
tool_submittals_view_project_submittal_insights
tool_timesheets_review_timesheets
tool_transmittals_view_private_transmittals"
project_permissions:
permission_template_id
project_role_memberships:
updated_at
invoice_compliance:
invoice_compliance_id
name
type
status
notes
attachment_count
effective_date
expiration_date
last_modified_by
last_modified_date
observation_custom_field_configs:
Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)
observation_custom_fields:
Changed the Custom_field_definitions_id format (e.g., 0_60128 to 12345_60128)
Procore added the following models (tables) and fields:
Show/Hide
Estimate_budget_item_included_item:
wbs_code_id
Estimate_budget_item:
wbs_code_id
Procore added the following models (tables) and fields:
Show/Hide
Bid
Bid_form
Bid_item
Bid_package
company_permissions
contact
project_contacts
Project_note
project_permissions
Project_task
Project_document
assembly_part
estimating_project_custom_field_configs
commitment_change_order_line_items:
quantity
tax_code
uom
commitments:
approved_change_orders
draft_change_orders
invoiced
pending_change_orders
pending_revised_contract_amount
owner_invoice_line_item_with_markups:
materials_retainage_released_this_period
materials_retainage_released_this_period_company_currency
materials_retainage_released_this_period_project_currency
owner_invoice_line_items:
materials_retainage_released_this_period
materials_retainage_released_this_period_company_currency
materials_retainage_released_this_period_project_currency
owner_invoice_markup_line_items:
materials_retainage_released_this_period
materials_retainage_released_this_period_company_currency
materials_retainage_released_this_period_project_currency
owner_invoices:
created_by_id
payments_subtier_waivers:
waiver_required
subcontractor_invoices:
created_by_id
total_contract_amount
photo:
uploaded_by_id
assignments:
employee_id
time_and_material_equipments:
equipment_id
equipment_identification_number
equipment_name_legacy
time_off:
employee_id
timecard_entries:
party_employee_id
timesheet_id
wp_people:
party_id
wp_role:
audit_transaction_timestamp
employee_id
Vendor:
avg_company_rating
Estimating Project:
created_by_id
primary_contact_full_address
budget_snapshot_line_item_headers:
line_items
requests:
status
wp_people:
customer_employee_id
user_id
incident_records:
affected_user_id
Procore updated the data type for the following models (tables) and fields:
Show/Hide
observation_custom_fields:
type_id from int to bigint
payments_subtier_waivers:
payment_subtier_waiver_id from bigint to string
incident_record:
incident_environmental_type from boolean to string
Procore added the following models (tables) and fields:
Show/Hide
company_project_currency_configurations
assignment_custom_fields
request_custom_fields
wp_people_custom_fields
folder_documents_custom_field_configs
folder_documents_custom_fields
task_distribution_member
project_vendors:
avg_company_rating
invoice_contact_email_address
invoice_contact_full_name
vendors:
avg_company_rating
invoice_contact_email_address
invoice_contact_full_name
direct_costs:
created_by_id
payments_subtiers:
hired_by_company_name
tier
tiering
subcontractor_invoices:
early_pay_fee_amount_calculated
incident_record:
affected_party_id
affected_party_name
inspection_items:
respondable
inspection_signature_requests:
requested
requested_login
submittals:
source_submittal_id
specification_area_name
actual_production_quantities:
created_by_id
budgeted_production_quantities:
created_by_id
equipment:
project_id
time_and_material_entries:
created_by_id
timecard_entries:
created_by_id
Procore added the following models (tables) and fields:
Show/Hide
Company_folder_documents
Folder_documents
Folder_watchers
Equipment_telematic
wp_project_custom_fields
estimating_project_custom_field_configs
subcontractor_invoice_line_items:
adjusted_materials_previously_stored
adjusted_materials_previously_stored_company_currency
adjusted_materials_previously_stored_project_currency
adjusted_materials_retained_previously
adjusted_materials_retained_previously_company_currency
adjusted_materials_retained_previously_project_currency
gross_amount
gross_amount_company_currency
gross_amount_project_currency
net_amount
net_amount_company_currency
net_amount_project_currency
retainage_new_materials_from_percent
retainage_new_materials_from_percent_company_currency
retainage_new_materials_from_percent_project_currency
total_completed_and_stored_to_date_from_previous
total_completed_and_stored_to_date_from_previous_company_currency
total_completed_and_stored_to_date_from_previous_project_currency
commitment_line_item_id
prime_contract_line_item_id
submittals:
anticipated_delivery_date_at_close
remaining_buffer_time_at_close
workflow_progress_at_close
wp_people:
custom_fields
wp_projects:
custom_fields
budget_view_details:
infojson_currency_conversion
Procore added the following models (tables) and fields:
Show/Hide
project_company_comments
tags
company_comments:
audit_transaction_timestamp
rating
company_distribution_groups:
audit_transaction_timestamp
project_id
project_distribution_groups:
audit_transaction_timestamp
company_id
project_tools:
audit_transaction_timestamp
is_active
budget_codes:
production_quantity_code_description
drawing_attachment:
folder_document_id
inspections:
closed_at
equipment:
status_type
field_productivity:
hours_utilization_enrp
projected_hours_at_completion_enrp
Procore added the following models (tables) and fields:
Show/Hide
early_pay_program
early_pay_program_enrollment
task_distribution_member
wp_roles
estimate_budget_item
estimate_budget_item_WBS_value
estimate_budget_included_item
procore_analytics_metadata
project_role_memberships:
employee_id
project_vendors:
cost_codes
trades
projects:
schedule_last_updated
schedule_percent_completion
vendors:
cost_codes
trades
budget_change_adjustment_line_items:
budget_changes_approved_amount
budget_changes_approved_amount_company_currency
budget_changes_approved_amount_project_currency
budget_changes_draft_amount
budget_changes_draft_amount_company_currency
budget_changes_draft_amount_project_currency
budget_changes_under_review_amount
budget_changes_under_review_amount_company_currency
budget_changes_under_review_amount_project_currency
budget_columns:
budget_column_id
budget_snapshot_line_item_forecasts:
approval_status
snapshot_type
budget_snapshot_line_item_headers:
approval_status
audit_transaction_timestamp
snapshot_type
budget_snapshot_line_items:
approval_status
audit_transaction_timestamp
snapshot_type
change_event_line_item_with_markups:
links_commitment_contract_cost
links_commitment_pco_cost
links_contract
links_edit
links_prime_pco_cost
links_rfq_amount
links_rom
links_view
commitment_line_items:
contracts_approved_amount
contracts_approved_amount_company_currency
contracts_approved_amount_project_currency
contracts_complete_amount
contracts_complete_amount_company_currency
contracts_complete_amount_project_currency
contracts_draft_amount
contracts_draft_amount_company_currency
contracts_draft_amount_project_currency
contracts_out_for_signature_amount
contracts_out_for_signature_amount_company_currency
contracts_out_for_signature_amount_project_currency
commitments:
global_insurance_compliance
project_insurance_compliance
remaining_balance
revised_contract_amount
payments_issued:
early_pay_fee_amount
payments_project_controls:
assigned_early_pay_program
audit_transaction_timestamp
early_pay_program_id
payments_subtier_waivers:
joint_check_requisition
payments_subtiers:
additional_address_information
address
amount_billed_to_date
city
country
joint_check_future_requisitions
kind_of_work
phone
state
subtier_type
waiver_contact_email
zip
prime_contract_change_order_requests:
schedule_impact_days
prime_contract_change_orders:
schedule_impact_days
prime_contract_potential_change_orders:
schedule_impact_days
subcontractor_invoices:
early_pay_fee_amount
early_pay_fee_rate
early_pay_status
missed_payment_due_date
original_payment_due
original_payment_due_company_currency
original_payment_due_project_currency
payment_due_date
correspondence_types:
created_at
correspondence_workflow_steps:
current_step_due_date
daily_log_accident_custom_fields:
type_id
daily_log_completion:
created_at
daily_log_construction_report_custom_fields:
type_id
daily_log_delay_custom_fields:
type_id
daily_log_delivery_custom_fields:
type_id
daily_log_dumpster_custom_fields:
type_id
daily_log_equipment:
equipment_id
equipment_identification_number
equipment_name_beta
daily_log_equipment_custom_fields:
type_id
daily_log_inspection_custom_fields:
type_id
daily_log_manpower_custom_fields:
type_id
daily_log_plan_revision_custom_fields:
type_id
daily_log_productivity_custom_fields:
type_id
daily_log_scheduled_work_task:
created_at
drawing_revision:
created_at
incident_alert:
created_at
updated_at
inspection_distribution_list:
created_at
updated_at
inspection_item_signature_requests:
created_at
updated_at
inspection_schedule_assignees:
created_at
updated_at
inspection_schedule_distribution_list:
created_at
updated_at
inspection_schedules:
created_at
equipment_id
equipment_identification_number
equipment_name
updated_at
meeting_attendee:
created_at
updated_at
meeting_item_assignee:
updated_at
observation_distribution_member:
created_at
punch_item:
audit_transaction_timestamp
punch_item_bic:
audit_transaction_timestamp
ball_in_court_role
punch_item_custom_fields:
type_id
punch_item_distribution_member:
audit_transaction_timestamp
rfi_assignees:
audit_transaction_timestamp
rfi_distributions:
audit_transaction_timestamp
rfi_responses:
audit_transaction_timestamp
rfis:
audit_transaction_timestamp
current_revision
revision
rfis_bic:
audit_transaction_timestamp
ball_in_court_role
schedule_calendar_item:
audit_transaction_timestamp
schedule_lookahead:
audit_transaction_timestamp
schedule_lookahead_task:
audit_transaction_timestamp
schedule_task:
audit_transaction_timestamp
schedule_task_changes:
audit_transaction_timestamp
schedule_task_requests:
audit_transaction_timestamp
site_instructions:
audit_transaction_timestamp
specification_sections:
audit_transaction_timestamp
submittal_approvers:
audit_transaction_timestamp
comments
submittal_ball_in_courts:
audit_transaction_timestamp
response_required
submittal_distributions:
audit_transaction_timestamp
submittals:
audit_transaction_timestamp
closed_at
task:
audit_transaction_timestamp
task_activity:
audit_transaction_timestamp
task_assignee:
audit_transaction_timestamp
equipment:
rental_end_date
rental_start_date
vendor_name
field_productivity:
cost_code_id
production_quantity_code
Procore added the following models (tables) and fields:
Show/Hide
Budget Code Segments
Layer WBS Values
Layer Group WBS Values
Estimate Adjustment
correspondence_workflow_steps:
current_step_due_date
current_step_name
payments_disbursements:
number
owner_invoices:
tax_applicable_to_this_payment_company_currency
tax_applicable_to_this_payment_project_currency
subcontractor_invoice_line_items:
total_retainage_company_currency
total_retainage_project_currency
action_plan:
audit_transaction_timestamp
action_plan_approver:
audit_transaction_timestamp
action_plan_completed_receiver:
audit_transaction_timestamp
action_plan_line_item:
audit_transaction_timestamp
action_plan_line_item_assignee:
audit_transaction_timestamp
action_plan_line_item_record:
audit_transaction_timestamp
action_plan_line_item_record_request:
audit_transaction_timestamp
action_plan_line_item_reference:
audit_transaction_timestamp
drawing_revision:
is_connected_drawing
incident_record:
affected_person_id
observation:
created_by_company
rfi_responses:
is_most_recent
rfis_bic:
response_required
schedule_task:
predecessor_wbs_list
successor_wbs_list
specification_sections:
`specification_area_description
specification_area_name
submittal_approvers:
previous_due_date
previous_returned_date
previous_sent_date
wp_projects:
categories
users:
audit_transaction_timestamp
estimate_layer_groups:
profit
Procore added the following models (tables) and fields:
Show/Hide
Financial:
payments_permissions
payments_disbursements
pay_requirement_settings
payments_project_controls
payments_invites
payments_agreements
payments_received
Project Management:
connected_rfi_responses
connected_rfis
daily_log_accident_custom_field_configs
daily_log_accident_custom_fields
daily_log_delay_custom_field_configs
daily_log_delay_custom_fields
daily_log_delivery_custom_field_configs
daily_log_delivery_custom_fields
daily_log_dumpster_custom_field_configs
daily_log_dumpster_custom_fields
daily_log_inspection_custom_field_configs
daily_log_inspection_custom_fields
daily_log_phone_call_custom_field_configs
daily_log_phone_call_custom_fields
daily_log_plan_revision_custom_field_configs
daily_log_plan_revision_custom_fields
daily_log_productivity_custom_field_configs
daily_log_productivity_custom_fields
daily_log_quantity_custom_field_configs
daily_log_quantity_custom_fields
daily_log_safety_violation_custom_field_configs
daily_log_safety_violation_custom_fields
daily_log_scheduled_work_custom_field_configs
daily_log_scheduled_work_custom_fields
daily_log_waste_custom_field_configs
daily_log_waste_custom_fields
inspection_item_references
schedule_task_changes
Resource Planning:
assignments
job titles
requests
time off
wp people
wp projects
groups
Equipment:
equipment
equipment project log
equipment timecard entry
Estimating:
estimating projects
estimate layers
estimate layer groups
estimating project custom fields
project_vendor_insurances:
sql
external_origin_data
external_origin_id
projects:
sql
code
delivery_method
external_origin_data
external_origin_id
sector
work_scope
users:
sql
abbreviated_name
can_push_to_accounting
company_name
company_permission_template
external_origin_data
external_origin_id
login_information_id
origin_id
origin_name
budget_changes:
sql
external_origin_data
external_origin_id
budget_line_items:
sql
budget_notes
change_events:
sql
external_origin_data
external_origin_id
commitment_change_orders:
sql
external_origin_data
external_origin_id
commitment_line_items:
sql
external_origin_data
external_origin_id
direct_cost_line_items:
sql
external_origin_data
external_origin_id
direct_costs:
sql
external_origin_data
external_origin_id
owner_invoice_line_item_with_markups:
sql
external_origin_data
external_origin_id
materials_presently_stored_qty
name
new_materials_stored_qty
previous_materials_stored_qty
prime_contract_id
owner_invoice_line_items:
sql
external_origin_data
external_origin_id
line_type
markup_id
materials_presently_stored_qty
name
new_materials_stored_qty
owner_invoice_line_item_with_markup_id
owner_invoice_markup_line_item_id
previous_materials_stored_qty
owner_invoice_markup_line_items:
sql
approved_changes
approved_changes_company_currency
approved_changes_project_currency
balance_to_finish
company_id_2
external_origin_data
external_origin_id
line_type
materials_presently_stored_qty
name
new_materials_stored_qty
owner_invoice_line_item_id
owner_invoice_line_item_with_markup_id
previous_materials_stored_qty
prime_contract_id
owner_invoices:
sql
external_origin_data
external_origin_id
tax_applicable_to_this_payment
payments_issued:
sql
external_origin_data
external_origin_id
prime_contract_change_order_line_items:
sql
external_origin_data
external_origin_id
prime_contract_change_order_requests:
sql
external_origin_data
external_origin_id
prime_contract_change_orders:
sql
external_origin_data
external_origin_id
prime_contract_line_items:
external_origin_data
external_origin_id
vendor_id
prime_contract_potential_change_orders:
sql
external_origin_data
external_origin_id
prime_contracts:
sql
external_origin_data
external_origin_id
subcontractor_invoice_line_items:
external_origin_id
materials_presently_stored_qty
materials_previously_stored_qty
new_materials_qty
subcontractor_invoices:
sql
external_origin_data
external_origin_id
inspections:
sql
equipment_identification_number
rfi_assignees:
sql
forwarded_by
submittal_approvers:
sql
is_last_step
equipment_timecard_entry:
sql
equipment_identification_number
equipment_name
Procore added the following models (tables) and fields:
Show/Hide
inspection_item_references
schedule_task_changes
equipment
equipment_project_log
equipment_timecard_entry
payments_project_controls
payments_invites
payments_agreements
pay_requirement_settings
company_vendor_insurances:
template_name
project_role_memberships:
user_id
budget_change_workflow_steps:
current_step_due_date
budget_codes:
attribute_1_line_item
attribute_1_name
attribute_2_line_item
attribute_2_name
attribute_3_line_item
attribute_3_name
budget_code
budget_columns:
created_at
updated_at
change_event_line_item_with_markups:
budget_days_in_stage
biller_id
biller_model_name
biller_name
budget_days_in_stage
change_event_events_id
change_event_status
change_event_title
contract_id
contract_number
contract_title
estimated_budget_amount
estimated_budget_transfer_amount
estimated_cost_amount
estimated_cost_amount_company_currency
estimated_cost_amount_project_currency
event_scope
proposed_contract_id
proposed_vendor_id
source
vendor_name
wbs_code_id
commitment_change_order_line_items:
commitment_change_order_request_id
commitment_potential_change_order_id
commitment_change_order_workflow_steps:
current_step_due_date
commitment_custom_field_configs:
name
commitment_pco_workflow_steps:
current_step_due_date
commitment_workflow_step_occurrences:
current_step_due_date
contract_compliance_documents:
template_name
owner_invoice_workflow_steps:
current_step_due_date
owner_invoices:
erp_latest_status
erp_updated_at
erp_user_name
synced_with_accounting
payments_beneficiaries:
early_pay_classification
prime_contract_change_order_line_items:
name
prime_contract_change_order_request_id
prime_contract_potential_change_order_id
prime_contract_change_order_workflow_steps:
current_step_due_date
prime_contract_pco_workflow_steps:
current_step_due_date
prime_contract_workflow_steps:
current_step_due_date
subcontractor_invoice_line_items:
total_retainage
subcontractor_invoice_workflow_steps:
current_step_due_date
action_plan_custom_fields:
type_id
action_plan_line_item_record:
action_plan_line_item_record_resource_url
correspondence_custom_fields:
type_id
correspondence_response_attachments:
type_id
correspondence_schedule_tasks:
type_id
correspondence_workflow_responses:
type_id
correspondence_workflow_steps:
type_id
daily_log_accident:
daily_log_completion_id
daily_log_construction_reports:
daily_log_completion_id
daily_log_delay:
daily_log_completion_id
daily_log_delivery:
daily_log_completion_id
daily_log_dumpster:
daily_log_completion_id
daily_log_equipment:
daily_log_completion_id
daily_log_inspection:
daily_log_completion_id
daily_log_manpower:
daily_log_completion_id
daily_log_note:
daily_log_completion_id
daily_log_observed_weather_condition:
daily_log_completion_id
daily_log_phone_call:
daily_log_completion_id
daily_log_plan_revision:
daily_log_completion_id
daily_log_productivity:
daily_log_completion_id
daily_log_quantity:
daily_log_completion_id
daily_log_safety_violation:
daily_log_completion_id
daily_log_scheduled_work:
daily_log_completion_id
daily_log_scheduled_work_task:
daily_log_completion_id
schedule_task_id
daily_log_visitor:
daily_log_completion_id
daily_log_waste:
daily_log_completion_id
inspection_custom_fields:
type_id
inspection_item_signature_requests:
inspection_schedule_id
inspection_items:
position_number
inspection_schedules:
ends_at
starts_at
inspections:
equipment_id
equipment_name
observation_custom_field_configs:
observation_type_id
type_id
observation_custom_fields:
type_id
punch_item_bic:
punch_item_bic_id
rfis_bic:
rfi_bic_id
schedule_lookahead_task:
task_id_comp
schedule_task:
task_id
submittal_ball_in_courts:
company_name
role
submittals:
ball_in_court_role
paused
actual_production_quantities:
wbs_code_id
budget_change_production_quantities:
budget_change_id
budget_change_production_quantity_id
wbs_code_id
prime_potential_change_order_production_quantities:
prime_contract_change_order_id
wbs_code_id
project:
code
owner_invoices:
Tax_Applicable_To_This_Payment
timecard_entries:
user_id
Procore removed the following models (tables) and fields:
Show/Hide
budget_codes:
budget_code
change_event_line_item_with_markups:
budget_days_in_stage
budget_change_production_quantities:
budget_change_production_quantity_id
Procore added the following models (tables) and fields:
Show/Hide
budget_change_workflow_steps:
current_step_due_date
commitment_change_order_workflow_steps:
current_step_due_date
commitment_pco_workflow_responses:
current_step_due_date
commitment_workflow_step_occurrences:
current_step_due_date
owner_invoice_workflow_steps:
current_step_due_date
prime_contract_change_order_workflow_steps:
current_step_due_date
prime_contract_pco_workflow_steps:
current_step_due_date
prime_contract_workflow_steps:
current_step_due_date
subcontractor_invoice_workflow_steps:
current_step_due_date
actual_production_quantities:
wbs_code_id
timecard_entries:
user_id
ProjectVendor[Name] field with IncidentInjury[Company_Affected] in the page slicer.Beta Reports
New Analytics BSA Compliance Scorecard (UK) Report
Introduced a new report for UK Dutyholders that provides an auditable digital record of Building Safety Act metrics. This report leverages Golden Thread principles to support Gateway 2 submissions and minimize regulatory delays.
Procore Financials 2.0
Added "company_currency" columns
The report uses currency columns to display values in the company's currency, ensuring that aggregates total correctly. This is particularly useful for companies managing projects in multiple currencies.
Procore Financials Budget 2.0 (Custom)
Fixed an issue where the report would fail to refresh if the "Job to Date Costs" step was included, but the column did not exist in the budget view.
Procore Specialty Contractor 2.0
Fixed an issue with "Budgeted Hours" and added "Revised Hours".
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.09.11
Procore Adoption 2.0 - 25.09.11
Procore Core 2.0 - 25.09.11
Procore Daily Logs 2.0 - 25.09.11
Procore Design Coordination 2.0 - 25.09.11
Procore Financials 2.0 - 25.12.30
Procore Financials Budget 2.0 - 25.09.19
Procore Financials Budget 2.0 (Custom) - 26.01.19
Procore Owner 2.0 - 25.09.23
Procore Project Management 2.0 - 25.12.10
Procore Quality and Safety 2.0 - 25.09.24
Procore Risk 2.0 - 25.09.11
Procore Specialty Contractor 2.0 - 26.01.14
Procore Vendor Performance 2.0 - 25.09.11
Procore Specialty Contractor 2.0
Fixed issues caused by source data type changes.
Procore Project Management 2.0
Fixed issues caused by source data type changes.
Updated "Late Items" calculations to include late inspections.
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.09.11
Procore Adoption 2.0 - 25.09.11
Procore Core 2.0 - 25.09.11
Procore Daily Logs 2.0 - 25.09.11
Procore Design Coordination 2.0 - 25.09.11
Procore Financials 2.0 - 25.09.11
Procore Financials Budget 2.0 - 25.09.19
Procore Financials Budget 2.0 (Custom) - 25.10.16
Procore Owner 2.0 - 25.09.23
Procore Project Management 2.0 - 25.12.10
Procore Quality and Safety 2.0 - 25.09.24
Procore Risk 2.0 - 25.09.11
Procore Specialty Contractor 2.0 - 25.11.24
Procore Vendor Performance 2.0 - 25.09.11
New Analytics Preconstruction Beta Report
Analytics Project Management 2.0
Resolved an issue where submittals were not displaying correctly.
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.09.11
Procore Adoption 2.0 - 25.09.11
Procore Core 2.0 - 25.09.11
Procore Daily Logs 2.0 - 25.09.11
Procore Design Coordination 2.0 - 25.09.11
Procore Financials 2.0 - 25.09.11
Procore Financials Budget 2.0 - 25.09.19
Procore Financials Budget 2.0 (Custom) - 25.10.16
Procore Owner 2.0 - 25.09.23
Procore Project Management 2.0 - 25.11.07
Procore Quality and Safety 2.0 - 25.09.24
Procore Risk 2.0 - 25.09.11
Procore Specialty Contractor 2.0 - 25.10.20
Procore Vendor Performance 2.0 - 25.09.11
Procore Specialty Contractor 2.0
Added new Work Force Planning Report pages.
Procore Financials Budget 2.0 (Custom)
Fixed an issue where the "Forecast column" would appear blank (null).
Procore Financials Budget 2.0
Fixed a display problem with the visual hierarchy in "Budget Comparison".
Procore Project Management 2.0
Converted date time zone data from UTC to the project's time zone. Find the columns with the "_local" suffix.
Procore Quality and Safety 2.0
Converted date time zone data from UTC to the project's time zone. Find the columns with the "_local" suffix.
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.09.11
Procore Adoption 2.0 - 25.09.11
Procore Core 2.0 - 25.09.11
Procore Daily Logs 2.0 - 25.09.11
Procore Design Coordination 2.0 - 25.09.11
Procore Financials 2.0 - 25.09.11
Procore Financials Budget 2.0 - 25.09.19
Procore Financials Budget 2.0 (Custom) - 25.10.16
Procore Owner 2.0 - 25.09.23
Procore Project Management 2.0 - 25.09.25
Procore Quality and Safety 2.0 - 25.09.24
Procore Risk 2.0 - 25.09.11
Procore Specialty Contractor 2.0 - 25.10.20
Procore Vendor Performance 2.0 - 25.09.11
Procore Core 2.0
Removed $ symbols
Procore Financials 2.0
Removed $ symbols
Procore Risk 2.0
Removed $ symbols
Procore Specialty Contractor 2.0
Minor Bug Fixes
Procore Project Management 2.0
Fixed a bug where the RFI Ball in court was displaying incorrectly
Procore Financials Budget 2.0
Fixed table visuals to display columns to match the Procore user interface
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 05.27
Procore Adoption 2.0 - 05.27
Procore Core 2.0 - 07.28
Procore Daily Logs 2.0 - 06.18
Procore Design - 06.18
Procore Financials - 07.28
Procore Financials Budget 2.0 - 08.06
Procore Financials Budget (Custom) - 06.18
Procore Quality & Safety 2.0 - 05.27
Procore Project Management 2.0 - 08.18
Procore Owner 2.0 - 06.18
Procore Risk 2.0 - 07.28
Procore Specialty Contractor 2.0 - 07.23
Procore Vendor Performance 2.0 - 05.27
Procore Financials 2.0
Commitment Payments report page
Fixed a bug where the 'Contractor' filter was not working correctly
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.05.27
Procore Adoption 2.0 - 25.05.27
Procore Core 2.0 - 25.06.18
Procore Daily Logs 2.0 - 25.06.18
Procore Design Coordination 2.0 - 25.06.18
Procore Financials 2.0 - 25.07.08
Procore Financials Budget 2.0 - 25.06.18
Procore Financials Budget (Custom) 2.0 - 25.06.18
Procore Owner 2.0 - 25.06.18
Procore Project Management 2.0 - 25.05.27
Procore Quality and Safety 2.0 - 25.05.27
Procore Risk 2.0 - 25.05.27
Procore Specialty Contractor 2.0 - 25.06.18
Procore Vendor Performance 2.0 - 25.05.27
Power BI Report Updates
All Reports
Minor performance tweaks
Procore Core
Fixed broken URLs in some visuals
Procore Daily Logs
Fixed broken URLs in some visuals
Procore Design Coordination
Fixed broken URLs in some visuals
Procore Financials
Fixed broken URLs in some visuals
Procore Financials Budget 2.0
Fixed an issue where the budget snapshots [Forecast to Complete] were not aggregating correctly
Fixed broken URLs in some visuals
Procore Financials Budget (Custom) 2.0
Fixed an issue where the budget snapshots [Forecast to Complete] were not aggregating correctly
Fixed broken URLs in some visuals
Other Updates
Current report version numbers:
Procore Action Plans 2.0 - 25.05.27
Procore Adoption 2.0 - 25.05.27
Procore Core 2.0 - 25.06.18
Procore Daily Logs 2.0 - 25.06.18
Procore Design Coordination 2.0 - 25.06.18
Procore Financials 2.0 - 25.06.18
Procore Financials Budget 2.0 - 25.06.18
Procore Financials Budget (Custom) 2.0 - 25.06.18
Procore Owner 2.0 - 25.06.18
Procore Project Management 2.0 - 25.05.27
Procore Quality and Safety 2.0 - 25.05.27
Procore Risk 2.0 - 25.05.27
Procore Specialty Contractor 2.0 - 25.06.18
Procore Vendor Performance 2.0 - 25.05.27
Power BI Report Updates
Procore Financials Budget (Custom)
Report updated to work with multi-select synced custom budget view
Report updated to include snapshot_type filter
Procore Financials Budget
Report updated to include snapshot_type filter
Procore Project Management Report
Fixed incorrect calculation for Gantt visuals
Report updated the start and end date column names in visuals to match the Procore user interface
Procore Specialty Contractor
Uploaded report to Analytics
Procore Action Plans 2.0
Adjusted logic on “Progress” page to include items that have no progress (0%)
Procore Financials Budget 2.0
Fixed bug that would occur with multiple budget snapshots taken in the same day
Procore Financials
Added ProjectTool table to data model
Added “Tool Configuration” report page
Procore Project Management 2.0
Added ProjectTool table to data model
Added “Tool Configuration” report page
All Reports
Minor performance enhancements
Data Connectors
Added support for incremental refresh.
Other Updates
Added procore_analytics_metadata table which contains:
Model Name
Primary Keys
Refresh Type - FULL/INCREMENTAL
last_refresh_time - Data last refreshed on PA tables
latest_transaction_timestamp - Cut off time from Procore APP
Power BI Report Updates
Core
Tool Configuration
Project Tasks
Financials
Financials Tool Utilization (Deprecated )
Financials Budget and Financials Budget (Custom)
Budget Snapshot Forecast (Deprecated)
Advanced Forecasting Over Time
Owner
Advanced Forecasting Over Time
Project Management
Project Tool Utilization (Deprecated)
Project Trending (Deprecated)
All Reports:
Fixed a bug causing an issue with relationships when a token has access to multiple companies.
Updated default row limit to prevent refresh from not pulling all data.
Added in line comments to some report measure and calculated columns.
Project Management
Fixed an issue with a relationship causing Ball In Court for submittals to not filter correctly.
Quality and Safety
Removed filter that was set as default.
Fixed an issue where Correspondence custom fields were returning empty.
Owner
Updated documentation URL.
Fixed an issue when duplicated budget names were used.
Performance Fixed to Custom Budget Report
Updated queries to remove redundant parameters and source queries, updated dynamic data type change to properly account for percentage data types.
Performance fixes for all reports
Removed some report parameters and standard source queries for performance, errors, and clarity.
Added Budget Comparison to Budget Report (Analytics 1.0 parity)
Added Advanced Forecasting Pages back to Owner and Budget Report
Bug Fix - Financials Report - Subcontractor Reconciliation Page
Fixes a bug where values of difference paid of 0 or 1 were counting as unpaid when marked paid in Procore.
Bug Fix - Drill through fixes
Reintroduced select missing drills through filters from Analytics 1.0.
All Reports
Removed some report parameters and standard source queries for performance, errors, and clarity
All Reports
Reintroduced some missing drills through filters from Procore Analytics 1.0
Procore Financials Budget (Custom)
Updated queries to remove redundant parameters and source queries
Updated dynamic data type change to properly account for percentage data types
Procore Financials Budget
Added Budget Comparison
Procore Owner and Procore Financials Budget
Added Advanced Forecasting
Procore Financials - Subcontractor Reconciliation
Fixed a bug where values of difference paid of 0 or 1 were counting as unpaid when marked paid in Procore
All Reports
Fixed bugs with various URLs
Removed HTML tags in some description columns to display better in Power BI
Procore Daily Logs
Added 'Attachment Details' visual to the following pages: Construction, Delays, Deliveries, Manpower, Notes
Procore Adoption
Various bug fixes
Procore Project Management
Added Schedule ToDos and Schedule ToDo Gantt pages
Procore Quality & Safety
Fixed tooltips for TRIFR Analysis
Procore Financials Budget
Various bug fixes and formatting changes
Procore Quality & Safety
Various bug fixes and formatting changes
Procore Project Management
Various bug fixes and formatting changes
Procore Actions Plans
Various bug fixes and formatting changes
Procore Daily Logs
Various bug fixes and formatting changes
Procore Adoption
Uploaded report to Analytics
Procore Design Coordination
Uploaded report to Analytics
Analytics 2.0 is generally available for new and existing Procore customers. Reach out to your Procore point of contact to learn more.
For support with Analytics 2.0:
| Issue | Solution |
|---|---|
|
Make sure you're working with the most up-to-date reports and data. The latest report files are found in your company level Analytics tool from the Power BI tile. Analytics 2.0 updates on a monthly cadence. View the latest changes and updates below: |
|
If you’re up-to-date and still experiencing issues, please collect the following information:
|
Please email this information to support@procore.com with 'Analytics 2.0' as part of the subject. |