Pipe Specification

This section provides a brief overview of the Pipe Specification table.

The Pipe Specification table allows you to create filters between parts and a pipe specification; it lists pipe attributes for one specification. When searching for parts in the database, the system uses this table as an additional layer of filtration.

In Data Setup, assign this definition table to:

• The Pipe Specification item in the resource table of Piping/Tubing Discipline Resources.
• The value of Pipe Specification in the Criteria column is set to the name of the specification (for example Pipe Specification = CS150R).

When users search catalogs and chapters for parts, there are three kinds of filters:

• The Standard value is blank: all values appear.
• The Standard value is set to a precise value: only parts that have this value appear.
• The Standard value is set to Unset: only parts that have a Standard keyword value equal to NULL appear.

This section describes the customization options of the Pipe Specification table.

Here is a typical Pipe Specification table:

V_SubPartType(string)	V_NominalSize(string)	V_Standard(string)	V_EndStyle(string)	V_Rating(string)
Tee	1/2in	ASTL	BUTT WELD
Tee	48in	ASTL	BUTT WELD
Olet	2in	ASTL	WELD SET ON
Olet	10in	ASTL	WELD SET ON
Olet	24in	ASTL	WELD SET ON
Elbow	1/2in	ASTL	BUTT WELD
Elbow	34in	ASTL	BUTT WELD
Elbow	48in	ASTL	BUTT WELD
Cap	1/2in	ASTL	BUTT WELD
Cap	48in	ASTL	BUTT WELD
Eccentric Reducer	3/4in	ASTL	BUTT WELD
Concentric Reducer	48in	ASTL	BUTT WELD
Sleeve	1/8in	ASTL
Sleeve	22in	ASTL
Sleeve	48in	ASTL
Blind Flange	1/8in	ASTL	RAISED FACE	300#
Blind Flange	4in	ASTL	RAISED FACE	300#
Blind Flange	5in	ASTL	RAISED FACE	300#
Blind Flange	6in	ASTL	RAISED FACE	300#

To customize the table, enter a line in the spreadsheet for standard and nominal size for every subpart type that you use.

If you want to define additional restrictions (criteria for parts queries), you can add as many columns you want to the file. Each column is based on piping part attributes.

Parameter	Type	Importance	Description
V_SubPartType	String	Required	Used for filtering and listing part types
V_NominalSize	String	Required	Used for filtering
V_Standard	String	Required	Used for filtering
V_EndStyle	String	Optional	-
V_Rating	String	Optional	-

This section explains where to find the sample resource file.

The default location of XXX_XXX.xls is

..\startup\EquipmentAndSystems\Piping\Specification\

and then the relevant specification, such as SS150R.

Used in this app	When	Seen as
Piping & Tubing Design	Placing parts within specifications	Unseen - filters the catalog
Functional & Logical Design	Creating a Line ID	Pipe Specification list in Create Line ID dialog box.