Table Local Harmonics

this table stores the results of the warm measurements of the magnetic field for the local harmonics performed by companies  

Table WMF_MEAS_LOCAL
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,5] Indicates if it is the final measure (True or False)
Feed_Down	string	No	'T' or 'F'	[PKey,3] [iA,3] Harmonics given with local feed-down (True) or without feed-down (False). Feed-down on b10,a10.
Aperture	integer	No	1 or 2	[PKey,4] [iA,2] Aperture number
Position_Meter [m]	real	No	?=-(j-10.5)*.75      j=1,2,..,20	Longitudinal position in meters, of the measurement along the magnet
Position_Number	integer	No	1<=?<=20	[PKey,5] [iA,4] Longitudinal position number of the measurement along the magnet
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 14 columns of the group 1 in this Oracle table)
end of group 1
b1 [T]	real	No	0<=?<=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	No	-0.03<=?<=0.03
Dy [m]	real	No	-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 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.