Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Engineering

Create P&ID Database Views and User Defined Attributes

Create P&ID Database Views and User Defined Attributes

  • Last UpdatedSep 29, 2025
  • 1 minute read

The procedure describes how to create the required database views and user defined attributes for Piping and Instrumentation Diagrams (P&ID) using the schema utility. The schema utility creates or updates all the database views with required expression filters to display catalog data in the catalog library and the respective attribute browser windows. The following attribute browser windows are updated:

  • Fluid Specification window

  • Piping Specification window

  • Tracing Specification window

  • Insulation Specification window

  • Piping System window

To create the required database views and user defined attributes:

  1. Launch the Configuration module and select the MLP or ASP project.

  2. On the Rules tab, in the Tools group, select Command Window to display the Command Window.

  3. Run the !!SchemaUtility() command.

The following user defined attributes are created:

UDA name

UDA text

Element type

SPCODescrpitionUDA

DescriptionSPCO

SPCOMPONENT

Text, 250

SPCOClassNameUDA

ClassName

SPCOMPONENT

Text, 250

PartDescUDA

PartDesc

SPCOMPONENT

Text, 250

PartNumUDA

PartNum

SPCOMPONENT

Text, 250

NominalTemperatureUDA

NominalTemperature

SPECIFICATION

Real, 20

NominalPressureUDA

NominalPressure

SPECIFICATION

Real, 20

The following database views are created:

User-defined name

Element type

AVEVA_PID_PipingSpecification

SPECIFICATION

AVEVA_PID_PipingSpecificationComponent

SPCOMPONENT

AVEVA_PID_InsulationSpecification

SPECIFICATION

AVEVA_PID_TracingSpecification

SPECIFICATION

AVEVA_PID_FluidSpecification

FLUID

AVEVA_PID_SystemSpecification

SYSGRP

The application checks for duplicate database views. Duplicate database views are only updated if the element type has changed.

TitleResults for “How to create a CRG?”Also Available in