Table Flanges

This table stores data about  the geometric measurements for the flanges of the cold bore tube extremities. Values are expressed in local (connection and lyre) coordinate systems with origin on end cover.

 

Table CRYOGEO_FLANGES
Fields Type Nullable Constraints Comments
Magnet_Nu integer No   [PKey,1] Serial number of the magnet (on 4 digits)
Step string No 'ITP20-GEO' or 'ITP20-MAG' or 'WP01-GEO' or 'WP01-MAG' or 'WP03-FID' or 'WP03-MAG' or 'WP08-FID' or 'WP08-MAG'

[PKey,2] Step where geometrical measurements have been performed

  • ITP20-GEO : Geometrical measurements done in ITP20 (mechanical axis)
  • ITP20-MAG : Geometrical measurements done in ITP20 (magnetic axis)
  • WP01-GEO : Optional geometrical test in WP01
  • WP01-MAG : Optional magnetic test in WP01
  • WP03-FID : Fiducialization in WP03
  • WP03-MAG : Warm magnetic measurements in WP03
  • WP08-FID : Fiducialization in WP08
  • WP08-MAG : Warm magnetic measurements in WP08
Side string No 'connection' or 'lyre' [PKey,3] Side of the cold mass
Aperture integer No 1 or 2  [PKey,4] 
Meas_Id string No   [PKey,5]
Magnet_Name string No like 'HC%' Name of the magnet
Stage string No 'cold mass' or 'cryomagnet'  
Final_Meas string No 'T' or 'F' Indicates if it is the final measurement (True or False)
DX [m] real No   Deviation from the theoretical value of the center of the flange in the x axis
DY [m] real No -0.003<=?<=0.003 

Deviation from the theoretical value of the center of the flange in the y axis (longitudinal direction)
DZ [m] real No   Deviation from the theoretical value of the center of the flange in the z axis (vertical direction)
DR [m] real No 0<=?<=0.01 Deviation from the theoretical value of the center of the flange in the radial direction
Angle [Rad] real No -0.045<=?<=0.045  Angle between the flange and the tube.


Remark :[PKey,n] at the beginning of the Comments column means that all those fields define a primary key (This set of fields identifies in an unique way each row of this table) and also an index with order n for the field.