| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
Equip Id |
Asset Identifier |
VARCHAR(30) |
NO |
Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
Test Date |
Date |
DATE |
NO |
Test Date |
| Updown |
|
NUMERIC(2, 0) |
YES |
Updown: Up(+1) or down(-1) ramp indicator. |
| Multipoles Cur |
Magnet Default |
NUMERIC(12, 6) |
YES |
Current |
| Pole |
|
NUMERIC(2, 0) |
YES |
Pole: Multipole of powered winding for measurement (Use if more than one per magnet) |
| X Ref |
Magnet Default |
NUMERIC(12, 6) |
NO |
X Reference: Horizontal location of the origin for the harmonic expansion, measured from the magnetic center, positive = to the right looking from the coil lead end. |
| Y Ref |
Magnet Default |
NUMERIC(12, 6) |
NO |
Y Reference: Vertical location of the origin for the harmonic expansion, measured from the magnetic center, positive = up. |
| R Ref |
Magnet Default |
NUMERIC(12, 6) |
YES |
R Reference: The radius of the measurement coil in m. |
| Norm Skew Cde |
|
NUMERIC(1, 0) |
YES |
Normal Skew: 0 = Skew measurement. 1 = Normal measurment. |
| Shim Thick |
Magnetic Field |
NUMERIC(12, 6) |
YES |
Shim Thickness: The shim thickness used in the measurement (mm), positive" is return leg shim (increasing the gap) and "negative" is pole shim (reducing the gap). |
| A1 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A1: Skew dipole coefficient |
| A2 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A2: Skew Quadrupole coefficient |
| A3 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A3: Skew sectupole coefficient |
| A4 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A4: Skew octupole coefficient |
| A5 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A5: Skew decopole coefficient |
| A6 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A6: Skew dodecopole coefficient |
| A7 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A7: Skew 14 pole coefficient |
| A8 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A8: Skew 16 pole coefficient |
| A9 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A9: Skew 18 pole coefficient |
| A10 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A10: Skew 20 pole coefficient |
| A11 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A11: Skew 22 pole coefficient |
| A12 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A12: Skew 24 pole coefficient |
| A13 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A13: Skew 26 pole coefficient. |
| A14 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A14: Skew 28 pole coefficient. |
| A15 |
Magnet Default |
NUMERIC(12, 6) |
YES |
A15: Skew 30 pole coefficient. |
| B1 |
|
NUMERIC(16, 10) |
YES |
B1: Normal dipole coefficient |
| B2 |
|
NUMERIC(16, 10) |
YES |
B2: Normal quadrupole coefficient |
| B3 |
|
NUMERIC(16, 10) |
YES |
B3: Normal sextupole coefficient |
| B4 |
|
NUMERIC(16, 10) |
YES |
B4: Normal octupole coefficient |
| B5 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B5: Normal decople coefficient |
| B6 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B6: Normal dodecopole coefficient |
| B7 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B7: Normal 14 pole coefficient |
| B8 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B8: Normal 16 pole coefficient |
| B9 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B9: Normal 18 pole coefficient |
| B10 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B10: Normal 20 pole coefficient |
| B11 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B11: Normal 22 pole coefficient. |
| B12 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B12: Normal 24 pole coefficient. |
| B13 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B13: Normal 26 pole coefficient. |
| B14 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B14: Normal 28 pole coefficient. |
| B15 |
Magnet Large Value |
NUMERIC(14, 10) |
YES |
B15: Normal 30 pole coefficient. |
| Meas Desc |
Description |
VARCHAR(255) |
YES |
Measurement Description: A free form text field used to describe the multipole data. |
Scenario Id |
|
VARCHAR(50) |
NO |
Scenario Identifier: The unique identifier for a scenario type. |
| Modify Date |
Modify Date |
DATE |
NO |
Modify Date: Date and time when this row was last modified |
| Mod By Uid |
Userid |
VARCHAR(64) |
NO |
Modify By Userid: The userid of the person who last changed the Magnet record. |