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 | 0 |
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 | 8 |
Percent Null | 0 |
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 | 8 |
Percent Null | 0 |
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 | 4 |
Percent Null | 0 |
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 | 8 |
Percent Null | 0 |
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 | 8 |
Percent Null | 0 |
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 | 8 |
Percent Null | 0 |
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 | 7 |
Percent Null | 0 |
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 | 7 |
Percent Null | 0 |
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 | 7 |
Percent Null | 0 |
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 | 0 |
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 | 7 |
Percent Null | 0 |
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 | 0 |
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 |