| Device Identifer |
| Base Entity | Beam Line Device Location |
| Attribute Name | Device Identifer |
| Logical Rolename | |
| ColumnName | DVC_ID |
| RoleName | |
| Domain | Device Id |
| Logical Only | NO |
| Definition | Device Identifier: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
| Note |
| Device Identifer Logical Attribute Properties |
| Logical Attribute Name | Device Identifer |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Device Identifer Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Device Identifer Security Types |
| Name | Current Value |
| Device Identifer Bound Attachments |
| Name | Current Value |
| Device Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Device Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Device Identifer |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC DVC_ID |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC DVC_ID |
NO |
| Device Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Seq Nm |
| Base Entity | Beam Line Device Location |
| Attribute Name | Seq Nm |
| Logical Rolename | |
| ColumnName | Seq Nm |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
| Note |
| Seq Nm Logical Attribute Properties |
| Logical Attribute Name | Seq Nm |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Seq Nm Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Seq Nm Security Types |
| Name | Current Value |
| Seq Nm Bound Attachments |
| Name | Current Value |
| Seq Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Seq Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Seq Nm |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Seq Nm |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Seq Nm |
NO |
| Seq Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Seq Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Seq Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Seq Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SEQ_NM |
| Base Entity | Beam Line Device Location |
| Attribute Name | SEQ_NM |
| Logical Rolename | |
| ColumnName | SEQ_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
| Note |
| SEQ_NM Logical Attribute Properties |
| Logical Attribute Name | SEQ_NM |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| SEQ_NM Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| SEQ_NM Security Types |
| Name | Current Value |
| SEQ_NM Bound Attachments |
| Name | Current Value |
| SEQ_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SEQ_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location SEQ_NM |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC SEQ_NM |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC SEQ_NM |
NO |
| SEQ_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SEQ_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SEQ_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SEQ_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord X |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord X |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord X |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate X: The global coordinate X in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord X Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord X |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord X Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord X Security Types |
| Name | Current Value |
| Dsgn Glbl Coord X Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord X Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord X Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord X |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord X |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord X |
NO |
| Dsgn Glbl Coord X Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord X Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord X Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord X Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Y |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord Y |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord Y |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate Y: The global coordinate Y in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord Y Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord Y |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord Y Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord Y Security Types |
| Name | Current Value |
| Dsgn Glbl Coord Y Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord Y Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord Y Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord Y |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Y |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Y |
NO |
| Dsgn Glbl Coord Y Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Y Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Y Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Y Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Z |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord Z |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord Z |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate Z: The global coordinate Z in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord Z Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord Z |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord Z Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord Z Security Types |
| Name | Current Value |
| Dsgn Glbl Coord Z Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord Z Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord Z Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord Z |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Z |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Z |
NO |
| Dsgn Glbl Coord Z Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Z Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Z Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Z Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PHI |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord PHI |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord PHI |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate PHI: The global coordinate PHI in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord PHI Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord PHI |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord PHI Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord PHI Security Types |
| Name | Current Value |
| Dsgn Glbl Coord PHI Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord PHI Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord PHI Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord PHI |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord PHI |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord PHI |
NO |
| Dsgn Glbl Coord PHI Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PHI Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PHI Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PHI Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PSI |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord PSI |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord PSI |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate PSI: The global coordinate PSI in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord PSI Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord PSI |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord PSI Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord PSI Security Types |
| Name | Current Value |
| Dsgn Glbl Coord PSI Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord PSI Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord PSI Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord PSI |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord PSI |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord PSI |
NO |
| Dsgn Glbl Coord PSI Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PSI Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PSI Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord PSI Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Theta |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Glbl Coord Theta |
| Logical Rolename | |
| ColumnName | Dsgn Glbl Coord Theta |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Design Global Coordinate Theta: The global coordinate Theta in meters representing the planned location of the device. |
| Note |
| Dsgn Glbl Coord Theta Logical Attribute Properties |
| Logical Attribute Name | Dsgn Glbl Coord Theta |
| Datatype | NUMERIC(12, 6) |
| Nullable | NO |
| Dsgn Glbl Coord Theta Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0.0 |
| Bound Default |
| Dsgn Glbl Coord Theta Security Types |
| Name | Current Value |
| Dsgn Glbl Coord Theta Bound Attachments |
| Name | Current Value |
| Dsgn Glbl Coord Theta Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Glbl Coord Theta Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Glbl Coord Theta |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Theta |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Glbl Coord Theta |
NO |
| Dsgn Glbl Coord Theta Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Theta Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Theta Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Glbl Coord Theta Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn H Aperture |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn H Aperture |
| Logical Rolename | |
| ColumnName | Dsgn H Aperture |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Design Horizontal Aperture: |
| Note |
| Dsgn H Aperture Logical Attribute Properties |
| Logical Attribute Name | Dsgn H Aperture |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Dsgn H Aperture Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Dsgn H Aperture Security Types |
| Name | Current Value |
| Dsgn H Aperture Bound Attachments |
| Name | Current Value |
| Dsgn H Aperture Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn H Aperture Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn H Aperture |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn H Aperture |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn H Aperture |
NO |
| Dsgn H Aperture Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn H Aperture Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn H Aperture Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn H Aperture Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn V Aperture |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn V Aperture |
| Logical Rolename | |
| ColumnName | Dsgn V Aperture |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Design Vertical Aperture: |
| Note |
| Dsgn V Aperture Logical Attribute Properties |
| Logical Attribute Name | Dsgn V Aperture |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Dsgn V Aperture Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Dsgn V Aperture Security Types |
| Name | Current Value |
| Dsgn V Aperture Bound Attachments |
| Name | Current Value |
| Dsgn V Aperture Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn V Aperture Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn V Aperture |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn V Aperture |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn V Aperture |
NO |
| Dsgn V Aperture Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn V Aperture Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn V Aperture Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn V Aperture Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord X |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord X |
| Logical Rolename | |
| ColumnName | Act Glbl Coord X |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate X: The global coordinate X in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord X Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord X |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord X Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord X Security Types |
| Name | Current Value |
| Act Glbl Coord X Bound Attachments |
| Name | Current Value |
| Act Glbl Coord X Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord X Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord X |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord X |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord X |
NO |
| Act Glbl Coord X Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord X Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord X Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord X Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Y |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord Y |
| Logical Rolename | |
| ColumnName | Act Glbl Coord Y |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate Y: The global coordinate Y in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord Y Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord Y |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord Y Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord Y Security Types |
| Name | Current Value |
| Act Glbl Coord Y Bound Attachments |
| Name | Current Value |
| Act Glbl Coord Y Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord Y Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord Y |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Y |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Y |
NO |
| Act Glbl Coord Y Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Y Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Y Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Y Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Z |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord Z |
| Logical Rolename | |
| ColumnName | Act Glbl Coord Z |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate Z: The global coordinate Z in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord Z Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord Z |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord Z Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord Z Security Types |
| Name | Current Value |
| Act Glbl Coord Z Bound Attachments |
| Name | Current Value |
| Act Glbl Coord Z Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord Z Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord Z |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Z |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Z |
NO |
| Act Glbl Coord Z Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Z Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Z Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Z Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PHI |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord PHI |
| Logical Rolename | |
| ColumnName | Act Glbl Coord PHI |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate PHI: The global coordinate PHI in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord PHI Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord PHI |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord PHI Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord PHI Security Types |
| Name | Current Value |
| Act Glbl Coord PHI Bound Attachments |
| Name | Current Value |
| Act Glbl Coord PHI Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord PHI Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord PHI |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord PHI |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord PHI |
NO |
| Act Glbl Coord PHI Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PHI Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PHI Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PHI Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PSI |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord PSI |
| Logical Rolename | |
| ColumnName | Act Glbl Coord PSI |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate PSI: The global coordinate PSI in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord PSI Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord PSI |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord PSI Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord PSI Security Types |
| Name | Current Value |
| Act Glbl Coord PSI Bound Attachments |
| Name | Current Value |
| Act Glbl Coord PSI Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord PSI Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord PSI |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord PSI |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord PSI |
NO |
| Act Glbl Coord PSI Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PSI Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PSI Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord PSI Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Theta |
| Base Entity | Beam Line Device Location |
| Attribute Name | Act Glbl Coord Theta |
| Logical Rolename | |
| ColumnName | Act Glbl Coord Theta |
| RoleName | |
| Domain | Global Coordinate |
| Logical Only | NO |
| Definition | Actual Global Coordinate Theta: The global coordinate Theta in meters representing the installed location of the device. |
| Note |
| Act Glbl Coord Theta Logical Attribute Properties |
| Logical Attribute Name | Act Glbl Coord Theta |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Act Glbl Coord Theta Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Act Glbl Coord Theta Security Types |
| Name | Current Value |
| Act Glbl Coord Theta Bound Attachments |
| Name | Current Value |
| Act Glbl Coord Theta Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Glbl Coord Theta Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Act Glbl Coord Theta |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Theta |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Act Glbl Coord Theta |
NO |
| Act Glbl Coord Theta Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Theta Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Theta Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Glbl Coord Theta Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dist From Strt |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dist From Strt |
| Logical Rolename | |
| ColumnName | Dist From Strt |
| RoleName | |
| Domain | Distance |
| Logical Only | NO |
| Definition | Distance From Start: Distance from the start of the beam line If the device if part of the Ring, the distance is from the beginning of the Ring. i.e. foil (m) |
| Note |
| Dist From Strt Logical Attribute Properties |
| Logical Attribute Name | Dist From Strt |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Dist From Strt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dist From Strt Security Types |
| Name | Current Value |
| Dist From Strt Bound Attachments |
| Name | Current Value |
| Dist From Strt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dist From Strt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dist From Strt |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dist From Strt |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dist From Strt |
NO |
| Dist From Strt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dist From Strt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dist From Strt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dist From Strt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phys Lngth |
| Base Entity | Beam Line Device Location |
| Attribute Name | Phys Lngth |
| Logical Rolename | |
| ColumnName | Phys Lngth |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Physical Length: The effective physical field length in meters. |
| Note |
| Phys Lngth Logical Attribute Properties |
| Logical Attribute Name | Phys Lngth |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Phys Lngth Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Phys Lngth Security Types |
| Name | Current Value |
| Phys Lngth Bound Attachments |
| Name | Current Value |
| Phys Lngth Data Movement Rules |
| Name | Type | Rule Text/Value |
| Phys Lngth Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Phys Lngth |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Phys Lngth |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Phys Lngth |
NO |
| Phys Lngth Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phys Lngth Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phys Lngth Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phys Lngth Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Z Mdl Offset |
| Base Entity | Beam Line Device Location |
| Attribute Name | Z Mdl Offset |
| Logical Rolename | |
| ColumnName | Z Mdl Offset |
| RoleName | |
| Domain | Distance |
| Logical Only | NO |
| Definition | Z Model Offset: Longitudinal offset to be used in the model (accounts for magnetic field interference). (m) |
| Note |
| Z Mdl Offset Logical Attribute Properties |
| Logical Attribute Name | Z Mdl Offset |
| Datatype | NUMERIC(12, 6) |
| Nullable | YES |
| Z Mdl Offset Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Z Mdl Offset Security Types |
| Name | Current Value |
| Z Mdl Offset Bound Attachments |
| Name | Current Value |
| Z Mdl Offset Data Movement Rules |
| Name | Type | Rule Text/Value |
| Z Mdl Offset Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Z Mdl Offset |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Z Mdl Offset |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Z Mdl Offset |
NO |
| Z Mdl Offset Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Z Mdl Offset Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Z Mdl Offset Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Z Mdl Offset Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Usage Ind |
| Base Entity | Beam Line Device Location |
| Attribute Name | Dsgn Usage Ind |
| Logical Rolename | |
| ColumnName | Dsgn Usage Ind |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Design Usage Indicator: Indicates if the current device is in use. There are several magnets that are installed but are not hooked up to power supplies due to funding reasons. As such, these devices should be ignored for most calculations but their coordinates are needed for installation purposes. This attribute will eventually be dropped from the entity. |
| Note |
| Dsgn Usage Ind Logical Attribute Properties |
| Logical Attribute Name | Dsgn Usage Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Dsgn Usage Ind Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'Y' | ||
| Bound Default |
| Dsgn Usage Ind Security Types |
| Name | Current Value |
| Dsgn Usage Ind Bound Attachments |
| Name | Current Value |
| Dsgn Usage Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dsgn Usage Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Line Device Location Dsgn Usage Ind |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Usage Ind |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC Dsgn Usage Ind |
NO |
| Dsgn Usage Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Usage Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Usage Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dsgn Usage Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid |
| Base Entity | Beam Line Device Location |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | Mod By Uid |
| RoleName | |
| Domain | Mod By Uid |
| Logical Only | NO |
| Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
| Note |
| Mod By Uid Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | YES |
| 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 Beam Line Device Location Mod By Uid |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Mod By Uid |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC 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 |
| Mod Dte |
| Base Entity | Beam Line Device Location |
| Attribute Name | Mod Dte |
| Logical Rolename | |
| ColumnName | Mod Dte |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Modify Date: The date the record was created or modified. |
| Note |
| Mod Dte Logical Attribute Properties |
| Logical Attribute Name | Mod Dte |
| Datatype | DATE |
| Nullable | YES |
| 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 Beam Line Device Location Mod Dte |
NO | ||
| EPICS (Oracle) BEAM_LINE_DVC_LOC Mod Dte |
NO | ||
| XAL_OPTICS (Oracle) BEAM_LINE_DVC_LOC 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 |