Analytics - Data Change Log
Vous trouverez ci-dessous les modifications importantes apportées à la couche de données et d’intelligence Procore, accessible via le connecteur cloud Procore Analytics 2.0.
Changements récents
procore analytics 2.0 data updates (10/21/2025)
Procore a mis à jour les modèles (tableaux) suivants :
action_plan:
Added status_id
actual_production_quantities :
Added description
bid_vendor:
Added audit_transaction_timestamp
assembly_part:
Added difficulty_factor
Added labor_margin
Added total_cost
Added total_labor_sales
Added unit_labor_
mins
Added unit_sales
bid_package:
Added require_
nda
bid_vendor:
Added bid_form_id
Added bid_id
Added bid_package_id
Added bid_vendor_id
Added company_id
Added created_at
Added jobsite_proximity_in_miles
Added project_id
Added updated_at
Added vendor_address
Added vendor_affirmative_action
Added vendor_
african
_
american
_business
Added vendor_asian_
american
_business
Added vendor_authorized_bidder
Added vendor_avg_company_rating
Added vendor_business_phone
Added vendor_certified_business_enterprise
Added vendor_city
Added vendor_country
Added vendor_disadvantaged_business
Added vendor_eight_a_business_enterprise
Added vendor_hispanic_business
Added vendor_historically_
underutlized
_business
Added vendor_id
Added vendor_minority_business_enterprise
Added vendor_name
Added vendor_native_
american
_business
Added vendor_service_disabled_veteran_owned_small_business
Added vendor_small_business
Added vendor_state
Added vendor_trades
Added vendor_
womens
_business
Added vendor_zip
bid:
Added bid_vendor_id
Added
nda
_activity
change_event_line_item_with_markups :
Added non_committed_cost
Added non_committed_cost_company_currency
Added non_committed_cost_project_currency
commitment_change_orders:
Added change_reason
company_granular_permissions:
Added audit_transaction_timestamp
Added company_granular_permission_id
Added company_id
Added login_information_id
Added tool_bid_board_can_access_projects_for_all_users
Added tool_bid_board_can_add_notes
Added tool_bid_board_can_edit_docs
Added tool_bid_board_can_edit_project_details
Added tool_bid_board_can_export_bid
Added tool_directory_add_user_to_project
Added tool_directory_assign_to_future_projects
Added tool_directory_create_users
Added tool_directory_create_vendors
Added tool_directory_remove_user_from_project
Added tool_directory_view_user_details
Added tool_directory_view_vendor_details
company_permissions:
Added permission_template_id
contract:
Added bid_vendor_id
daily_log_types:
Added audit_transaction_timestamp
Added company_id
Added created_at
Added daily_log_type_id
Added enabled
Added label
Added name
Added updated_at
équipement:
Added daily_logs_count_l7
Added engine_hours_changes_count_l7
Added inspections_count_l7
Added is_idle_last_7_days
Added last_activity
Added last_activity_date
Added last_daily_log_date
Added last_engine_hours_activity_date
Added last_inspection_date
Added last_location_activity_date
Added last_timecard_date
Added location_changes_count_l7
Added timecards_count_l7
form:
Added template_archived_date
Inspections:
Added group
Added reinspected_by_id
Added reinspected_by_name
Added reinspected_from_id
Added reinspected_from_name
meeting:
Added distributed_at
Added distributed_by_id
Added distributed_by_name
Added last_distributed_event
observation:
Added group
project_granular_permissions:
Added audit_transaction_timestamp
Added company_id
Added login_information_id
Added pk_user_id
Added project_granular_permission_id
Added project_id
Added tool_action_plans_act_as_approver
Added tool_action_plans_act_as_receiver
Added tool_action_plans_create_and_edit_plan
Added tool_action_plans_create_test_records_as_assignee
Added tool_action_plans_delete_plan
Added tool_action_plans_edit_due_date
Added tool_action_plans_edit_item_notes_as_assignee
Added tool_action_plans_edit_item_status_as_assignee
Added tool_action_plans_edit_notifications
Added tool_action_plans_edit_project_templates
Added tool_action_plans_link_record
Added tool_action_plans_sign_as_any_assignee
Added tool_action_plans_sign_as_same_company_approver
Added tool_action_plans_sign_as_same_company_assignee
Added tool_action_plans_sign_as_same_company_receiver
Added tool_action_plans_sign_as_self_assignee
Added tool_action_plans_unlink_record
Added tool_admin_manage_locations
Added tool_admin_manage_
wbs
_codes
Added tool_admin_update_active_tabs
Added tool_admin_update_cost_codes
Added tool_admin_update_general_settings
Added tool_budget_create_edit_delete_budget_changes
Added tool_budget_delete_budget_line_items
Added tool_budget_import_line_items_from_
csv
Added tool_budget_lock_budget
Added tool_budget_modify_original_budget_amount
Added tool_budget_send_and_retrieve_from_
erp
Added tool_budget_view_budget_insights
Added tool_budget_view_direct_cost_details
Added tool_change_events_can_export_to_
pdf
_or_
csv
Added tool_change_events_can_view_change_history
Added tool_commitments_create_purchase_order_contract
Added tool_commitments_create_work_order_contract
Added tool_commitments_select_out_of_scope_
wbs
_codes_on_commitment_change_orders
Added tool_commitments_update_contract_currency_exchange_rate
Added tool_commitments_update_purchase_order_contract
Added tool_commitments_update_work_order_contract
Added tool_commitments_view_private_purchase_order_contract
Added tool_commitments_view_private_work_order_contract
Added tool_daily_log_copy
Added tool_daily_log_log_restrictively
Added tool_daily_log_update_own_entries
Added tool_daily_log_view_company_entries
Added tool_data_extracts_can_create
Added tool_data_extracts_can_delete_drafts
Added tool_data_extracts_can_download
Added tool_data_extracts_can_edit_drafts
Added tool_data_extracts_can_extract_data
Added tool_data_extracts_can_view
Added tool_direct_costs_create_direct_cost
Added tool_direct_costs_delete_direct_cost
Added tool_direct_costs_update_direct_cost
Added tool_direct_costs_update_exchange_rate
Added tool_directory_add_user
Added tool_directory_assign_project_role
Added tool_directory_create_distribution_group
Added tool_directory_create_person
Added tool_directory_create_user
Added tool_directory_create_vendor
Added tool_directory_manage_permission_templates
Added tool_directory_manage_vendor_insurances
Added tool_directory_remove_user
Added tool_directory_remove_vendor
Added tool_directory_request_imports
Added tool_directory_see_vendor_insurances
Added tool_directory_update_person
Added tool_documents_access_private
Added tool_documents_destroy_files_and_folders
Added tool_documents_move_files_and_folders
Added tool_documents_rename_files_and_folders
Added tool_documents_see_recycle_bin
Added tool_documents_set_permissions
Added tool_drawings_upload_and_review_drawings
Added tool_drawings_upload_drawings
Added tool_inspections_can_bulk_create_inspections
Added tool_inspections_can_reinspect
Added tool_inspections_create_edit_inspection_schedules
Added tool_meetings_add_comment
Added tool_meetings_create
Added tool_meetings_delete_own_comment
Added tool_meetings_distribute
Added tool_meetings_edit
Added tool_meetings_manage_meeting_categories
Added tool_meetings_manage_meeting_items
Added tool_meetings_manage_related_items
Added tool_meetings_send_emails
Added tool_observations_assign_standard_user
Added tool_observations_respond_to_vendor_observation_items
Added tool_observations_view_vendor_observation_items
Added tool_photos_create_photo_album
Added tool_photos_delete_photo_album
Added tool_photos_reorder_photo_albums
Added tool_photos_view_private_photo_album
Added tool_prime_contracts_can_import_markups
Added tool_prime_contracts_create_prime_contract
Added tool_prime_contracts_delete_prime_contract
Added tool_prime_contracts_update_contract_currency_exchange_rate
Added tool_prime_contracts_update_prime_contract
Added tool_prime_contracts_view_payment_application_detail
Added tool_punch_list_respond_to_vendor_punch_items
Added tool_punch_list_view_vendor_punch_items
Added tool_
rfis
_act_as_
rfi
_manager
Added tool_
rfis
_mark_official_responses
Added tool_
rfis
_view_private_
rfis
Added tool_
rfis
_view_project_
rfi
_insights
Added tool_schedule_
lookahead
_create
Added tool_schedule_
lookahead
_delete
Added tool_schedule_
lookahead
_task_create
Added tool_schedule_lookahead_task_delete
Added tool_schedule_lookahead_task_update
Added tool_schedule_lookahead_view
Added tool_schedule_lookahead_view_change_history
Added tool_schedule_task_update_percent_complete
Added tool_specifications_can_configure
Added tool_specifications_can_create
Added tool_specifications_can_create_specification_set
Added tool_specifications_can_delete_pending_specification_uploads
Added tool_specifications_can_destroy
Added tool_specifications_can_download_specification
Added tool_specifications_can_email
Added tool_specifications_can_export_specification
Added tool_specifications_can_manually_create_divisions
Added tool_specifications_can_manually_create_spec_sections
Added tool_specifications_can_publish
Added tool_specifications_can_relate_items
Added tool_specifications_can_review
Added tool_specifications_can_show
Added tool_specifications_can_show_uploads
Added tool_specifications_can_update
Added tool_specifications_can_view_all_revision
Added tool_specifications_can_view_change_history
Added tool_specifications_can_view_deleted_specifications
Added tool_submittals_apply_submittal_workflow_template
Added tool_submittals_create_submittal
Added tool_submittals_create_submittal_package
Added tool_submittals_view_private_submittals
Added tool_submittals_view_project_submittal_insights
Added tool_timesheets_review_timesheets
Added tool_transmittals_view_private_transmittals"
project_permissions:
Added permission_template_id
project_role_memberships :
Added updated_at
invoice_compliance:
Added invoice_compliance_id
Added name
Added type
Ajout d’un statut
Added notes
Added attachment_count
Added effective_date
Added expiration_date
Added last_modified_by
Added 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)
Correction de bogue de Procore Analytics 2.0 (02/09/2025)
Procore a mis à jour les modèles (tableaux) suivants :
Estimate_budget_item_included_item :
Ajout wbs_code_id
Estimate_budget_item :
Ajout wbs_code_id
Mises à jour des données Procore Analytics 2.0 (19/08/2025)
Procore a ajouté les modèles (tableaux) suivants :
Offre
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
Procore a mis à jour les modèles (tableaux) suivants :
observation_custom_fields :
Changement de type_id de int à bigint
payments_subtier_waivers :
Changement de payment_subtier_waiver_id de bigint à string
incident_record :
Changement de incident_environmental_type de booléen à chaîne de caractères
commitment_change_order_line_items :
Ajouté commitment_change_order_line_items.quantity
Ajout de commitment_change_order_line_items.tax_code
Ajout de commitment_change_order_line_items.uom
Engagements:
Ajout commitments.approved_change_orders
Ajout commitments.draft_change_orders
Ajout d’engagements.facturé
Ajout commitments.pending_change_orders
Ajout commitments.pending_revised_contract_amount
owner_invoice_line_item_with_markups :
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period_project_currency
owner_invoice_line_items :
Ajout de owner_invoice_line_items.materials_retainage_released_this_period
Ajout de owner_invoice_line_items.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_line_items.materials_retainage_released_this_period_project_currency
owner_invoice_markup_line_items :
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period_project_currency
owner_invoices :
Ajout de owner_invoices.created_by_id
payments_subtier_waivers :
Ajout de payments_subtier_waivers.waiver_required
subcontractor_invoices :
Ajout de subcontractor_invoices.created_by_id
Ajout de subcontractor_invoices.montant_total_du_contrat.
photo:
Ajout photo.uploaded_by_id
Affectations:
Ajout assignments.employee_id
time_and_material_equipments :
Ajout de time_and_material_equipments.equipment_id
Ajout de time_and_material_equipments.numéro_d’identification_de_l’équipement
Ajout de time_and_material_equipments.equipment_name_legacy
time_off :
Ajout de time_off.employee_id
timecard_entries :
Ajout de timecard_entries.party_employee_id
Ajout timesheet_id
wp_people :
Ajout de wp_people.party_id
wp_role :
Ajout de wp_roles.audit_transaction_timestamp
Ajout de wp_roles.employee_id
Vendeur:
Ajout avg_company_rating
Projet d’estimation :
Ajout created_by_id
Ajout primary_contact_full_address
budget_snapshot_line_item_headers :
Ajout line_items
Requêtes:
Ajout d’un statut
wp_people :
Ajout customer_employee_id
Ajout user_id
incident_records :
Ajout affected_user_id
Mises à jour des données Procore Analytics 2.0 (22/07/2025)
Procore a ajouté les modèles (tableaux) suivants :
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
Procore a mis à jour les modèles (tableaux) suivants :
project_vendors :
Ajout de project_vendors.avg_company_rating
Ajout de project_vendors.invoice_contact_email_address
Ajout de project_vendors.invoice_contact_full_name
Fournisseurs:
Ajout vendors.avg_company_rating
Ajout vendors.invoice_contact_email_address
Ajout vendors.invoice_contact_full_name
direct_costs :
Ajout de direct_costs.created_by_id
payments_subtiers :
Ajout de payments_subtiers.hired_by_company_name
Ajout de payments_subtiers.tier
Ajout de payments_subtiers.tiering
subcontractor_invoices :
Ajout de subcontractor_invoices.early_pay_fee_amount_calculated
incident_record :
Ajout de incident_record.affected_party_id
Ajout de incident_record.affected_party_name
inspection_items :
Ajout de inspection_items.respondable
inspection_signature_requests :
Ajouté inspection_signature_requests.demandé
Ajout de inspection_signature_requests.requested_login
Livrables :
Ajout submittals.source_submittal_id
Ajout submittals.specification_area_name
actual_production_quantities :
Ajout de actual_production_quantities.created_by_id
budgeted_production_quantities :
Ajout de budgeted_production_quantities.created_by_id
équipement:
Ajout equipment.project_id
time_and_material_entries :
Ajout de time_and_material_entries.created_by_id
timecard_entries :
Ajout de timecard_entries.created_by_id
Mises à jour des données Procore Analytics 2.0 (17/06/2025)
Procore a ajouté les modèles (tableaux) suivants :
Company_folder_documents
Folder_documents
Folder_watchers
Equipment_telematic
wp_project_custom_fields
estimating_project_custom_field_configs
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans subcontractor_invoice_line_items :
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored_company_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored_project_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously company_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously project_currency
Ajout de subcontractor_invoice_line_items.gross_amount
Ajout de subcontractor_invoice_line_items.gross_amount_company_currency
Ajout de subcontractor_invoice_line_items.gross_amount_project_currency
Ajout de subcontractor_invoice_line_items.net_amount
Ajout de subcontractor_invoice_line_items.net_amount_company_currency
Ajout de subcontractor_invoice_line_items.net_amount_project_currency
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent_company_currency
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent_project_currency
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_depuis_le_précédent
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_de_la_monnaie_précédente_de_l’entreprise
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_de_la_monnaie_du_projet_précédent
Ajout de subcontractor_invoice_line_items.commitment_line_item_id
Ajout de subcontractor_invoice_line_items.prime_contract_line_item_id
Modifications dans les livrables :
Ajout submittals.anticipated_delivery_date_at_close
Ajout submittals.remaining_buffer_time_at_close
Ajout submittals.workflow_progress_at_close
Changements dans wp_people :
Ajout de wp_people.custom_fields
Changements dans wp_projects :
Ajout de wp_projects.custom_fields
Changements dans budget_view_details :
Ajout de budget_view_details.infojson_currency_conversion
Mises à jour des données Procore Analytics 2.0 (20/05/2025)
Procore a ajouté les modèles (tableaux) suivants :
project_company_comments
étiquettes
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans company_comments :
Ajout de company_comments.audit_transaction_timestamp
Ajout company_comments.note
Changements dans company_distribution_groups :
Ajout de company_distribution_groups.audit_transaction_timestamp
Ajout de company_distribution_groups.project_id
Changements dans project_distribution_groups :
Ajout de project_distribution_groups.audit_transaction_timestamp
Ajout de project_distribution_groups.company_id
Changements dans project_tools :
Ajout de project_tools.audit_transaction_timestamp
Ajout de project_tools.is_active
Changements dans budget_codes :
Ajout de budget_codes.production_quantity_code_description
Changements dans drawing_attachment :
Ajout de drawing_attachment.folder_document_id
Changements dans les inspections :
Ajout inspections.closed_at
Changements d’équipement :
Ajout equipment.status_type
Changements dans field_productivity :
Ajout de field_productivity.hours_utilization_enrp
Ajout de field_productivity.projected_hours_at_completion_enrp
Mises à jour des données Procore Analytics 2.0 (22/04/2025)
Procore a ajouté les modèles (tableaux) suivants :
budget_forecasts
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
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans project_role_memberships :
Ajouté : project_role_memberships.employee_id
Changements dans project_vendors :
Ajouté : project_vendors.cost_codes
Ajouté : project_vendors.trades
Changements dans les projets :
Ajouté : projects.schedule_last_updated
Ajouté : projects.schedule_percent_completion
Changements de fournisseurs :
Ajouté : vendors.cost_codes
Ajouté : vendors.trades
Changements dans budget_change_adjustment_line_items :
Ajouté : budget_change_adjustment_line_items.budget_changes_approved_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency
Ajout : budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_under_review_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency
Ajout : budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency
Changements dans budget_columns :
Ajout : budget_columns.budget_column_id
Changements dans budget_snapshot_line_item_forecasts :
Ajouté : budget_snapshot_line_item_forecasts.approval_status
Ajouté : budget_snapshot_line_item_forecasts.snapshot_type
Changements dans budget_snapshot_line_item_headers :
Ajout de budget_snapshot_line_item_headers.approval_status
Ajouté : budget_snapshot_line_item_headers.audit_transaction_timestamp
Ajouté : budget_snapshot_line_item_headers.snapshot_type
Changements dans budget_snapshot_line_items :
Ajout de budget_snapshot_line_items.approval_status
Ajouté : budget_snapshot_line_items.audit_transaction_timestamp
Ajouté : budget_snapshot_line_items.snapshot_type
Changements dans change_event_line_item_with_markups :
Ajout : change_event_line_item_with_markups.links_commitment_contract_cost
Ajouté : change_event_line_item_with_markups.links_commitment_pco_cost
Ajouté : change_event_line_item_with_markups.links_contract
Ajouté : change_event_line_item_with_markups.links_edit
Ajout : change_event_line_item_with_markups.links_prime_pco_cost
Ajouté : change_event_line_item_with_markups.links_rfq_amount
Ajouté : change_event_line_item_with_markups.links_rom
Ajout : change_event_line_item_with_markups.links_view
Changements dans commitment_line_items :
Ajouté : commitment_line_items.contracts_approved_amount
Ajout : commitment_line_items.contracts_approved_amount_company_currency
Ajouté : commitment_line_items.contracts_approved_amount_project_currency
Ajouté : commitment_line_items.contracts_complete_amount
Ajout : commitment_line_items.contracts_complete_amount_company_currency
Ajout : commitment_line_items.contracts_complete_amount_project_currency
Ajouté : commitment_line_items.contracts_draft_amount
Ajout : commitment_line_items.contrats_montant_projet_de_la_compagnie_currency
Ajouté : commitment_line_items.contracts_draft_amount_project_currency
Ajouté : commitment_line_items.contracts_out_for_signature_amount
Ajout : commitment_line_items.contracts_out_for_signature_amount_company_currency
Ajouté : commitment_line_items.contracts_out_for_signature_amount_project_currency
Modifications des engagements :
Ajouté : commitments.global_insurance_compliance
Ajouté : commitments.project_insurance_compliance
Ajouté : commitments.remaining_balance
Ajouté : commitments.revised_contract_amount
Changements dans payments_issued :
Ajouté : payments_issued.early_pay_fee_amount
Changements dans payments_project_controls :
Ajout de payments_project_controls.assigned_early_pay_program
Ajouté : payments_project_controls.audit_transaction_timestamp
Ajout : payments_project_controls.early_pay_program_id
Changements dans payments_subtier_waivers :
Ajout : payments_subtier_waivers.joint_check_requisition
Changements dans payments_subtiers :
Ajout de payments_subtiers.additional_address_information
Ajouté : payments_subtiers.address
Ajouté : payments_subtiers.montant_facturé_à_ce jour
Ajouté : payments_subtiers.city
Ajouté : payments_subtiers.country
Ajout : payments_subtiers.joint_check_future_requisitions
Ajouté : payments_subtiers.kind_of_work
Ajouté : payments_subtiers.phone
Ajouté : payments_subtiers.state
Ajouté : payments_subtiers.subtier_type
Ajouté : payments_subtiers.waiver_contact_email
Ajouté : payments_subtiers.zip
Changements dans prime_contract_change_order_requests :
Ajout : prime_contract_change_order_requests.schedule_impact_days
Changements dans prime_contract_change_orders :
Ajout : prime_contract_change_orders.schedule_impact_days
Changements dans prime_contract_potential_change_orders :
Ajout : prime_contract_potential_change_orders.schedule_impact_days
Changements dans subcontractor_invoices :
Ajouté : subcontractor_invoices.early_pay_fee_amount
Ajouté : subcontractor_invoices.early_pay_fee_rate
Ajouté : subcontractor_invoices.early_pay_status
Ajouté : subcontractor_invoices.missed_payment_due_date
Ajouté : subcontractor_invoices.original_payment_due
Ajout : subcontractor_invoices.original_payment_due_company_currency
Ajout : subcontractor_invoices.original_payment_due_project_currency
Ajouté : subcontractor_invoices.payment_due_date
Changements dans correspondence_types :
Ajouté : correspondence_types.created_at
Changements dans correspondence_workflow_steps :
Ajouté : correspondence_workflow_steps.current_step_due_date
Changements dans daily_log_accident_custom_fields :
Ajouté : daily_log_accident_custom_fields.type_id
Changements dans daily_log_completion :
Ajouté : daily_log_completion.created_at
Changements dans daily_log_construction_report_custom_fields :
Ajouté : daily_log_construction_report_custom_fields.type_id
Changements dans daily_log_delay_custom_fields :
Ajouté : daily_log_delay_custom_fields.type_id
Changements dans daily_log_delivery_custom_fields :
Ajouté : daily_log_delivery_custom_fields.type_id
Changements dans daily_log_dumpster_custom_fields :
Ajouté : daily_log_dumpster_custom_fields.type_id
Changements dans daily_log_equipment :
Ajouté : daily_log_equipment.equipment_id
Ajout : daily_log_equipment.numéro_d’identification_de_l’équipement
Ajouté : daily_log_equipment.equipment_name_beta
Changements dans daily_log_equipment_custom_fields :
Ajouté : daily_log_equipment_custom_fields.type_id
Changements dans daily_log_inspection_custom_fields :
Ajouté : daily_log_inspection_custom_fields.type_id
Changements dans daily_log_manpower_custom_fields :
Ajouté : daily_log_manpower_custom_fields.type_id
Changements dans daily_log_plan_revision_custom_fields :
Ajouté : daily_log_plan_revision_custom_fields.type_id
Changements dans daily_log_productivity_custom_fields :
Ajouté : daily_log_productivity_custom_fields.type_id
Changements dans daily_log_scheduled_work_task :
Ajouté : daily_log_scheduled_work_task.created_at
Changements dans drawing_revision :
Ajouté : drawing_revision.created_at
Changements dans incident_alert :
Ajouté : incident_alert.created_at
Ajouté : incident_alert.updated_at
Changements dans inspection_distribution_list :
Ajouté : inspection_distribution_list.created_at
Ajouté : inspection_distribution_list.updated_at
Changements dans inspection_item_signature_requests :
Ajouté : inspection_item_signature_requests.created_at
Ajouté : inspection_item_signature_requests.updated_at
Changements dans inspection_schedule_assignees :
Ajouté : inspection_schedule_assignees.created_at
Ajouté : inspection_schedule_assignees.updated_at
Changements dans inspection_schedule_distribution_list :
Ajouté : inspection_schedule_distribution_list.created_at
Ajouté : inspection_schedule_distribution_list.updated_at
Changements dans inspection_schedules :
Ajouté : inspection_schedules.created_at
Ajouté : inspection_schedules.equipment_id
Ajout : inspection_schedules.numéro_d’identification_de_l’équipement
Ajouté : inspection_schedules.equipment_name
Ajouté : inspection_schedules.updated_at
Changements dans meeting_attendee :
Ajouté : meeting_attendee.created_at
Ajouté : meeting_attendee.updated_at
Changements dans meeting_item_assignee :
Ajouté : meeting_item_assignee.updated_at
Changements dans observation_distribution_member :
Ajouté : observation_distribution_member.created_at
Changements dans punch_item :
Ajouté : punch_item.audit_transaction_timestamp
Changements dans punch_item_bic :
Ajout de punch_item_bic.audit_transaction_timestamp
Ajouté : punch_item_bic.ball_in_court_role
Changements dans punch_item_custom_fields :
Ajouté : punch_item_custom_fields.type_id
Changements dans punch_item_distribution_member :
Ajout de punch_item_distribution_member.audit_transaction_timestamp
Changements dans rfi_assignees :
Ajouté : rfi_assignees.audit_transaction_timestamp
Changements dans rfi_distributions :
Ajout de rfi_distributions.audit_transaction_timestamp
Changements dans rfi_responses :
Ajout de rfi_responses.audit_transaction_timestamp
Changements dans les DDR :
Ajouté : rfis.audit_transaction_timestamp
Ajouté : rfis.current_revision
Ajouté : rfis.revision
Changements dans rfis_bic :
Ajout de rfis_bic.audit_transaction_timestamp
Ajouté : rfis_bic.ball_in_court_role
Changements dans schedule_calendar_item :
Ajouté : schedule_calendar_item.audit_transaction_timestamp
Changements dans schedule_lookahead :
Ajout de schedule_lookahead.audit_transaction_timestamp
Changements dans schedule_lookahead_task :
Ajouté : schedule_lookahead_task.audit_transaction_timestamp
Changements dans schedule_task :
Ajouté : schedule_task.audit_transaction_timestamp
Changements dans schedule_task_changes :
Ajouté : schedule_task_changes.audit_transaction_timestamp
Changements dans schedule_task_requests :
Ajout de schedule_task_requests.audit_transaction_timestamp
Changements dans site_instructions :
Ajouté : site_instructions.audit_transaction_timestamp
Changements dans specification_sections :
Ajout de specification_sections.audit_transaction_timestamp
Changements dans submittal_approvers :
Ajout de submittal_approvers.audit_transaction_timestamp
Ajouté : submittal_approvers.comments
Changements dans submittal_ball_in_courts :
Ajout de submittal_ball_in_courts.audit_transaction_timestamp
Ajouté : submittal_ball_in_courts.response_required
Changements dans submittal_distributions :
Ajout de submittal_distributions.audit_transaction_timestamp
Modifications dans les livrables :
Ajouté : submittals.audit_transaction_timestamp
Ajout : submittals.closed_at
Changements dans la tâche :
Ajouté : task.audit_transaction_timestamp
Changements dans task_activity :
Ajouté : task_activity.audit_transaction_timestamp
Changements dans task_assignee :
Ajout : task_assignee.audit_transaction_timestamp
Changements d’équipement :
Ajouté : equipment.rental_end_date
Ajouté : equipment.rental_start_date
Ajouté : equipment.vendor_name
Changements dans field_productivity :
Ajout : field_productivity.cost_code_id
Ajouté : field_productivity.production_quantity_code
Mises à jour des données Procore Analytics 2.0 (18/03/2025)
Procore a ajouté les modèles (tableaux) suivants :
Segments de code budgétaire
Valeurs SDP de la couche
Valeurs SDP du groupe de calques
Ajustement de l’estimation
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans correspondence_workflow_steps
Ajout current_step_due_date
Ajout current_step_name
Changements dans payments_disbursements
Ajout de owner_invoices.tax_applicable_to_this_payment_company_currency
Ajout de owner_invoices.tax_applicable_to_this_payment_project_currency
Changements dans subcontractor_invoice_line_items
Ajouté payments_disbursements.number
Ajout de subcontractor_invoice_line_items.total_retainage_company_currency
Ajout de subcontractor_invoice_line_items.total_retainage_project_currency
Changements dans action_plan
Ajout de action_plan.audit_transaction_timestamp
Changements dans action_plan_approver
Ajout de action_plan_approver.audit_transaction_timestamp
Changements dans action_plan_completed_receiver
Ajout de action_plan_completed_receiver.audit_transaction_timestamp
Changements dans action_plan_line_item
Ajout de action_plan_line_item.audit_transaction_timestamp
Changements dans action_plan_line_item_assignee
Ajout de action_plan_line_item_assignee.audit_transaction_timestamp
Changements dans action_plan_line_item_record
Ajout de action_plan_line_item_record.audit_transaction_timestamp
Changements dans action_plan_line_item_record_request
Ajout de action_plan_line_item_record_request.audit_transaction_timestamp
Changements dans action_plan_line_item_reference
Ajout de action_plan_line_item_reference.audit_transaction_timestamp
Changements dans drawing_revision
Ajout de drawing_revision.is_connected_drawing
Changements dans incident_record
Ajout de incident_record.affected_person_id
Changements dans l’observation
Ajout observation.created_by_company
Changements dans rfi_responses
Ajout de rfi_responses.is_most_recent
Changements dans rfis_bic
Ajout de rfis_bic.response_required
Changements dans schedule_task
Ajout de schedule_task.predecessor_wbs_list
Ajout de schedule_task.successor_wbs_list
Changements dans specification_sections
'Ajout de specification_sections.specification_area_description
Ajout de specification_sections.specification_area_name
Changements dans submittal_approvers
Ajout de submittal_approvers.previous_due_date
Ajouté submittal_approvers.previous_returned_date
Ajout de submittal_approvers.previous_sent_date
Changements dans wp_projects
Ajout de wp_projects.categories
Ajout users.audit_transaction_timestamp
Ajouté estimate_layer_groups.profit
Mises à jour des données Procore Analytics 2.0 (18/02/2025)
Procore a ajouté les modèles (tableaux) suivants :
Financier
payments_permissions
payments_disbursements
pay_requirement_settings
payments_project_controls
payments_invites
payments_agreements
payments_received
Gestion de projet
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
Planification des ressources
Affectations
Titres de poste
Requêtes
congé
Les gens de wp
Projets WP
groupe
Équipement
équipement
Registre de projet d’équipement
Entrée de pointage de l’équipement
Estimation
Estimation de projets
Estimer les couches
Estimer les groupes de couches
Champs personnalisés du projet d’estimation
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans project_vendor_insurances.sql :
Ajout de project_vendor_insurances.external_origin_data
Ajout de project_vendor_insurances.external_origin_id
Changements dans projects.sql :
Ajout de projects.code
Ajout projects.delivery_method
Ajout projects.external_origin_data
Ajout projects.external_origin_id
Ajout de projects.sector
Ajout projects.work_scope
Changements dans users.sql :
Ajout users.abbreviated_name
Ajout users.can_push_to_accounting
Ajout users.company_name
Ajout users.company_permission_template
Ajout users.external_origin_data
Ajout users.external_origin_id
Ajout users.login_information_id
Ajout users.origin_id
Ajout users.origin_name
Changements dans budget_changes.sql :
Ajout de budget_changes.external_origin_data
Ajout de budget_changes.external_origin_id
Changements dans budget_line_items.sql :
Ajout de budget_line_items.budget_notes
Changements dans change_events.sql :
Ajout de change_events.external_origin_data
Ajout de change_events.external_origin_id
Changements dans commitment_change_orders.sql :
Ajout de commitment_change_orders.external_origin_data
Ajout de commitment_change_orders.external_origin_id
Changements dans commitment_line_items.sql :
Ajout de commitment_line_items.external_origin_data
Ajout de commitment_line_items.external_origin_id
Changements dans direct_cost_line_items.sql :
Ajout de direct_cost_line_items.external_origin_data
Ajout de direct_cost_line_items.external_origin_id
Changements dans direct_costs.sql :
Ajout de direct_costs.external_origin_data
Ajout de direct_costs.external_origin_id
Changements dans owner_invoice_line_item_with_markups.sql :
Ajout de owner_invoice_line_item_with_markups.external_origin_data
Ajout de owner_invoice_line_item_with_markups.external_origin_id
Ajout de owner_invoice_line_item_with_markups.materials_presently_stored_qty
Ajouté owner_invoice_line_item_with_markups.name
Ajout de owner_invoice_line_item_with_markups.new_materials_stored_qty
Ajout de owner_invoice_line_item_with_markups.previous_materials_stored_qty
Ajout de owner_invoice_line_item_with_markups.prime_contract_id
Changements dans owner_invoice_line_items.sql :
Ajout de owner_invoice_line_items.external_origin_data
Ajout de owner_invoice_line_items.external_origin_id
Ajout de owner_invoice_line_items.line_type
Ajout de owner_invoice_line_items.markup_id
Ajout de owner_invoice_line_items.materials_presently_stored_qty
Ajouté owner_invoice_line_items.name
Ajout de owner_invoice_line_items.new_materials_stored_qty
Ajout de owner_invoice_line_items.owner_invoice_line_item_with_markup_id
Ajout de owner_invoice_line_items.owner_invoice_markup_line_item_id
Ajout de owner_invoice_line_items.previous_materials_stored_qty
Changements dans owner_invoice_markup_line_items.sql :
Ajout de owner_invoice_markup_line_items.approved_changes
Ajout de owner_invoice_markup_line_items.approved_changes_company_currency
Ajout de owner_invoice_markup_line_items.approved_changes_project_currency
Ajout de owner_invoice_markup_line_items.balance_to_finish
Ajout de owner_invoice_markup_line_items.company_id_2
Ajout de owner_invoice_markup_line_items.external_origin_data
Ajout de owner_invoice_markup_line_items.external_origin_id
Ajout de owner_invoice_markup_line_items.line_type
Ajout de owner_invoice_markup_line_items.materials_presently_stored_qty
Ajouté owner_invoice_markup_line_items.name
Ajout de owner_invoice_markup_line_items.new_materials_stored_qty
Ajout de owner_invoice_markup_line_items.owner_invoice_line_item_id
Ajout de owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id
Ajout de owner_invoice_markup_line_items.previous_materials_stored_qty
Ajout de owner_invoice_markup_line_items.prime_contract_id
Changements dans owner_invoices.sql :
Ajout de owner_invoices.external_origin_data
Ajout de owner_invoices.external_origin_id
Ajout de owner_invoices.tax_applicable_to_this_payment
Changements dans payments_issued.sql :
Ajout de payments_issued.external_origin_data
Ajout de payments_issued.external_origin_id
Changements dans prime_contract_change_order_line_items.sql :
Ajout de prime_contract_change_order_line_items.external_origin_data
Ajout de prime_contract_change_order_line_items.external_origin_id
Changements dans prime_contract_change_order_requests.sql :
Ajout de prime_contract_change_order_requests.external_origin_data
Ajout de prime_contract_change_order_requests.external_origin_id
Changements dans prime_contract_change_orders.sql :
Ajout de prime_contract_change_orders.external_origin_data
Ajout de prime_contract_change_orders.external_origin_id
Changements dans prime_contract_line_items.sql :
Ajout de prime_contract_line_items.external_origin_data
Ajout de prime_contract_line_items.external_origin_id
Ajout de prime_contract_line_items.vendor_id
Changements dans prime_contract_potential_change_orders.sql :
Ajout de prime_contract_potential_change_orders.external_origin_data
Ajout de prime_contract_potential_change_orders.external_origin_id
Changements dans prime_contracts.sql :
Ajout de prime_contracts.external_origin_data
Ajout de prime_contracts.external_origin_id
Changements dans subcontractor_invoice_line_items.sql :
Ajout de subcontractor_invoice_line_items.materials_presently_stored_qty
Ajout de subcontractor_invoice_line_items.materials_previously stored_qty
Ajout de subcontractor_invoice_line_items.new_materials_qty
Changements dans subcontractor_invoices.sql :
Ajout de subcontractor_invoices.external_origin_data
Ajout de subcontractor_invoices.external_origin_id
Changements dans inspections.sql :
Ajout inspections.equipment_identification_number
Changements dans rfi_assignees.sql :
Ajouté rfi_assignees.forwarded_by
Changements dans submittal_approvers.sql :
Ajout de submittal_approvers.is_last_step
Changements dans equipment_timecard_entry.sql :
Ajout de equipment_timecard_entry.numéro_d’identification_de_l’équipement
Ajout de equipment_timecard_entry.equipment_name
Mises à jour des données Procore Analytics 2.0 (21/01/2025)
Procore a ajouté les modèles (tableaux) suivants :
inspection_item_references
schedule_task_changes
équipement
equipment_project_log
equipment_timecard_entry
payments_project_controls
payments_invites
payments_agreements
pay_requirement_settings
Procore a mis à jour les modèles (tableaux) suivants :
company_vendor_insurances :
Ajout de company_vendor_insurances.template_name
project_role_memberships :
Ajout de project_role_memberships.user_id
budget_change_workflow_steps :
Ajout de budget_change_workflow_steps.current_step_due_date
budget_codes :
Supprimé SELECT budget_codes.budget_code
Ajout de SELECT budget_codes.attribute_1_line_item
Ajout de budget_codes.attribute_1_name
Ajout de budget_codes.attribute_2_line_item
Ajout de budget_codes.attribute_2_name
Ajout de budget_codes.attribute_3_line_item
Ajout de budget_codes.attribute_3_name
Ajout de budget_codes.budget_code
budget_columns :
Ajout de budget_columns.created_at
Ajouté budget_columns.updated_at
change_event_line_item_with_markups :
Supprimé SELECT change_event_line_item_with_markups.budget_days_in_stage
Ajout de SELECT change_event_line_item_with_markups.biller_id
Ajout de change_event_line_item_with_markups.biller_model_name
Ajout de change_event_line_item_with_markups.biller_name
Ajout de change_event_line_item_with_markups.budget_days_in_stage
Ajout de change_event_line_item_with_markups.change_event_events_id
Ajout de change_event_line_item_with_markups.change_event_status
Ajout de change_event_line_item_with_markups.change_event_title
Ajout de change_event_line_item_with_markups.contract_id
Ajout de change_event_line_item_with_markups.numéro_du_contrat
Ajout de change_event_line_item_with_markups.contract_title
Ajout de change_event_line_item_with_markups.estimated_budget_amount
Ajout de change_event_line_item_with_markups.estimated_budget_transfer_amount
Ajout de change_event_line_item_with_markups.estimated_cost_amount
Ajout de change_event_line_item_with_markups.estimated_cost_amount_company_currency
Ajout de change_event_line_item_with_markups.estimated_cost_amount_project_currency
Ajout de change_event_line_item_with_markups.event_scope
Ajout de change_event_line_item_with_markups.proposed_contract_id
Ajout de change_event_line_item_with_markups.proposed_vendor_id
Ajouté change_event_line_item_with_markups.source
Ajout de change_event_line_item_with_markups.vendor_name
Ajout de change_event_line_item_with_markups.wbs_code_id
commitment_change_order_line_items :
Ajout de commitment_change_order_line_items.commitment_change_order_request_id
Ajout de commitment_change_order_line_items.commitment_potential_change_order_id
commitment_change_order_workflow_steps :
Ajout de commitment_change_order_workflow_steps.current_step_due_date
commitment_custom_field_configs :
Ajouté commitment_custom_field_configs.name
commitment_pco_workflow_steps :
Ajout de commitment_pco_workflow_steps.current_step_due_date
commitment_workflow_step_occurrences :
Ajout de commitment_workflow_step_occurrences.current_step_due_date
contract_compliance_documents :
Ajout de contract_compliance_documents.template_name
owner_invoice_workflow_steps :
Ajout de owner_invoice_workflow_steps.current_step_due_date
owner_invoices :
Ajout de owner_invoices.erp_latest_status
Ajout de owner_invoices.erp_updated_at
Ajout de owner_invoices.erp_user_name
Ajout de owner_invoices.synced_with_accounting
payments_beneficiaries :
Ajout de payments_beneficiaries.early_pay_classification
prime_contract_change_order_line_items :
Ajouté prime_contract_change_order_line_items.name
Ajout de prime_contract_change_order_line_items.prime_contract_change_order_request_id
Ajout de prime_contract_change_order_line_items.prime_contract_potential_change_order_id
prime_contract_change_order_workflow_steps :
Ajout de prime_contract_change_order_workflow_steps.current_step_due_date
prime_contract_pco_workflow_steps :
Ajout de prime_contract_pco_workflow_steps.current_step_due_date
prime_contract_workflow_steps :
Ajout de prime_contract_workflow_steps.current_step_due_date
subcontractor_invoice_line_items :
Ajout de subcontractor_invoice_line_items.total_retainage
subcontractor_invoice_workflow_steps :
Ajout de subcontractor_invoice_workflow_steps.current_step_due_date
action_plan_custom_fields :
Ajout de action_plan_custom_fields.type_id
action_plan_line_item_record :
Ajout de action_plan_line_item_record.action_plan_line_item_record_resource_url
correspondence_custom_fields :
Ajout de correspondence_custom_fields.type_id
correspondence_response_attachments :
Ajout de correspondence_response_attachments.type_id
correspondence_schedule_tasks :
Ajout de correspondence_schedule_tasks.type_id
correspondence_workflow_responses :
Ajout de correspondence_workflow_responses.type_id
correspondence_workflow_steps :
Ajout de correspondence_workflow_steps.type_id
daily_log_accident :
Ajout de daily_log_accident.daily_log_completion_id
daily_log_construction_reports :
Ajout de daily_log_construction_reports.daily_log_completion_id
daily_log_delay :
Ajout de daily_log_delay.daily_log_completion_id
daily_log_delivery :
Ajout de daily_log_delivery.daily_log_completion_id
daily_log_dumpster :
Ajout de daily_log_dumpster.daily_log_completion_id
daily_log_equipment :
Ajout de daily_log_equipment.daily_log_completion_id
daily_log_inspection :
Ajout de daily_log_inspection.daily_log_completion_id
daily_log_manpower :
Ajout de daily_log_manpower.daily_log_completion_id
daily_log_note :
Ajout de daily_log_note.daily_log_completion_id
daily_log_observed_weather_condition :
Ajout de daily_log_observed_weather_condition.daily_log_completion_id
daily_log_phone_call :
Ajout de daily_log_phone_call.daily_log_completion_id
daily_log_plan_revision :
Ajout de daily_log_plan_revision.daily_log_completion_id
daily_log_productivity :
Ajout de daily_log_productivity.daily_log_completion_id
daily_log_quantity :
Ajout de daily_log_quantity.daily_log_completion_id
daily_log_safety_violation :
Ajout de daily_log_safety_violation.daily_log_completion_id
daily_log_scheduled_work :
Ajout de daily_log_scheduled_work.daily_log_completion_id
daily_log_scheduled_work_task :
Ajout de daily_log_scheduled_work_task.daily_log_completion_id
Ajout de daily_log_scheduled_work_task.schedule_task_id
daily_log_visitor :
Ajout de daily_log_visitor.daily_log_completion_id
daily_log_waste :
Ajout de daily_log_waste.daily_log_completion_id
inspection_custom_fields :
Ajout de inspection_custom_fields.type_id
inspection_item_signature_requests :
Ajout de inspection_item_signature_requests.inspection_schedule_id
inspection_items :
Ajout de inspection_items.position_number
inspection_schedules :
Ajout de inspection_schedules.ends_at
Ajout de inspection_schedules.starts_at
Inspections:
Ajout inspections.equipment_id
Ajout inspections.equipment_name
observation_custom_field_configs :
Ajout de observation_custom_field_configs.observation_type_id
Ajout de observation_custom_field_configs.type_id
observation_custom_fields :
Ajout de observation_custom_fields.type_id
punch_item_bic :
Ajout de punch_item_bic.punch_item_bic_id
rfis_bic :
Ajout de rfis_bic.rfi_bic_id
schedule_lookahead_task :
Ajout de schedule_lookahead_task.task_id_comp
schedule_task :
Ajout de schedule_task.task_id
submittal_ball_in_courts :
Ajout de submittal_ball_in_courts.nom_de_l’entreprise
Ajout de submittal_ball_in_courts.role
Livrables :
Ajout submittals.ball_in_court_role
Ajout de livrables.paused
actual_production_quantities :
Ajout de actual_production_quantities.wbs_code_id
budget_change_production_quantities :
Supprimé SELECT budget_change_production_quantities.budget_change_production_quantity_id
Ajout de SELECT budget_change_production_quantities.budget_change_id
Ajout de budget_change_production_quantities.budget_change_production_quantity_id
Ajout de budget_change_production_quantities.wbs_code_id
prime_potential_change_order_production_quantities :
Ajout de prime_potential_change_order_production_quantities.prime_contract_change_order_id
Ajout de prime_potential_change_order_production_quantities.wbs_code_id
projet:
Ajout de project.code
owner_invoices :
Ajout owner_invoices. Tax_Applicable_To_This_Payment
timecard_entries :
Ajout de timecard_entries.user_id
Mises à jour des données Procore Analytics 2.0 (17/12/2024)
Procore a ajouté (current_step_due_date) aux modèles (tableaux) suivants :
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
Procore a ajouté les champs suivants :
actual_production_quantities.wbs_code_id (en anglais seulement)
timecard_entries.identifiant_utilisateur
Changements récents
Mises à jour des données Procore Analytics 2.0 (19/08/2025)
Procore a ajouté les modèles (tableaux) suivants :
Offre
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
Procore a mis à jour les modèles (tableaux) suivants :
observation_custom_fields :
Changement de type_id de int à bigint
payments_subtier_waivers :
Changement de payment_subtier_waiver_id de bigint à string
incident_record :
Changement de incident_environmental_type de booléen à chaîne de caractères
commitment_change_order_line_items :
Ajouté commitment_change_order_line_items.quantity
Ajout de commitment_change_order_line_items.tax_code
Ajout de commitment_change_order_line_items.uom
Engagements:
Ajout commitments.approved_change_orders
Ajout commitments.draft_change_orders
Ajout d’engagements.facturé
Ajout commitments.pending_change_orders
Ajout commitments.pending_revised_contract_amount
owner_invoice_line_item_with_markups :
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_line_item_with_markups.materials_retainage_released_this_period_project_currency
owner_invoice_line_items :
Ajout de owner_invoice_line_items.materials_retainage_released_this_period
Ajout de owner_invoice_line_items.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_line_items.materials_retainage_released_this_period_project_currency
owner_invoice_markup_line_items :
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period_company_currency
Ajout de owner_invoice_markup_line_items.materials_retainage_released_this_period_project_currency
owner_invoices :
Ajout de owner_invoices.created_by_id
payments_subtier_waivers :
Ajout de payments_subtier_waivers.waiver_required
subcontractor_invoices :
Ajout de subcontractor_invoices.created_by_id
Ajout de subcontractor_invoices.montant_total_du_contrat.
photo:
Ajout photo.uploaded_by_id
Affectations:
Ajout assignments.employee_id
time_and_material_equipments :
Ajout de time_and_material_equipments.equipment_id
Ajout de time_and_material_equipments.numéro_d’identification_de_l’équipement
Ajout de time_and_material_equipments.equipment_name_legacy
time_off :
Ajout de time_off.employee_id
timecard_entries :
Ajout de timecard_entries.party_employee_id
Ajout timesheet_id
wp_people :
Ajout de wp_people.party_id
wp_role :
Ajout de wp_roles.audit_transaction_timestamp
Ajout de wp_roles.employee_id
Vendeur:
Ajout avg_company_rating
Projet d’estimation :
Ajout created_by_id
Ajout primary_contact_full_address
budget_snapshot_line_item_headers :
Ajout line_items
Requêtes:
Ajout d’un statut
wp_people :
Ajout customer_employee_id
Ajout user_id
incident_records :
Ajout affected_user_id
Mises à jour des données Procore Analytics 2.0 (22/07/2025)
Procore a ajouté les modèles (tableaux) suivants :
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
Procore a mis à jour les modèles (tableaux) suivants :
project_vendors :
Ajout de project_vendors.avg_company_rating
Ajout de project_vendors.invoice_contact_email_address
Ajout de project_vendors.invoice_contact_full_name
Fournisseurs:
Ajout vendors.avg_company_rating
Ajout vendors.invoice_contact_email_address
Ajout vendors.invoice_contact_full_name
direct_costs :
Ajout de direct_costs.created_by_id
payments_subtiers :
Ajout de payments_subtiers.hired_by_company_name
Ajout de payments_subtiers.tier
Ajout de payments_subtiers.tiering
subcontractor_invoices :
Ajout de subcontractor_invoices.early_pay_fee_amount_calculated
incident_record :
Ajout de incident_record.affected_party_id
Ajout de incident_record.affected_party_name
inspection_items :
Ajout de inspection_items.respondable
inspection_signature_requests :
Ajouté inspection_signature_requests.demandé
Ajout de inspection_signature_requests.requested_login
Livrables :
Ajout submittals.source_submittal_id
Ajout submittals.specification_area_name
actual_production_quantities :
Ajout de actual_production_quantities.created_by_id
budgeted_production_quantities :
Ajout de budgeted_production_quantities.created_by_id
équipement:
Ajout equipment.project_id
time_and_material_entries :
Ajout de time_and_material_entries.created_by_id
timecard_entries :
Ajout de timecard_entries.created_by_id
Mises à jour des données Procore Analytics 2.0 (17/06/2025)
Procore a ajouté les modèles (tableaux) suivants :
Company_folder_documents
Folder_documents
Folder_watchers
Equipment_telematic
wp_project_custom_fields
estimating_project_custom_field_configs
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans subcontractor_invoice_line_items :
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored_company_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_previously stored_project_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously company_currency
Ajout de subcontractor_invoice_line_items.adjusted_materials_retained_previously project_currency
Ajout de subcontractor_invoice_line_items.gross_amount
Ajout de subcontractor_invoice_line_items.gross_amount_company_currency
Ajout de subcontractor_invoice_line_items.gross_amount_project_currency
Ajout de subcontractor_invoice_line_items.net_amount
Ajout de subcontractor_invoice_line_items.net_amount_company_currency
Ajout de subcontractor_invoice_line_items.net_amount_project_currency
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent_company_currency
Ajout de subcontractor_invoice_line_items.retainage_new_materials_from_percent_project_currency
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_depuis_le_précédent
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_de_la_monnaie_précédente_de_l’entreprise
Ajout de subcontractor_invoice_line_items.total_terminé_et_stocké_à_ce jour_de_la_monnaie_du_projet_précédent
Ajout de subcontractor_invoice_line_items.commitment_line_item_id
Ajout de subcontractor_invoice_line_items.prime_contract_line_item_id
Modifications dans les livrables :
Ajout submittals.anticipated_delivery_date_at_close
Ajout submittals.remaining_buffer_time_at_close
Ajout submittals.workflow_progress_at_close
Changements dans wp_people :
Ajout de wp_people.custom_fields
Changements dans wp_projects :
Ajout de wp_projects.custom_fields
Changements dans budget_view_details :
Ajout de budget_view_details.infojson_currency_conversion
Mises à jour des données Procore Analytics 2.0 (20/05/2025)
Procore a ajouté les modèles (tableaux) suivants :
project_company_comments
étiquettes
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans company_comments :
Ajout de company_comments.audit_transaction_timestamp
Ajout company_comments.note
Changements dans company_distribution_groups :
Ajout de company_distribution_groups.audit_transaction_timestamp
Ajout de company_distribution_groups.project_id
Changements dans project_distribution_groups :
Ajout de project_distribution_groups.audit_transaction_timestamp
Ajout de project_distribution_groups.company_id
Changements dans project_tools :
Ajout de project_tools.audit_transaction_timestamp
Ajout de project_tools.is_active
Changements dans budget_codes :
Ajout de budget_codes.production_quantity_code_description
Changements dans drawing_attachment :
Ajout de drawing_attachment.folder_document_id
Changements dans les inspections :
Ajout inspections.closed_at
Changements d’équipement :
Ajout equipment.status_type
Changements dans field_productivity :
Ajout de field_productivity.hours_utilization_enrp
Ajout de field_productivity.projected_hours_at_completion_enrp
Mises à jour des données Procore Analytics 2.0 (22/04/2025)
Procore a ajouté les modèles (tableaux) suivants :
budget_forecasts
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
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans project_role_memberships :
Ajouté : project_role_memberships.employee_id
Changements dans project_vendors :
Ajouté : project_vendors.cost_codes
Ajouté : project_vendors.trades
Changements dans les projets :
Ajouté : projects.schedule_last_updated
Ajouté : projects.schedule_percent_completion
Changements de fournisseurs :
Ajouté : vendors.cost_codes
Ajouté : vendors.trades
Changements dans budget_change_adjustment_line_items :
Ajouté : budget_change_adjustment_line_items.budget_changes_approved_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency
Ajout : budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency
Ajouté : budget_change_adjustment_line_items.budget_changes_under_review_amount
Ajouté : budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency
Ajout : budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency
Changements dans budget_columns :
Ajout : budget_columns.budget_column_id
Changements dans budget_snapshot_line_item_forecasts :
Ajouté : budget_snapshot_line_item_forecasts.approval_status
Ajouté : budget_snapshot_line_item_forecasts.snapshot_type
Changements dans budget_snapshot_line_item_headers :
Ajout de budget_snapshot_line_item_headers.approval_status
Ajouté : budget_snapshot_line_item_headers.audit_transaction_timestamp
Ajouté : budget_snapshot_line_item_headers.snapshot_type
Changements dans budget_snapshot_line_items :
Ajout de budget_snapshot_line_items.approval_status
Ajouté : budget_snapshot_line_items.audit_transaction_timestamp
Ajouté : budget_snapshot_line_items.snapshot_type
Changements dans change_event_line_item_with_markups :
Ajout : change_event_line_item_with_markups.links_commitment_contract_cost
Ajouté : change_event_line_item_with_markups.links_commitment_pco_cost
Ajouté : change_event_line_item_with_markups.links_contract
Ajouté : change_event_line_item_with_markups.links_edit
Ajout : change_event_line_item_with_markups.links_prime_pco_cost
Ajouté : change_event_line_item_with_markups.links_rfq_amount
Ajouté : change_event_line_item_with_markups.links_rom
Ajout : change_event_line_item_with_markups.links_view
Changements dans commitment_line_items :
Ajouté : commitment_line_items.contracts_approved_amount
Ajout : commitment_line_items.contracts_approved_amount_company_currency
Ajouté : commitment_line_items.contracts_approved_amount_project_currency
Ajouté : commitment_line_items.contracts_complete_amount
Ajout : commitment_line_items.contracts_complete_amount_company_currency
Ajout : commitment_line_items.contracts_complete_amount_project_currency
Ajouté : commitment_line_items.contracts_draft_amount
Ajout : commitment_line_items.contrats_montant_projet_de_la_compagnie_currency
Ajouté : commitment_line_items.contracts_draft_amount_project_currency
Ajouté : commitment_line_items.contracts_out_for_signature_amount
Ajout : commitment_line_items.contracts_out_for_signature_amount_company_currency
Ajouté : commitment_line_items.contracts_out_for_signature_amount_project_currency
Modifications des engagements :
Ajouté : commitments.global_insurance_compliance
Ajouté : commitments.project_insurance_compliance
Ajouté : commitments.remaining_balance
Ajouté : commitments.revised_contract_amount
Changements dans payments_issued :
Ajouté : payments_issued.early_pay_fee_amount
Changements dans payments_project_controls :
Ajout de payments_project_controls.assigned_early_pay_program
Ajouté : payments_project_controls.audit_transaction_timestamp
Ajout : payments_project_controls.early_pay_program_id
Changements dans payments_subtier_waivers :
Ajout : payments_subtier_waivers.joint_check_requisition
Changements dans payments_subtiers :
Ajout de payments_subtiers.additional_address_information
Ajouté : payments_subtiers.address
Ajouté : payments_subtiers.montant_facturé_à_ce jour
Ajouté : payments_subtiers.city
Ajouté : payments_subtiers.country
Ajout : payments_subtiers.joint_check_future_requisitions
Ajouté : payments_subtiers.kind_of_work
Ajouté : payments_subtiers.phone
Ajouté : payments_subtiers.state
Ajouté : payments_subtiers.subtier_type
Ajouté : payments_subtiers.waiver_contact_email
Ajouté : payments_subtiers.zip
Changements dans prime_contract_change_order_requests :
Ajout : prime_contract_change_order_requests.schedule_impact_days
Changements dans prime_contract_change_orders :
Ajout : prime_contract_change_orders.schedule_impact_days
Changements dans prime_contract_potential_change_orders :
Ajout : prime_contract_potential_change_orders.schedule_impact_days
Changements dans subcontractor_invoices :
Ajouté : subcontractor_invoices.early_pay_fee_amount
Ajouté : subcontractor_invoices.early_pay_fee_rate
Ajouté : subcontractor_invoices.early_pay_status
Ajouté : subcontractor_invoices.missed_payment_due_date
Ajouté : subcontractor_invoices.original_payment_due
Ajout : subcontractor_invoices.original_payment_due_company_currency
Ajout : subcontractor_invoices.original_payment_due_project_currency
Ajouté : subcontractor_invoices.payment_due_date
Changements dans correspondence_types :
Ajouté : correspondence_types.created_at
Changements dans correspondence_workflow_steps :
Ajouté : correspondence_workflow_steps.current_step_due_date
Changements dans daily_log_accident_custom_fields :
Ajouté : daily_log_accident_custom_fields.type_id
Changements dans daily_log_completion :
Ajouté : daily_log_completion.created_at
Changements dans daily_log_construction_report_custom_fields :
Ajouté : daily_log_construction_report_custom_fields.type_id
Changements dans daily_log_delay_custom_fields :
Ajouté : daily_log_delay_custom_fields.type_id
Changements dans daily_log_delivery_custom_fields :
Ajouté : daily_log_delivery_custom_fields.type_id
Changements dans daily_log_dumpster_custom_fields :
Ajouté : daily_log_dumpster_custom_fields.type_id
Changements dans daily_log_equipment :
Ajouté : daily_log_equipment.equipment_id
Ajout : daily_log_equipment.numéro_d’identification_de_l’équipement
Ajouté : daily_log_equipment.equipment_name_beta
Changements dans daily_log_equipment_custom_fields :
Ajouté : daily_log_equipment_custom_fields.type_id
Changements dans daily_log_inspection_custom_fields :
Ajouté : daily_log_inspection_custom_fields.type_id
Changements dans daily_log_manpower_custom_fields :
Ajouté : daily_log_manpower_custom_fields.type_id
Changements dans daily_log_plan_revision_custom_fields :
Ajouté : daily_log_plan_revision_custom_fields.type_id
Changements dans daily_log_productivity_custom_fields :
Ajouté : daily_log_productivity_custom_fields.type_id
Changements dans daily_log_scheduled_work_task :
Ajouté : daily_log_scheduled_work_task.created_at
Changements dans drawing_revision :
Ajouté : drawing_revision.created_at
Changements dans incident_alert :
Ajouté : incident_alert.created_at
Ajouté : incident_alert.updated_at
Changements dans inspection_distribution_list :
Ajouté : inspection_distribution_list.created_at
Ajouté : inspection_distribution_list.updated_at
Changements dans inspection_item_signature_requests :
Ajouté : inspection_item_signature_requests.created_at
Ajouté : inspection_item_signature_requests.updated_at
Changements dans inspection_schedule_assignees :
Ajouté : inspection_schedule_assignees.created_at
Ajouté : inspection_schedule_assignees.updated_at
Changements dans inspection_schedule_distribution_list :
Ajouté : inspection_schedule_distribution_list.created_at
Ajouté : inspection_schedule_distribution_list.updated_at
Changements dans inspection_schedules :
Ajouté : inspection_schedules.created_at
Ajouté : inspection_schedules.equipment_id
Ajout : inspection_schedules.numéro_d’identification_de_l’équipement
Ajouté : inspection_schedules.equipment_name
Ajouté : inspection_schedules.updated_at
Changements dans meeting_attendee :
Ajouté : meeting_attendee.created_at
Ajouté : meeting_attendee.updated_at
Changements dans meeting_item_assignee :
Ajouté : meeting_item_assignee.updated_at
Changements dans observation_distribution_member :
Ajouté : observation_distribution_member.created_at
Changements dans punch_item :
Ajouté : punch_item.audit_transaction_timestamp
Changements dans punch_item_bic :
Ajout de punch_item_bic.audit_transaction_timestamp
Ajouté : punch_item_bic.ball_in_court_role
Changements dans punch_item_custom_fields :
Ajouté : punch_item_custom_fields.type_id
Changements dans punch_item_distribution_member :
Ajout de punch_item_distribution_member.audit_transaction_timestamp
Changements dans rfi_assignees :
Ajouté : rfi_assignees.audit_transaction_timestamp
Changements dans rfi_distributions :
Ajout de rfi_distributions.audit_transaction_timestamp
Changements dans rfi_responses :
Ajout de rfi_responses.audit_transaction_timestamp
Changements dans les DDR :
Ajouté : rfis.audit_transaction_timestamp
Ajouté : rfis.current_revision
Ajouté : rfis.revision
Changements dans rfis_bic :
Ajout de rfis_bic.audit_transaction_timestamp
Ajouté : rfis_bic.ball_in_court_role
Changements dans schedule_calendar_item :
Ajouté : schedule_calendar_item.audit_transaction_timestamp
Changements dans schedule_lookahead :
Ajout de schedule_lookahead.audit_transaction_timestamp
Changements dans schedule_lookahead_task :
Ajouté : schedule_lookahead_task.audit_transaction_timestamp
Changements dans schedule_task :
Ajouté : schedule_task.audit_transaction_timestamp
Changements dans schedule_task_changes :
Ajouté : schedule_task_changes.audit_transaction_timestamp
Changements dans schedule_task_requests :
Ajout de schedule_task_requests.audit_transaction_timestamp
Changements dans site_instructions :
Ajouté : site_instructions.audit_transaction_timestamp
Changements dans specification_sections :
Ajout de specification_sections.audit_transaction_timestamp
Changements dans submittal_approvers :
Ajout de submittal_approvers.audit_transaction_timestamp
Ajouté : submittal_approvers.comments
Changements dans submittal_ball_in_courts :
Ajout de submittal_ball_in_courts.audit_transaction_timestamp
Ajouté : submittal_ball_in_courts.response_required
Changements dans submittal_distributions :
Ajout de submittal_distributions.audit_transaction_timestamp
Modifications dans les livrables :
Ajouté : submittals.audit_transaction_timestamp
Ajout : submittals.closed_at
Changements dans la tâche :
Ajouté : task.audit_transaction_timestamp
Changements dans task_activity :
Ajouté : task_activity.audit_transaction_timestamp
Changements dans task_assignee :
Ajout : task_assignee.audit_transaction_timestamp
Changements d’équipement :
Ajouté : equipment.rental_end_date
Ajouté : equipment.rental_start_date
Ajouté : equipment.vendor_name
Changements dans field_productivity :
Ajout : field_productivity.cost_code_id
Ajouté : field_productivity.production_quantity_code
Mises à jour des données Procore Analytics 2.0 (18/03/2025)
Procore a ajouté les modèles (tableaux) suivants :
Segments de code budgétaire
Valeurs SDP de la couche
Valeurs SDP du groupe de calques
Ajustement de l’estimation
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans correspondence_workflow_steps
Ajout current_step_due_date
Ajout current_step_name
Changements dans payments_disbursements
Ajout de owner_invoices.tax_applicable_to_this_payment_company_currency
Ajout de owner_invoices.tax_applicable_to_this_payment_project_currency
Changements dans subcontractor_invoice_line_items
Ajouté payments_disbursements.number
Ajout de subcontractor_invoice_line_items.total_retainage_company_currency
Ajout de subcontractor_invoice_line_items.total_retainage_project_currency
Changements dans action_plan
Ajout de action_plan.audit_transaction_timestamp
Changements dans action_plan_approver
Ajout de action_plan_approver.audit_transaction_timestamp
Changements dans action_plan_completed_receiver
Ajout de action_plan_completed_receiver.audit_transaction_timestamp
Changements dans action_plan_line_item
Ajout de action_plan_line_item.audit_transaction_timestamp
Changements dans action_plan_line_item_assignee
Ajout de action_plan_line_item_assignee.audit_transaction_timestamp
Changements dans action_plan_line_item_record
Ajout de action_plan_line_item_record.audit_transaction_timestamp
Changements dans action_plan_line_item_record_request
Ajout de action_plan_line_item_record_request.audit_transaction_timestamp
Changements dans action_plan_line_item_reference
Ajout de action_plan_line_item_reference.audit_transaction_timestamp
Changements dans drawing_revision
Ajout de drawing_revision.is_connected_drawing
Changements dans incident_record
Ajout de incident_record.affected_person_id
Changements dans l’observation
Ajout observation.created_by_company
Changements dans rfi_responses
Ajout de rfi_responses.is_most_recent
Changements dans rfis_bic
Ajout de rfis_bic.response_required
Changements dans schedule_task
Ajout de schedule_task.predecessor_wbs_list
Ajout de schedule_task.successor_wbs_list
Changements dans specification_sections
'Ajout de specification_sections.specification_area_description
Ajout de specification_sections.specification_area_name
Changements dans submittal_approvers
Ajout de submittal_approvers.previous_due_date
Ajouté submittal_approvers.previous_returned_date
Ajout de submittal_approvers.previous_sent_date
Changements dans wp_projects
Ajout de wp_projects.categories
Ajout users.audit_transaction_timestamp
Ajouté estimate_layer_groups.profit
Mises à jour des données Procore Analytics 2.0 (18/02/2025)
Procore a ajouté les modèles (tableaux) suivants :
Financier
payments_permissions
payments_disbursements
pay_requirement_settings
payments_project_controls
payments_invites
payments_agreements
payments_received
Gestion de projet
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
Planification des ressources
Affectations
Titres de poste
Requêtes
congé
Les gens de wp
Projets WP
groupe
Équipement
équipement
Registre de projet d’équipement
Entrée de pointage de l’équipement
Estimation
Estimation de projets
Estimer les couches
Estimer les groupes de couches
Champs personnalisés du projet d’estimation
Procore a mis à jour les modèles (tableaux) suivants :
Changements dans project_vendor_insurances.sql :
Ajout de project_vendor_insurances.external_origin_data
Ajout de project_vendor_insurances.external_origin_id
Changements dans projects.sql :
Ajout de projects.code
Ajout projects.delivery_method
Ajout projects.external_origin_data
Ajout projects.external_origin_id
Ajout de projects.sector
Ajout projects.work_scope
Changements dans users.sql :
Ajout users.abbreviated_name
Ajout users.can_push_to_accounting
Ajout users.company_name
Ajout users.company_permission_template
Ajout users.external_origin_data
Ajout users.external_origin_id
Ajout users.login_information_id
Ajout users.origin_id
Ajout users.origin_name
Changements dans budget_changes.sql :
Ajout de budget_changes.external_origin_data
Ajout de budget_changes.external_origin_id
Changements dans budget_line_items.sql :
Ajout de budget_line_items.budget_notes
Changements dans change_events.sql :
Ajout de change_events.external_origin_data
Ajout de change_events.external_origin_id
Changements dans commitment_change_orders.sql :
Ajout de commitment_change_orders.external_origin_data
Ajout de commitment_change_orders.external_origin_id
Changements dans commitment_line_items.sql :
Ajout de commitment_line_items.external_origin_data
Ajout de commitment_line_items.external_origin_id
Changements dans direct_cost_line_items.sql :
Ajout de direct_cost_line_items.external_origin_data
Ajout de direct_cost_line_items.external_origin_id
Changements dans direct_costs.sql :
Ajout de direct_costs.external_origin_data
Ajout de direct_costs.external_origin_id
Changements dans owner_invoice_line_item_with_markups.sql :
Ajout de owner_invoice_line_item_with_markups.external_origin_data
Ajout de owner_invoice_line_item_with_markups.external_origin_id
Ajout de owner_invoice_line_item_with_markups.materials_presently_stored_qty
Ajouté owner_invoice_line_item_with_markups.name
Ajout de owner_invoice_line_item_with_markups.new_materials_stored_qty
Ajout de owner_invoice_line_item_with_markups.previous_materials_stored_qty
Ajout de owner_invoice_line_item_with_markups.prime_contract_id
Changements dans owner_invoice_line_items.sql :
Ajout de owner_invoice_line_items.external_origin_data
Ajout de owner_invoice_line_items.external_origin_id
Ajout de owner_invoice_line_items.line_type
Ajout de owner_invoice_line_items.markup_id
Ajout de owner_invoice_line_items.materials_presently_stored_qty
Ajouté owner_invoice_line_items.name
Ajout de owner_invoice_line_items.new_materials_stored_qty
Ajout de owner_invoice_line_items.owner_invoice_line_item_with_markup_id
Ajout de owner_invoice_line_items.owner_invoice_markup_line_item_id
Ajout de owner_invoice_line_items.previous_materials_stored_qty
Changements dans owner_invoice_markup_line_items.sql :
Ajout de owner_invoice_markup_line_items.approved_changes
Ajout de owner_invoice_markup_line_items.approved_changes_company_currency
Ajout de owner_invoice_markup_line_items.approved_changes_project_currency
Ajout de owner_invoice_markup_line_items.balance_to_finish
Ajout de owner_invoice_markup_line_items.company_id_2
Ajout de owner_invoice_markup_line_items.external_origin_data
Ajout de owner_invoice_markup_line_items.external_origin_id
Ajout de owner_invoice_markup_line_items.line_type
Ajout de owner_invoice_markup_line_items.materials_presently_stored_qty
Ajouté owner_invoice_markup_line_items.name
Ajout de owner_invoice_markup_line_items.new_materials_stored_qty
Ajout de owner_invoice_markup_line_items.owner_invoice_line_item_id
Ajout de owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id
Ajout de owner_invoice_markup_line_items.previous_materials_stored_qty
Ajout de owner_invoice_markup_line_items.prime_contract_id
Changements dans owner_invoices.sql :
Ajout de owner_invoices.external_origin_data
Ajout de owner_invoices.external_origin_id
Ajout de owner_invoices.tax_applicable_to_this_payment
Changements dans payments_issued.sql :
Ajout de payments_issued.external_origin_data
Ajout de payments_issued.external_origin_id
Changements dans prime_contract_change_order_line_items.sql :
Ajout de prime_contract_change_order_line_items.external_origin_data
Ajout de prime_contract_change_order_line_items.external_origin_id
Changements dans prime_contract_change_order_requests.sql :
Ajout de prime_contract_change_order_requests.external_origin_data
Ajout de prime_contract_change_order_requests.external_origin_id
Changements dans prime_contract_change_orders.sql :
Ajout de prime_contract_change_orders.external_origin_data
Ajout de prime_contract_change_orders.external_origin_id
Changements dans prime_contract_line_items.sql :
Ajout de prime_contract_line_items.external_origin_data
Ajout de prime_contract_line_items.external_origin_id
Ajout de prime_contract_line_items.vendor_id
Changements dans prime_contract_potential_change_orders.sql :
Ajout de prime_contract_potential_change_orders.external_origin_data
Ajout de prime_contract_potential_change_orders.external_origin_id
Changements dans prime_contracts.sql :
Ajout de prime_contracts.external_origin_data
Ajout de prime_contracts.external_origin_id
Changements dans subcontractor_invoice_line_items.sql :
Ajout de subcontractor_invoice_line_items.materials_presently_stored_qty
Ajout de subcontractor_invoice_line_items.materials_previously stored_qty
Ajout de subcontractor_invoice_line_items.new_materials_qty
Changements dans subcontractor_invoices.sql :
Ajout de subcontractor_invoices.external_origin_data
Ajout de subcontractor_invoices.external_origin_id
Changements dans inspections.sql :
Ajout inspections.equipment_identification_number
Changements dans rfi_assignees.sql :
Ajouté rfi_assignees.forwarded_by
Changements dans submittal_approvers.sql :
Ajout de submittal_approvers.is_last_step
Changements dans equipment_timecard_entry.sql :
Ajout de equipment_timecard_entry.numéro_d’identification_de_l’équipement
Ajout de equipment_timecard_entry.equipment_name
Mises à jour des données Procore Analytics 2.0 (21/01/2025)
Procore a ajouté les modèles (tableaux) suivants :
inspection_item_references
schedule_task_changes
équipement
equipment_project_log
equipment_timecard_entry
payments_project_controls
payments_invites
payments_agreements
pay_requirement_settings
Procore a mis à jour les modèles (tableaux) suivants :
company_vendor_insurances :
Ajout de company_vendor_insurances.template_name
project_role_memberships :
Ajout de project_role_memberships.user_id
budget_change_workflow_steps :
Ajout de budget_change_workflow_steps.current_step_due_date
budget_codes :
Supprimé SELECT budget_codes.budget_code
Ajout de SELECT budget_codes.attribute_1_line_item
Ajout de budget_codes.attribute_1_name
Ajout de budget_codes.attribute_2_line_item
Ajout de budget_codes.attribute_2_name
Ajout de budget_codes.attribute_3_line_item
Ajout de budget_codes.attribute_3_name
Ajout de budget_codes.budget_code
budget_columns :
Ajout de budget_columns.created_at
Ajouté budget_columns.updated_at
change_event_line_item_with_markups :
Supprimé SELECT change_event_line_item_with_markups.budget_days_in_stage
Ajout de SELECT change_event_line_item_with_markups.biller_id
Ajout de change_event_line_item_with_markups.biller_model_name
Ajout de change_event_line_item_with_markups.biller_name
Ajout de change_event_line_item_with_markups.budget_days_in_stage
Ajout de change_event_line_item_with_markups.change_event_events_id
Ajout de change_event_line_item_with_markups.change_event_status
Ajout de change_event_line_item_with_markups.change_event_title
Ajout de change_event_line_item_with_markups.contract_id
Ajout de change_event_line_item_with_markups.numéro_du_contrat
Ajout de change_event_line_item_with_markups.contract_title
Ajout de change_event_line_item_with_markups.estimated_budget_amount
Ajout de change_event_line_item_with_markups.estimated_budget_transfer_amount
Ajout de change_event_line_item_with_markups.estimated_cost_amount
Ajout de change_event_line_item_with_markups.estimated_cost_amount_company_currency
Ajout de change_event_line_item_with_markups.estimated_cost_amount_project_currency
Ajout de change_event_line_item_with_markups.event_scope
Ajout de change_event_line_item_with_markups.proposed_contract_id
Ajout de change_event_line_item_with_markups.proposed_vendor_id
Ajouté change_event_line_item_with_markups.source
Ajout de change_event_line_item_with_markups.vendor_name
Ajout de change_event_line_item_with_markups.wbs_code_id
commitment_change_order_line_items :
Ajout de commitment_change_order_line_items.commitment_change_order_request_id
Ajout de commitment_change_order_line_items.commitment_potential_change_order_id
commitment_change_order_workflow_steps :
Ajout de commitment_change_order_workflow_steps.current_step_due_date
commitment_custom_field_configs :
Ajouté commitment_custom_field_configs.name
commitment_pco_workflow_steps :
Ajout de commitment_pco_workflow_steps.current_step_due_date
commitment_workflow_step_occurrences :
Ajout de commitment_workflow_step_occurrences.current_step_due_date
contract_compliance_documents :
Ajout de contract_compliance_documents.template_name
owner_invoice_workflow_steps :
Ajout de owner_invoice_workflow_steps.current_step_due_date
owner_invoices :
Ajout de owner_invoices.erp_latest_status
Ajout de owner_invoices.erp_updated_at
Ajout de owner_invoices.erp_user_name
Ajout de owner_invoices.synced_with_accounting
payments_beneficiaries :
Ajout de payments_beneficiaries.early_pay_classification
prime_contract_change_order_line_items :
Ajouté prime_contract_change_order_line_items.name
Ajout de prime_contract_change_order_line_items.prime_contract_change_order_request_id
Ajout de prime_contract_change_order_line_items.prime_contract_potential_change_order_id
prime_contract_change_order_workflow_steps :
Ajout de prime_contract_change_order_workflow_steps.current_step_due_date
prime_contract_pco_workflow_steps :
Ajout de prime_contract_pco_workflow_steps.current_step_due_date
prime_contract_workflow_steps :
Ajout de prime_contract_workflow_steps.current_step_due_date
subcontractor_invoice_line_items :
Ajout de subcontractor_invoice_line_items.total_retainage
subcontractor_invoice_workflow_steps :
Ajout de subcontractor_invoice_workflow_steps.current_step_due_date
action_plan_custom_fields :
Ajout de action_plan_custom_fields.type_id
action_plan_line_item_record :
Ajout de action_plan_line_item_record.action_plan_line_item_record_resource_url
correspondence_custom_fields :
Ajout de correspondence_custom_fields.type_id
correspondence_response_attachments :
Ajout de correspondence_response_attachments.type_id
correspondence_schedule_tasks :
Ajout de correspondence_schedule_tasks.type_id
correspondence_workflow_responses :
Ajout de correspondence_workflow_responses.type_id
correspondence_workflow_steps :
Ajout de correspondence_workflow_steps.type_id
daily_log_accident :
Ajout de daily_log_accident.daily_log_completion_id
daily_log_construction_reports :
Ajout de daily_log_construction_reports.daily_log_completion_id
daily_log_delay :
Ajout de daily_log_delay.daily_log_completion_id
daily_log_delivery :
Ajout de daily_log_delivery.daily_log_completion_id
daily_log_dumpster :
Ajout de daily_log_dumpster.daily_log_completion_id
daily_log_equipment :
Ajout de daily_log_equipment.daily_log_completion_id
daily_log_inspection :
Ajout de daily_log_inspection.daily_log_completion_id
daily_log_manpower :
Ajout de daily_log_manpower.daily_log_completion_id
daily_log_note :
Ajout de daily_log_note.daily_log_completion_id
daily_log_observed_weather_condition :
Ajout de daily_log_observed_weather_condition.daily_log_completion_id
daily_log_phone_call :
Ajout de daily_log_phone_call.daily_log_completion_id
daily_log_plan_revision :
Ajout de daily_log_plan_revision.daily_log_completion_id
daily_log_productivity :
Ajout de daily_log_productivity.daily_log_completion_id
daily_log_quantity :
Ajout de daily_log_quantity.daily_log_completion_id
daily_log_safety_violation :
Ajout de daily_log_safety_violation.daily_log_completion_id
daily_log_scheduled_work :
Ajout de daily_log_scheduled_work.daily_log_completion_id
daily_log_scheduled_work_task :
Ajout de daily_log_scheduled_work_task.daily_log_completion_id
Ajout de daily_log_scheduled_work_task.schedule_task_id
daily_log_visitor :
Ajout de daily_log_visitor.daily_log_completion_id
daily_log_waste :
Ajout de daily_log_waste.daily_log_completion_id
inspection_custom_fields :
Ajout de inspection_custom_fields.type_id
inspection_item_signature_requests :
Ajout de inspection_item_signature_requests.inspection_schedule_id
inspection_items :
Ajout de inspection_items.position_number
inspection_schedules :
Ajout de inspection_schedules.ends_at
Ajout de inspection_schedules.starts_at
Inspections:
Ajout inspections.equipment_id
Ajout inspections.equipment_name
observation_custom_field_configs :
Ajout de observation_custom_field_configs.observation_type_id
Ajout de observation_custom_field_configs.type_id
observation_custom_fields :
Ajout de observation_custom_fields.type_id
punch_item_bic :
Ajout de punch_item_bic.punch_item_bic_id
rfis_bic :
Ajout de rfis_bic.rfi_bic_id
schedule_lookahead_task :
Ajout de schedule_lookahead_task.task_id_comp
schedule_task :
Ajout de schedule_task.task_id
submittal_ball_in_courts :
Ajout de submittal_ball_in_courts.nom_de_l’entreprise
Ajout de submittal_ball_in_courts.role
Livrables :
Ajout submittals.ball_in_court_role
Ajout de livrables.paused
actual_production_quantities :
Ajout de actual_production_quantities.wbs_code_id
budget_change_production_quantities :
Supprimé SELECT budget_change_production_quantities.budget_change_production_quantity_id
Ajout de SELECT budget_change_production_quantities.budget_change_id
Ajout de budget_change_production_quantities.budget_change_production_quantity_id
Ajout de budget_change_production_quantities.wbs_code_id
prime_potential_change_order_production_quantities :
Ajout de prime_potential_change_order_production_quantities.prime_contract_change_order_id
Ajout de prime_potential_change_order_production_quantities.wbs_code_id
projet:
Ajout de project.code
owner_invoices :
Ajout owner_invoices. Tax_Applicable_To_This_Payment
timecard_entries :
Ajout de timecard_entries.user_id
Mises à jour des données Procore Analytics 2.0 (17/12/2024)
Procore a ajouté (current_step_due_date) aux modèles (tableaux) suivants :
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
Procore a ajouté les champs suivants :
actual_production_quantities.wbs_code_id (en anglais seulement)
timecard_entries.identifiant_utilisateur
See Also
Loading related articles...