Table Correctors 
This table stores the results of the geometric measurements for the correctors of the cold mass and cryo magnet performed by companies and CERN. Values are expressed in local (connection and lyre) coordinate systems with origin on end plate.

Table CRYOGEO_CORRECTORS
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-MAG' or  'WP03-MAG' 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-MAG : Optional magnetic test in WP01
  • WP03-MAG : Warm magnetic measurements in WP03
  • WP08-MAG : Warm magnetic measurements in WP08
Meas_Type string No 'magnetic' or 'mechanic' [PKey,3]
Aperture number No 1 or 2 [PKey,4]
Point_Id string No MCS or MCO or MCD or MCDO [PKey,5] indicates the corrector
Meas_Id string No   [PKey,6]
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 in the x axis 
Y [m] real No   Position of the corrector on the y axis (longitudinal direction)
DZ [m] real No   Deviation from the theoretical value in the z axis (vertical direction)
DR [m] real Yes 0<=?<=0.003 Deviation from the theoretical value in the radial direction.


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.