Análisis: registro de cambios de datos

Actualizaciones de datos de Procore Analytics 2.0 (¡próximamente!)

Procore agregó los siguientes modelos (tablas):

Company_folder_documents
Folder_documents
Folder_watchers
Equipment_telematic
wp_project_custom_fields
estimating_project_custom_field_configs

Procore actualizó los siguientes modelos (tablas):

Cambios en project_users:
- Se agregó project_users.nombre_abreviado
- Añadido project_users.add_to_new_projects
- Añadido project_users.address
- Se agregó project_users.business_phone_extension
- Se agregó project_users.cached_full_name
- Añadido project_users.can_add_new_projects
- Se agregó project_users.can_push_to_accounting
- Añadido project_users.city
- Se ha añadido project_users.classification
- Se agregó project_users.nombre_de_la_empresa
- Se agregó project_users.company_permission_template
- Añadido project_users.contact_id
- Añadido project_users.nombre_país
- Añadido project_users.entregable
- Se agregó project_users.email_signature
- Se ha añadido project_users.external_origin_data
- Se ha añadido project_users.external_origin_id
- Se agregó project_users.is_company_primary_contact
- Se agregó project_users.is_insurance_manager
- Añadido project_users.last_activated_at
- Añadido project_users.login
- Se agregó project_users.login_information_id
- Añadido project_users.name
- Se agregó project_users.new_project_permission_template_id
- Se ha añadido project_users.origin_id
- Se ha añadido project_users.nombre_origen
- Se agregó project_users.permission_template
- Se agregó project_users.permission_template_project_specific
- Se agregó project_users.pk_user_id
- Se ha añadido project_users.project_roles
- Se agregó project_users.project_user_id
- Se agregó project_users.send_this_user_messages
- Se agregó project_users.state_name
- Se agregó project_users.user_resource_url
- Añadido project_users.users_slony
- Añadido project_users.welcome_email_sent_at
Cambios en subcontractor_invoice_line_items:
- Se ha añadido subcontractor_invoice_line_items.ajuste_materials_before_stored
- Se agregó subcontractor_invoice_line_items.adjusted_materials_before_stored_company_currency
- Se agregó subcontractor_invoice_line_items.adjusted_materials_before_stored_project_currency
- Se agregó subcontractor_invoice_line_items.adjusted_materials_retained_previously
- Se agregó subcontractor_invoice_line_items.adjusted_materials_retained_before_company_currency
- Se agregó subcontractor_invoice_line_items.adjusted_materials_retained_before_project_currency
- Se ha añadido subcontractor_invoice_line_items.gross_amount
- Se agregó subcontractor_invoice_line_items.gross_amount_company_currency
- Se agregó subcontractor_invoice_line_items.gross_amount_project_currency
- Se agregó subcontractor_invoice_line_items.net_amount
- Se agregó subcontractor_invoice_line_items.net_amount_company_currency
- Se agregó subcontractor_invoice_line_items.net_amount_project_currency
- Se agregó subcontractor_invoice_line_items.retainage_new_materials_from_percent
- Se agregó subcontractor_invoice_line_items.retainage_new_materials_from_percent_company_currency
- Se agregó subcontractor_invoice_line_items.retainage_new_materials_from_percent_project_currency
- Se agregó subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous
- Se agregó subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_company_currency
- Se agregó subcontractor_invoice_line_items.total_completed_and_stored_to_date_from_previous_project_currency
- Se agregó subcontractor_invoice_line_items.commitment_line_item_id
- Se agregó subcontractor_invoice_line_items.prime_contract_line_item_id
Cambios en los submittals:
- Añadido submittals.anticipated_delivery_date_at_close
- Añadido submittals.remaining_buffer_time_at_close
- Añadido submittals.workflow_progress_at_close
- Cambios en wp_people:
- Añadido wp_people.custom_fields
Cambios en wp_projects:
- Añadido wp_projects.custom_fields
Cambios en budget_view_details:
- Se agregó budget_view_details.infojson_currency_conversion

Actualizaciones de datos de Procore Analytics 2.0 (20/05/2025)

Procore agregó los siguientes modelos (tablas):

project_company_comments
Etiquetas

Procore actualizó los siguientes modelos (tablas):

Cambios en company_comments:
- Se agregó company_comments.audit_transaction_timestamp
- Añadido company_comments.rating
Cambios en company_distribution_groups:
- Se agregó company_distribution_groups.audit_transaction_timestamp
- Se agregó ,company_distribution_groups.project_id
Cambios en project_distribution_groups:
- Se agregó project_distribution_groups.audit_transaction_timestamp
- Se agregó ,project_distribution_groups.company_id
Cambios en project_tools:
- Se agregó project_tools.audit_transaction_timestamp
- Añadido ,project_tools.is_active
Cambios en budget_codes:
- Se agregó ,budget_codes.production_quantity_code_description
Cambios en drawing_attachment:
- Se agregó ,drawing_attachment.folder_document_id
Cambios en las inspecciones:
- Añadido ,inspections.closed_at
Cambios en el equipo:
- Añadido ,equipment.status_type
Cambios en field_productivity:
- Se agregó ,field_productivity.hours_utilization_enrp
- Se agregó ,field_productivity.projected_hours_at_completion_enrp

Actualizaciones de datos de Procore Analytics 2.0 (22/04/2025)

Procore agregó los siguientes modelos (tablas):

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 actualizó los siguientes modelos (tablas):

Cambios en project_role_memberships:
- Agregado: project_role_memberships.employee_id
Cambios en project_vendors:
- Añadido: project_vendors.cost_codes
- Añadido: project_vendors.trades
Cambios en los proyectos:
- Añadido: projects.schedule_last_updated
- Añadido: projects.schedule_percent_completion
Cambios en los proveedores:
- Añadido: vendors.cost_codes
- Añadido: vendors.trades
Cambios en budget_change_adjustment_line_items:
- Agregado: budget_change_adjustment_line_items.budget_changes_approved_amount
- Agregado: budget_change_adjustment_line_items.budget_changes_approved_amount_company_currency
- Agregado: budget_change_adjustment_line_items.budget_changes_approved_amount_project_currency
- Agregado: budget_change_adjustment_line_items.budget_changes_draft_amount
- Agregado: budget_change_adjustment_line_items.budget_changes_draft_amount_company_currency
- Agregado: budget_change_adjustment_line_items.budget_changes_draft_amount_project_currency
- Agregado: budget_change_adjustment_line_items.budget_changes_under_review_amount
- Agregado: budget_change_adjustment_line_items.budget_changes_under_review_amount_company_currency
- Agregado: budget_change_adjustment_line_items.budget_changes_under_review_amount_project_currency
Cambios en budget_columns:
- Agregado: budget_columns.budget_column_id
Cambios en budget_snapshot_line_item_forecasts:
- Agregado: budget_snapshot_line_item_forecasts.approval_status
- Añadido: budget_snapshot_line_item_forecasts.snapshot_type
Cambios en budget_snapshot_line_item_headers:
- Se agregó budget_snapshot_line_item_headers.approval_status
- Agregado: budget_snapshot_line_item_headers.audit_transaction_timestamp
- Añadido: budget_snapshot_line_item_headers.snapshot_type
Cambios en budget_snapshot_line_items:
- Se agregó budget_snapshot_line_items.approval_status
- Agregado: budget_snapshot_line_items.audit_transaction_timestamp
- Añadido: budget_snapshot_line_items.snapshot_type
Cambios en change_event_line_item_with_markups:
- Agregado: change_event_line_item_with_markups.links_commitment_contract_cost
- Agregado: change_event_line_item_with_markups.links_commitment_pco_cost
- Añadido: change_event_line_item_with_markups.links_contract
- Añadido: change_event_line_item_with_markups.links_edit
- Agregado: change_event_line_item_with_markups.links_prime_pco_cost
- Agregado: change_event_line_item_with_markups.links_rfq_amount
- Añadido: change_event_line_item_with_markups.links_rom
- Añadido: change_event_line_item_with_markups.links_view
Cambios en commitment_line_items:
- Agregado: commitment_line_items.contracts_approved_amount
- Agregado: commitment_line_items.contracts_approved_amount_company_currency
- Agregado: commitment_line_items.contracts_approved_amount_project_currency
- Agregado: commitment_line_items.contracts_complete_amount
- Agregado: commitment_line_items.contracts_complete_amount_company_currency
- Agregado: commitment_line_items.contracts_complete_amount_project_currency
- Agregado: commitment_line_items.contracts_draft_amount
- Agregado: commitment_line_items.contracts_draft_amount_company_currency
- Agregado: commitment_line_items.contracts_draft_amount_project_currency
- Agregado: commitment_line_items.contracts_out_for_signature_amount
- Agregado: commitment_line_items.contracts_out_for_signature_amount_company_currency
- Agregado: commitment_line_items.contracts_out_for_signature_amount_project_currency
Cambios en los compromisos:
- Añadido: commitments.global_insurance_compliance
- Añadido: commitments.project_insurance_compliance
- Añadido: commitments.remaining_balance
- Añadido: commitments.revised_contract_amount
Cambios en payments_issued:
- Agregado: payments_issued.early_pay_fee_amount
Cambios en payments_project_controls:
- Se agregó payments_project_controls.assigned_early_pay_program
- Agregado: payments_project_controls.audit_transaction_timestamp
- Añadido: payments_project_controls.early_pay_program_id
Cambios en payments_subtier_waivers:
- Agregado: payments_subtier_waivers.joint_check_requisition
Cambios en payments_subtiers:
- Se agregó payments_subtiers.additional_address_information
- Añadido: payments_subtiers.address
- Agregado: payments_subtiers.amount_billed_to_date
- Añadido: payments_subtiers.city
- Añadido: payments_subtiers.country
- Agregado: payments_subtiers.joint_check_future_requisitions
- Añadido: payments_subtiers.tipo_de_trabajo
- Añadido: payments_subtiers.phone
- Añadido: payments_subtiers.state
- Añadido: payments_subtiers.subtier_type
- Agregado: payments_subtiers.waiver_contact_email
- Añadido: payments_subtiers.zip
Cambios en prime_contract_change_order_requests:
- Agregado: prime_contract_change_order_requests.schedule_impact_days
Cambios en prime_contract_change_orders:
- Agregado: prime_contract_change_orders.schedule_impact_days
Cambios en prime_contract_potential_change_orders:
- Agregado: prime_contract_potential_change_orders.schedule_impact_days
Cambios en subcontractor_invoices:
- Añadido: subcontractor_invoices.early_pay_fee_amount
- Añadido: subcontractor_invoices.early_pay_fee_rate
- Añadido: subcontractor_invoices.early_pay_status
- Agregado: subcontractor_invoices.missed_payment_due_date
- Añadido: subcontractor_invoices.original_payment_due
- Agregado: subcontractor_invoices.original_payment_due_company_currency
- Añadido: subcontractor_invoices.original_payment_due_project_currency
- Añadido: subcontractor_invoices.payment_due_date
Cambios en correspondence_types:
- Añadido: correspondence_types.created_at
Cambios en correspondence_workflow_steps:
- Agregado: correspondence_workflow_steps.current_step_due_date
Cambios en daily_log_accident_custom_fields:
- Añadido: daily_log_accident_custom_fields.type_id
Cambios en daily_log_completion:
- Añadido: daily_log_completion.created_at
Cambios en daily_log_construction_report_custom_fields:
- Añadido: daily_log_construction_report_custom_fields.type_id
Cambios en daily_log_delay_custom_fields:
- Añadido: daily_log_delay_custom_fields.type_id
Cambios en daily_log_delivery_custom_fields:
- Añadido: daily_log_delivery_custom_fields.type_id
Cambios en daily_log_dumpster_custom_fields:
- Añadido: daily_log_dumpster_custom_fields.type_id
Cambios en daily_log_equipment:
- Añadido: daily_log_equipment.equipment_id
- Agregado: daily_log_equipment.número_de_identificación_de_equipos
- Añadido: daily_log_equipment.nombre_equipo_beta
Cambios en daily_log_equipment_custom_fields:
- Añadido: daily_log_equipment_custom_fields.type_id
Cambios en daily_log_inspection_custom_fields:
- Añadido: daily_log_inspection_custom_fields.type_id
Cambios en daily_log_manpower_custom_fields:
- Agregado: daily_log_manpower_custom_fields.type_id
Cambios en daily_log_plan_revision_custom_fields:
- Añadido: daily_log_plan_revision_custom_fields.type_id
Cambios en daily_log_productivity_custom_fields:
- Añadido: daily_log_productivity_custom_fields.type_id
Cambios en daily_log_scheduled_work_task:
- Añadido: daily_log_scheduled_work_task.created_at
Cambios en drawing_revision:
- Añadido: drawing_revision.created_at
Cambios en incident_alert:
- Añadido: incident_alert.created_at
- Añadido: incident_alert.updated_at
Cambios en inspection_distribution_list:
- Añadido: inspection_distribution_list.created_at
- Añadido: inspection_distribution_list.updated_at
Cambios en inspection_item_signature_requests:
- Añadido: inspection_item_signature_requests.created_at
- Añadido: inspection_item_signature_requests.updated_at
Cambios en inspection_schedule_assignees:
- Añadido: inspection_schedule_assignees.created_at
- Añadido: inspection_schedule_assignees.updated_at
Cambios en inspection_schedule_distribution_list:
- Añadido: inspection_schedule_distribution_list.created_at
- Añadido: inspection_schedule_distribution_list.updated_at
Cambios en inspection_schedules:
- Añadido: inspection_schedules.created_at
- Añadido: inspection_schedules.equipment_id
- Agregado: inspection_schedules.número_de_identificación_de_equipos
- Añadido: inspection_schedules.nombre_equipo
- Añadido: inspection_schedules.updated_at
Cambios en meeting_attendee:
- Añadido: meeting_attendee.created_at
- Añadido: meeting_attendee.updated_at
Cambios en meeting_item_assignee:
- Añadido: meeting_item_assignee.updated_at
Cambios en observation_distribution_member:
- Añadido: observation_distribution_member.created_at
Cambios en punch_item:
- Agregado: punch_item.audit_transaction_timestamp
Cambios en punch_item_bic:
- Se agregó punch_item_bic.audit_transaction_timestamp
- Añadido: punch_item_bic.ball_in_court_role
Cambios en punch_item_custom_fields:
- Agregado: punch_item_custom_fields.type_id
Cambios en punch_item_distribution_member:
- Se agregó punch_item_distribution_member.audit_transaction_timestamp
Cambios en rfi_assignees:
- Agregado: rfi_assignees.audit_transaction_timestamp
Cambios en rfi_distributions:
- Se agregó rfi_distributions.audit_transaction_timestamp
Cambios en rfi_responses:
- Se agregó rfi_responses.audit_transaction_timestamp
Cambios en las RFI:
- Añadido: rfis.audit_transaction_timestamp
- Añadido: rfis.current_revision
- Añadido: rfis.revision
Cambios en rfis_bic:
- Se agregó rfis_bic.audit_transaction_timestamp
- Añadido: rfis_bic.ball_in_court_role
Cambios en schedule_calendar_item:
- Agregado: schedule_calendar_item.audit_transaction_timestamp
Cambios en schedule_lookahead:
- Se agregó schedule_lookahead.audit_transaction_timestamp
Cambios en schedule_lookahead_task:
- Agregado: schedule_lookahead_task.audit_transaction_timestamp
Cambios en schedule_task:
- Agregado: schedule_task.audit_transaction_timestamp
Cambios en schedule_task_changes:
- Agregado: schedule_task_changes.audit_transaction_timestamp
Cambios en schedule_task_requests:
- Se agregó schedule_task_requests.audit_transaction_timestamp
Cambios en site_instructions:
- Agregado: site_instructions.audit_transaction_timestamp
Cambios en specification_sections:
- Se agregó specification_sections.audit_transaction_timestamp
Cambios en submittal_approvers:
- Se agregó submittal_approvers.audit_transaction_timestamp
- Añadido: submittal_approvers.comments
Cambios en submittal_ball_in_courts:
- Se agregó submittal_ball_in_courts.audit_transaction_timestamp
- Agregado: submittal_ball_in_courts.response_required
Cambios en submittal_distributions:
Se agregó submittal_distributions.audit_transaction_timestamp
Cambios en los submittals:
- Añadido: submittals.audit_transaction_timestamp
- Añadido: submittals.closed_at
Cambios en la tarea:
- Añadido: task.audit_transaction_timestamp
Cambios en task_activity:
- Agregado: task_activity.audit_transaction_timestamp
Cambios en task_assignee:
- Agregado: task_assignee.audit_transaction_timestamp
Cambios en el equipo:
- Añadido: equipment.rental_end_date
- Añadido: equipment.rental_start_date
- Añadido: equipment.vendor_name
Cambios en field_productivity:
- Añadido: field_productivity.cost_code_id
- Añadido: field_productivity.production_quantity_code

Actualizaciones de datos de Procore Analytics 2.0 (18/03/2025)

Procore agregó los siguientes modelos (tablas):

Segmentos de código de presupuesto
Valores WBS de capa
Valores WBS del grupo de capas
Ajuste de estimación

Procore actualizó los siguientes modelos (tablas):

Cambios en correspondence_workflow_steps
- Añadido current_step_due_date
- Añadido current_step_name
Cambios en payments_disbursements
- Se agregó owner_invoices.tax_applicable_to_this_payment_company_currency
- Se agregó owner_invoices.tax_applicable_to_this_payment_project_currency
Cambios en subcontractor_invoice_line_items
- Se agregó payments_disbursements.number
- Se agregó subcontractor_invoice_line_items.total_retainage_company_currency
- Se agregó subcontractor_invoice_line_items.total_retainage_project_currency
Cambios en action_plan
- Se agregó action_plan.audit_transaction_timestamp
Cambios en action_plan_approver
- Se agregó action_plan_approver.audit_transaction_timestamp
Cambios en action_plan_completed_receiver
- Se agregó action_plan_completed_receiver.audit_transaction_timestamp
Cambios en action_plan_line_item
- Se agregó action_plan_line_item.audit_transaction_timestamp
Cambios en action_plan_line_item_assignee
- Se agregó action_plan_line_item_assignee.audit_transaction_timestamp
Cambios en action_plan_line_item_record
- Se agregó action_plan_line_item_record.audit_transaction_timestamp
Cambios en action_plan_line_item_record_request
- Se agregó action_plan_line_item_record_request.audit_transaction_timestamp
Cambios en action_plan_line_item_reference
- Se agregó action_plan_line_item_reference.audit_transaction_timestamp
Cambios en drawing_revision
- Se agregó drawing_revision.is_connected_drawing
Cambios en incident_record
- Se agregó incident_record.affected_person_id
Cambios en la observación
- Añadido observation.created_by_company
Cambios en rfi_responses
- Se agregó rfi_responses.is_most_recent
Cambios en rfis_bic
- Se agregó rfis_bic.response_required
Cambios en schedule_task
- Añadido schedule_task.predecesor_wbs_list
- Añadido schedule_task.successor_wbs_list
Cambios en specification_sections
- 'Añadido specification_sections.specification_area_description
- Se agregó specification_sections.specification_area_name
Cambios en submittal_approvers
- Se agregó submittal_approvers.previous_due_date
- Se agregó submittal_approvers.previous_returned_date
- Se agregó submittal_approvers.previous_sent_date
Cambios en wp_projects
- Añadido wp_projects.categorías
Añadido users.audit_transaction_timestamp
Añadido estimate_layer_groups.profit

Actualizaciones de datos de Procore Analytics 2.0 (18/02/2025)

Procore agregó los siguientes modelos (tablas):

Financiero
- payments_permissions
- payments_disbursements
- pay_requirement_settings
- payments_project_controls
- payments_invites
- payments_agreements
- payments_received
Administración de proyectos
- 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
Planificación de recursos
- Asignaciones
- Títulos de trabajo
- Solicitudes
- Tiempo libre
- Gente de WP
- Proyectos WP
- grupos
Equipos
- equipo
- Registro de proyecto de equipo
- Entrada de tarjeta horaria de equipos
Estimar
- Estimación de proyectos
- Capas de estimación
- Estimación de grupos de capas
- Estimación de campos personalizados del proyecto

Procore actualizó los siguientes modelos (tablas):

Cambios en project_vendor_insurances.sql:
- Se ha añadido project_vendor_insurances.external_origin_data
- Se agregó project_vendor_insurances.external_origin_id
Cambios en projects.sql:
- Se ha añadido projects.code
- Añadido projects.delivery_method
- Añadido projects.external_origin_data
- Añadido projects.external_origin_id
- Se ha añadido projects.sector
- Añadido projects.work_scope
Cambios en users.sql:
- Añadido users.abbreviated_name
- Añadido users.can_push_to_accounting
- Añadido users.company_name
- Añadido users.company_permission_template
- Añadido users.external_origin_data
- Añadido users.external_origin_id
- Añadido users.login_information_id
- Añadido users.origin_id
- Añadido users.origin_name
Cambios en budget_changes.sql:
- Se ha añadido budget_changes.external_origin_data
- Se agregó budget_changes.external_origin_id
Cambios en budget_line_items.sql:
- Se agregó budget_line_items.budget_notes
Cambios en change_events.sql:
- Se agregó change_events.external_origin_data
- Se agregó change_events.external_origin_id
Cambios en commitment_change_orders.sql:
- Se agregó commitment_change_orders.external_origin_data
- Se agregó commitment_change_orders.external_origin_id
Cambios en commitment_line_items.sql:
- Se ha añadido commitment_line_items.external_origin_data
- Se agregó commitment_line_items.external_origin_id
Cambios en direct_cost_line_items.sql:
- Se ha añadido direct_cost_line_items.external_origin_data
- Se agregó direct_cost_line_items.external_origin_id
Cambios en direct_costs.sql:
- Se ha añadido direct_costs.external_origin_data
- Se agregó direct_costs.external_origin_id
Cambios en owner_invoice_line_item_with_markups.sql:
- Se ha añadido owner_invoice_line_item_with_markups.external_origin_data
- Se agregó owner_invoice_line_item_with_markups.external_origin_id
- Se agregó owner_invoice_line_item_with_markups.materials_presently_stored_qty
- Añadido owner_invoice_line_item_with_markups.name
- Se agregó owner_invoice_line_item_with_markups.new_materials_stored_qty
- Se agregó owner_invoice_line_item_with_markups.previous_materials_stored_qty
- Se agregó owner_invoice_line_item_with_markups.prime_contract_id
Cambios en owner_invoice_line_items.sql:
- Se ha añadido owner_invoice_line_items.external_origin_data
- Se agregó owner_invoice_line_items.external_origin_id
- Se agregó owner_invoice_line_items.line_type
- Se agregó owner_invoice_line_items.markup_id
- Se agregó owner_invoice_line_items.materials_presently_stored_qty
- Añadido owner_invoice_line_items.name
- Se agregó owner_invoice_line_items.new_materials_stored_qty
- Se agregó owner_invoice_line_items.owner_invoice_line_item_with_markup_id
- Se agregó owner_invoice_line_items.owner_invoice_markup_line_item_id
- Se agregó owner_invoice_line_items.previous_materials_stored_qty
Cambios en owner_invoice_markup_line_items.sql:
- Añadido owner_invoice_markup_line_items.approved_changes
- Se agregó owner_invoice_markup_line_items.approved_changes_company_currency
- Se agregó owner_invoice_markup_line_items.approved_changes_project_currency
- Se ha añadido owner_invoice_markup_line_items.balance_to_finish
- Se agregó owner_invoice_markup_line_items.company_id_2
- Se ha añadido owner_invoice_markup_line_items.external_origin_data
- Se agregó owner_invoice_markup_line_items.external_origin_id
- Se agregó owner_invoice_markup_line_items.line_type
- Se agregó owner_invoice_markup_line_items.materials_presently_stored_qty
- Añadido owner_invoice_markup_line_items.name
- Se agregó owner_invoice_markup_line_items.new_materials_stored_qty
- Se agregó owner_invoice_markup_line_items.owner_invoice_line_item_id
- Se agregó owner_invoice_markup_line_items.owner_invoice_line_item_with_markup_id
- Se agregó owner_invoice_markup_line_items.previous_materials_stored_qty
- Se agregó owner_invoice_markup_line_items.prime_contract_id
Cambios en owner_invoices.sql:
- Se ha añadido owner_invoices.external_origin_data
- Se agregó owner_invoices.external_origin_id
- Se agregó owner_invoices.tax_applicable_to_this_payment
Cambios en payments_issued.sql:
- Se ha añadido payments_issued.external_origin_data
- Se agregó payments_issued.external_origin_id
Cambios en prime_contract_change_order_line_items.sql:
- Se agregó prime_contract_change_order_line_items.external_origin_data
- Se agregó prime_contract_change_order_line_items.external_origin_id
Cambios en prime_contract_change_order_requests.sql:
- Se ha añadido prime_contract_change_order_requests.external_origin_data
- Se ha añadido prime_contract_change_order_requests.external_origin_id
Cambios en prime_contract_change_orders.sql:
- Se ha añadido prime_contract_change_orders.external_origin_data
- Se agregó prime_contract_change_orders.external_origin_id
Cambios en prime_contract_line_items.sql:
- Se agregó prime_contract_line_items.external_origin_data
- Se agregó prime_contract_line_items.external_origin_id
- Se agregó prime_contract_line_items.vendor_id
Cambios en prime_contract_potential_change_orders.sql:
- Se ha añadido prime_contract_potential_change_orders.external_origin_data
- Se agregó prime_contract_potential_change_orders.external_origin_id
Cambios en prime_contracts.sql:
- Se ha añadido prime_contracts.external_origin_data
Se ha añadido prime_contracts.external_origin_id
Cambios en subcontractor_invoice_line_items.sql:
- Se agregó subcontractor_invoice_line_items.materials_presently_stored_qty
- Se ha añadido subcontractor_invoice_line_items.materials_before_stored_qty
- Añadido subcontractor_invoice_line_items.new_materials_qty
Cambios en subcontractor_invoices.sql:
- Se ha añadido subcontractor_invoices.external_origin_data
- Se agregó subcontractor_invoices.external_origin_id
Cambios en inspections.sql:
- Añadido inspections.equipment_identification_number
Cambios en rfi_assignees.sql:
- Añadido rfi_assignees.forwarded_by
Cambios en submittal_approvers.sql:
- Se ha añadido submittal_approvers.is_last_step
Cambios en equipment_timecard_entry.sql:
- Se agregó equipment_timecard_entry.equipment_identification_number
- Se ha añadido equipment_timecard_entry.nombre_equipo

Actualizaciones de datos de Procore Analytics 2.0 (21/01/2025)

Procore ha agregado los siguientes modelos (tablas):

inspection_item_references
schedule_task_changes
equipo
equipment_project_log
equipment_timecard_entry
payments_project_controls
payments_invites
payments_agreements
pay_requirement_settings

Procore ha actualizado los siguientes modelos (tablas):

company_vendor_insurances:
- Se agregó company_vendor_insurances.template_name
project_role_memberships:
- Se agregó project_role_memberships.user_id
budget_change_workflow_steps:
- Se agregó budget_change_workflow_steps.current_step_due_date
budget_codes:
- Eliminado SELECT budget_codes.código_presupuesto
- Se agregó SELECT budget_codes.attribute_1_line_item
- Se agregó budget_codes.attribute_1_name
- Se agregó budget_codes.attribute_2_line_item
- Se agregó budget_codes.attribute_2_name
- Se agregó budget_codes.attribute_3_line_item
- Se agregó budget_codes.attribute_3_name
- Se ha añadido budget_codes.budget_code
budget_columns:
- Añadido budget_columns.created_at
- Añadido budget_columns.updated_at
change_event_line_item_with_markups:
- Eliminado SELECT change_event_line_item_with_markups.budget_days_in_stage
- Se agregó SELECT change_event_line_item_with_markups.biller_id
- Se agregó change_event_line_item_with_markups.biller_model_name
- Se agregó change_event_line_item_with_markups.biller_name
- Se agregó change_event_line_item_with_markups.budget_days_in_stage
- Se agregó change_event_line_item_with_markups.change_event_events_id
- Se agregó change_event_line_item_with_markups.change_event_status
- Se agregó change_event_line_item_with_markups.change_event_title
- Añadido change_event_line_item_with_markups.contract_id
- Se agregó change_event_line_item_with_markups.número_contrato
- Se ha añadido change_event_line_item_with_markups.contract_title
- Se agregó change_event_line_item_with_markups.estimated_budget_amount
- Se agregó change_event_line_item_with_markups.estimated_budget_transfer_amount
- Se agregó change_event_line_item_with_markups.estimated_cost_amount
- Se agregó change_event_line_item_with_markups.estimated_cost_amount_company_currency
- Se agregó change_event_line_item_with_markups.estimated_cost_amount_project_currency
- Se agregó change_event_line_item_with_markups.event_scope
- Se agregó change_event_line_item_with_markups.proposed_contract_id
- Se agregó change_event_line_item_with_markups.proposed_vendor_id
- Añadido change_event_line_item_with_markups.source
- Se agregó change_event_line_item_with_markups.nombre_proveedor
- Se agregó change_event_line_item_with_markups.wbs_code_id
commitment_change_order_line_items:
- Se agregó commitment_change_order_line_items.commitment_change_order_request_id
- Se agregó commitment_change_order_line_items.commitment_potential_change_order_id
commitment_change_order_workflow_steps:
- Se agregó commitment_change_order_workflow_steps.current_step_due_date
commitment_custom_field_configs:
- Añadido commitment_custom_field_configs.name
commitment_pco_workflow_steps:
- Se agregó commitment_pco_workflow_steps.current_step_due_date
commitment_workflow_step_occurrences:
- Se agregó commitment_workflow_step_occurrences.current_step_due_date
contract_compliance_documents:
- Se agregó contract_compliance_documents.template_name
owner_invoice_workflow_steps:
- Se agregó owner_invoice_workflow_steps.current_step_due_date
owner_invoices:
- Se agregó owner_invoices.erp_latest_status
- Añadido owner_invoices.erp_updated_at
- Se agregó owner_invoices.erp_user_name
- Añadido owner_invoices.synced_with_accounting
payments_beneficiaries:
- Se agregó payments_beneficiaries.early_pay_classification
prime_contract_change_order_line_items:
- Añadido prime_contract_change_order_line_items.name
- Se agregó prime_contract_change_order_line_items.prime_contract_change_order_request_id
- Se agregó prime_contract_change_order_line_items.prime_contract_potential_change_order_id
prime_contract_change_order_workflow_steps:
- Se agregó prime_contract_change_order_workflow_steps.current_step_due_date
prime_contract_pco_workflow_steps:
- Se agregó prime_contract_pco_workflow_steps.current_step_due_date
prime_contract_workflow_steps:
- Se agregó prime_contract_workflow_steps.current_step_due_date
subcontractor_invoice_line_items:
- Se agregó subcontractor_invoice_line_items.total_retainage
subcontractor_invoice_workflow_steps:
- Se agregó subcontractor_invoice_workflow_steps.current_step_due_date
action_plan_custom_fields:
- Se agregó action_plan_custom_fields.type_id
action_plan_line_item_record:
- Se agregó action_plan_line_item_record.action_plan_line_item_record_resource_url
correspondence_custom_fields:
- Se agregó correspondence_custom_fields.type_id
correspondence_response_attachments:
- Se agregó correspondence_response_attachments.type_id
correspondence_schedule_tasks:
- Se agregó correspondence_schedule_tasks.type_id
correspondence_workflow_responses:
- Se agregó correspondence_workflow_responses.type_id
correspondence_workflow_steps:
- Se agregó correspondence_workflow_steps.type_id
daily_log_accident:
- Se agregó daily_log_accident.daily_log_completion_id
daily_log_construction_reports:
- Se agregó daily_log_construction_reports.daily_log_completion_id
daily_log_delay:
- Se agregó daily_log_delay.daily_log_completion_id
daily_log_delivery:
- Se agregó daily_log_delivery.daily_log_completion_id
daily_log_dumpster:
- Se agregó daily_log_dumpster.daily_log_completion_id
daily_log_equipment:
- Se agregó daily_log_equipment.daily_log_completion_id
daily_log_inspection:
- Se agregó daily_log_inspection.daily_log_completion_id
daily_log_manpower:
- Se agregó daily_log_manpower.daily_log_completion_id
daily_log_note:
- Se agregó daily_log_note.daily_log_completion_id
daily_log_observed_weather_condition:
- Se agregó daily_log_observed_weather_condition.daily_log_completion_id
daily_log_phone_call:
- Se agregó daily_log_phone_call.daily_log_completion_id
daily_log_plan_revision:
- Se agregó daily_log_plan_revision.daily_log_completion_id
daily_log_productivity:
- Se agregó daily_log_productivity.daily_log_completion_id
daily_log_quantity:
- Se agregó daily_log_quantity.daily_log_completion_id
daily_log_safety_violation:
- Se agregó daily_log_safety_violation.daily_log_completion_id
daily_log_scheduled_work:
- Se agregó daily_log_scheduled_work.daily_log_completion_id
daily_log_scheduled_work_task:
- Se agregó daily_log_scheduled_work_task.daily_log_completion_id
- Se agregó daily_log_scheduled_work_task.schedule_task_id
daily_log_visitor:
- Se agregó daily_log_visitor.daily_log_completion_id
daily_log_waste:
- Se agregó daily_log_waste.daily_log_completion_id
inspection_custom_fields:
Se agregó inspection_custom_fields.type_id
inspection_item_signature_requests:
- Se agregó inspection_item_signature_requests.inspection_schedule_id
inspection_items:
- Se ha añadido inspection_items.position_number
inspection_schedules:
- Añadido inspection_schedules.ends_at
- Añadido inspection_schedules.starts_at
Inspecciones:
- Añadido inspections.equipment_id
- Añadido inspections.equipment_name
observation_custom_field_configs:
- Se agregó observation_custom_field_configs.observation_type_id
- Se agregó observation_custom_field_configs.type_id
observation_custom_fields:
- Se agregó observation_custom_fields.type_id
punch_item_bic:
- Se agregó punch_item_bic.punch_item_bic_id
rfis_bic:
- Se agregó rfis_bic.rfi_bic_id
schedule_lookahead_task:
- Se agregó schedule_lookahead_task.task_id_comp
schedule_task:
- Se agregó schedule_task.task_id
submittal_ball_in_courts:
- Se agregó submittal_ball_in_courts.nombre_de_la_compañía
- Añadido submittal_ball_in_courts.role
Submittals:
- Añadido submittals.ball_in_court_role
- Se agregaron submittals.paused
actual_production_quantities:
- Se agregó actual_production_quantities.wbs_code_id
budget_change_production_quantities:
- Eliminado SELECT budget_change_production_quantities.budget_change_production_quantity_id
- Se agregó SELECT budget_change_production_quantities.budget_change_id
- Se agregó budget_change_production_quantities.budget_change_production_quantity_id
- Se agregó budget_change_production_quantities.wbs_code_id
prime_potential_change_order_production_quantities:
- Se agregó prime_potential_change_order_production_quantities.prime_contract_change_order_id
- Se agregó prime_potential_change_order_production_quantities.wbs_code_id
proyecto:
- Se ha añadido project.code
owner_invoices:
- Se ha añadido owner_invoices. Tax_Applicable_To_This_Payment
timecard_entries:
- Se agregó timecard_entries.user_id

Actualizaciones de datos de Procore Analytics 2.0 (17/12/2024)

Procore ha agregado (current_step_due_date) a los siguientes modelos (tablas):

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 ha agregado los siguientes campos:

actual_production_quantities.wbs_código_id
timecard_entries.id_de_usuario