Table Geometric Measurements Environment

This table stores the results of the conditions of the cold mass and cryo magnet geometric measurements performed by companies and CERN.
 
Table CRYOGEO_MEAS_ENVIRONMENT
Fields Type Nullable Constraints Comments
Meas_Id string No   [PKey]
Magnet_Nu integer No   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'

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
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)
Operator string No    
Laser_Tracker string Yes   Number of the laser tracker
Mole_Name string Yes    
Bundle_RMS [m] number Yes   Quality of the measurement
Fiducial_Tilt [Rad] number Yes   Angle of the fiducials (two on lyre side) with regard to the horizontal plan.
CM_Tilt [Rad] number Yes   Angle of the mid plan with regard to the horizontal plan.
Room_Temperature [K] number Yes 275<?<310  
Magnet_Temprature [K] number Yes    
Comments string Yes   comments about the measurement
Loader_Name string No   Name of one loaded data
Loading_Date date No   Date of loading data


String length for the field Comments : 500 characters

Remark :[PKey] at the beginning of the Comments column means that this field define a primary key (This field identifies in an unique way each row of this table) and also an index.