Geometric – Attribute Relations - Intergraph Smart Reference Data Standard Database - Version 12.3 - Help - Hexagon PPM

Standard Database for Intergraph Smart Reference Data Help

Language
English (United States)
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Help
Standard Database for Smart Reference Data Version
12.3

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.