Piping Commodity Specification Data (202)

The Piping Commodity Specification Data defines all the components, pipes, bolts, and gaskets associated with a particular Piping Materials Class. It defines the standard components found in a manufacturers catalog (commonly referred to as off-the-shelf components). Because the Piping Commodity Specification Data is linked to the Piping Materials Class, a separate set of commodity items must be defined for each Piping Materials Class.

Information for connect point data is defined in terms of two types of connect points known as green and red connect points. Refer to Connect Point Data, page 270, for more information on green and red connect points.

The Piping Commodity Specification Data table contains 28 attributes:

1. system_unique_no , integer

2. piping_mater_class , character(16) , index 1

This attribute identifies the Piping Materials Class for the piping commodity.

3. commodity_name , character(6)

This attribute identifies the commodity item name. This can be

a PDS commodity item name. Refer to the PDS Piping Component Data Reference Guide for more information on item names.

a Piping Job Specification access name. If you do not use the AABBCC code, you must define a Commodity Synonym Library for proper communication with the P&ID Task. The PDS commodity item names are also used with the

delivered Place Component forms. If you use a different code, you should create a forms customization file as defined in the Piping Designer.

4. option_code , short , SN 400

This code-listed attribute identifies the option code which determines the search criteria. This parameter enables you to request that the system retrieve the primary commodity item, a secondary commodity item, or another special option from the Piping Job Specification.

This parameter is used as a commodity override in Piping Design. You can select the unique options (as defined in CL400) from a form. If no option is specified at placement, this attribute defaults to option 1 (primary commodity item). Option 2 is reserved as the secondary commodity item.

Option codes 4001 to 4010 are used to specify manual input of bend data for pipe bends.

Reference Data Manager Reference Guide — April 2002

________________

Option codes 4500 to 4999 are reserved for company practice (user-defined). Option codes 5000 to 5999 are used to refer to implied components.

5. maximum_temp , double

This attribute is used if the commodity item is temperature dependent. It represents the maximum temperature for which this commodity item is acceptable. When a

commodity item is retrieved from the Piping Job Specification, the system verifies that the normal operating temperature, the alternate operating temperature, the normal design temperature, and the alternate design temperature are less than this maximum allowable temperature. If this maximum is exceeded by any of these temperatures, the system automatically searches for another occurrence of the same commodity item.

For gaskets, to help determine the gap thickness at bolted joints, the maximum temperature value is used as an input to the Gasket Gap Table. Proper entry of temperature values in the PJS assists the definition of gap thicknesses when gaskets with different gap thicknesses are used in the same piping materials class. If you specify the default value (-9999), no test is performed. Any reports created from the Piping Job Specification depict this default value as alphanumeric blanks.

The order in which entries of the same piping commodities with different maximum temperature values are made in the PJS (PDtable_202) is not considered by the system; however, these entries must have the same option code in order to be considered by the commodity selection in the Place Component command. When you do define the piping commodity, a maximum temperature value must be defined for each entry or an error message is displayed. To define the highest maximum temperature for the same piping commodity, set the maximum temperature equal to or greater than the maximum temperature of the spec limits table for the applicable piping materials class instead of using an undefined value (’-’).

6. gcp_from_nom_diam , short (NPD Units)

7. gcp_to_nom_diam , short (NPD Units)

These coded attributes identify the range of nominal piping diameters (lower bound to higher bound) for the green connect point (first size) in NPD units. The to value must equal or exceed the from value. These values are not necessarily the same as the range in Tables 211 and 212. The applicable NPD value specified at placement is used to search for the suitable component in the Piping Job Specification.

5. Piping Job

Specification

Piping Commodity Specification Data (202)

________________

This code-listed attribute identifies the end preparation for the green connect point. The system determines the termination type based on the range of values

2 - 199 bolted terminations 300 - 399 male terminations 400 - 599 female terminations

You can define end compatibilities by using the End Preparation Compatibility Table. (Refer to the Project Data Manager in the Project Administrator Reference Guide.)

9. gcp_rating , character(8)

This attribute identifies the pressure rating for the green connect point. This parameter exists as alphanumeric data. The system interprets the first set of sequential numeric characters as being the pressure rating value.

Ratings can be expressed in any of the following formats: CLxxxx, xxxx#, or OTxxxx. However, table entries and file names representing the rating exclude the CL, #, or OT characters. This enables the same table to be used regardless of how the rating is defined. In the delivered PJS, these rating formats are used in accordance with the following criteria:

CLxxxx refers to an ANSI or API pressure rating

xxxx# refers to a pressure rating defined by an organization other than ANSI or API.

OTxxxx refers to the rating of a connect point that meets the applicable ANSI or API rating geometrically but not from a pressure carrying standpoint. An example is a valve supplied with flanged ends that meets the bolting pattern of ANSI CL150 pressure rating but has pressure carrying characteristics different from those of that ANSI rating.

For bolts and gaskets, you must use a numeric pressure rating (do not use the characters CL, #, or OT). If any character entries are

encountered, the system will be unable to locate the proper information.

Female ends for plastic pipe are usually defined in terms of schedule/thickness and not in terms of rating. To make female ends for plastic pipe follow the rules for other female ends, the applicable schedule/thickness is used as the value for rating. If such rating values consist of alphanumeric characters, the system strips all alpha characters from the rating value and uses only the numeric values in accessing the applicable tables.

If the rating in the PJS is expressed in terms of alphabetic characters only, the system uses the characters in accessing the data tables. The names of the data tables include all the alphabetic characters included in the PJS.

Reference Data Manager Reference Guide — April 2002

________________

OTHER can be used to identify a non standard rating value.

NONE can be used to identify the rating for components whose ends would normally require the attribute rating as part of the table name, but for which a rating does not apply. This value can be used in the PJS and in the data tables.

10. gcp_sch_thk , character(8)

This attribute identifies the schedule thickness value for the green connect point. This parameter exist as alphanumeric data. (Refer to Wall Thickness and Branch

Reinforcement Equations, page 203, for more information on this attribute.) In order of preference, schedule and thickness are expressed in terms of:

A generic schedule such as S-STD, S-XS and S-XXS. If a schedule name exceeds the provided field length (for example S-SDR13.5) it is defined in terms of its wall thickness.

A specific schedule such as S-40, S-40S and S-80.

NREQD is used in cases where all of the following conditions apply: — The thickness value is not required in purchasing the component. — Empty weights are not significantly affected by actual thickness values. — Either stress analysis is not applicable or, if applicable, the component is to be

considered infinitely rigid in stress analysis calculations.

A value with all numeric characters is interpreted as a wall thickness value in the same physical units as nominal piping diameter. To insure compatibility between the PJS, data tables, and wall thickness calculations, thickness is expressed in the form:

.xxxx if the thickness is less than 1 inch x if the thickness is an even inch x.xxx if the thickness is 1 inch or larger

Trailing zeroes are not included. Decimal points are not included for numbers without decimals.

An asterisk (*) followed by a name (of the form Cyyy) defines the specific calculation or table lookup to be used for wall thickness. Refer to Wall Thickness and Branch Reinforcement Equations, page 203 for a more detailed description of

5. Piping Job

Specification

Piping Commodity Specification Data (202)

________________

This code-listed attribute is used to further reference the source of the generic

dimensional data, such as flange data or piping outside diameter data. This attribute is also referred to as the table suffix.

For AMS standards, it represents the table suffix for the green connect point. For DIN standards, it represents the piping outside diameter selection flag (reihe number) for pipes and fittings.

12. rcp_from_nom_diam , short

13. rcp_to_nom_diam , short

These coded attributes identify the range of nominal piping diameters (lower bound to higher bound) for the red connect point (second size). The to value must equal or exceed the from value. These values are not necessarily the same as the range in Tables 211 and 212.

For a full size component, you should set these parameters to - (hyphen). In cases such as a concentric reducer or weldolet, this value must be less than the corresponding green value. 14. rcp_end_prep , short , SN 330 See gcp_end_prep. 15. rcp_rating , character(8) See gcp_rating. 16. rcp_sch_thk , character(8) See gcp_sch_thk. 17. rcp_table_suffix , short , SN 577

This attribute is used to further reference the dimensional data for a specific component. For AMS standards, it represents the table suffix for the red connect point. For DIN standards, it represents the built-in length selection flag (or reihe number) for valves and wall thickness selection flag for pipes and fittings. A parametric definition is used when connection graphics are required in the model and orthographic drawings.

18. commodity_code , character(16)

The commodity code is a user-assigned code that together with the NPD and schedule/thickness uniquely defines the component. It defines the customer’s

Reference Data Manager Reference Guide — April 2002

________________

Commodity codes with neither an * or a + prefix, indicate a commodity item that has no associated implied components.

Commodity codes prefixed by an *, indicate a commodity item (primary component) which has one associated implied component (such as a lap joint flange and stub end). For more information on defining * implied items, refer to the PD_Report User’s Guide.

It is not recommended that specification implied (*) items be generated by size change components (i.e. reducers, reducing flanges, etc.) as the NPD assigned by the system for the implied component can be either the larger or smaller (green or red) NPD of the implying item based on how the system traces the line.

Commodity codes prefixed by a +, indicate a commodity item (primary

component) which has one or more associated implied components as defined in Table 212.

The default length for a commodity code is 16 characters, but you can modify this length if needed. This value is specified in two files: design.ddl and reference.ddl. To customize the character length, modify the design.ddl file as follows:

In table 34 (Piping Component Data), modify the value in column 8. In table 50 (Piping/Tubing Data), modify the value in column 12. Modify the reference.ddl file as follows:

In table 202 (Piping Commodity Specification Data), modify the value in column 18.

In table 211 (Piping Commodity Size-Dependent Material Data), modify the values in column 2 and column 7.

In table 212 (Piping Commodity Implies Material Data), modify the values in column 2 and column 7.

When you modify these values, set the character limit to be one more than the number of characters you actually want in the commodity code. This is necessary for you to add a * or + prefix if needed. For example, to create a 20-character commodity code, set the specified values to 21. You must make these modifications before the project is created.

5. Piping Job

Specification

Piping Commodity Specification Data (202)

________________

19. model_code , character(6)

This attribute identifies the specific item name for generic bends, spec flanges, or spec valves. Each model code is classified by

- Item name - option - size ranges - end preparations - ratings

The model code includes the definition of the graphic representation of the component in the piping model. Depending upon the circumstances:

One or more model codes can be assigned to to a single Item Name (for example, GAT, GATR, and GATF are all used for 6Q1C01).

The same model code can be assigned to different Item Names.

For gaskets, this attribute can be used to prioritize gasket entries in the Piping Materials Class. The priority is set with a numeric value (integer or decimal) greater than zero. Non-numeric values are ignored by MTO and not considered to be a priority selection. The smaller the value the higher the priority. A value of 999999 is interpreted as an undefined priority.

20. PDS_sort_code , character(6)

This field can be used to specify the length (in subunits) for Purchased length pipe, or to specify the gasket diameter for gaskets. The gasket diameter table is used if the pds_sort_code for the gasket spec entry is set to _GKT. The system uses the NPD to determine the gasket inside and outside diameters.

If the pds_sort_code for the gasket spec entry is set to "_GKT", the gasket outside and inside diameters are generated using the table

gasket_commodity_code_GKT.TBL.

If the pds_sort_code for the gasket spec entry is not "_GKT", the gasket outside diameter is equivalent to the NPD of the rated component and the gasket inside diameter is undefined.

21. modifier , double

This attribute is used for pipe bends, elbows, miters, and valves. It has various uses depending on the type of commodity item as defined below.

For pipe bends, it defines the bend radius of the pipe in terms of the numeric factor by which the nominal diameter of the pipe is to be multiplied to obtain the bend radius.

Reference Data Manager Reference Guide — April 2002

________________

For orifice flanges and drip ring tees, it defines the number of taps to be provided. A value of 1 defines a single tap. A value of 2 defines 2 taps, 180 degrees apart. A value of negative 2 (-2) defines 2 taps, 90 degrees apart.

For nippolets and nipples, it defines the length of the component.

For reinforcing pads and welds, it defines whether data about the component is to be derived from tables in the system (0) or from the user by prompting (1). For gaskets, it defines the gasket thickness to be used in procuring the gasket. This is the actual gasket thickness for MTO reports - not the compressed gasket thickness (gasket separation), which is derived from the Piping Materials Class data.

For bolts, it defines whether the bolt is a stud bolt (0 or positive), or machine bolt (negative). The absolute value of this modifier, which ranges from 0 to 5, determines the applicable bolt extension.

For valves, it represents the code list number from CL550 (operator/actuator type) which defines the symbol description and the source of the physical data for the valve operator. If this value is a negative number (such as -3) the operator is not displayed when placing the component.

22. geometric_standard , short , SN 575

This code-listed attribute identifies the source of the data (which is usually an industry standard, such as ANSI, ISO, or DIN, or a company standard) from which the specific geometry of the commodity item can be deduced. This parameter represents the vendor or industry standard, and the material if either affects the dimensions of the commodity item.

Code list numbers 2-6999 are reserved for geometry standards that apply to US piping practices. Numbers 7000-27999 are reserved for geometry standards that apply to European piping practices. Numbers 28000-31999 are reserved for specific company practices.

23. weight_code , short , SN 578

This code-listed attribute defines the weight code for the component. It determines the table to be used in finding the dry weight of the component. It is required for those cases where material causes the dry weight data but not the dimensional data to differ for a specific geometric industry standard.

5. Piping Job

Specification

Piping Commodity Specification Data (202)

________________

This code-listed attribute identifies the material code, specification, grade-temper, and joint efficiency for the component. This data is used in wall thickness calculations. It can also be used to access physical data in the Physical Data Library.

26. standard_note_no_a , short , SN 499

27. standard_note_no_b , short , SN 499

These code-listed attributes provide index numbers to standard notes in standard note type 499 that apply to this commodity item. The input to the Standard Note File is the note number. The output is the free- format text which forms the standard note.

In the delivered data, note numbers 200 through 599 are allocated for piping commodity items.

28. input_form_type , short , SN 990

This code-listed attribute defines the type of input form to be used to define data with the Spec Writer command.

Neutral File Format

The following is a partial listing of the sample neutral file for the Piping Commodity Specification Data. Entries in this table should be sorted alphanumerically by commodity_name.

The Sequence= keyword in a piping commodity data neutral file does not require the *2 for the piping materials class name. Any previously created piping commodity data neutral files will not require any revision as a result of this change.

Reference Data Manager Reference Guide — April 2002

________________

Sample Files

A set of neutral file for US practice are delivered in the files

\win32app\ingr\rdusrdb\spec_data\*.pcd (one for each piping materials class specified in the classes.pmc file).

A set of sample files depicting various options are delivered in the \win32app\ingr\pddata\sample\data directory. bend_tbl.pcd equiv_npd.pcd fluid_code.pcd fpipe.pcd gasket.pcd gskt_tbl.pcd metric_npd.pcd pharm.pcd pharmf.pcd pharmk.pcd piplen_tbl.pcd thickness.pcd

5. Piping Job

Specification

Piping Specialty Specification Data (203)

________________

In document PDS Data Manager (Page 68-78)