Análise - Registro de alterações de dados

Atualizações de dados do Analytics 2.0 (17/03/2026)

O Procore adicionou os seguintes modelos (tabelas) e campos:

Atualizações de dados do Analytics 2.0 (17/02/2026)

O Procore adicionou os seguintes modelos (tabelas):

O Procore removeu os seguintes modelos (tabelas):

O Procore atualizou o tipo de dados para os seguintes modelos (tabelas):

Atualizações de dados do Analytics 2.0 (20/01/2026)

O Procore atualizou os seguintes modelos (tabelas):

• bid_Package:

  • Adicionado bid_Manager

  • Adicionado bid_submission_notifications

• timecard_entries:

  • Adicionado clock_in_gps_onsite

  • Adicionado clock_out_gps_onsite

  • Adicionado lunch_clock_in_gps_onsite

  • Adicionado lunch_clock_out_gps_onsite

• equipment_timecard_entry:

  • Adicionado idle_hours

• labor_allocations:

  • Adicionado created_at

  • Adicionado updated_at

• budget_change_adjustment_line_items:

  • Adicionado change_event_line_item_id

  • Adicionado vendor_id

• budget_change_custom_fields:

  • Adicionado audit_transaction_timestamp

  • Adicionado budget_change_custom_field_id

  • Adicionado budget_change_id

  • Adicionado company_id

  • Adicionado custom_field_data_type

  • Adicionado custom_field_definitions_id

  • Adicionado custom_field_name

  • Adicionado custom_field_value

  • Adicionado custom_field_value_id

  • Adicionado project_id

• budget_forecast_line_items:

  • Adicionado wbs_code_id

• commitment_change_order_line_items:

  • Adicionado vendor_id

• commitment_line_items:

  • Adicionado prime_contract_line_item_id

  • Adicionado vendor_id

• contract_compliance_documents:

  • Adicionado vendor_id

• direct_cost_line_items:

  • Adicionado employee_id

  • Adicionado vendor_id

• owner_invoices:

  • Adicionado vendor_id

• payments_issued:

  • Adicionado disbursement_id

  • Adicionado vendor_id

• payments_lien_waivers:

  • Adicionado commitment_id

  • Adicionado vendor_id

• payments_received:

  • Adicionado vendor_id

• payments_requirements:

  • Adicionado commitment_id

• prime_contract_workflow_responses:

  • Adicionado vendor_id

• prime_contract_workflow_steps:

  • Adicionado vendor_id

• wbs_codes:

  • Adicionado wbs_code_status

• submittal_approver_attachments:

  • Adicionado submittal_approver_attachment_id

  • Adicionado company_id

  • Adicionado company_type

  • Adicionado content_type

  • Adicionado submittal_approver_id

  • Adicionado submittal_id

  • Adicionado created_at

  • Adicionado created_by

  • Adicionado created_by_id

  • Adicionado created_by_login

  • Adicionado nome de arquivo

  • Nome adicionado

  • Adicionado project_id

  • Adicionado prostore_file_id

  • Adicionado updated_at

  • Adicionado viewable_type

• inspection_item_attachments:

  • Adicionado inspection_item_attachment_id

  • Adicionado company_id

  • Adicionado company_type

  • Adicionado content_type

  • Adicionado inspection_item_id

  • Adicionado created_at

  • Adicionado created_by

  • Adicionado created_by_id

  • Adicionado created_by_login

  • Adicionado nome de arquivo

  • Nome adicionado

  • Adicionado project_id

  • Adicionado prostore_file_id

  • Adicionado updated_at

  • Adicionado viewable_type

Atualizações de dados do Analytics 2.0 (16/12/2025)

O Procore atualizou os seguintes modelos (tabelas):

• invoice_compliance:

  • Adicionado vendor_id

• subcontractor_invoices:

  • Adicionado early_pay_fee_amount_company_currency

  • Adicionado early_pay_fee_amount_project_currency

  • Adicionado total_contract_amount_company_currency

  • Adicionado total_contract_amount_project_currency

• commitment_line_items:

  • Adicionado allow_these_users_to_see_sov_items

  • Adicionado contract_assignee_id

  • Adicionado contract_created_by_id

  • Adicionado contract_private

  • Adicionado contract_user_id_list

• prime_contract_line_items:

  • Adicionado allow_these_users_to_see_sov_items

  • Adicionado contract_assignee_id

  • Adicionado contract_created_by_id

  • Adicionado contract_private

  • Adicionado contract_status

  • Adicionado contract_type

  • Adicionado contract_user_id_list

• daily_log_accident:

  • Área adicionada

• daily_log_construction_reports:

  • Área adicionada

• daily_log_delay:

  • Área adicionada

• daily_log_delivery:

  • Área adicionada

• action_plan:

  • Adicionado approver_party_id_list

• coordination_issue_custom_fields:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado coordination_issue_custom_field_id

  • Adicionado coordination_issue_id

  • Adicionado custom_field_data_type

  • Adicionado custom_field_definitions_id

  • Adicionado custom_field_name

  • Adicionado custom_field_value

  • Adicionado custom_field_value_id

  • Adicionado project_id

• daily_log_dumpster:

  • Área adicionada

• daily_log_equipment:

  • Área adicionada

• daily_log_inspection:

  • Segmento adicionado

• daily_log_manpower:

  • Área adicionada

• daily_log_note:

  • Área adicionada

• daily_log_observed_weather_condition:

  • Área adicionada

• daily_log_phone_call:

  • Área adicionada

• daily_log_plan_revision:

  • Área adicionada

• daily_log_productivity:

  • Área adicionada

• daily_log_quantity:

  • Área adicionada

• daily_log_safety_violation:

  • Área adicionada

• daily_log_scheduled_work:

  • Área adicionada

• daily_log_visitor:

  • Área adicionada

• daily_log_waste:

  • Área adicionada

• equipment_telematic:

  • Adicionado provider_name

  • Adicionado provider_id

• equipment_telematics_daily_summary:

  • Adicionado active_regeneration_hours

  • Data adicionada

  • Distância adicionada

  • Adicionado equipment_telematics_daily_summary_id

  • Adicionado fuel_used

  • Adicionado fuel_used_last_24

  • Adicionado identification_number

  • Adicionado idle_hours

  • Adicionado idle_non_operating_hours

  • Adicionado load_count

  • Adicionado maximum_speed_last_24

  • Adicionado operating_hours

  • Adicionado power_take_off_hours

  • Adicionado company_id

  • Adicionado equipment_id

• Incidente:

  • Adicionado assignee_id_list

  • Adicionado assignee_list

  • Adicionado global_status

• incident_assignee:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado incident_assignee_id

  • Adicionado incident_id

  • Adicionado login

  • Adicionado project_id

  • Adicionado assignee_id

  • Adicionado company_name

  • Adicionado created_at

  • Nome adicionado

  • Adicionado updated_at

• Compromissos:

  • Adicionado bid_id

  • Adicionado bid_vendor_id

  • Adicionado bid_package_id

  • Adicionado bid_form_id

• punch_item_activities:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado created_by_id

  • Adicionado created_by_login

  • Adicionado project_id

  • Adicionado punch_item_id

  • Adicionado attachments_count

  • Comentário adicionado

  • Adicionado created_at

  • Adicionado created_by_name

  • Adicionado punch_item_activity_id

  • Status adicionado

  • Adicionado updated_at

• rfi_responses:

  • Adicionado rfi_project_id

• site_instruction_attentions:

  • Adicionado user_id

  • Nome adicionado

• incident_record:

  • Adicionado equipment_identification_number

  • Adicionado equipment_id

  • Adicionado equipment_name

• site_instruction_distribution_members:

  • Adicionado user_id

  • Nome adicionado

• specification_sections:

  • Adicionado created_by_id

• bid_package:

  • Adicionado require_nda

• labor_equipment_productivity:

  • Adicionado cost_code

  • Adicionado wbs_code_flat_code

  • Adicionado labor_estimated_hours

  • Adicionado labor_reported_hours

  • Adicionado labor_reported_cost

  • Adicionado labor_percent_completion

  • Adicionado equipment_estimated_hours

  • Adicionado equipment_reported_hours

  • Adicionado equipment_reported_cost

  • Adicionado equipment_percent_completion

  • Adicionado total_estimated_hours

  • Adicionado total_reported_hours

  • Adicionado total_reported_cost

  • Adicionado labor_equipment_productivity_id

  • Adicionado company_id

  • Adicionado project_id

  • Adicionado cost_code_id

  • Adicionado wbs_code_id

• timecard_entries:

  • Adicionado wp_people_id

• labor_allocations:

  • Adicionado labor_allocation_id

  • Adicionado allocation_date

  • Adicionado wbs_code_id

  • Adicionado allocation_hours

  • Adicionado company_id

  • Adicionado project_id

  • Adicionado created_by_id

• prime_contract:

  • Adicionado pending_change_orders

  • Adicionado faturado

  • Adicionado approved_change_orders

  • Adicionado pending_revised_contract_amount

  • Adicionado remaining_balance

  • Adicionado revised_contract_amount

  • Adicionado draft_change_orders

  • Adicionado pending_change_orders_project_currency

  • Adicionado invoiced_project_currency

  • Adicionado approved_change_orders_project_currency

  • Adicionado pending_revised_contract_amount_project_currency

  • Adicionado remaining_balance_project_currency

  • Adicionado revised_contract_amount_project_currency

  • Adicionado draft_change_orders_company_currency

  • Adicionado pending_change_orders_company_currency

  • Adicionado invoiced_company_currency

  • Adicionado approved_change_orders_company_currency

  • Adicionado pending_revised_contract_amount_company_currency

  • Adicionado remaining_balance_company_currency

  • Adicionado revised_contract_amount_company_currency

  • Adicionado draft_change_orders_company_currency

• RFIs:

  • Adicionado attachment_count

Atualizações de dados do Analytics 2.0 (18/11/2025)

O Procore adicionou os seguintes modelos (tabelas):

• budget_forecasts

O Procore removeu os seguintes modelos (tabelas):

• 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:

  • Removido bidding_vendor_id

• bid_vendor:

  • Removido bidding_vendor_id

• Oferta:

  • Removido bidding_vendor_id

• Contratos:

  • Removido bidding_vendor_id

• wp_people:

  • Tags removidas

  • Removido tag_instance_id

  • Removido wp_people_project_tag_id

  • Removido wp_project_id

• wp_projects:

  • Tags removidas

  • Removido tag_instance_id

  • Removido wp_project_tag_id

O Procore atualizou o tipo de dados para os seguintes modelos (tabelas):

• action_plan_custom_fields:

  • Alteração custom_field_value_id de int para string

• budget_change_custom_fields:

  • Alteração custom_field_value_id de int para string

• change_event_custom_fields:

  • Alteração custom_field_value_id de int para string

• commitment_co_custom_fields:

  • Alteração custom_field_value_id de int para string

• commitment_custom_fields

  • Alteração custom_field_value_id de int para string

• commitment_pco_custom_fields:

  • Alteração custom_field_value_id de int para string

• company_folder_documents_custom_fields:

  • Alteração custom_field_value_id de int para string

• correspondence_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_accident_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_construction_report_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_delay_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_delivery_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_dumpster_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_equipment_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_inspection_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_manpower_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_note_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_phone_call_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_plan_revision_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_productivity_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_quantity_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_safety_violation_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_scheduled_work_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_visitor_custom_fields:

  • Alteração custom_field_value_id de int para string

• daily_log_waste_custom_fields:

  • Alteração custom_field_value_id de int para string

• drawing_revision_custom_fields:

  • Alteração custom_field_value_id de int para string

• folder_documents_custom_fields:

  • Alteração custom_field_value_id de int para string

• incident_action_custom_fields:

  • Alteração custom_field_value_id de int para string

• incident_custom_fields:

  • Alteração custom_field_value_id de int para string

• incident_record_custom_fields:

  • Alteração custom_field_value_id de int para string

• incident_witness_statement_custom_fields:

  • Alteração custom_field_value_id de int para string

• inspection_custom_fields:

  • Alteração custom_field_value_id de int para string

• observation_custom_fields:

  • Alteração custom_field_value_id de int para string

• prime_contract_co_custom_fields:

  • Alteração custom_field_value_id de int para string

• prime_contract_custom_fields:

  • Alteração custom_field_value_id de int para string

• prime_contract_pco_custom_fields:

  • Alteração custom_field_value_id de int para string

• project_custom_fields:

  • Alteração custom_field_value_id de int para string

• punch_item_custom_fields:

  • Alteração custom_field_value_id de int para string

• rfi_custom_fields:

  • Alteração custom_field_value_id de int para string

• subcontractor_invoice_custom_fields:

  • Alteração custom_field_value_id de int para string

• submittal_custom_fields:

  • Alteração custom_field_value_id de int para string

O Procore atualizou os seguintes modelos (tabelas):

• submittal_approvers:

  • Adicionado variance_at_end

• Oferta:

  • Adicionado invitation_first_sent_at

• Projetos:

  • Adicionado budget_locked

  • Adicionado actual_completion_date

• form_template:

  • Adicionado company_id

  • Adicionado created_by_id

  • Adicionado prostore_file_id

  • Adicionado audit_transaction_timestamp

  • Adicionado form_template_id

  • Nome adicionado

  • Descrição adicionada

  • Adicionado created_at

  • Adicionado updated_at

  • Adicionado archived_at

• Compromissos:

  • Adicionado draft_change_orders_company_currency

  • Adicionado invoiced_company_currency

  • Adicionado pending_change_orders_company_currency

  • Adicionado pending_revised_contract_amount_company_currency

  • Adicionado approved_change_orders_company_currency

  • Adicionado approved_change_orders_project_currency

  • Adicionado contract_user_id_list

  • Adicionado draft_change_orders_project_currency

  • Adicionado invoiced_project_currency

  • Adicionado pending_change_orders_project_currency

  • Adicionado pending_revised_contract_amount_project_currency

  • Adicionado remaining_balance_project_currency

  • Adicionado revised_contract_amount_project_currency

  • Adicionado workflow_distribution_member_id_list

  • Adicionado workflow_role_user_id_list

  • Adicionado pending_revised_contract_amount_company_currency

• commitment_change_order_workflow_responses:

  • Adicionado current_step_response

• commitment_pco_workflow_responses:

  • Adicionado current_step_response

• correspondence_workflow_responses:

  • Adicionado current_step_response

• drawing_revision:

  • Adicionado current_revision

  • Adicionado reviewed_by_id

  • Adicionado status_id

• prime_contracts:

  • Adicionado contract_user_id_list

  • Adicionado workflow_distribution_member_id_list

  • Adicionado workflow_role_user_id_list

• budget_change_workflow_responses:

  • Adicionado current_step_response

  • Adicionado remaining_balance_company_currency

  • Adicionado revised_contract_amount_company_currency

• bid_item:

  • Adicionado bid_vendor_id

• bid_vendor:

  • Adicionado bid_form_id

• estimate_adjustment:

  • Adicionado procore_project_id

• estimate_budget_item:

  • Adicionado procore_project_id

• estimate_budget_item_included_item:

  • Adicionado procore_project_id

• estimate_layer_groups:

  • Adicionado procore_project_id

• estimate_layers:

  • Adicionado procore_project_id

• Estimativas:

  • Adicionado procore_project_id

• estimating_project_custom_fields:

  • Adicionado procore_project_id

• action_plan:

  • Adicionado assignee_party_id_list

  • Adicionado completed_plan_receiver_party_id_list

• correspondence_assignees:

  • Adicionado user_id

• correspondence_distributions:

  • Adicionado user_id

• Correspondências:

  • Adicionado assignee_id_list

  • Adicionado composite_provider_key

  • Adicionado distribution_member_id_list

• daily_log_accident:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_construction_reports:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_delay:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_delivery:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_dumpster:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_equipment:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_inspection:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_manpower:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_note:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_observed_weather_condition:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_phone_call:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_plan_revision:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_productivity:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_quantity:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_safety_violation:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_scheduled_work:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_visitor:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• daily_log_waste:

  • Adicionado created_by_collaborator

  • Adicionado raw_status

• inspection_items:

  • Adicionado date_value_timestamp

• Incidente:

  • Adicionado distribution_member_id_list

  • Adicionado recipient_id_list

• incident_alert:

  • Adicionado permission_recipient_id

  • Adicionado recipient_name

• site_instruction_attentions:

  • Adicionado member_name

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado site_instruction_attention_id

  • Adicionado member_id

  • Adicionado project_id

  • Adicionado site_instruction_id

• site_instruction_distribution_members:

  • Adicionado member_name

  • Adicionado site_instruction_distribution_member_id

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado member_id

  • Adicionado project_id

  • Adicionado site_instruction_id

• site_instructions:

  • Adicionado attention_user_id_list

  • Adicionado distribution_member_id_list

• Inspecções:

  • Adicionado assignee_id_list

  • Adicionado distribution_member_id_list

  • Adicionado signature_id_list

• Reunião:

  • Adicionado assignee_id_list

• meeting_attendee:

  • Adicionado person_id

• Observação:

  • Adicionado distribution_member_ids

• observation_distribution_member:

  • Adicionado user_id

• punch_item:

  • Adicionado assignee_id_list

  • Adicionado distribution_member_id_list

  • Adicionado permission_workflow_status

• rfi_responses:

  • Adicionado assignee_id_list

  • Adicionado distribution_member_id_list

  • Adicionado rfi_created_by_id

  • Adicionado rfi_draft

  • Adicionado rfi_hidden

  • Adicionado rfi_manager_id

  • Adicionado rfi_private

• RFIs:

  • Adicionado assignee_id_list

  • Adicionado distribution_member_id_list

• schedule_calendar_item:

  • Adicionado assigned_id

• schedule_lookahead:

  • Adicionado created_by_id

• schedule_lookahead_task:

  • Adicionado created_by_id

• schedule_task:

  • Adicionado created_by_id

• maintenance_record:

  • Tipo adicionado

  • Duração adicionada

  • Adicionado start_date

  • Problema adicionado

  • Notas adicionadas

  • Adicionado maintenance_record_id

  • Adicionado company_id

  • Adicionado equipment_id

• owner_invoice_workflow_responses:

  • Adicionado current_step_response

• Tarefa:

  • Adicionado assignee_user_id_list

  • Adicionado created_by_id

  • Adicionado task_item_distribution_member_id_list

• task_assignee:

  • Adicionado assignee_id

• task_distribution_member:

  • Adicionado user_id

• prime_contract_workflow_responses:

  • Adicionado current_step_response

• prime_contract_change_order_workflow_responses:

  • Adicionado current_step_response

• prime_contract_pco_workflow_responses:

  • Adicionado current_step_response

• Submissões:

  • Adicionado approvers_ids

  • Adicionado distribution_id_list

• specification_sections:

  • Adicionado current_revision

  • Adicionado issued_date

  • Adicionado received_date

  • Revisão adicionada

• Estimativa:

  • Adicionado include_in_primary_estimate

• equipment_timecard_entry_custom_fields:

  • Adicionado batch_id

  • Adicionado partition_company_id

  • Adicionado equipment_timecard_entry_id

  • Adicionado equipment_timecard_entry_custom_field_id

  • Adicionado custom_field_value

  • Adicionado custom_field_value_id

  • Adicionado custom_field_definitions_id

  • Adicionado custom_field_name

  • Adicionado custom_field_data_type

  • Adicionado company_id

  • Adicionado project_id

• estimating_projects:

  • Adicionado primary_contact_full_address

• subcontractor_invoice_workflow_responses:

  • Adicionado current_step_response

• Atribuições:

  • Adicionado percent_allocation

• wp_wage_overrides:

  • Adicionado wp_project_id

  • Adicionado wp_wage_override_id

  • Adicionado job_title_id

  • Adicionado company_id

  • Adicionado job_title

  • Adicionado wage_override_rate

  • Adicionado project_id

• Tags:

  • Adicionado wp_people_id

  • Adicionado wp_project_id

• commitment_workflow_response_occurrences:

  • Adicionado current_step_response

Atualizações de dados do Analytics 2.0 (28/10/2025)

O Procore atualizou os seguintes modelos (tabelas):

• inspection_items:

  • Adicionado attachment_count

• correspondences_workflow_responses:

  • Adicionado current_step_response

Atualizações de dados do Analytics 2.0 (21/10/2025)

O Procore atualizou os seguintes modelos (tabelas):

• action_plan:

  • Adicionado status_id

• actual_production_quantities:

  • Descrição adicionada

• bid_vendor:

  • Adicionado audit_transaction_timestamp

• assembly_part:

  • Adicionado difficulty_factor

  • Adicionado labor_margin

  • Adicionado total_cost

  • Adicionado total_labor_sales

  • Adicionado unit_labor_mins

  • Adicionado unit_sales

• bid_package:

  • Adicionado require_

    Nda

• bid_vendor:

  • Adicionado bid_form_id

  • Adicionado bid_id

  • Adicionado bid_package_id

  • Adicionado bid_vendor_id

  • Adicionado company_id

  • Adicionado created_at

  • Adicionado jobsite_proximity_in_miles

  • Adicionado project_id

  • Adicionado updated_at

  • Adicionado vendor_address

  • Adicionado vendor_affirmative_action

  • Adicionado vendor_african_american_business

  • Adicionado vendor_asian_american_business

  • Adicionado vendor_authorized_bidder

  • Adicionado vendor_avg_company_rating

  • Adicionado vendor_business_phone

  • Adicionado vendor_certified_business_enterprise

  • Adicionado vendor_city

  • Adicionado vendor_country

  • Adicionado vendor_disadvantaged_business

  • Adicionado vendor_eight_a_business_enterprise

  • Adicionado vendor_hispanic_business

  • Adicionado vendor_historically_underutlized_business

  • Adicionado vendor_id

  • Adicionado vendor_minority_business_enterprise

  • Adicionado vendor_name

  • Adicionado vendor_native_american_business

  • Adicionado vendor_service_disabled_veteran_owned_small_business

  • Adicionado vendor_small_business

  • Adicionado vendor_state

  • Adicionado vendor_trades

  • Adicionado vendor_womens_business

  • Adicionado vendor_zip

• Oferta:

  • Adicionado bid_vendor_id

  • Adicionado nda_activity

• change_event_line_item_with_markups:

  • Adicionado non_committed_cost

  • Adicionado non_committed_cost_company_currency

  • Adicionado non_committed_cost_project_currency

• commitment_change_orders:

  • Adicionado change_reason

• company_granular_permissions:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_granular_permission_id

  • Adicionado company_id

  • Adicionado login_information_id

  • Adicionado tool_bid_board_can_access_projects_for_all_users

  • Adicionado tool_bid_board_can_add_notes

  • Adicionado tool_bid_board_can_edit_docs

  • Adicionado tool_bid_board_can_edit_project_details

  • Adicionado tool_bid_board_can_export_bid

  • Adicionado tool_directory_add_user_to_project

  • Adicionado tool_directory_assign_to_future_projects

  • Adicionado tool_directory_create_users

  • Adicionado tool_directory_create_vendors

  • Adicionado tool_directory_remove_user_from_project

  • Adicionado tool_directory_view_user_details

  • Adicionado tool_directory_view_vendor_details

• company_permissions:

  • Adicionado permission_template_id

• Contrato:

  • Adicionado bid_vendor_id

• daily_log_types:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado created_at

  • Adicionado daily_log_type_id

  • Adicionado habilitado

  • Rótulo adicionado

  • Nome adicionado

  • Adicionado updated_at

• Equipamento:

  • Adicionado daily_logs_count_l7

  • Adicionado engine_hours_changes_count_l7

  • Adicionado inspections_count_l7

  • Adicionado is_idle_last_7_days

  • Adicionado last_activity

  • Adicionado last_activity_date

  • Adicionado last_daily_log_date

  • Adicionado last_engine_hours_activity_date

  • Adicionado last_inspection_date

  • Adicionado last_location_activity_date

  • Adicionado last_timecard_date

  • Adicionado location_changes_count_l7

  • Adicionado timecards_count_l7

• Forma:

  • Adicionado template_archived_date

• Inspecções:

  • Grupo adicionado

  • Adicionado reinspected_by_id

  • Adicionado reinspected_by_name

  • Adicionado reinspected_from_id

  • Adicionado reinspected_from_name

• Reunião:

  • Adicionado distributed_at

  • Adicionado distributed_by_id

  • Adicionado distributed_by_name

  • Adicionado last_distributed_event

• Observação:

  • Grupo adicionado

• project_granular_permissions:

  • Adicionado audit_transaction_timestamp

  • Adicionado company_id

  • Adicionado login_information_id

  • Adicionado pk_user_id

  • Adicionado project_granular_permission_id

  • Adicionado project_id

  • Adicionado tool_action_plans_act_as_approver

  • Adicionado tool_action_plans_act_as_receiver

  • Adicionado tool_action_plans_create_and_edit_plan

  • Adicionado tool_action_plans_create_test_records_as_assignee

  • Adicionado tool_action_plans_delete_plan

  • Adicionado tool_action_plans_edit_due_date

  • Adicionado tool_action_plans_edit_item_notes_as_assignee

  • Adicionado tool_action_plans_edit_item_status_as_assignee

  • Adicionado tool_action_plans_edit_notifications

  • Adicionado tool_action_plans_edit_project_templates

  • Adicionado tool_action_plans_link_record

  • Adicionado tool_action_plans_sign_as_any_assignee

  • Adicionado tool_action_plans_sign_as_same_company_approver

  • Adicionado tool_action_plans_sign_as_same_company_assignee

  • Adicionado tool_action_plans_sign_as_same_company_receiver

  • Adicionado tool_action_plans_sign_as_self_assignee

  • Adicionado tool_action_plans_unlink_record

  • Adicionado tool_admin_manage_locations

  • Adicionado tool_admin_manage_wbs_codes

  • Adicionado tool_admin_update_active_tabs

  • Adicionado tool_admin_update_cost_codes

  • Adicionado tool_admin_update_general_settings

  • Adicionado tool_budget_create_edit_delete_budget_changes

  • Adicionado tool_budget_delete_budget_line_items

  • Adicionado tool_budget_import_line_items_from_csv

  • Adicionado tool_budget_lock_budget

  • Adicionado tool_budget_modify_original_budget_amount

  • Adicionado tool_budget_send_and_retrieve_from_erp

  • Adicionado tool_budget_view_budget_insights

  • Adicionado tool_budget_view_direct_cost_details

  • Adicionado tool_change_events_can_export_to_pdf_or_csv

  • Adicionado tool_change_events_can_view_change_history

  • Adicionado tool_commitments_create_purchase_order_contract

  • Adicionado tool_commitments_create_work_order_contract

  • Adicionado tool_commitments_select_out_of_scope_wbs_codes_on_commitment_change_orders

  • Adicionado tool_commitments_update_contract_currency_exchange_rate

  • Adicionado tool_commitments_update_purchase_order_contract

  • Adicionado tool_commitments_update_work_order_contract

  • Adicionado tool_commitments_view_private_purchase_order_contract

  • Adicionado tool_commitments_view_private_work_order_contract

  • Adicionado tool_daily_log_copy

  • Adicionado tool_daily_log_log_restrictively

  • Adicionado tool_daily_log_update_own_entries

  • Adicionado tool_daily_log_view_company_entries

  • Adicionado tool_data_extracts_can_create

  • Adicionado tool_data_extracts_can_delete_drafts

  • Adicionado tool_data_extracts_can_download

  • Adicionado tool_data_extracts_can_edit_drafts

  • Adicionado tool_data_extracts_can_extract_data

  • Adicionado tool_data_extracts_can_view

  • Adicionado tool_direct_costs_create_direct_cost

  • Adicionado tool_direct_costs_delete_direct_cost

  • Adicionado tool_direct_costs_update_direct_cost

  • Adicionado tool_direct_costs_update_exchange_rate

  • Adicionado tool_directory_add_user

  • Adicionado tool_directory_assign_project_role

  • Adicionado tool_directory_create_distribution_group

  • Adicionado tool_directory_create_person

  • Adicionado tool_directory_create_user

  • Adicionado tool_directory_create_vendor

  • Adicionado tool_directory_manage_permission_templates

  • Adicionado tool_directory_manage_vendor_insurances

  • Adicionado tool_directory_remove_user

  • Adicionado tool_directory_remove_vendor

  • Adicionado tool_directory_request_imports

  • Adicionado tool_directory_see_vendor_insurances

  • Adicionado tool_directory_update_person

  • Adicionado tool_documents_access_private

  • Adicionado tool_documents_destroy_files_and_folders

  • Adicionado tool_documents_move_files_and_folders

  • Adicionado tool_documents_rename_files_and_folders

  • Adicionado tool_documents_see_recycle_bin

  • Adicionado tool_documents_set_permissions

  • Adicionado tool_drawings_upload_and_review_drawings

  • Adicionado tool_drawings_upload_drawings

  • Adicionado tool_inspections_can_bulk_create_inspections

  • Adicionado tool_inspections_can_reinspect

  • Adicionado tool_inspections_create_edit_inspection_schedules

  • Adicionado tool_meetings_add_comment

  • Adicionado tool_meetings_create

  • Adicionado tool_meetings_delete_own_comment

  • Adicionado tool_meetings_distribute

  • Adicionado tool_meetings_edit

  • Adicionado tool_meetings_manage_meeting_categories

  • Adicionado tool_meetings_manage_meeting_items

  • Adicionado tool_meetings_manage_related_items

  • Adicionado tool_meetings_send_emails

  • Adicionado tool_observations_assign_standard_user

  • Adicionado tool_observations_respond_to_vendor_observation_items

  • Adicionado tool_observations_view_vendor_observation_items

  • Adicionado tool_photos_create_photo_album

  • Adicionado tool_photos_delete_photo_album

  • Adicionado tool_photos_reorder_photo_albums

  • Adicionado tool_photos_view_private_photo_album

  • Adicionado tool_prime_contracts_can_import_markups

  • Adicionado tool_prime_contracts_create_prime_contract

  • Adicionado tool_prime_contracts_delete_prime_contract

  • Adicionado tool_prime_contracts_update_contract_currency_exchange_rate

  • Adicionado tool_prime_contracts_update_prime_contract

  • Adicionado tool_prime_contracts_view_payment_application_detail

  • Adicionado tool_punch_list_respond_to_vendor_punch_items

  • Adicionado tool_punch_list_view_vendor_punch_items

  • Adicionado tool_rfis_act_as_rfi_manager

  • Adicionado tool_rfis_mark_official_responses

  • Adicionado tool_rfis_view_private_rfis

  • Adicionado tool_rfis_view_project_rfi_insights

  • Adicionado tool_schedule_lookahead_create

  • Adicionado tool_schedule_lookahead_delete

  • Adicionado tool_schedule_lookahead_task_create

  • Adicionado tool_schedule_lookahead_task_delete

  • Adicionado tool_schedule_lookahead_task_update

  • Adicionado tool_schedule_lookahead_view

  • Adicionado tool_schedule_lookahead_view_change_history

  • Adicionado tool_schedule_task_update_percent_complete

  • Adicionado tool_specifications_can_configure

  • Adicionado tool_specifications_can_create

  • Adicionado tool_specifications_can_create_specification_set

  • Adicionado tool_specifications_can_delete_pending_specification_uploads

  • Adicionado tool_specifications_can_destroy

  • Adicionado tool_specifications_can_download_specification

  • Adicionado tool_specifications_can_email

  • Adicionado tool_specifications_can_export_specification

  • Adicionado tool_specifications_can_manually_create_divisions

  • Adicionado tool_specifications_can_manually_create_spec_sections

  • Adicionado tool_specifications_can_publish

  • Adicionado tool_specifications_can_relate_items

  • Adicionado tool_specifications_can_review

  • Adicionado tool_specifications_can_show

  • Adicionado tool_specifications_can_show_uploads

  • Adicionado tool_specifications_can_update

  • Adicionado tool_specifications_can_view_all_revision

  • Adicionado tool_specifications_can_view_change_history

  • Adicionado tool_specifications_can_view_deleted_specifications

  • Adicionado tool_submittals_apply_submittal_workflow_template

  • Adicionado tool_submittals_create_submittal

  • Adicionado tool_submittals_create_submittal_package

  • Adicionado tool_submittals_view_private_submittals

  • Adicionado tool_submittals_view_project_submittal_insights

  • Adicionado tool_timesheets_review_timesheets

  • Adicionado tool_transmittals_view_private_transmittals"

• project_permissions:

  • Adicionado permission_template_id

• project_role_memberships:

  • Adicionado updated_at

• invoice_compliance:

  • Adicionado invoice_compliance_id

  • Nome adicionado

  • Tipo adicionado

  • Status adicionado

  • Notas adicionadas

  • Adicionado attachment_count

  • Adicionado effective_date

  • Adicionado expiration_date

  • Adicionado last_modified_by

  • Adicionado last_modified_date

• observation_custom_field_configs:

  • Alteração do formato Custom_field_definitions_id (p. ex., 0_60128 para 12345_60128)

• observation_custom_fields:

  • Alteração do formato Custom_field_definitions_id (p. ex., 0_60128 para 12345_60128)

Correção de bug do Analytics 2.0 (02/09/2025)

O Procore atualizou os seguintes modelos (tabelas):

• Estimate_budget_item_included_item:

  • Adicionado wbs_code_id

• Estimate_budget_item:

  • Adicionado wbs_code_id

Atualizações de dados do Analytics 2.0 (19/08/2025)

O Procore adicionou os seguintes modelos (tabelas):

• Cotação

• Bid_form

• Bid_item

• Bid_package

• company_permissions

• Contato

• project_contacts

• Project_note

• project_permissions

• Project_task

• Project_document

• assembly_part

• estimating_project_custom_field_configs

O Procore atualizou os seguintes modelos (tabelas):

• observation_custom_fields:

  • Mudou type_id de int para bigint

• payments_subtier_waivers:

  • Alteração payment_subtier_waiver_id de bigint para string

• incident_record:

  • Alteração incident_environmental_type de booleano para string

• commitment_change_order_line_items:

  • Adicionado commitment_change_order_line_items.quantity

  • Adicionado commitment_change_order_line_items.tax_code

  • Adicionado commitment_change_order_line_items.uom

• Compromissos:

  • Adicionado commitments.approved_change_orders

  • Adicionado commitments.draft_change_orders

  • Compromissos adicionados.faturado

  • Adicionado commitments.pending_change_orders

  • Adicionado commitments.pending_revised_contract_amount

• owner_invoice_line_item_with_markups:

  • Adicionado owner_invoice_line_item_with_markups.materials_retainage_released_this_period

  • Adicionado owner_invoice_line_item_with_markups.materials_retainage_released_this_period_company_currency

  • Adicionado owner_invoice_line_item_with_markups.materials_retainage_released_this_period_project_currency

• owner_invoice_line_items:

  • Adicionado owner_invoice_line_items.materials_retainage_released_this_period

  • Adicionado owner_invoice_line_items.materials_retainage_released_this_period_company_currency

  • Adicionado owner_invoice_line_items.materials_retainage_released_this_period_project_currency

• owner_invoice_markup_line_items:

  • Adicionado owner_invoice_markup_line_items.materials_retainage_released_this_period

  • Adicionado owner_invoice_markup_line_items.materials_retainage_released_this_period_company_currency

  • Adicionado owner_invoice_markup_line_items.materials_retainage_released_this_period_project_currency

• owner_invoices:

  • Adicionado owner_invoices.created_by_id

• payments_subtier_waivers:

  • Adicionado payments_subtier_waivers.waiver_required

• subcontractor_invoices:

  • Adicionado subcontractor_invoices.created_by_id

  • Adicionado subcontractor_invoices.total_contract_amount

• Foto:

  • Adicionado photo.uploaded_by_id

• Atribuições:

  • Adicionado assignments.employee_id

• time_and_material_equipments:

  • Adicionado time_and_material_equipments.equipment_id

  • Adicionado time_and_material_equipments.equipment_identification_number

  • Adicionado time_and_material_equipments.equipment_name_legacy

• time_off:

  • Adicionado time_off.employee_id

• timecard_entries:

  • Adicionado timecard_entries.party_employee_id adicionado

  • Adicionado timesheet_id

• wp_people:

  • Adicionado wp_people.party_id

• wp_role:

  • Adicionado wp_roles.audit_transaction_timestamp

  • Adicionado wp_roles.employee_id

• Fornecedor:

  • Adicionado avg_company_rating

• Projeto de Estimativa:

  • Adicionado created_by_id

  • Adicionado primary_contact_full_address

• budget_snapshot_line_item_headers:

  • Adicionado line_items

• Solicitações:

  • Status adicionado

• wp_people:

  • Adicionado customer_employee_id

  • Adicionado user_id

• incident_records:

  • Adicionado affected_user_id

Atualizações de dados do Analytics 2.0 (22/07/2025)

O Procore adicionou os seguintes modelos (tabelas):

• 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

O Procore atualizou os seguintes modelos (tabelas):

• project_vendors:

  • Adicionado project_vendors.avg_company_rating

  • Adicionado project_vendors.invoice_contact_email_address

  • Adicionado project_vendors.invoice_contact_full_name

• Fornecedores:

  • Adicionado vendors.avg_company_rating

  • Adicionado vendors.invoice_contact_email_address

  • Adicionado vendors.invoice_contact_full_name

• direct_costs:

  • Adicionado direct_costs.created_by_id

• payments_subtiers:

  • Adicionado payments_subtiers.hired_by_company_name

  • Adicionado payments_subtiers.tier

  • Adição payments_subtiers.hierarquização

• subcontractor_invoices:

  • Adicionado subcontractor_invoices.early_pay_fee_amount_calculated

• incident_record:

  • Adicionado incident_record.affected_party_id adicionado

  • Adicionado incident_record.affected_party_name

• inspection_items:

  • Adicionado inspection_items.respondable

• inspection_signature_requests:

  • Adicionado inspection_signature_requests.requested

  • Adicionado inspection_signature_requests.requested_login

• Submissões:

  • Adicionado submittals.source_submittal_id

  • Adicionado submittals.specification_area_name

• actual_production_quantities:

  • Adicionado actual_production_quantities.created_by_id

• budgeted_production_quantities:

  • Adicionado budgeted_production_quantities.created_by_id

• Equipamento:

  • Adicionado equipment.project_id

• time_and_material_entries:

  • Adicionado time_and_material_entries.created_by_id

• timecard_entries:

  • Adicionado timecard_entries.created_by_id

Atualizações de dados do Analytics 2.0 (17/06/2025)

O Procore adicionou os seguintes modelos (tabelas):

• Company_folder_documents

• Folder_documents

• Folder_watchers

• Equipment_telematic

• wp_project_custom_fields

• estimating_project_custom_field_configs

O Procore atualizou os seguintes modelos (tabelas):

• Alterações no subcontractor_invoice_line_items:

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_before_stored

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_before_stored_company_currency

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_before_stored_project_currency

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_retained_previously

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_retained_before_company_currency

  • Adicionado subcontractor_invoice_line_items.adjusted_materials_retained_before_project_currency

  • Adicionado subcontractor_invoice_line_items.valor_bruto

  • Adicionado subcontractor_invoice_line_items.quanto_bruto_moeda_da_empresa

  • Adicionado subcontractor_invoice_line_items.quanto_bruto_do_projeto_moeda

  • Adicionado subcontractor_invoice_line_items.net_amount

  • Adicionado subcontractor_invoice_line_items.net_amount_company_currency

  • Adicionado subcontractor_invoice_line_items.net_amount_project_currency

  • Adicionado subcontractor_invoice_line_items.retainage_new_materials_from_percent

  • Adicionado subcontractor_invoice_line_items.retainage_new_materials_from_percent_company_currency

  • Adicionado subcontractor_invoice_line_items.retainage_new_materials_from_percent_project_currency

  • Adicionado subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous

  • Adicionado subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_company_currency

  • Adicionado subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_project_currency

  • Adicionado subcontractor_invoice_line_items.commitment_line_item_id adicionado

  • Adicionado subcontractor_invoice_line_items.prime_contract_line_item_id

• Alterações nos envios para aprovação:

  • Adicionado submittals.anticipated_delivery_date_at_close

  • Adicionado submittals.remaining_buffer_time_at_close

  • Adicionado submittals.workflow_progress_at_close

  • Alterações no wp_people:

  • Adicionado wp_people.custom_fields

• Alterações no wp_projects:

  • Adicionado wp_projects.custom_fields

• Alterações no budget_view_details:

  • Adicionado budget_view_details.infojson_currency_conversion

Atualizações de dados do Analytics 2.0 (20/05/2025)

O Procore adicionou os seguintes modelos (tabelas):

• project_company_comments

• Tags

O Procore atualizou os seguintes modelos (tabelas):

• Alterações no company_comments:

  • Adicionado company_comments.audit_transaction_timestamp

  • Adicionado company_comments.rating

• Alterações no company_distribution_groups:

  • Adicionado company_distribution_groups.audit_transaction_timestamp

  • Adicionado company_distribution_groups.project_id

• Alterações no project_distribution_groups:

  • Adicionado project_distribution_groups.audit_transaction_timestamp

  • Adicionado project_distribution_groups.company_id

• Alterações no project_tools:

  • Adicionado project_tools.audit_transaction_timestamp

  • Adicionado project_tools.is_active

• Alterações no budget_codes:

  • Adicionado budget_codes.production_quantity_code_description

• Alterações no drawing_attachment:

  • Adicionado drawing_attachment.folder_document_id

• Alterações nas inspeções:

  • Adicionado inspections.closed_at

• Mudanças de equipamento:

  • Adicionado equipment.status_type

• Alterações no field_productivity:

  • Adicionado field_productivity.hours_utilization_enrp

  • Adicionado field_productivity.projected_hours_at_completion_enrp

Atualizações de dados do Analytics 2.0 (22/04/2025)

O Procore adicionou os seguintes modelos (tabelas):

• 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

O Procore atualizou os seguintes modelos (tabelas):

• Alterações no project_role_memberships:

  • Adicionado: project_role_memberships.employee_id

• Alterações no project_vendors:

  • Adicionado: project_vendors.cost_codes

  • Adicionado: project_vendors.trades

• Mudanças em projetos:

  • Adicionado: projects.schedule_last_updated

  • Adicionado: projects.schedule_percent_completion

• Alterações nos fornecedores:

  • Adicionado: vendors.cost_codes

  • Adicionado: vendors.trades

• Alterações no budget_change_adjustment_line_items:

  • Adicionado: budget_change_adjustment_line_items.budget_changes_approved_amount

  • Adicionado: budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency

  • Adicionado: budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency

  • Adicionado: budget_change_adjustment_line_items.budget_changes_draft_amount

  • Adicionado: budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency

  • Adicionado: budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency

  • Adicionado: budget_change_adjustment_line_items.budget_changes_under_review_amount

  • Adicionado: budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency

  • Adicionado: budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency

• Alterações no budget_columns:

  • Adicionado: budget_columns.budget_column_id

• Alterações no budget_snapshot_line_item_forecasts:

  • Adicionado: budget_snapshot_line_item_forecasts.approval_status

  • Adicionado: budget_snapshot_line_item_forecasts.snapshot_type

• Alterações no budget_snapshot_line_item_headers:

  • Adicionado budget_snapshot_line_item_headers.approval_status

  • Adicionado: budget_snapshot_line_item_headers.audit_transaction_timestamp

  • Adicionado: budget_snapshot_line_item_headers.snapshot_type

• Alterações no budget_snapshot_line_items:

  • Adicionado budget_snapshot_line_items.approval_status

  • Adicionado: budget_snapshot_line_items.audit_transaction_timestamp

  • Adicionado: budget_snapshot_line_items.snapshot_type

• Alterações no change_event_line_item_with_markups:

  • Adicionado: change_event_line_item_with_markups.links_commitment_contract_cost

  • Adicionado: change_event_line_item_with_markups.links_commitment_pco_cost

  • Adicionado: change_event_line_item_with_markups.links_contract

  • Adicionado: change_event_line_item_with_markups.links_edit

  • Adicionado: change_event_line_item_with_markups.links_prime_pco_cost

  • Adicionado: change_event_line_item_with_markups.links_rfq_amount

  • Adicionado: change_event_line_item_with_markups.links_rom

  • Adicionado: change_event_line_item_with_markups.links_view

• Alterações no commitment_line_items:

  • Adicionado: commitment_line_items.contracts_approved_amount

  • Adicionado: commitment_line_items.contracts_approved_amount_company_currency

  • Adicionado: commitment_line_items.contracts_approved_amount_project_currency

  • Adicionado: commitment_line_items.contracts_complete_amount

  • Adicionado: commitment_line_items.contracts_complete_amount_company_currency

  • Adicionado: commitment_line_items.contracts_complete_amount_project_currency

  • Adicionado: commitment_line_items.contracts_draft_amount

  • Adicionado: commitment_line_items.contracts_draft_amount_company_currency

  • Adicionado: commitment_line_items.contracts_draft_amount_project_currency

  • Adicionado: commitment_line_items.contracts_out_for_signature_amount

  • Adicionado: commitment_line_items.contracts_out_for_signature_amount_company_currency

  • Adicionado: commitment_line_items.contracts_out_for_signature_amount_project_currency

• Alterações nos compromissos:

  • Adicionado: commitments.global_insurance_compliance

  • Adicionado: commitments.project_insurance_compliance

  • Adicionado: commitments.remaining_balance

  • Adicionado: commitments.revised_contract_amount

• Alterações no payments_issued:

  • Adicionado: payments_issued.early_pay_fee_amount

• Alterações no payments_project_controls:

  • Adicionado payments_project_controls.assigned_early_pay_program

  • Adicionado: payments_project_controls.audit_transaction_timestamp

  • Adicionado: payments_project_controls.early_pay_program_id

• Alterações no payments_subtier_waivers:

  • Adicionado: payments_subtier_waivers.joint_check_requisition

• Alterações no payments_subtiers:

  • Adicionado payments_subtiers.additional_address_information

  • Adicionado: payments_subtiers.address

  • Adicionado: payments_subtiers.amount_billed_to_date

  • Adicionado: payments_subtiers.city

  • Adicionado: payments_subtiers.country

  • Adicionado: payments_subtiers.joint_check_future_requisitions

  • Adicionado: payments_subtiers.kind_of_work

  • Adicionado: payments_subtiers.phone

  • Adicionado: payments_subtiers.state

  • Adicionado: payments_subtiers.subtier_type

  • Adicionado: payments_subtiers.waiver_contact_email

  • Adicionado: payments_subtiers.zip

• Alterações no prime_contract_change_order_requests:

  • Adicionado: prime_contract_change_order_requests.schedule_impact_days

• Alterações no prime_contract_change_orders:

  • Adicionado: prime_contract_change_orders.schedule_impact_days

• Alterações no prime_contract_potential_change_orders:

  • Adicionado: prime_contract_potential_change_orders.schedule_impact_days

• Alterações no subcontractor_invoices:

  • Adicionado: subcontractor_invoices.early_pay_fee_amount

  • Adicionado: subcontractor_invoices.early_pay_fee_rate

  • Adicionado: subcontractor_invoices.early_pay_status

  • Adicionado: subcontractor_invoices.missed_payment_due_date

  • Adicionado: subcontractor_invoices.original_payment_due

  • Adicionado: subcontractor_invoices.original_payment_due_company_currency

  • Adicionado: subcontractor_invoices.original_payment_due_project_currency

  • Adicionado: subcontractor_invoices.payment_due_date

• Alterações no correspondence_types:

  • Adicionado: correspondence_types.created_at

• Alterações no correspondence_workflow_steps:

  • Adicionado: correspondence_workflow_steps.current_step_due_date

• Alterações no daily_log_accident_custom_fields:

  • Adicionado: daily_log_accident_custom_fields.type_id

• Alterações no daily_log_completion:

  • Adicionado: daily_log_completion.created_at

• Alterações no daily_log_construction_report_custom_fields:

  • Adicionado: daily_log_construction_report_custom_fields.type_id

• Alterações no daily_log_delay_custom_fields:

  • Adicionado: daily_log_delay_custom_fields.type_id

• Alterações no daily_log_delivery_custom_fields:

  • Adicionado: daily_log_delivery_custom_fields.type_id

• Alterações no daily_log_dumpster_custom_fields:

  • Adicionado: daily_log_dumpster_custom_fields.type_id

• Alterações no daily_log_equipment:

  • Adicionado: daily_log_equipment.equipment_id

  • Adicionado: daily_log_equipment.equipment_identification_number

  • Adicionado: daily_log_equipment.equipment_name_beta

• Alterações no daily_log_equipment_custom_fields:

  • Adicionado: daily_log_equipment_custom_fields.type_id

• Alterações no daily_log_inspection_custom_fields:

  • Adicionado: daily_log_inspection_custom_fields.type_id

• Alterações no daily_log_manpower_custom_fields:

  • Adicionado: daily_log_manpower_custom_fields.type_id

• Alterações no daily_log_plan_revision_custom_fields:

  • Adicionado: daily_log_plan_revision_custom_fields.type_id

• Alterações no daily_log_productivity_custom_fields:

  • Adicionado: daily_log_productivity_custom_fields.type_id

• Alterações no daily_log_scheduled_work_task:

  • Adicionado: daily_log_scheduled_work_task.created_at

• Alterações no drawing_revision:

  • Adicionado: drawing_revision.created_at

• Alterações no incident_alert:

  • Adicionado: incident_alert.created_at

  • Adicionado: incident_alert.updated_at

• Alterações no inspection_distribution_list:

  • Adicionado: inspection_distribution_list.created_at

  • Adicionado: inspection_distribution_list.updated_at

• Alterações no inspection_item_signature_requests:

  • Adicionado: inspection_item_signature_requests.created_at

  • Adicionado: inspection_item_signature_requests.updated_at

• Alterações no inspection_schedule_assignees:

  • Adicionado: inspection_schedule_assignees.created_at

  • Adicionado: inspection_schedule_assignees.updated_at

• Alterações no inspection_schedule_distribution_list:

  • Adicionado: inspection_schedule_distribution_list.created_at

  • Adicionado: inspection_schedule_distribution_list.updated_at

• Alterações no inspection_schedules:

  • Adicionado: inspection_schedules.created_at

  • Adicionado: inspection_schedules.equipment_id

  • Adicionado: inspection_schedules.equipment_identification_number

  • Adicionado: inspection_schedules.nome_do_equipamento

  • Adicionado: inspection_schedules.updated_at

• Alterações no meeting_attendee:

  • Adicionado: meeting_attendee.created_at

  • Adicionado: meeting_attendee.updated_at

• Alterações no meeting_item_assignee:

  • Adicionado: meeting_item_assignee.updated_at

• Alterações no observation_distribution_member:

  • Adicionado: observation_distribution_member.created_at

• Alterações no punch_item:

  • Adicionado: punch_item.audit_transaction_timestamp

• Alterações no punch_item_bic:

  • Adicionado punch_item_bic.audit_transaction_timestamp

  • Adicionado: punch_item_bic.ball_in_court_role

• Alterações no punch_item_custom_fields:

  • Adicionado: punch_item_custom_fields.type_id

• Alterações no punch_item_distribution_member:

  • Adicionado punch_item_distribution_member.audit_transaction_timestamp

• Alterações no rfi_assignees:

  • Adicionado: rfi_assignees.audit_transaction_timestamp

• Alterações no rfi_distributions:

  • Adicionado rfi_distributions.audit_transaction_timestamp

• Alterações no rfi_responses:

  • Adicionado rfi_responses.audit_transaction_timestamp

• Alterações nas rfis:

  • Adicionado: rfis.audit_transaction_timestamp

  • Adicionado: rfis.current_revision

  • Adicionado: rfis.revision

• Alterações no rfis_bic:

  • Adicionado rfis_bic.audit_transaction_timestamp

  • Adicionado: rfis_bic.ball_in_court_role

• Alterações no schedule_calendar_item:

  • Adicionado: schedule_calendar_item.audit_transaction_timestamp

• Alterações no schedule_lookahead:

  • Adicionado schedule_lookahead.audit_transaction_timestamp

• Alterações no schedule_lookahead_task:

  • Adicionado: schedule_lookahead_task.audit_transaction_timestamp

• Alterações no schedule_task:

  • Adicionado: schedule_task.audit_transaction_timestamp

• Alterações no schedule_task_changes:

  • Adicionado: schedule_task_changes.audit_transaction_timestamp

• Alterações no schedule_task_requests:

  • Adicionado schedule_task_requests.audit_transaction_timestamp

• Alterações no site_instructions:

  • Adicionado: site_instructions.audit_transaction_timestamp

• Alterações no specification_sections:

  • Adicionado specification_sections.audit_transaction_timestamp

• Alterações no submittal_approvers:

  • Adicionado submittal_approvers.audit_transaction_timestamp

  • Adicionado: submittal_approvers.comments

• Alterações no submittal_ball_in_courts:

  • Adicionado submittal_ball_in_courts.audit_transaction_timestamp

  • Adicionado: submittal_ball_in_courts.response_required

• Alterações no submittal_distributions:

• Adicionado submittal_distributions.audit_transaction_timestamp

• Alterações nos envios para aprovação:

  • Adicionado: submittals.audit_transaction_timestamp

  • Adicionado: submittals.closed_at

• Alterações na tarefa:

  • Adicionado: task.audit_transaction_timestamp

• Alterações no task_activity:

  • Adicionado: task_activity.audit_transaction_timestamp

• Alterações no task_assignee:

  • Adicionado: task_assignee.audit_transaction_timestamp

• Mudanças de equipamento:

  • Adicionado: equipment.rental_end_date

  • Adicionado: equipment.rental_start_date

  • Adicionado: equipment.vendor_name

• Alterações no field_productivity:

  • Adicionado: field_productivity.cost_code_id

  • Adicionado: field_productivity.production_quantity_code

Atualizações de dados do Analytics 2.0 (18/03/2025)

O Procore adicionou os seguintes modelos (tabelas):

• Segmentos de código de orçamento

• Valores da EAP da camada

• Valores da EAP do grupo de camadas

• Ajuste de Estimativa

O Procore atualizou os seguintes modelos (tabelas):

• Mudanças no correspondence_workflow_steps

  • Adicionado current_step_due_date

  • Adicionado current_step_name

• Alterações no payments_disbursements

  • Adicionado owner_invoices.tax_applicable_to_this_payment_company_currency

  • Adicionado owner_invoices.tax_applicable_to_this_payment_project_currency

• Mudanças no subcontractor_invoice_line_items

  • Adicionado payments_disbursements.number

  • Adicionado subcontractor_invoice_line_items.total_retainage_company_currency

  • Adicionado subcontractor_invoice_line_items.total_retainage_project_currency

• Mudanças no action_plan

  • Adicionado action_plan.audit_transaction_timestamp

• Mudanças no action_plan_approver

  • Adicionado action_plan_approver.audit_transaction_timestamp

• Mudanças no action_plan_completed_receiver

  • Adicionado action_plan_completed_receiver.audit_transaction_timestamp

• Alterações no action_plan_line_item

  • Adicionado action_plan_line_item.audit_transaction_timestamp

• Mudanças no action_plan_line_item_assignee

  • Adicionado action_plan_line_item_assignee.audit_transaction_timestamp

• Mudanças no action_plan_line_item_record

  • Adicionado action_plan_line_item_record.audit_transaction_timestamp

• Mudanças no action_plan_line_item_record_request

  • Adicionado action_plan_line_item_record_request.audit_transaction_timestamp

• Mudanças no action_plan_line_item_reference

  • Adicionado action_plan_line_item_reference.audit_transaction_timestamp

• Mudanças no drawing_revision

  • Adicionado drawing_revision.is_connected_drawing

• Mudanças no incident_record

  • Adicionado incident_record.affected_person_id adicionado

• Mudanças na observação

  • Adicionado observation.created_by_company

• Mudanças no rfi_responses

  • Adicionado rfi_responses.is_most_recent

• Mudanças no rfis_bic

  • Adicionado rfis_bic.response_required

• Mudanças no schedule_task

  • Adicionado schedule_task.predecessor_wbs_list

  • Adicionado schedule_task.successor_wbs_list adicionado

• Mudanças no specification_sections

  • 'Adicionado specification_sections.specification_area_description

  • Adicionado specification_sections.specification_area_name adicionado

• Mudanças no submittal_approvers

  • Adicionado submittal_approvers.previous_due_date

  • Adicionado submittal_approvers.previous_returned_date

  • Adicionado submittal_approvers.previous_sent_date

• Mudanças no wp_projects

  • Adicionado wp_projects.categories

• Adicionado users.audit_transaction_timestamp

• Adicionado estimate_layer_groups.profit

Atualizações de dados do Analytics 2.0 (18/02/2025)

O Procore adicionou os seguintes modelos (tabelas):

• Financeiro

  • payments_permissions

  • payments_disbursements

  • pay_requirement_settings

  • payments_project_controls

  • payments_invites

  • payments_agreements

  • payments_received

• Gestão de projetos

  • 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

• Planejamento de Recursos

  • Atribuições

  • Cargos

  • Solicitações

  • férias

  • WP pessoas

  • Projetos WP

  • Grupos

• Equipamento

  • equipamento

  • Registro de projeto de equipamentos

  • entrada no cartão de ponto de equipamentos

• Estimativas

  • Estimando projetos

  • Estimar camadas

  • Estimar camada grupos

  • Campos personalizados do projeto de estimativa

O Procore atualizou os seguintes modelos (tabelas):

• Alterações no project_vendor_insurances.sql:

  • Adicionado project_vendor_insurances.external_origin_data

  • Adicionado project_vendor_insurances.external_origin_id

• Alterações no projects.sql:

  • Adicionado projects.code

  • Adicionado projects.delivery_method

  • Adicionado projects.external_origin_data

  • Adicionado projects.external_origin_id

  • Adicionado projects.sector

  • Adicionado projects.work_scope

• Alterações no users.sql:

  • Adicionado users.abbreviated_name

  • Adicionado users.can_push_to_accounting

  • Adicionado users.company_name

  • Adicionado users.company_permission_template

  • Adicionado users.external_origin_data

  • Adicionado users.external_origin_id

  • Adicionado users.login_information_id

  • Adicionado users.origin_id

  • Adicionado users.origin_name

• Alterações no budget_changes.sql:

  • Adicionado budget_changes.external_origin_data

  • Adicionado budget_changes.external_origin_id

• Alterações no budget_line_items.sql:

  • Adicionado budget_line_items.budget_notes

• Alterações no change_events.sql:

  • Adicionado change_events.external_origin_data

  • Adicionado change_events.external_origin_id

• Alterações no commitment_change_orders.sql:

  • Adicionado commitment_change_orders.external_origin_data

  • Adicionado commitment_change_orders.external_origin_id

• Alterações no commitment_line_items.sql:

  • Adicionado commitment_line_items.external_origin_data

  • Adicionado commitment_line_items.external_origin_id

• Alterações no direct_cost_line_items.sql:

  • Adicionado direct_cost_line_items.external_origin_data

  • Adicionado direct_cost_line_items.external_origin_id

• Alterações no direct_costs.sql:

  • Adicionado direct_costs.external_origin_data

  • Adicionado direct_costs.external_origin_id

• Alterações no owner_invoice_line_item_with_markups.sql:

  • Adicionado owner_invoice_line_item_with_markups.external_origin_data

  • Adicionado owner_invoice_line_item_with_markups.external_origin_id

  • Adicionado owner_invoice_line_item_with_markups.materials_presently_stored_qty

  • Adicionado owner_invoice_line_item_with_markups.name

  • Adicionado owner_invoice_line_item_with_markups.new_materials_stored_qty

  • Adicionado owner_invoice_line_item_with_markups.previous_materials_stored_qty

  • Adicionado owner_invoice_line_item_with_markups.prime_contract_id adicionado

• Alterações no owner_invoice_line_items.sql:

  • Adicionado owner_invoice_line_items.external_origin_data

  • Adicionado owner_invoice_line_items.external_origin_id

  • Adicionado owner_invoice_line_items.line_type

  • Adicionado owner_invoice_line_items.markup_id

  • Adicionado owner_invoice_line_items.materials_presently_stored_qty

  • Adicionado owner_invoice_line_items.name

  • Adicionado owner_invoice_line_items.new_materials_stored_qty

  • Adicionado owner_invoice_line_items.owner_invoice_line_item_with_markup_id

  • Adicionado owner_invoice_line_items.owner_invoice_markup_line_item_id

  • Adicionado owner_invoice_line_items.previous_materials_stored_qty

• Alterações no owner_invoice_markup_line_items.sql:

  • Adicionado owner_invoice_markup_line_items.approved_changes

  • Adicionado owner_invoice_markup_line_items.approved_changes_company_currency

  • Adicionado owner_invoice_markup_line_items.approved_changes_project_currency

  • Adicionado owner_invoice_markup_line_items.balance_to_finish

  • Adicionado owner_invoice_markup_line_items.company_id_2

  • Adicionado owner_invoice_markup_line_items.external_origin_data

  • Adicionado owner_invoice_markup_line_items.external_origin_id

  • Adicionado owner_invoice_markup_line_items.line_type

  • Adicionado owner_invoice_markup_line_items.materials_presently_stored_qty

  • Adicionado owner_invoice_markup_line_items.name

  • Adicionado owner_invoice_markup_line_items.new_materials_stored_qty

  • Adicionado owner_invoice_markup_line_items.owner_invoice_line_item_id

  • Adicionado owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id adicionado

  • Adicionado owner_invoice_markup_line_items.previous_materials_stored_qty

  • Adicionado owner_invoice_markup_line_items.prime_contract_id

• Alterações no owner_invoices.sql:

  • Adicionado owner_invoices.external_origin_data

  • Adicionado owner_invoices.external_origin_id

  • Adicionado owner_invoices.tax_applicable_to_this_payment

• Alterações no payments_issued.sql:

  • Adicionado payments_issued.external_origin_data

  • Adicionado payments_issued.external_origin_id

• Alterações no prime_contract_change_order_line_items.sql:

  • Adicionado prime_contract_change_order_line_items.external_origin_data

  • Adicionado prime_contract_change_order_line_items.external_origin_id

• Alterações no prime_contract_change_order_requests.sql:

  • Adicionado prime_contract_change_order_requests.external_origin_data

  • Adicionado prime_contract_change_order_requests.external_origin_id

• Alterações no prime_contract_change_orders.sql:

  • Adicionado prime_contract_change_orders.external_origin_data

  • Adicionado prime_contract_change_orders.external_origin_id

• Alterações no prime_contract_line_items.sql:

  • Adicionado prime_contract_line_items.external_origin_data

  • Adicionado prime_contract_line_items.external_origin_id

  • Adicionado prime_contract_line_items.vendor_id

• Alterações no prime_contract_potential_change_orders.sql:

  • Adicionado prime_contract_potential_change_orders.external_origin_data

  • Adicionado prime_contract_potential_change_orders.external_origin_id

• Alterações no prime_contracts.sql:

  • Adicionado prime_contracts.external_origin_data

• Adicionado prime_contracts.external_origin_id

• Alterações no subcontractor_invoice_line_items.sql:

  • Adicionado subcontractor_invoice_line_items.materials_presently_stored_qty

  • Adicionado subcontractor_invoice_line_items.materials_before_stored_qty

  • Adicionado subcontractor_invoice_line_items.new_materials_qty

• Alterações no subcontractor_invoices.sql:

  • Adicionado subcontractor_invoices.external_origin_data

  • Adicionado subcontractor_invoices.external_origin_id

• Alterações no inspections.sql:

  • Adicionado inspections.equipment_identification_number

• Alterações no rfi_assignees.sql:

  • Adicionado rfi_assignees.forwarded_by

• Alterações no submittal_approvers.sql:

  • Adicionado submittal_approvers.is_last_step

• Alterações no equipment_timecard_entry.sql:

  • Adicionado equipment_timecard_entry.número_de_identificação_do_equipamento

  • Adicionado equipment_timecard_entry.nome_do_equipamento

Atualizações de dados do Analytics 2.0 (21/01/2025)

O Procore adicionou os seguintes modelos (tabelas):

• inspection_item_references

• schedule_task_changes

• equipamento

• equipment_project_log

• equipment_timecard_entry

• payments_project_controls

• payments_invites

• payments_agreements

• pay_requirement_settings

O Procore atualizou os seguintes modelos (tabelas):

• company_vendor_insurances:

  • Adicionado company_vendor_insurances.template_name

• project_role_memberships:

  • Adicionado project_role_memberships.user_id

• budget_change_workflow_steps:

  • Adicionado budget_change_workflow_steps.current_step_due_date

• budget_codes:

  • Excluído SELECT budget_codes.budget_code

  • Adicionado SELECT budget_codes.attribute_1_line_item

  • Adicionado budget_codes.attribute_1_name

  • Adicionado budget_codes.attribute_2_line_item

  • Adicionado budget_codes.attribute_2_name

  • Adicionado budget_codes.attribute_3_line_item

  • Adicionado budget_codes.attribute_3_name

  • Adicionado budget_codes.budget_code

• budget_columns:

  • Adicionado budget_columns.created_at

  • Adicionado budget_columns.updated_at

• change_event_line_item_with_markups:

  • SELECT excluído change_event_line_item_with_markups.budget_days_in_stage

  • Adicionado SELECT change_event_line_item_with_markups.biller_id

  • Adicionado change_event_line_item_with_markups.biller_model_name

  • Adicionado change_event_line_item_with_markups.biller_name

  • Adicionado change_event_line_item_with_markups.budget_days_in_stage

  • Adicionado change_event_line_item_with_markups.change_event_events_id adicionado

  • Adicionado change_event_line_item_with_markups.change_event_status adicionado

  • Adicionado change_event_line_item_with_markups.change_event_title

  • Adicionado change_event_line_item_with_markups.contract_id

  • Adicionado change_event_line_item_with_markups.número_do_contrato

  • Adicionado change_event_line_item_with_markups.title_do_contrato

  • Adicionado change_event_line_item_with_markups.valor_do_orçamento_estimado

  • Adicionado change_event_line_item_with_markups.estimated_budget_transfer_amount

  • Adicionado change_event_line_item_with_markups.valor_custo_estimado

  • Adicionado change_event_line_item_with_markups.estimated_cost_amount_company_currency

  • Adicionado change_event_line_item_with_markups.estimated_cost_amount_project_currency

  • Adicionado change_event_line_item_with_markups.event_scope

  • Adicionado change_event_line_item_with_markups.proposed_contract_id

  • Adicionado change_event_line_item_with_markups.proposed_vendor_id

  • Adicionado change_event_line_item_with_markups.source

  • Adicionado change_event_line_item_with_markups.vendor_name

  • Adicionado change_event_line_item_with_markups.wbs_code_id

• commitment_change_order_line_items:

  • Adicionado commitment_change_order_line_items.commitment_change_order_request_id adicionado

  • Adicionado commitment_change_order_line_items.commitment_potential_change_order_id adicionado

• commitment_change_order_workflow_steps:

  • Adicionado commitment_change_order_workflow_steps.current_step_due_date

• commitment_custom_field_configs:

  • Adicionado commitment_custom_field_configs.name

• commitment_pco_workflow_steps:

  • Adicionado commitment_pco_workflow_steps.current_step_due_date

• commitment_workflow_step_occurrences:

  • Adicionado commitment_workflow_step_occurrences.current_step_due_date

• contract_compliance_documents:

  • Adicionado contract_compliance_documents.template_name

• owner_invoice_workflow_steps:

  • Adicionado owner_invoice_workflow_steps.current_step_due_date

• owner_invoices:

  • Adicionado owner_invoices.erp_latest_status

  • Adicionado owner_invoices.erp_updated_at

  • Adicionado owner_invoices.erp_user_name

  • Adicionado owner_invoices.synced_with_accounting

• payments_beneficiaries:

  • Adicionado payments_beneficiaries.early_pay_classification

• prime_contract_change_order_line_items:

  • Adicionado prime_contract_change_order_line_items.name

  • Adicionado prime_contract_change_order_line_items.prime_contract_change_order_request_id

  • Adicionado prime_contract_change_order_line_items.prime_contract_potential_change_order_id

• prime_contract_change_order_workflow_steps:

  • Adicionado prime_contract_change_order_workflow_steps.current_step_due_date

• prime_contract_pco_workflow_steps:

  • Adicionado prime_contract_pco_workflow_steps.current_step_due_date

• prime_contract_workflow_steps:

  • Adicionado prime_contract_workflow_steps.current_step_due_date

• subcontractor_invoice_line_items:

  • Adicionado subcontractor_invoice_line_items.total_retainage

• subcontractor_invoice_workflow_steps:

  • Adicionado subcontractor_invoice_workflow_steps.current_step_due_date

• action_plan_custom_fields:

  • Adicionado action_plan_custom_fields.type_id

• action_plan_line_item_record:

  • Adicionado action_plan_line_item_record.action_plan_line_item_record_resource_url

• correspondence_custom_fields:

  • Adicionado correspondence_custom_fields.type_id

• correspondence_response_attachments:

  • Adicionado correspondence_response_attachments.type_id

• correspondence_schedule_tasks:

  • Adicionado correspondence_schedule_tasks.type_id

• correspondence_workflow_responses:

  • Adicionado correspondence_workflow_responses.type_id

• correspondence_workflow_steps:

  • Adicionado correspondence_workflow_steps.type_id

• daily_log_accident:

  • Adicionado daily_log_accident.daily_log_completion_id

• daily_log_construction_reports:

  • Adicionado daily_log_construction_reports.daily_log_completion_id

• daily_log_delay:

  • Adicionado daily_log_delay.daily_log_completion_id

• daily_log_delivery:

  • Adicionado daily_log_delivery.daily_log_completion_id

• daily_log_dumpster:

  • Adicionado daily_log_dumpster.daily_log_completion_id

• daily_log_equipment:

  • Adicionado daily_log_equipment.daily_log_completion_id

• daily_log_inspection:

  • Adicionado daily_log_inspection.daily_log_completion_id

• daily_log_manpower:

  • Adicionado daily_log_manpower.daily_log_completion_id

• daily_log_note:

  • Adicionado daily_log_note.daily_log_completion_id

• daily_log_observed_weather_condition:

  • Adicionado daily_log_observed_weather_condition.daily_log_completion_id

• daily_log_phone_call:

  • Adicionado daily_log_phone_call.daily_log_completion_id

• daily_log_plan_revision:

  • Adicionado daily_log_plan_revision.daily_log_completion_id

• daily_log_productivity:

  • Adicionado daily_log_productivity.daily_log_completion_id

• daily_log_quantity:

  • Adicionado daily_log_quantity.daily_log_completion_id

• daily_log_safety_violation:

  • Adicionado daily_log_safety_violation.daily_log_completion_id

• daily_log_scheduled_work:

  • Adicionado daily_log_scheduled_work.daily_log_completion_id

• daily_log_scheduled_work_task:

  • Adicionado daily_log_scheduled_work_task.daily_log_completion_id

  • Adicionado daily_log_scheduled_work_task.schedule_task_id

• daily_log_visitor:

  • Adicionado daily_log_visitor.daily_log_completion_id

• daily_log_waste:

  • Adicionado daily_log_waste.daily_log_completion_id

• inspection_custom_fields:

• Adicionado inspection_custom_fields.type_id

• inspection_item_signature_requests:

  • Adicionado inspection_item_signature_requests.inspection_schedule_id

• inspection_items:

  • Adicionado inspection_items.position_number

• inspection_schedules:

  • Adicionado inspection_schedules.ends_at

  • Adicionado inspection_schedules.starts_at

• Inspecções:

  • Adicionado inspections.equipment_id

  • Adicionado inspections.equipment_name

• observation_custom_field_configs:

  • Adicionado observation_custom_field_configs.observation_type_id

  • Adicionado observation_custom_field_configs.type_id

• observation_custom_fields:

  • Adicionado observation_custom_fields.type_id

• punch_item_bic:

  • Adicionado punch_item_bic.punch_item_bic_id

• rfis_bic:

  • Adicionado rfis_bic.rfi_bic_id

• schedule_lookahead_task:

  • Adicionado schedule_lookahead_task.task_id_comp

• schedule_task:

  • Adicionado schedule_task.task_id

• submittal_ball_in_courts:

  • Adicionado submittal_ball_in_courts.nome_da_empresa

  • Adicionado submittal_ball_in_courts.role

• Submissões:

  • Adicionado submittals.ball_in_court_role

  • Adicionado envios para aprovação.pausado

• actual_production_quantities:

  • Adicionado actual_production_quantities.wbs_code_id

• budget_change_production_quantities:

  • SELECT excluído budget_change_production_quantities.budget_change_production_quantity_id

  • Adicionado SELECT budget_change_production_quantities.budget_change_id

  • Adicionado budget_change_production_quantities.budget_change_production_quantity_id

  • Adicionado budget_change_production_quantities.wbs_code_id

• prime_potential_change_order_production_quantities:

  • Adicionado prime_potential_change_order_production_quantities.prime_contract_change_order_id adicionado

  • Adicionado prime_potential_change_order_production_quantities.wbs_code_id

• projeto:

  • Adicionado project.code

• owner_invoices:

  • Adicionado owner_invoices. Tax_Applicable_To_This_Payment

• timecard_entries:

  • Adicionado timecard_entries.user_id

Atualizações de dados do Analytics 2.0 (17/12/2024)

O Procore adicionou (current_step_due_date) aos seguintes modelos (tabelas):

• budget_change_workflow_steps

• commitment_change_order_workflow_steps

• commitment_pco_workflow_responses

• commitment_workflow_step_occurrences

• owner_invoice_workflow_steps

• prime_contract_change_order_workflow_steps

• prime_contract_pco_workflow_steps

• prime_contract_workflow_steps

• subcontractor_invoice_workflow_steps

O Procore adicionou os seguintes campos:

• actual_production_quantities.wbs_code_id

• timecard_entries.user_id