Beam Line Device Location |
EntityType | Dependent |
Logical Entity Name | Beam Line Device Location |
Default Table Name | BEAM_LINE_DVC_LOC |
Logical Only | NO |
Owner | EPICS |
Definition | Beam Line Device Location: |
Note |
Beam Line Device Location Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Device Identifer | Device Id | VARCHAR(50) | NO | 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. |
Seq Nm | VARCHAR(25) | NO | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
|
SEQ_NM | VARCHAR(25) | NO | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
|
Dsgn Glbl Coord X | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate X: The global coordinate X in meters representing the planned location of the device. |
Dsgn Glbl Coord Y | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate Y: The global coordinate Y in meters representing the planned location of the device. |
Dsgn Glbl Coord Z | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate Z: The global coordinate Z in meters representing the planned location of the device. |
Dsgn Glbl Coord PHI | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate PHI: The global coordinate PHI in meters representing the planned location of the device. |
Dsgn Glbl Coord PSI | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate PSI: The global coordinate PSI in meters representing the planned location of the device. |
Dsgn Glbl Coord Theta | Global Coordinate | NUMERIC(12, 6) | NO | Design Global Coordinate Theta: The global coordinate Theta in meters representing the planned location of the device. |
Dsgn H Aperture | NUMERIC(12, 6) | YES | Design Horizontal Aperture: |
|
Dsgn V Aperture | NUMERIC(12, 6) | YES | Design Vertical Aperture: |
|
Act Glbl Coord X | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate X: The global coordinate X in meters representing the installed location of the device. |
Act Glbl Coord Y | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate Y: The global coordinate Y in meters representing the installed location of the device. |
Act Glbl Coord Z | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate Z: The global coordinate Z in meters representing the installed location of the device. |
Act Glbl Coord PHI | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate PHI: The global coordinate PHI in meters representing the installed location of the device. |
Act Glbl Coord PSI | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate PSI: The global coordinate PSI in meters representing the installed location of the device. |
Act Glbl Coord Theta | Global Coordinate | NUMERIC(12, 6) | YES | Actual Global Coordinate Theta: The global coordinate Theta in meters representing the installed location of the device. |
Dist From Strt | Distance | NUMERIC(12, 6) | YES | 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) |
Phys Lngth | NUMERIC(12, 6) | YES | Physical Length: The effective physical field length in meters. |
|
Z Mdl Offset | Distance | NUMERIC(12, 6) | YES | Z Model Offset: Longitudinal offset to be used in the model (accounts for magnetic field interference). (m) |
Dsgn Usage Ind | CHAR(1) | NO | 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. |
|
Mod By Uid | Mod By Uid | VARCHAR(64) | YES | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
Mod Dte | DATE | YES | Modify Date: The date the record was created or modified. |
Beam Line Device Location Keys |
Key Name | Key Type | Keys |
beam_line_dvc_loc_pk | PrimaryKey | Device Identifer, Seq Nm |
BEAM_LINE_DVC_LOC_SEQ_NM_IDX | Inversion Entry | SEQ_NM |
Beam Line Device Location Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Device Sequence Name | Identifying | One To Zero or More | Seq Nm | NO | |||
Device | Identifying | One To Zero or More | Device Identifer | YES |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Beam Line Device Location Check Constraints |
Check Constraint Name | CheckConstraint |
Beam Line Device Location Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Beam Line Device Location Security Types |
Name | Current Value |
Beam Line Device Location Bound Attachments |
Name | Current Value |
Beam Line Device Location Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EPICS.Beam Line Device Location |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.BEAM_LINE_DVC_LOC |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) EPICS.BEAM_LINE_DVC_LOC |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
Beam Line Device Location Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | EPICS |
Logical | XAL Optics |
EPICS (Oracle) | Main Model |
XAL_OPTICS (Oracle) | Main Model |
Beam Line Device Location Data Movement Rules |
Name | Type | Rule Text/Value |