Piping Attributes
The list of attributes which are most often used for defining the dimensional attributes of piping components are shown below:
|
Attribute |
Short Description |
Units |
|---|---|---|
|
NPS1 |
NPS 1 |
IN |
|
NPS2 |
NPS 2 |
IN |
|
OD1 |
OD 1 |
IN |
|
OD2 |
OD 2 |
IN |
|
SCH1 |
SCH 1 |
- |
|
SCH2 |
SCH 2 |
- |
|
P_F_TO_F |
P_FACE_TO_FACE |
IN |
|
P_F_TO_C_1 |
P_FACE_TO_CENTER_1 |
IN |
|
P_F_TO_C_2 |
P_FACE_TO_CENTER_2 |
IN |
|
P_C_TO_C |
P_CENTER_TO_CENTER |
IN |
|
P_F_TO_END |
P_FACE_TO_END |
IN |
|
P_PART_OD |
P_PART_OD |
IN |
|
P_HUB_DIA |
P_HUB_DIA |
IN |
|
P_FLG_THK |
P_FLANGE_THICKNESS |
IN |
|
P_HUB_LGTH |
P_HUB_LENGTH |
IN |
|
P_BCD |
P_BOLT_CIRCULAR_DIA |
IN |
|
P_BOLT_NO |
P_BOLT_NO |
- |
|
P_BOLT_DIA |
P_BOLT_DIA |
IN |
|
P_BORE_DIA |
P_BORE_DIA |
IN |
|
WEIGHT |
WEIGHT |
kg/UOM |
|
WATER_WGT |
WATER_WEIGHT |
kg/UOM |
|
SURF_AREA |
SURFACE_AREA |
m2/UOM |
|
P_FLG_THD_L |
P_FLANGE_THD_LENGTH |
IN |
|
P_FLG_SO_D |
P_FLANGE_SOCKET_DEPTH |
IN |
|
P_PIPE_OD1 |
P_PIPE_OUTSIDE_DIA1 |
IN |
|
P_PIPE_OD2 |
P_PIPE_OUTSIDE_DIA2 |
IN |
|
P_SBORE_DIA |
P_SOCKET_BORE_DIA |
IN |
|
P_THD_LGTH |
P_MINIMUM_THD_LGTH |
IN |
|
P_E_TO_E |
P_END_TO_END |
IN |
|
P_E_TO_CRTCH |
P_END_TO_CRTCH |
IN |
|
P_LAY_LEN |
P_LAYING_LENGTH |
IN |
|
P_F_TO_CRTCH |
P_FACE_TO_CRTCH |
IN |
|
P_SWALL_THK |
P_SOCKET_WALL_THK |
IN |
|
P_DIA_WIDTH |
PLUG_DIAMETER OR WIDTH |
IN |
|
P_WALL_THK |
P_WALL_THK |
IN |
|
P_WEB_WDTH |
P_WEB_WDTH |
IN |
|
P_SOC_DEPTH |
P_SOCKET_DEPTH |
IN |
|
P_WEB_THK |
P_WEB_THK |
IN |
|
P_EWALL_THK |
P_END_WALL_THK |
IN |
|
P_BARREL_OD |
P_BARREL_OD |
IN |
|
P_F_TO_LC |
P_FACE_TO_LONG_CENTRE |
IN |
|
P_F_TO_SC |
P_FACE_TO_SHORT_CENTRE |
IN |
|
P_F_TO_TAP |
P_FACE_TO_TAP |
IN |
|
P_CYL_LEN |
P_CYLINDER_LENGTH |
IN |
|
P_H_TO_C |
P_HANDLE_TO_CENTRE |
IN |
|
P_TAN_LEN_1 |
P_TANGENT_LENGTH_1 |
IN |
|
P_TAN_LEN_2 |
P_TANGENT_LENGTH_2 |
IN |
|
P_F_TO_C_3 |
P_FACE_TO_CENTER_3 |
IN |
|
P_F_TO_HC |
P_FACE_TO_HEADER_CENTRE |
IN |
|
P_PART_THK |
P_PART_THICKNESS |
IN |
|
P_MAX_OD |
P_MAXIMUM_DIAMETER |
IN |
|
P_H_HOLE |
P_HOLE_IN_HEADER |
IN |
|
P_FLG_THD_L |
P_FLANGE_THD_LENGTH |
IN |
|
P_FLG_SO_D |
P_FLANGE_SOCKET_DEPTH |
IN |
|
DRYCOGX |
DRYCOGX |
- |
|
DRYCOGY |
DRYCOGY |
- |
|
DRYCOGZ |
DRYCOGZ |
- |
|
WATERCOGX |
WATERCOGX |
- |
|
WATERCOGY |
WATERCOGY |
- |
|
WATERCOGZ |
WATERCOGZ |
- |
|
DRYCOGX1 |
DRYCOGX1 |
- |
|
DRYCOGY1 |
DRYCOGY1 |
- |
|
DRYCOGZ1 |
DRYCOGZ1 |
- |
|
WATERCOGX1 |
WATERCOGX1 |
- |
|
WATERCOGY1 |
WATERCOGY1 |
- |
|
WATERCOGZ1 |
WATERCOGZ1 |
- |
The COG attributes with a suffix of 1 are reserved for customer use. Customers can
define their own COG data. An internal check for exporting COG data is provided; it
first looks for data added under COG attributes with a suffix of 1, and if that data
is not available, it will export SDB OOTB data.
Piping Components and Geometric Attribute Relations
BW Fittings
Below are a few parts that are defined with required dimensional attributes from commodity group B (Butt Weld Fittings).
|
Part Name |
Short Description |
Description |
|---|---|---|
|
CAP |
Cap |
Cap |
|
E4L |
45 Deg. LR Elbow |
45 Degree Elbow Long Radius (R=1.5D) |
|
E9L |
90 Deg. LR Elbow |
90 Degree Elbow Long Radius (R=1.5D) |
|
REC |
Con. Reducer |
Concentric Reducer |
|
REE |
Ecc. Reducer |
Eccentric Reducer |
|
TEE |
Equal Tee |
Equal Tee |
Required dimensional attributes for CAP are defined with table name P_END_1NPS_1SCH_IN as shown in the snapshot shown below:
BW cap with attributes is shown below:
Required dimensional attributes for 90 Deg. and 45 Deg. LR Elbows are defined with table name P_DIR_CHANGE_1NPS_1SCH_IN as shown below:
Elbow with attributes are shown below.
Required dimensional attributes for Concentric and Eccentric reducer are defined with table name P_SIZE_CHANGE_2NPS_2SCH_IN as shown below:
Reducers and swages with attributes are shown below:
Required dimensional attributes for Equal Tee are defined with table name P_90_BRANCH_1NPS_1SCH_IN are shown below:
TEE and Cross with attributes are shown below.
Flanges
Below are a few parts that are defined with required dimensional attributes from commodity group F (Flanges):
|
WN |
WN Flg. |
Weld neck Flange |
|
SG |
SO Flg. |
Slip-on flange |
|
SW |
SW Flg. |
Socket welded flange |
|
BL |
Blind Flg. |
Blind Flange |
Required dimensional attributes for Weld neck flange are defined with table name P_FLANGE_1NPS_1SCH_IN as shown below:
A weld neck flange with attributes is shown below:
Valves
All the valve geometric data in SDB are defined as two parts, one is valve body and other as operator.
Valve Body
All the Geometric physical attributes related to the valve body are associated to each commodity code.
The parts that use this geometric are from groups VG, VL, and VC.
Required dimensional attributes for valves are defined with table name P_VALVE_1NPS_1SCH_IN and P_VALVE_1NPS_IN as shown below:
Since the number of records for the P_VALVE_1NPS_IN table is more than 16, P_VALVE_1NPS_IN_EX table is created as shown below.