EQUIP_ID 
Base Object  MAG 
Attribute Name  Equip Id 
ColumnName  EQUIP_ID 
Logical Rolename   
RoleName   
Domain  Asset Identifier 
Physical Only  NO 
Definition 
Asset Identifier: The Datastream/Infor asset identifier also often referred to as the Barcode Id.
 
Note 
 

EQUIP_ID Column Properties 
Datatype  VARCHAR2(30) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

EQUIP_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  11 
Percent Null 

EQUIP_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EQUIP_ID Security Types 
Name  Current Value 

EQUIP_ID Bound Attachments 
Name  Current Value 

EQUIP_ID Data Movement Rules 
Name  Type  Rule Text/Value 

EQUIP_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Equip Id 
NO     
Magnet (Oracle)
MAG
EQUIP_ID 
NO     

EQUIP_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PARTNER_ID 
Base Object  MAG 
Attribute Name  Partner Id 
ColumnName  PARTNER_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Partner Identifier:  The partner lab magnet name.
 
Note 
 

PARTNER_ID Column Properties 
Datatype  VARCHAR2(8) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

PARTNER_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

PARTNER_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PARTNER_ID Security Types 
Name  Current Value 

PARTNER_ID Bound Attachments 
Name  Current Value 

PARTNER_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PARTNER_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Partner Id 
NO     
Magnet (Oracle)
MAG
PARTNER_ID 
NO     

PARTNER_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PARTNER_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PARTNER_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PARTNER_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PHY_GAP_LNGTH 
Base Object  MAG 
Attribute Name  Phy Gap Lngth 
ColumnName  PHY_GAP_LNGTH 
Logical Rolename   
RoleName   
Domain  Magnet Large Value 
Physical Only  NO 
Definition 
Physical Gap Length:  Physical gap length (m)
 
Note 
 

PHY_GAP_LNGTH Column Properties 
Datatype  NUMBER(14, 10) 
Nullable  YES 

PHY_GAP_LNGTH Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

PHY_GAP_LNGTH Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PHY_GAP_LNGTH Security Types 
Name  Current Value 

PHY_GAP_LNGTH Bound Attachments 
Name  Current Value 

PHY_GAP_LNGTH Data Movement Rules 
Name  Type  Rule Text/Value 

PHY_GAP_LNGTH Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Phy Gap Lngth 
NO     
Magnet (Oracle)
MAG
PHY_GAP_LNGTH 
NO     

PHY_GAP_LNGTH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PHY_GAP_LNGTH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PHY_GAP_LNGTH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PHY_GAP_LNGTH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MAG_LNGTH 
Base Object  MAG 
Attribute Name  Mag Lngth 
ColumnName  MAG_LNGTH 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Magnetic Length:  Effective magnetic length(m)
 
Note 
 

MAG_LNGTH Column Properties 
Datatype  NUMBER(7, 3) 
Nullable  YES 

MAG_LNGTH Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MAG_LNGTH Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MAG_LNGTH Security Types 
Name  Current Value 

MAG_LNGTH Bound Attachments 
Name  Current Value 

MAG_LNGTH Data Movement Rules 
Name  Type  Rule Text/Value 

MAG_LNGTH Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Mag Lngth 
NO     
Magnet (Oracle)
MAG
MAG_LNGTH 
NO     

MAG_LNGTH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MAG_LNGTH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MAG_LNGTH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MAG_LNGTH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HOR_APER 
Base Object  MAG 
Attribute Name  Hor Aper 
ColumnName  HOR_APER 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Horizontal Aperture:  Horizontal aperture (m)
 
Note 
 

HOR_APER Column Properties 
Datatype  NUMBER(14, 10) 
Nullable  YES 

HOR_APER Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

HOR_APER Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

HOR_APER Security Types 
Name  Current Value 

HOR_APER Bound Attachments 
Name  Current Value 

HOR_APER Data Movement Rules 
Name  Type  Rule Text/Value 

HOR_APER Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Hor Aper 
NO     
Magnet (Oracle)
MAG
HOR_APER 
NO     

HOR_APER Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HOR_APER Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HOR_APER Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HOR_APER Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


VER_APER 
Base Object  MAG 
Attribute Name  Ver Aper 
ColumnName  VER_APER 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Vertical Aperture:  Vertical Aperture(m)
 
Note 
 

VER_APER Column Properties 
Datatype  NUMBER(14, 10) 
Nullable  YES 

VER_APER Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

VER_APER Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

VER_APER Security Types 
Name  Current Value 

VER_APER Bound Attachments 
Name  Current Value 

VER_APER Data Movement Rules 
Name  Type  Rule Text/Value 

VER_APER Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Ver Aper 
NO     
Magnet (Oracle)
MAG
VER_APER 
NO     

VER_APER Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

VER_APER Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

VER_APER Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

VER_APER Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SLOPE 
Base Object  MAG 
Attribute Name  Slope 
ColumnName  SLOPE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Slope: The linear fit coefficient of the integrated field (T-M) over current (A), used only for dipole correctors.
 
Note 
 

SLOPE Column Properties 
Datatype  NUMBER(14, 10) 
Nullable  YES 

SLOPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

SLOPE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SLOPE Security Types 
Name  Current Value 

SLOPE Bound Attachments 
Name  Current Value 

SLOPE Data Movement Rules 
Name  Type  Rule Text/Value 

SLOPE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Slope 
NO     
Magnet (Oracle)
MAG
SLOPE 
NO     

SLOPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SLOPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SLOPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SLOPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RAMP_RATE 
Base Object  MAG 
Attribute Name  Ramp Rate 
ColumnName  RAMP_RATE 
Logical Rolename   
RoleName   
Domain  Magnet Default 
Physical Only  NO 
Definition 
Ramp Rate:  The rate of current change between measurement points.  (A/sec)
 
Note 
 

RAMP_RATE Column Properties 
Datatype  NUMBER(12, 6) 
Nullable  YES 

RAMP_RATE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

RAMP_RATE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RAMP_RATE Security Types 
Name  Current Value 

RAMP_RATE Bound Attachments 
Name  Current Value 

RAMP_RATE Data Movement Rules 
Name  Type  Rule Text/Value 

RAMP_RATE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Ramp Rate 
NO     
Magnet (Oracle)
MAG
RAMP_RATE 
NO     

RAMP_RATE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RAMP_RATE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RAMP_RATE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RAMP_RATE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MEAS_WAIT 
Base Object  MAG 
Attribute Name  Meas Wait 
ColumnName  MEAS_WAIT 
Logical Rolename   
RoleName   
Domain  Magnet Default 
Physical Only  NO 
Definition 
Measure Wait: The time between end of ramp and start of measurement (sec).
 
Note 
 

MEAS_WAIT Column Properties 
Datatype  NUMBER(12, 6) 
Nullable  YES 

MEAS_WAIT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MEAS_WAIT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MEAS_WAIT Security Types 
Name  Current Value 

MEAS_WAIT Bound Attachments 
Name  Current Value 

MEAS_WAIT Data Movement Rules 
Name  Type  Rule Text/Value 

MEAS_WAIT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Meas Wait 
NO     
Magnet (Oracle)
MAG
MEAS_WAIT 
NO     

MEAS_WAIT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MEAS_WAIT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MEAS_WAIT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MEAS_WAIT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


FINAL_SHIM 
Base Object  MAG 
Attribute Name  Final Shim 
ColumnName  FINAL_SHIM 
Logical Rolename   
RoleName   
Domain  Magnet Default 
Physical Only  NO 
Definition 
Final Shim: Final shim thickness used in mm. "Positive" is return leg shim (increasing the gap) and "negative" is pole shim (reducing the gap).
 
Note 
 

FINAL_SHIM Column Properties 
Datatype  NUMBER(12, 6) 
Nullable  YES 

FINAL_SHIM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

FINAL_SHIM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

FINAL_SHIM Security Types 
Name  Current Value 

FINAL_SHIM Bound Attachments 
Name  Current Value 

FINAL_SHIM Data Movement Rules 
Name  Type  Rule Text/Value 

FINAL_SHIM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Final Shim 
NO     
Magnet (Oracle)
MAG
FINAL_SHIM 
NO     

FINAL_SHIM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FINAL_SHIM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FINAL_SHIM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FINAL_SHIM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NOTE 
Base Object  MAG 
Attribute Name  Note 
ColumnName  NOTE 
Logical Rolename   
RoleName   
Domain  Note 
Physical Only  NO 
Definition 
 
Note 
 

NOTE Column Properties 
Datatype  VARCHAR2(4000) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

NOTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null 

NOTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NOTE Security Types 
Name  Current Value 

NOTE Bound Attachments 
Name  Current Value 

NOTE Data Movement Rules 
Name  Type  Rule Text/Value 

NOTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Note 
NO     
Magnet (Oracle)
MAG
NOTE 
NO     

NOTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NOTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NOTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NOTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MOD_DTE 
Base Object  MAG 
Attribute Name  Modify Date 
ColumnName  MOD_DTE 
Logical Rolename   
RoleName   
Domain  Modify Date 
Physical Only  NO 
Definition 
Modify Date: Date and time when this row was last modified
 
Note 
 

MOD_DTE Column Properties 
Datatype  DATE 
Nullable  NO 

MOD_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MOD_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MOD_DTE Security Types 
Name  Current Value 

MOD_DTE Bound Attachments 
Name  Current Value 

MOD_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Modify Date 
NO     
Magnet (Oracle)
MAG
MOD_DTE 
NO     

MOD_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MOD_BY_UID 
Base Object  MAG 
Attribute Name  Mod By Uid 
ColumnName  MOD_BY_UID 
Logical Rolename   
RoleName   
Domain  Userid 
Physical Only  NO 
Definition 
Modify By Userid: The userid of the person who last changed the  Magnet record.
 
Note 
 

MOD_BY_UID Column Properties 
Datatype  VARCHAR2(64) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

MOD_BY_UID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null 

MOD_BY_UID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MOD_BY_UID Security Types 
Name  Current Value 

MOD_BY_UID Bound Attachments 
Name  Current Value 

MOD_BY_UID Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_BY_UID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Magnet
Mod By Uid 
NO     
Magnet (Oracle)
MAG
MOD_BY_UID 
NO     

MOD_BY_UID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description