DVC_ID |
Base Object | BEAM_LINE_DVC_LOC |
Attribute Name | Device Identifer |
ColumnName | DVC_ID |
Logical Rolename | Device Identifer |
RoleName | |
Domain | Device Id |
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(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
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 | 25 |
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 |
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 | 25 |
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 | Global Coordinate |
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 | Global Coordinate |
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 | Global Coordinate |
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 | Global Coordinate |
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 | Global Coordinate |
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 | Global Coordinate |
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 | 0 |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Global Coordinate |
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 | 0 |
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 | Distance |
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 | 0 |
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 | 0 |
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 | Distance |
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 | 0 |
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 | Mod By Uid |
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 | 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 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 | 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 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 |