| DVC_ID |
| Base Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DVC_ID |
| ColumnName | DVC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 |
| DVC_ID Column Properties |
| Datatype | VARCHAR2(40) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DVC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| DVC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DVC_ID Security Types |
| Name | Current Value |
| DVC_ID Bound Attachments |
| Name | Current Value |
| DVC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DVC_ID 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 |
| DVC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SEQ_NM |
| Base Object | BEAM_LINE_DVC_LOC |
| Attribute Name | SEQ_NM |
| ColumnName | SEQ_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
| Note |
| SEQ_NM Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SEQ_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_X |
| ColumnName | DSGN_GLBL_COORD_X |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_X Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_Y |
| ColumnName | DSGN_GLBL_COORD_Y |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_Y Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_Z |
| ColumnName | DSGN_GLBL_COORD_Z |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_Z Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_PHI |
| ColumnName | DSGN_GLBL_COORD_PHI |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_PHI Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_PSI |
| ColumnName | DSGN_GLBL_COORD_PSI |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_PSI Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_GLBL_COORD_THETA |
| ColumnName | DSGN_GLBL_COORD_THETA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_GLBL_COORD_THETA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_H_APERTURE |
| ColumnName | DSGN_H_APERTURE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Design Horizontal Aperture: |
| Note |
| DSGN_H_APERTURE Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_H_APERTURE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 81 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_V_APERTURE |
| ColumnName | DSGN_V_APERTURE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Design Vertical Aperture: |
| Note |
| DSGN_V_APERTURE Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_V_APERTURE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 81 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_X |
| ColumnName | ACT_GLBL_COORD_X |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_X Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 96 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_Y |
| ColumnName | ACT_GLBL_COORD_Y |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_Y Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 96 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_Z |
| ColumnName | ACT_GLBL_COORD_Z |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_Z Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 96 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_PHI |
| ColumnName | ACT_GLBL_COORD_PHI |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_PHI Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 98 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_PSI |
| ColumnName | ACT_GLBL_COORD_PSI |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_PSI Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 98 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | ACT_GLBL_COORD_THETA |
| ColumnName | ACT_GLBL_COORD_THETA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_GLBL_COORD_THETA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 98 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DIST_FROM_STRT |
| ColumnName | DIST_FROM_STRT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIST_FROM_STRT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 11 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | PHYS_LNGTH |
| ColumnName | PHYS_LNGTH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Physical Length: The effective physical field length in meters. |
| Note |
| PHYS_LNGTH Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHYS_LNGTH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 69 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | Z_MDL_OFFSET |
| ColumnName | Z_MDL_OFFSET |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Z Model Offset: Longitudinal offset to be used in the model (accounts for magnetic field interference). (m) |
| Note |
| Z_MDL_OFFSET Column Properties |
| Datatype | NUMBER(12, 6) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Z_MDL_OFFSET Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 100 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | DSGN_USAGE_IND |
| ColumnName | DSGN_USAGE_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DSGN_USAGE_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | MOD_BY_UID |
| ColumnName | MOD_BY_UID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_UID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 34 |
| 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 Object | BEAM_LINE_DVC_LOC |
| Attribute Name | MOD_DTE |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Modify Date: The date the record was created or modified. |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 34 |
| 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 |