BEAM_LINE_DVC_LOC |
Logical Entity Name | Beam Line Device Location |
Default Table Name | BEAM_LINE_DVC_LOC |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | EPICS |
Definition | Beam Line Device Location: |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EPICS.BEAM_LINE_DVC_LOC(      DVC_ID                    VARCHAR2(50)      NOT NULL,      "Seq Nm"                  VARCHAR2(25)      NOT NULL,      SEQ_NM                    VARCHAR2(25)      NOT NULL,      "Dsgn Glbl Coord X"       NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn Glbl Coord Y"       NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn Glbl Coord Z"       NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn Glbl Coord PHI"     NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn Glbl Coord PSI"     NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn Glbl Coord Theta"   NUMBER(12, 6)     DEFAULT 0.0 NOT NULL,      "Dsgn H Aperture"         NUMBER(12, 6),      "Dsgn V Aperture"         NUMBER(12, 6),      "Act Glbl Coord X"        NUMBER(12, 6),      "Act Glbl Coord Y"        NUMBER(12, 6),      "Act Glbl Coord Z"        NUMBER(12, 6),      "Act Glbl Coord PHI"      NUMBER(12, 6),      "Act Glbl Coord PSI"      NUMBER(12, 6),      "Act Glbl Coord Theta"    NUMBER(12, 6),      "Dist From Strt"          NUMBER(12, 6),      "Phys Lngth"              NUMBER(12, 6),      "Z Mdl Offset"            NUMBER(12, 6),      "Dsgn Usage Ind"          CHAR(1)           DEFAULT 'Y' NOT NULL,      "Mod By Uid"              VARCHAR2(64),      "Mod Dte"                 DATE,      CONSTRAINT beam_line_dvc_loc_pk PRIMARY KEY (DVC_ID, "Seq Nm")      USING INDEX          LOGGING,      CONSTRAINT BEAM_LINE_DVC_DVC_RF FOREIGN KEY (DVC_ID)      REFERENCES EPICS.DVC(DVC_ID),      CONSTRAINT RefDVC_SEQ_NM2391 FOREIGN KEY ("Seq Nm")      REFERENCES EPICS.DVC_SEQ_NM("Seq Nm") ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
BEAM_LINE_DVC_LOC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
DVC_ID | Device Id | VARCHAR2(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 | VARCHAR2(25) | NO | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
|
SEQ_NM | VARCHAR2(25) | NO | Sequence Name: The name used to describe a grouping of devices within the SNS facility. |
|
Dsgn Glbl Coord X | Global Coordinate | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(12, 6) | NO | Design Global Coordinate Theta: The global coordinate Theta in meters representing the planned location of the device. |
Dsgn H Aperture | NUMBER(12, 6) | YES | Design Horizontal Aperture: |
|
Dsgn V Aperture | NUMBER(12, 6) | YES | Design Vertical Aperture: |
|
Act Glbl Coord X | Global Coordinate | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(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 | NUMBER(12, 6) | YES | Actual Global Coordinate Theta: The global coordinate Theta in meters representing the installed location of the device. |
Dist From Strt | Distance | NUMBER(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 | NUMBER(12, 6) | YES | Physical Length: The effective physical field length in meters. |
|
Z Mdl Offset | Distance | NUMBER(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 | VARCHAR2(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_DVC_LOC Primary and Unique Keys |
Key Name | Key Type | Keys |
beam_line_dvc_loc_pk | PrimaryKey | DVC_ID, Seq Nm |
BEAM_LINE_DVC_LOC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
DVC_SEQ_NM | Identifying | One To Zero or More | Seq Nm | NO | NO | NO | |||
DVC | Identifying | One To Zero or More | BEAM_LINE_DVC_DVC_RF | DVC_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BEAM_LINE_DVC_LOC Check Constraints |
Check Constraint Name | CheckConstraint |
BEAM_LINE_DVC_LOC Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
BEAM_LINE_DVC_LOC Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BEAM_LINE_DVC_LOC Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
BEAM_LINE_DVC_LOC Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
BEAM_LINE_DVC_LOC Security Types |
Name | Current Value |
BEAM_LINE_DVC_LOC Bound Attachments |
Name | Current Value |
BEAM_LINE_DVC_LOC 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_DVC_LOC 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_DVC_LOC Data Movement Rules |
Name | Type | Rule Text/Value |