| Equip Id |
| Base Entity | Magnet |
| Attribute Name | Equip Id |
| Logical Rolename | |
| ColumnName | Equip Id |
| RoleName | |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
| Note |
| Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| 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 Entity | Magnet |
| Attribute Name | Partner Id |
| Logical Rolename | |
| ColumnName | Partner Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Partner Identifier: The partner lab magnet name. |
| Note |
| Partner Id Logical Attribute Properties |
| Logical Attribute Name | Partner Id |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Phy Gap Lngth |
| Logical Rolename | |
| ColumnName | Phy Gap Lngth |
| RoleName | |
| Domain | Magnet Large Value |
| Logical Only | NO |
| Definition | Physical Gap Length: Physical gap length (m) |
| Note |
| Phy Gap Lngth Logical Attribute Properties |
| Logical Attribute Name | Phy Gap Lngth |
| Datatype | NUMERIC(14, 10) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Mag Lngth |
| Logical Rolename | |
| ColumnName | Mag Lngth |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Magnetic Length: Effective magnetic length(m) |
| Note |
| Mag Lngth Logical Attribute Properties |
| Logical Attribute Name | Mag Lngth |
| Datatype | NUMERIC(7, 3) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Hor Aper |
| Logical Rolename | |
| ColumnName | Hor Aper |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Horizontal Aperture: Horizontal aperture (m) |
| Note |
| Hor Aper Logical Attribute Properties |
| Logical Attribute Name | Hor Aper |
| Datatype | NUMERIC(14, 10) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Ver Aper |
| Logical Rolename | |
| ColumnName | Ver Aper |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Vertical Aperture: Vertical Aperture(m) |
| Note |
| Ver Aper Logical Attribute Properties |
| Logical Attribute Name | Ver Aper |
| Datatype | NUMERIC(14, 10) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Slope |
| Logical Rolename | |
| ColumnName | Slope |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Slope: The linear fit coefficient of the integrated field (T-M) over current (A), used only for dipole correctors. |
| Note |
| Slope Logical Attribute Properties |
| Logical Attribute Name | Slope |
| Datatype | NUMERIC(14, 10) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Ramp Rate |
| Logical Rolename | |
| ColumnName | Ramp Rate |
| RoleName | |
| Domain | Magnet Default |
| Logical Only | NO |
| Definition | Ramp Rate: The rate of current change between measurement points. (A/sec) |
| Note |
| Ramp Rate Logical Attribute Properties |
| Logical Attribute Name | Ramp Rate |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Meas Wait |
| Logical Rolename | |
| ColumnName | Meas Wait |
| RoleName | |
| Domain | Magnet Default |
| Logical Only | NO |
| Definition | Measure Wait: The time between end of ramp and start of measurement (sec). |
| Note |
| Meas Wait Logical Attribute Properties |
| Logical Attribute Name | Meas Wait |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Final Shim |
| Logical Rolename | |
| ColumnName | Final Shim |
| RoleName | |
| Domain | Magnet Default |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Final Shim |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| 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 Entity | Magnet |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Note Logical Attribute Properties |
| Logical Attribute Name | Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| 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 |
| Modify Date |
| Base Entity | Magnet |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: Date and time when this row was last modified |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | NO |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Modify Date |
NO | ||
| Magnet (Oracle) MAG MOD_DTE |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid |
| Base Entity | Magnet |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | Mod By Uid |
| RoleName | |
| Domain | Userid |
| Logical Only | NO |
| Definition | Modify By Userid: The userid of the person who last changed the Magnet record. |
| Note |
| Mod By Uid Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| 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 |