Table Integral Harmonics

This table stores the results of the warm measurements of the magnetic field for the integral harmonics (including ends) performed by companies  

Table WMF_MEAS_INTEGRAL
Fields	Type	Nullable	Constraints	Comments
Magnet_Name	string	No	like 'HCMB__A001-0%'	[iA,1] Name of the magnet
Magnet_Nu	number	No		Number of the manufacturer on 1 digit + sequential number of the magnet on 3 digits.
Stage	string	No	'collared coil' or 'cold mass'	State of the magnet
Measure_Id	string	No		[PKey,1] date of test + "_"  + serial number
Final_Measure	string	No	'T' or 'F'	[PKey,2] [iA,4] Indicates if it is the final measure (True or False)
Aperture	integer	No	1 or 2	[PKey,3] [iA,2] Aperture number
Position	string	No	'integral' or 'central' or 'sigma'	[PKey,4] [iA,3] integral : pos 1...20 (global feed-down); central : average on pos 2...19 (local feed-down); sigma : on pos 2...19 (local feed-down)
Multipole a1 [Rad]	real	No	-1<=?<=1	contains the value of Angle
group 1 of 14 columns
Skew multipoles [Unit]	real	No	-100<=?<=100	a2, a3, a4, ..... , a14, a15 (Names of the columns of the group1 in this Oracle table)
end of group 1
Multipole b1 [T]	real	No	-0.01<=?<=0.01	contains the value of  C1
group 2 of 14 columns
Normal multipoles [Unit]	real	No	-100<=?<=100	b2, b3, b4, ..... , b14, b15 (Names of the columns of the group 2 in this Oracle table)
end of group 2
Dx [m]	real	Yes	-0.03<=?<=0.03
Dy [m]	real	Yes	-0.03<=?<=0.03

For information please send e-email to Ezio Todesco or Jerome Beauquis.

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