Section 5 — Piping

IPE Piping Database Format

IPE Engineering Practice IPE-EP-5-2-5

Document number: IPE-EP-5-2-5 · Section: 5 — Piping

SCOPE

• This Practice provides documentation of the schema used for the Piping Database and the COMPCODE matrix intelligence. This database is used to generate the piping classes and the valve data sheets accessible via the external web application and the COMPCODE is used to facilitate identification, tracking, requisitioning and generation of a piping bill of materials. EP 5-2-3 covers the material and component requirements used in the IPE Piping Standards for process and utility piping, instrumentation piping, instrument supports and heat tracing. EP 5-3-2 discusses the data sheets for all the valves that are specified in the IPE Piping Standards.
• Any deviation from this Practice must be approved by the procedure in EP 1-1-3.
• An asterisk (*) indicates that a decision by the Owner’s Engineer or Owner is required, or that additional information is furnished by the Purchaser.
• A revision bar indicates all changes made to this Revision.

2.0 REFERENCES

The latest edition of the following standards and publications are referred to herein

DEFINITIONS

• Contractor - Company or business that agrees to furnish materials or perform specified services at a specified price and/or rate to the Owner.
• Manufacturer - The recipient of a direct or indirect purchase order for materials and/or equipment. In this context, a direct order is one issued to a manufacturer by a contractor or the Owner. An indirect order is one issued to a manufacturer by a vendor (recipient of a direct order) for materials, fabricated components, or subassemblies.
• Owner - IPE Service, LLC.
• Owner’s Engineer - A IPE Service, LLC appointed engineer.

IPE PIPING DATABASE SCHEMA

• (*)The piping database is composed of 30 tables. Five of the 30 tables are considered primary tables and are called directly from the web application. The remaining 26 tables are considered admin tables (3) and secondary component tables (23) that are required to support the 5 primary tables. Renaming of the tables or the table fields are not allowed. The addition of information to the row of the database tables is allowed with Owner’s Engineer approval.
• The 5 primary tables are listed in Table 1. These tables are called directly from the web application. All of the tables have information unique to each piping class.

• (*)The 3 admin tables are listed in Table 2. These 3 tables are linked to the primary tables via the TABLE, FIELD, and TABLE_NAME column names. These 3 tables supply the order in which the valve description and valve data sheet information is presented and also the component section names used in the piping standard. This allows future revisions to the valve description, valve data sheet information, and component section names to be easily modified via these 3 admin tables versus editing the VB script in the web application. Any modifications to these tables require Owner’s Engineer approval.
• The 23 secondary component tables are listed in Table 3 of this practice. These 23 tables are linked to the primary tables via the COMPCODE or CNOTE fields. These tables have complete descriptions of the component or the component note for the unique COMPCODE or CNOTE identification.
• Tables 4 through 34 list the column names and a description of the column data for all 31 of the piping database tables.
• The COMPONENT_MASTER primary table lists identification codes (COMPCODE) for each required component per each pipe class. Along with each COMPCODE input, the appropriate component table, the respective size range for the component, and any associated notes (CNOTE) for the component are also listed. The web application builds the component description in the pipe class by linking the COMPCODE id from the COMPONENT_MASTER table to the COMPCODE id in the referenced component table and pulling the text from the DESCRIPTION column from the referenced component table.
• The VALVE_MASTER primary table lists identification codes (COMPCODE) for each required valve per each pipe class. Along with each COMPCODE input, the appropriate valve table, the respective size range for the valve, and any associated notes (CNOTE) for the valve are also listed. The web application builds the valve description in the pipe class by linking the COMPCODE id from the VALVE_MASTER table to the COMPCODE id in the referenced valve table and pulling the text from a number of columns in the referenced valve table. The VLV_DESCR_ORDER table gives the logic for the ordering of the valve description respective to the appropriate valve table. Thus, future modifications to the valve descriptions in the pipe class can be easily implemented by changing the VLV_DESCR_ORDER table and not the VB script in the web application.
• Valve Data Sheets are also built online via the web application. All the information for the Valve Data Sheets are in the 12 valve tables, shown in Table 3 of this EP. The required line entry text for each Valve Data Sheet and the pointer to the appropriate valve table and column are detailed in the VLV_DS_LOGIC table. This table defines the logic for the creation of the Valve Data Sheets to the web application. Thus, future modifications to the Valve Data Sheets can be easily implemented by changing the VLV_VDS_LOGIC table and not the VB script in the web application.

COMPCODE MATRIX

• A unique COMPCODE is used in both the piping class and the valve data sheets to identify piping components (valves, pipe, fittings, flanges, etc.). The COMPCODE is a unique 10 character identification. The COMPCODE is used to facilitate identification, tracking, requisitioning and generation of a piping bill of materials.

• The COMPCODE is an intelligent number, which uniquely describes a piping component. The first character of the COMPCODE defines the category, the second and third describes the material, the fourth describes the type, the fifth describes the end, the sixth describes the rating, the seventh and eighth describe the schedule 1, and the ninth and tenth describe the schedule

2. Only for the valve category, the fourth and fifth define the type, the sixth defines the end, the seventh defines the rating, the eighth defines the schedule 1, the ninth defines the trim, and the tenth defines the operator. The alphanumerical code designators used for the COMPCODE identification are shown in the COMPCODE Matrix Report, see Figure 1.

• (*)This COMPCODE MATRIX can be used by contractors to cross reference their component takeoffs with those listed in the individual piping classes. The existing COMPCODE MATRIX shall not be altered without Owner’s Engineer approval. Additions to the COMPCODE MATRIX are also not allowed without Owner’s Engineer approval.

TABLES

TABLE 1

IPE PIPE DATABASE PRIMARY TABLES

TABLE 2

IPE PIPING DATABASE ADMIN TABLES

TABLE 4 SERVICE

(PRIMARY TABLE)

TABLE 5 DESIGN_NOTES (PRIMARY TABLE)

TABLE 6 VALVE_MASTER (PRIMARY TABLE)

TABLE 7 COMPONENT_MASTER (PRIMARY TABLE)

TABLE 8 BRANCH

(PRIMARY TABLE)

TABLE 9 COMPONENT_NOTES (PRIMARY TABLE)

TABLE 10 VLV_DESCR_ORDER (ADMIN TABLE)

TABLE 11 VLV_DS_LOGIC (ADMIN TABLE)

TABLE 12 SECTION_NAME (ADMIN TABLE)

TABLE 13 BALL_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 14 BELLOWS_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 15 BUTR_HYD_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 17 CHECK_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 18 COMPACT_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 19 GATE_DI_CI_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 20 GATE_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 21 GLOBE_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 22 NEEDLE_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 23 PLUG_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 24 SPECIALTY_VALVE

(SECONDARY COMPONENT TABLE)

TABLE 25 PIPE

(SECONDARY COMPONENT TABLE)

TABLE 26 NIPPLES

(SECONDARY COMPONENT TABLE)

TABLE 27 FITTINGS

(SECONDARY COMPONENT TABLE)

TABLE 28 FLANGES

(SECONDARY COMPONENT TABLE)

TABLE 29 ORFICE_FLANGES

(SECONDARY COMPONENT TABLE)

TABLE 30 GASKETS

(SECONDARY COMPONENT TABLE)

TABLE 31 BOLTING

(SECONDARY COMPONENT TABLE)

TABLE 32 BLINDS

(SECONDARY COMPONENT TABLE)

TABLE 33 SPECIALTY_PIPE

(SECONDARY COMPONENT TABLE)

TABLE 34 SPECIALTY_COMPONENTS (SECONDARY COMPONENT TABLE)

FIGURE 1 COMPCODE MATRIX

Excel Compcode Matrix Report Tables:

• Category 0 – PIPE
• Category 1 – FLANGE
• Category 2 – FITTING (Typ. Wrought Matl.)
• Category 3 – FITTING (Typ. Forged Matl.)
• Category 4 – PIPE NIPPLE
• Category 5 – SPECIAL
• Category 6 – TUBING
• Category 7 – GASKET
• Category 8 – BOLTING
• Category 9 – LABOR/MATERIAL
• Category J – JACKETED
• Category V – VALVE

© 2026 Inflection Point Engineering, LLC. All rights reserved.