Piping Design Database Table Format - PDS - Reference

Plant Design System (PDS) ISOGEN

PPMProductFamily
3D Design and Visualization
PPMProduct
PDS
PPMCategory
Reference
Version_S3D
12.x(2018)

# Piping Design Database

# Default Relational Database Definition

# Piping Segment Data

table number = 12 , number of columns = 73

1 , system_unique_no , integer , index 1

2 , line_number_label , character(40)

3 , line_id , character(16)

4 , unit_number , character(12)

5 , unit_code , character(3)

6 , module_no , character(16)

7 , package_system_no , character(12)

8 , train_number , character(2)

9 , fluid_code , short , standard note 125

10 , line_sequence_no , character(16)

11 , nominal_piping_dia , short

12 , piping_mater_class , character(16)

13 , gasket_separation , character(8)

14 , insulation_purpose , short , standard note 220

15 , insulation_thick , double

16 , insulation_density , double , standard note 1074 (units)

17 , heat_tracing_reqmt , short , standard note 200

18 , heat_tracing_media , short , standard note 210

19 , heat_tracing_temp , double

20 , construction_stat , short , standard note 130

21 , hold_status , short , standard note 50

22 , approval_status , short , standard note 35

23 , schedule_override , character(8)

24 , nor_oper_pres , double

25 , nor_oper_temp , double

26 , alt_oper_pres , double

27 , alt_oper_temp , double

28 , nor_dgn_pres , double

29 , nor_dgn_temp , double

30 , alt_dgn_pres , double

31 , alt_dgn_temp , double

32 , steam_outlet_temp , double

33 , mater_of_construct , character(6)

34 , safety_class , short , standard note 340

35 , design_standard , short , standard note 570

36 , design_area_number , character(12)

37 , design_resp , short , standard note 160

38 , construction_resp , short , standard note 160

39 , supply_resp , short , standard note 160

40 , coating_reqmts , short , standard note 190

41 , cleaning_reqmts , short , standard note 230

42 , fluid_category , character(4)

43 , nor_op_pres_units , short , standard note 1064

44 , nor_op_temp_units , short , standard note 1056

45 , alt_op_pres_units , short , standard note 1064

46 , alt_op_temp_units , short , standard note 1056

47 , nor_dgn_pres_units , short , standard note 1064

48 , nor_dgn_temp_units , short , standard note 1056

49 , alt_dgn_pres_units , short , standard note 1064

50 , alt_dgn_temp_units , short , standard note 1056

51 , steam_temp_units , short , standard note 1056

52 , stress_system_no , character(12)

53 , stress_reqmts , short , standard note 360

54 , hyd_system_no , character(12)

55 , hyd_reqmts , short , standard note 360

56 , specific_gravity_a , double

57 , specific_gravity_b , double

58 , specific_gravity_c , double

59 , viscosity , double

60 , density , double

61 , spec_heat_ratio , double

62 , sonic_velocity , double

63 , surface_roughness , double

64 , test_system_no , character(6)

65 , test_fluid , short , standard note 125

66 , test_pressure , double

67 , PID_id_part_a , character(4)

68 , PID_id_part_b , character(4)

69 , end_1_nozzle_id , integer

70 , end_2_nozzle_id , integer

71 , alpha_descript_id , character(12)

72 , standard_note_no , short , standard note 499

73 , pid_index_no , integer

# Piping Component Data

table number = 34 , number of columns = 113

1 , system_unique_no , integer , index 1

2 , piping_comp_no , character(20)

3 , commodity_name , character(6)

4 , model_code , character(6)

5 , option_code , short , standard note 400

6 , maximum_temp , double

7 , sched_thick_basis , character(8)

8 , commodity_code , character(16)

9 , MTO_requirements , short , standard note 365

10 , fabrication_cat , short , standard note 180

11 , source_of_data , short , standard note 420

12 , PDS_sort_code , character(6)

13 , physical_data_id , character(8)

14 , geometric_standard , short , standard note 575

15 , weight_code , short , standard note 578

16 , table_suffix_green , short , standard note 576

17 , table_suffix_red , short , standard note 577

18 , materials_grade , short , standard note 145

19 , bend_radius , double

20 , bend_angle , double

21 , face_to_face_dim , double

22 , dimension_a , double

23 , dimension_b , double

24 , dimension_c , double

25 , surface_area , double , standard note 1010 (units)

26 , empty_weight , double , standard note 1028 (units)

27 , water_weight , double , standard note 1028 (units)

28 , operator_weight , double

29 , operator_sym_name , character(6)

30 , chain_operator_no , short

31 , opening_action , short , standard note 390

32 , construction_stat , short , standard note 130

33 , hold_status , short , standard note 50

34 , heat_tracing_reqmt , short , standard note 200

35 , heat_tracing_media , short , standard note 210

36 , heat_tracing_temp , double

37 , iso_dwg_index_no , integer

38 , isometric_sheet_no , character(2)

39 , piece_mark_no , character(10)

40 , color_code , character(8)

41 , stress_node_no , short

42 , stress_intens_fact , double

43 , head_loss_factor , double

44 , piping_assembly , character(12)

45 , component_group_no , short

46 , remarks , character(16)

47 , standard_note_no_a , short , standard note 499

48 , standard_note_no_b , short , standard note 499

49 , cp_1_nom_pipe_diam , short

50 , cp_1_outside_diam , double

51 , cp_1_end_prep , short , standard note 330

52 , cp_1_sch_thk , character(8)

53 , cp_1_rating , character(8)

54 , cp_1_face_to_ctr , double

55 , cp_1_weld_no , character(8)

56 , cp_1_weld_type , short , standard note 1100 / 400 (bolt option)

57 , cp_1_gasket_gap , double

58 , cp_1_gasket_option , short , standard note 400

59 , cp_1_stress_node , short

60 , cp_1_stress_factor , double

61 , cp_1_head_loss , double

62 , cp_2_nom_pipe_diam , short

63 , cp_2_outside_diam , double

64 , cp_2_end_prep , short , standard note 330

65 , cp_2_sch_thk , character(8)

66 , cp_2_rating , character(8)

67 , cp_2_face_to_ctr , double

68 , cp_2_weld_no , character(8)

69 , cp_2_weld_type , short , standard note 1100 / 400 (bolt option)

70 , cp_2_gasket_gap , double

71 , cp_2_gasket_option , short , standard note 400

72 , cp_2_stress_node , short

73 , cp_2_stress_factor , double

74 , cp_2_head_loss , double

75 , cp_3_nom_pipe_diam , short

76 , cp_3_outside_diam , double

77 , cp_3_end_prep , short , standard note 330

78 , cp_3_sch_thk , character(8)

79 , cp_3_rating , character(8)

80 , cp_3_face_to_ctr , double

81 , cp_3_weld_no , character(8)

82 , cp_3_weld_type , short , standard note 1100 / 400 (bolt option)

83 , cp_3_gasket_gap , double

84 , cp_3_gasket_option , short , standard note 400

85 , cp_3_stress_node , short

86 , cp_3_stress_factor , double

87 , cp_3_head_loss , double

88 , cp_4_nom_pipe_diam , short

89 , cp_4_outside_diam , double

90 , cp_4_end_prep , short , standard note 330

91 , cp_4_sch_thk , character(8)

92 , cp_4_rating , character(8)

93 , cp_4_face_to_ctr , double

94 , cp_4_weld_no , character(8)

95 , cp_4_weld_type , short , standard note 1100 / 400 (bolt option)

96 , cp_4_gasket_gap , double

97 , cp_4_gasket_option , short , standard note 400

98 , cp_4_stress_node , short

99 , cp_4_stress_factor , double

100, cp_4_head_loss , double

101, cp_5_nom_pipe_diam , short

102, cp_5_outside_diam , double

103, cp_5_end_prep , short , standard note 330

104, cp_5_sch_thk , character(8)

105, cp_5_rating , character(8)

106, cp_5_face_to_ctr , double

107, cp_5_weld_no , character(8)

108, cp_5_weld_type , short , standard note 1100 / 400 (bolt option)

109, cp_5_gasket_gap , double

110, cp_5_gasket_option , short , standard note 400

111, cp_5_stress_node , short

112, cp_5_stress_factor , double

113, cp_5_head_loss , double

# Piping/Tubing Data

table number = 50 , number of columns = 56

1 , system_unique_no , integer , index 1

2 , piping_comp_no , character(20)

3 , commodity_name , character(6)

4 , model_code , character(6)

5 , option_code , short , standard note 400

6 , maximum_temp , double

7 , nominal_piping_dia , short

8 , outside_diameter , double

9 , schedule_thickness , character(8)

10 , sched_thick_basis , character(8)

11 , rating , character(8)

12 , commodity_code , character(16)

13 , MTO_requirements , short , standard note 365

14 , fabrication_cat , short , standard note 180

15 , source_of_data , short , standard note 425

16 , PDS_sort_code , character(6)

17 , geometric_standard , short , standard note 575

18 , weight_code , short , standard note 578

19 , table_suffix_green , short , standard note 576

20 , table_suffix_red , short , standard note 577

21 , materials_grade , short , standard note 145

22 , pipe_length , double

23 , surface_area , double , standard note 1010 (units)

24 , empty_weight , double , standard note 1028 (units)

25 , water_weight , double , standard note 1028 (units)

26 , cold_spring_length , double

27 , construction_stat , short , standard note 130

28 , hold_status , short , standard note 50

29 , heat_tracing_reqmt , short , standard note 200

30 , heat_tracing_media , short , standard note 210

31 , heat_tracing_temp , double

32 , iso_dwg_index_no , integer

33 , isometric_sheet_no , character(2)

34 , piece_mark_no , character(10)

35 , color_code , character(8)

36 , piping_assembly , character(12)

37 , component_group_no , short

38 , remarks , character(16)

39 , standard_note_no_a , short , standard note 499

40 , standard_note_no_b , short , standard note 499

41 , end_1_end_prep , short , standard note 330

42 , end_1_weld_no , character(8)

43 , end_1_weld_type , short , standard note 1100 / 400 (bolt option)

44 , end_1_gasket_gap , double

45 , end_1_gasket_opt , short , standard note 400

46 , end_1_stress_node , short

47 , end_1_stres_int , double

48 , end_1_head_loss , double

49 , end_2_end_prep , short , standard note 330

50 , end_2_weld_no , character(8)

51 , end_2_weld_type , short , standard note 1100 / 400 (bolt option)

52 , end_2_gasket_gap , double

53 , end_2_gasket_opt , short , standard note 400

54 , end_2_stress_node , short

55 , end_2_stres_int , double

56 , end_2_head_loss , double

# Instrument Component Data

table number = 67 , number of columns = 119

1 , system_unique_no , integer , index 1

2 , instrument_comp_no , character(20)

3 , model_code , character(6)

4 , option_code , short , standard note 400

5 , sched_thick_basis , character(8)

6 , MTO_requirements , short , standard note 365

7 , fabrication_cat , short , standard note 180

8 , source_of_data , short , standard note 430

9 , PDS_sort_code , character(6)

10 , physical_data_id , character(8)

11 , geometric_standard , short , standard note 575

12 , weight_code , short , standard note 578

13 , table_suffix_green , short , standard note 576

14 , table_suffix_red , short , standard note 577

15 , materials_grade , short , standard note 145

16 , face_to_face_dim , double

17 , dimension_a , double

18 , dimension_b , double

19 , dimension_c , double

20 , surface_area , double , standard note 1010 (units)

21 , empty_weight , double , standard note 1028 (units)

22 , water_weight , double , standard note 1028 (units)

23 , operator_weight , double , standard note 1028 (units)

24 , operator_type , double

25 , operator_sym_name , character(6)

26 , chain_operator_no , short

27 , chain_length , double

28 , opening_action , short , standard note 390

29 , construction_stat , short , standard note 130

30 , hold_status , short , standard note 50

31 , design_resp , short , standard note 160

32 , construction_resp , short , standard note 160

33 , heat_tracing_reqmt , short , standard note 200

34 , heat_tracing_media , short , standard note 210

35 , heat_tracing_temp , double

36 , insulation_purpose , short , standard note 220

37 , insulation_thick , double

38 , insulation_density , double , standard note 1074 (units)

39 , cleaning_reqmts , short , standard note 230

40 , safety_class , short , standard note 340

41 , module_no , character(16)

42 , package_system_no , character(12)

43 , iso_dwg_index_no , integer

44 , isometric_sheet_no , character(2)

45 , piece_mark_no , character(10)

46 , color_code , character(8)

47 , stress_node_no , short

48 , stress_intens_fact , double

49 , head_loss_factor , double

50 , piping_assembly , character(12)

51 , component_group_no , short

52 , remarks , character(16)

53 , standard_note_no_a , short , standard note 499

54 , standard_note_no_b , short , standard note 499

55 , cp_1_nom_pipe_diam , short

56 , cp_1_outside_diam , double

57 , cp_1_end_prep , short , standard note 330

58 , cp_1_sch_thk , character(8)

59 , cp_1_rating , character(8)

60 , cp_1_face_to_ctr , double

61 , cp_1_weld_no , character(8)

62 , cp_1_weld_type , short , standard note 1100 / 400 (bolt option)

63 , cp_1_gasket_gap , double

64 , cp_1_gasket_option , short , standard note 400

65 , cp_1_stress_node , short

66 , cp_1_stress_factor , double

67 , cp_1_head_loss , double

68 , cp_2_nom_pipe_diam , short

69 , cp_2_outside_diam , double

70 , cp_2_end_prep , short , standard note 330

71 , cp_2_sch_thk , character(8)

72 , cp_2_rating , character(8)

73 , cp_2_face_to_ctr , double

74 , cp_2_weld_no , character(8)

75 , cp_2_weld_type , short , standard note 1100 / 400 (bolt option)

76 , cp_2_gasket_gap , double

77 , cp_2_gasket_option , short , standard note 400

78 , cp_2_stress_node , short

79 , cp_2_stress_factor , double

80 , cp_2_head_loss , double

81 , cp_3_nom_pipe_diam , short

82 , cp_3_outside_diam , double

83 , cp_3_end_prep , short , standard note 330

84 , cp_3_sch_thk , character(8)

85 , cp_3_rating , character(8)

86 , cp_3_face_to_ctr , double

87 , cp_3_weld_no , character(8)

88 , cp_3_weld_type , short , standard note 1100 / 400 (bolt option)

89 , cp_3_gasket_gap , double

90 , cp_3_gasket_option , short , standard note 400

91 , cp_3_stress_node , short

92 , cp_3_stress_factor , double

93 , cp_3_head_loss , double

94 , cp_4_nom_pipe_diam , short

95 , cp_4_outside_diam , double

96 , cp_4_end_prep , short , standard note 330

97 , cp_4_sch_thk , character(8)

98 , cp_4_rating , character(8)

99 , cp_4_face_to_ctr , double

100, cp_4_weld_no , character(8)

101, cp_4_weld_type , short , standard note 1100 / 400 (bolt option)

102, cp_4_gasket_gap , double

103, cp_4_gasket_option , short , standard note 400

104, cp_4_stress_node , short

105, cp_4_stress_factor , double

106, cp_4_head_loss , double

107, cp_5_nom_pipe_diam , short

108, cp_5_outside_diam , double

109, cp_5_end_prep , short , standard note 330

110, cp_5_sch_thk , character(8)

111, cp_5_rating , character(8)

112, cp_5_face_to_ctr , double

113, cp_5_weld_no , character(8)

114, cp_5_weld_type , short , standard note 1100 / 400 (bolt option)

115, cp_5_gasket_gap , double

116, cp_5_gasket_option , short , standard note 400

117, cp_5_stress_node , short

118, cp_5_stress_factor , double

119, cp_5_head_loss , double

# Pipe Support Data

table number = 80 , number of columns = 36

1 , system_unique_no , integer , index 1

2 , pipe_support_no , character(20)

3 , model_code_phy , character(6)

4 , model_code_log , character(6)

5 , iso_support_type_a , short , standard note 380

6 , iso_support_type_b , short , standard note 380

7 , iso_support_type_c , short , standard note 380

8 , iso_support_type_d , short , standard note 380

9 , details_for_shop , character(50)

10 , details_for_field , character(50)

11 , fabrication_orient , character(20)

12 , commodity_code , character(16)

13 , MTO_requirements , short , standard note 365

14 , fabrication_cat , short , standard note 180

15 , weight , double , standard note 1028 (units)

16 , construction_stat , short , standard note 130

17 , hold_status , short , standard note 50

18 , standard_note_no , short , standard note 499

19 , iso_dwg_index_no , integer

20 , isometric_sheet_no , character(2)

21 , piece_mark_no , character(10)

22 , color_code , character(8)

23 , isometric_dim_a , double

24 , isometric_dim_b , double

25 , isometric_dim_c , double

26 , isometric_dim_d , double

27 , isometric_dim_e , double

28 , trans_rigidity_x , double

29 , trans_rigidity_y , double

30 , trans_rigidity_z , double

31 , rot_rigidity_x , double

32 , rot_rigidity_y , double

33 , rot_rigidity_z , double

34 , spring_gap_length , double

35 , sping_gap_direct , short

36 , number_of_springs , short