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:
-
Launch the Configuration module and select the MLP or ASP project.
-
On the Rules tab, in the Tools group, select Command Window to display the Command Window.
-
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.