Piping Design Database (dd_projname) - PDS - Help

Plant Design System (PDS) Report Manager (PD_Report)

PPMProductFamily
3D Design and Visualization
PPMProduct
PDS
PPMCategory
Help

Table 12 - Piping Segment Data

1 system_unique_no integer index 1

2 line_number_label character(24) .......................... 1

3 line_id character(16) .......................... 1

4 unit_number character(12) .......................... 1

5 unit_code character(3) ........................... 1

6 module_no character(16) .......................... 1

7 package_system_no character(12) .......................... 1

8 train_number character(2) ........................... 1

9 fluid_code short (SN125)..................... 1

10 line_sequence_no character(16) .......................... 1

11 nominal_piping_dia short ...........(NPD).................. 1

12 piping_mater_class character(16) .......................... 1

13 gasket_separation character(8) ........................... 1

14 insulation_purpose short (SN220) ................ 1

15 insulation_thick double (ins thick units) ............... 1

16 insulation_density double (SN1074 units) ........ 5

17 heat_tracing_reqmt short (SN200) ............... 1

18 heat_tracing_media short (SN210) ............... 1

19 heat_tracing_temp double ................................. 5

20 construction_stat short (SN130) ............... 1

21 hold_status short (SN50) ................ 1

22 approval_status short (SN35) ................ 1

23 schedule_override character(8) (SN332) ............... 1

24 nor_oper_pres double ................................. 5

25 nor_oper_temp double ................................. 5

26 alt_oper_pres double ................................. 5

27 alt_oper_temp double ................................. 5

28 nor_dgn_pres double ................................. 5

29 nor_dgn_temp double ................................. 5

30 alt_dgn_pres double ................................. 5

31 alt_dgn_temp double ................................. 5

32 steam_outlet_temp double ................................. 5

33 mater_of_construct character(6) ........................... 1

34 safety_class short (SN340) ............... 1

35 design_standard short (SN570) ............... 1

36 design_area_number character(10) .......................... 1

37 design_resp short (SN160) ................1

38 construction_resp short (SN160) ............... 1

39 supply_resp short (SN160) ............... 1

40 coating_reqmts short (SN190) ............... 1

41 cleaning_reqmts short (SN230) ............... 1

42 fluid_category character(4) ........................... 1

43 nor_op_pres_units short (SN1064) .............. 1

44 nor_op_temp_units short (SN1056) .............. 1

45 alt_op_pres_units short (SN1064) .............. 1

46 alt_op_temp_units short (SN1056) .............. 1

47 nor_dgn_pres_units short (SN1064) .............. 1

48 nor_dgn_temp_units short (SN1056) .............. 1

49 alt_dgn_pres_units short (SN1064) .............. 1

50 alt_dgn_temp_units short (SN1056) .............. 1

51 steam_temp_units short (SN1056) .............. 1

52 stress_system_no character(12) .......................... 1

53 stress_reqmts short (SN360) ............... 1

54 hyd_system_no character(12) .......................... 1

55 hyd_reqmts short (SN360) ............... 1

56 specific_gravity_a double ................................. 5

57 specific_gravity_b double ................................. 5

58 specific_gravity_c double ................................. 5

59 viscosity double ................................. 5

60 density double ................................. 5

61 spec_heat_ratio double ................................. 5

62 sonic_velocity double ................................. 5

63 surface_roughness double ................................. 5

64 test_system_no character(6) ........................... 1

65 test_fluid short (SN125) ............... 1

66 test_pressure double ................................. 5

67 PID_id_part_a character(4) ........................... 1

68 PID_id_part_b character(4) ........................... 1

69 end_1_nozzle_id integer ................................ 3

70 end_2_nozzle_id integer ................................ 3

71 alpha_descript_id character(12) .......................... 1

72 standard_note_no short (SN499) ...........2 or 1

73 pid_index_no integer ................................ 3

74 color_code character(8) ........................... 1

75 inspection_iso_id character(24) .......................... 1

76 index_to_pi_dwg integer ................................ 3

77 weld_id character(80) .......................... 1

78 sppid_piperun_guid character(32) .......................... 1

79 sppid_drawing_guid character(32) .......................... 1

Table 34 - Piping Components

1 system_unique_no integer index 1

2 piping_comp_no character(20) ..........................1

3 commodity_name character(6) ...........................1

4 model_code character(6) .......................... 1

5 option_code short (SN400) ...............1

6 maximum_temp double .................................5

7 sched_thick_basis character(8) ...........................1

8 commodity_code character(16) ..........................1

9 MTO_requirements short (SN365) ...............1

10 fabrication_cat short (SN180) ...............1

11 source_of_data short (SN420) ...............1

12 PDS_sort_code character(6) ...........................1

13 physical_data_id character(8) ...........................1

14 geometric_standard short (SN575) ...............1

15 weight_code short (SN578) ...............1

16 table_suffix_green short (SN576) ...............1

17 table_suffix_red short (SN577) ...............1

18 materials_grade short (SN145) ...............1

19 bend_radius double .................................5

20 bend_angle double .................................5

21 face_to_face_dim double .................................1

22 dimension_a double .................................5

23 dimension_b double .................................5

24 dimension_c double .................................5

25 surface_area double (SN 1010 units) ........5

26 empty_weight double (SN 1028 units) ........5

27 water_weight double (SN 1028 units) ........5

28 operator_weight double .................................5

29 operator_sym_name character(6) ...........................1

30 chain_operator_no short ..................................2

31 opening_action short (SN390) ...............1

32 construction_stat short (SN130) ...............1

33 hold_status short (SN50) ................1

34 heat_tracing_reqmt short (SN200) ...............1

35 heat_tracing_media short (SN210) ...............1

36 heat_tracing_temp double .................................5

37 iso_dwg_index_no integer ................................3

38 isometric_sheet_no character(2) ...........................1

39 piece_mark_no character(60) ..........................1

40 color_code character(8) ...........................1

41 stress_node_no short ..................................2

42 stress_intens_fact double .................................5

43 head_loss_factor double .................................5

44 piping_assembly character(12) ..........................1

45 component_group_no short ..................................2

46 remarks character(50) ..........................1

47 standard_note_no_a short (SN499) ..........2 or 1

48 standard_note_no_b short (SN499) ..........2 or 1

49 cp_1_nom_pipe_diam short ...........................(NPD). 1

50 cp_1_outside_diam double .....................(Dist. NPD) 1

51 cp_1_end_prep short (SN330) .............. 1

52 cp_1_sch_thk character(8) (SN332) .............. 1

53 cp_1_rating character(8) ...........................1

54 cp_1_face_to_ctr double .................................5

55 cp_1_weld_no character(8) ...........................1

56 cp_1_weld_type short (SN1100)/400 (bolt option).1

57 cp_1_gasket_gap double .................................5

58 cp_1_gasket_option short (SN400) ...............1

59 cp_1_stress_node short ..................................2

60 cp_1_stress_factor double .................................5

61 cp_1_head_loss double .................................5

62 cp_2_nom_pipe_diam short ............................(NPD).1

63 cp_2_outside_diam double .....................(Dist. NPD).1

64 cp_2_end_prep short (SN330) ...............1

65 cp_2_sch_thk character(8) (SN332) ...............1

66 cp_2_rating character(8) ...........................1

67 cp_2_face_to_ctr double ...................(Dist. Model).1

68 cp_2_weld_no character(8) ...........................1

69 cp_2_weld_type short (SN1100)/400 (bolt option)1

70 cp_2_gasket_gap double ...................(Dist. Model).1

71 cp_2_gasket_option short (SN400) ...............1

72 cp_2_stress_node short ..................................2

73 cp_2_stress_factor double .................................5

74 cp_2_head_loss double .................................5

75 cp_3_nom_pipe_diam short ............................(NPD).1

76 cp_3_outside_diam double .....................(Dist. NPD).1

77 cp_3_end_prep short (SN330) ...............1

78 cp_3_sch_thk character(8) (SN332) ...............1

79 cp_3_rating character(8) ...........................1

80 cp_3_face_to_ctr double ...................(Dist. Model).1

81 cp_3_weld_no character(8) ...........................1

82 cp_3_weld_type short (SN1100)/400 (bolt option) 1

83 cp_3_gasket_gap double ...................(Dist. Model).1

84 cp_3_gasket_option short (SN400) ...............1

85 cp_3_stress_node short ..................................2

86 cp_3_stress_factor double .................................5

87 cp_3_head_loss double .................................5

88 cp_4_nom_pipe_diam short ............................(NPD).1

89 cp_4_outside_diam double .....................(Dist. NPD).1

90 cp_4_end_prep short (SN330) ...............1

91 cp_4_sch_thk character(8) (SN332) ...............1

92 cp_4_rating character(8) ...........................1

93 cp_4_face_to_ctr double ...................(Dist. Model).1

94 cp_4_weld_no character(8) ...........................1

95 cp_4_weld_type short (SN1100)/400 (bolt option) 1

96 cp_4_gasket_gap double ...................(Dist. Model).1

97 cp_4_gasket_option short (SN400) ...............1

98 cp_4_stress_node short ..................................2

99 cp_4_stress_factor double .................................5

100 cp_4_head_loss double .................................5

101 cp_5_nom_pipe_diam short ............................(NPD).1

102 cp_5_outside_diam double .....................(Dist. NPD).1

103 cp_5_end_prep short (SN330) ...............1

104 cp_5_sch_thk character(8) (SN332) ...............1

105 cp_5_rating character(8) ...........................1

106 cp_5_face_to_ctr double ...................(Dist. Model).1

107 cp_5_weld_no character(8) ...........................1

108 cp_5_weld_type short (SN1100/400 (bolt option).1

109 cp_5_gasket_gap double ...................(Dist. Model).1

110 cp_5_gasket_option short (SN400) ...............1

111 cp_5_stress_node short ..................................2

112 cp_5_stress_factor double .................................5

113 cp_5_head_loss double .................................5

114 unique_name character(12) ..........................1

115 vlv_operator_dim_a double .................................5

116 vlv_operator_dim_b double .................................5

117 vlv_operator_dim_c double .................................5

118 vlv_operator_dim_d double .................................5

119 last_placed_date integer ................................3

120 generic_comp_no character(20) ..........................1

121 inspection_key short ..................................2

122 cp_1_inspect_key short ..................................2

123 cp_2_inspect_key short ..................................2

124 cp_3_inspect_key short ..................................2

125 cp_4_inspect_key short ..................................2

126 cp_5_inspect_key short ..................................2

Table 50 - Piping/Tubing

1 system_unique_no integer index 1
2 piping_comp_no character(20) ..........................1

3 commodity_name character(6) ...........................1

4 model_code character(6) ...........................1

5 option_code short (SN400) ...............1

6 maximum_temp double .................................5

7 nominal_piping_dia short ............................(NPD).1

8 outside_diameter double .....................(Dist. NPD).1

9 schedule_thickness character(8) (SN332) ...............1

10 sched_thick_basis character(8) (SN332) ...............1

11 rating character(8) ...........................1

12 commodity_code character(16) ..........................1

13 MTO_requirements short (SN365) ...............1

14 fabrication_cat short (SN180) ...............1

15 source_of_data short (SN425) ...............1

16 PDS_sort_code character(6) ...........................1

17 geometric_standard short (SN575) ...............1

18 weight_code short (SN578) ...............1

19 table_suffix_green short (SN576) ...............1

20 table_suffix_red short (SN577) ...............1

21 materials_grade short (SN145) ...............1

22 pipe_length double ...................(Dist. Model).1

23 surface_area double (SN1010 units) ........5

24 empty_weight double (SN1028 units) ........5

25 water_weight double (SN1028 units) ........5

26 cold_spring_length double ...................(Dist. Model).1

27 construction_stat short (SN130) ...............1

28 hold_status short (SN50) ................1

29 heat_tracing_reqmt short (SN200) ...............1

30 heat_tracing_media short (SN210) ...............1

31 heat_tracing_temp double .................................5

32 iso_dwg_index_no integer ................................3

33 isometric_sheet_no character(2) ...........................1

34 piece_mark_no character(60) ..........................1

35 color_code character(8) ...........................1

36 piping_assembly character(12) ..........................1

37 component_group_no short ..................................2

38 remarks character(50) ..........................1

39 standard_note_no_a short (SN499) ..........2 or 1

40 standard_note_no_b short (SN499) ..........2 or 1

41 end_1_end_prep short (SN330) ...............1

42 end_1_weld_no character(8) ...........................1

43 end_1_weld_type short (SN1100)/400 (bolt option) 1

44 end_1_gasket_gap double ...................(Dist. Model).1

45 end_1_gasket_opt short (SN400) ...............1

46 end_1_stress_node short ..................................2

47 end_1_stres_int double .................................5

48 end_1_head_loss double .................................5

49 end_2_end_prep short (SN330) ...............1

50 end_2_weld_no character(8) ...........................1

51 end_2_weld_type short (SN1100)/400 (bolt option) 1

52 end_2_gasket_gap double ...................(Dist. Model).1

53 end_2_gasket_opt short (SN400) ...............1

54 end_2_stress_node short ..................................2

55 end_2_stres_int double .................................5

56 end_2_head_loss double .................................5

57 unique_name character(12) ..........................1

58 last_placed_date integer ................................3

59 inspection_key short ..................................2

60 end_1_inspect_key short ..................................2

61 end_2_inspect_key short ..................................2

Table 67 - Instrument Components

1 system_unique_no integer index 1
2 instrument_comp_no character(20) ..........................1

3 model_code character(6) ...........................1

4 option_code short (SN400) ...............1

5 sched_thick_basis character(8) (SN332) ...............1

6 MTO_requirements short (SN365) ...............1

7 fabrication_cat short (SN180) ...............1

8 source_of_data short (SN430) ...............1

9 PDS_sort_code character(6) ...........................1

10 physical_data_id character(8) ...........................1

11 geometric_standard short (SN575) ...............1

12 weight_code short (SN578) ...............1

13 table_suffix_green short (SN576) ...............1

14 table_suffix_red short (SN577) ...............1

15 materials_grade short (SN145) ...............1

16 face_to_face_dim double .................................1

17 dimension_a double .................................5

18 dimension_b double .................................5

19 dimension_c double .................................5

20 surface_area double (SN1010 units) ........5

21 empty_weight double (SN1028 units) ........5

22 water_weight double (SN1028 units) ........5

23 operator_weight double (SN1028 units) ........5

24 operator_type double .................................5

25 operator_sym_name character(6) ...........................1

26 chain_operator_no short ..................................2

27 chain_length double .................................5

28 opening_action short (SN390) ...............1

29 construction_stat short (SN130) ...............1

30 hold_status short (SN50) ................1

31 design_resp short (SN160) ...............1

32 construction_resp short (SN160) ...............1

33 heat_tracing_reqmt short (SN200) ...............1

34 heat_tracing_media short (SN210) ...............1

35 heat_tracing_temp double .................................5

36 insulation_purpose short (SN220) ...............1

37 insulation_thick double ...............(ins thick units).1

38 insulation_density double (SN1074 units) ........5

39 cleaning_reqmts short (SN230) ...............1

40 safety_class short (SN340) ...............1

41 module_no character(16) ..........................1

42 package_system_no character(12) ..........................1

43 iso_dwg_index_no integer ................................3

44 isometric_sheet_no character(2) ...........................1

45 piece_mark_no character(60) ..........................1

46 color_code character(8) ...........................1

47 stress_node_no short ..................................2

48 stress_intens_fact double .................................5

49 head_loss_factor double .................................5

50 piping_assembly character(12) ..........................1

51 component_group_no short ..................................2

52 remarks character(50) ..........................1

53 standard_note_no_a short (SN499) ..........2 or 1

54 standard_note_no_b short (SN499) ..........2 or 1

55 cp_1_nom_pipe_diam short ............................(NPD).1

56 cp_1_outside_diam double .....................(Dist. NPD).1

57 cp_1_end_prep short (SN330) ...............1

58 cp_1_sch_thk character(8) (SN332) ...............1

59 cp_1_rating character(8) ...........................1

60 cp_1_face_to_ctr double ...................(Dist. Model).1

61 cp_1_weld_no character(8) ...........................1

62 cp_1_weld_type short (SN1100)/400 (bolt option)1

63 cp_1_gasket_gap double ...................(Dist. Model).1

64 cp_1_gasket_option short (SN400) ...............1

65 cp_1_stress_node short ..................................2

66 cp_1_stress_factor double .................................5

67 cp_1_head_loss double .................................5

68 cp_2_nom_pipe_diam short ............................(NPD).1

69 cp_2_outside_diam double .....................(Dist. NPD).1

70 cp_2_end_prep short (SN330) ...............1

71 cp_2_sch_thk character(8) (SN332) ...............1

72 cp_2_rating character(8) ...........................1

73 cp_2_face_to_ctr double ...................(Dist. Model).1

74 cp_2_weld_no character(8) ...........................1

75 cp_2_weld_type short (SN1100)/400 (bolt option)1

76 cp_2_gasket_gap double ...................(Dist. Model).1

77 cp_2_gasket_option short (SN400) ...............1

78 cp_2_stress_node short ..................................2

79 cp_2_stress_factor double .................................5

80 cp_2_head_loss double .................................5

81 cp_3_nom_pipe_diam short ............................(NPD).1

82 cp_3_outside_diam double .....................(Dist. NPD).1

83 cp_3_end_prep short (SN330) ...............1

84 cp_3_sch_thk character(8) (SN332) ...............1

85 cp_3_rating character(8) ...........................1

86 cp_3_face_to_ctr double ...................(Dist. Model).1

87 cp_3_weld_no character(8) ...........................1

88 cp_3_weld_type short (SN1100)/400 (bolt option)1

89 cp_3_gasket_gap double ...................(Dist. Model).1

90 cp_3_gasket_option short (SN400) ...............1

91 cp_3_stress_node short ..................................2

92 cp_3_stress_factor double .................................5

93 cp_3_head_loss double .................................5

94 cp_4_nom_pipe_diam short ............................(NPD).1

95 cp_4_outside_diam double .....................(Dist. NPD).1

96 cp_4_end_prep short (SN330) ...............1

97 cp_4_sch_thk character(8) (SN332) ...............1

98 cp_4_rating character(8) ...........................1

99 cp_4_face_to_ctr double ...................(Dist. Model).1

100 cp_4_weld_no character(8) ...........................1

101 cp_4_weld_type short (SN1100)/400 (bolt option)1

102 cp_4_gasket_gap double ...................(Dist. Model).1

103 cp_4_gasket_option short (SN400) ...............1

104 cp_4_stress_node short ..................................2

105 cp_4_stress_factor double .................................5

106 cp_4_head_loss double .................................5

107 cp_5_nom_pipe_diam short ............................(NPD).1

108 cp_5_outside_diam double .....................(Dist. NPD).1

109 cp_5_end_prep short (SN330) ...............1

110 cp_5_sch_thk character(8) (SN332) ...............1

111 cp_5_rating character(8) ...........................1

112 cp_5_face_to_ctr double ...................(Dist. Model).1

113 cp_5_weld_no character(8) ...........................1

114 cp_5_weld_type short (SN1100)/400 (bolt option)1

115 cp_5_gasket_gap double ...................(Dist. Model).1

116 cp_5_gasket_option short (SN400) ...............1

117 cp_5_stress_node short ..................................2

118 cp_5_stress_factor double .................................5

119 cp_5_head_loss double .................................5

120 unique_name character(12) ...........................1

121 bend_angle double ..................................5

122 vlv_operator_dim_a double ..................................5

123 vlv_operator_dim_b double ..................................5

124 vlv_operator_dim_c double ..................................5

125 vlv_operator_dim_d double ..................................5

126 last_placed_date integer .................................3

127 generic_comp_no character(20) ...........................1

128 inspection_key short ...................................2

129 cp_1_inspect_key short ...................................2

130 cp_2_inspect_key short ...................................2

131 cp_3_inspect_key short ...................................2

132 cp_4_inspect_key short ...................................2

133 cp_5_inspect_key short ...................................2

Table 80 - Pipe Supports

1 system_unique_no integer index 1

2 pipe_support_no character(20) ..........................1

3 model_code_phy character(6) ...........................1

4 model_code_log character(6) ...........................1

5 iso_support_type_a short (SN380) ...............1

6 iso_support_type_b short (SN380) ...............1

7 iso_support_type_c short (SN380) ...............1

8 iso_support_type_d short (SN380) ...............1

9 details_for_shop character(50) ..........................1

10 details_for_field character(50) ..........................1

11 fabrication_orient character(20) ..........................1

12 commodity_code character(16) ..........................1

13 MTO_requirements short (SN365) ...............1

14 fabrication_cat short (SN180) ...............1

15 weight double (SN1028 units) .........5

16 construction_stat short (SN130) ...............1

17 hold_status short (SN50) ................1

18 standard_note_no short (SN499) ..........2 or 1

19 iso_dwg_index_no integer ................................3

20 isometric_sheet_no character(2) ...........................1

21 piece_mark_no character(60) ..........................1

22 color_code character(8) ...........................1

23 isometric_dim_a double .................................5

24 isometric_dim_b double .................................5

25 isometric_dim_c double .................................5

26 isometric_dim_d double .................................5

27 isometric_dim_e double .................................5

28 trans_rigidity_x double .................................5

29 trans_rigidity_y double .................................5

30 trans_rigidity_z double .................................5

31 rot_rigidity_x double .................................5

32 rot_rigidity_y double .................................5

33 rot_rigidity_z double .................................5

34 spring_gap_length double .................................5

35 sping_gap_direct short ..................................2

36 number_of_springs short ..................................2

37 last_placed_date integer .................................3

38 inspection_key short ..................................2

40 group_id integer .................................3

41 gang_id integer .................................3

42 material_grade short (SN145) .................1

43 weld_code short ..................................1

44 material_index character(16) ..........................1

45 operating_load double .................................5

46 installed_load double .................................5

47 hydrostatic_load double .................................5

48 total_movement_1 double in subunits (dist. att.) .......1

49 total_movement_2 double in subunits (dist. att.) .......1

50 rod_diameter double in subunits ....................1