BEAM_LINE_DVC

BEAM_LINE_DVC_LOC

Logical Entity Name	BEAM_LINE_DVC_LOC
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(40) 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 PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE EPICS_INDEX_TS NOLOGGING STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ), CONSTRAINT BEAM_LINE_DVC_DVC_RF FOREIGN KEY (DVC_ID) REFERENCES EPICS.DVC(DVC_ID) ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE EPICS_TS LOGGING NOPARALLEL STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOCACHE NOCOMPRESS ;
PostSQL

BEAM_LINE_DVC_LOC Columns

ColumnName Domain Datatype NULL Definition

DVC_ID (PK)(FK) VARCHAR2(40) 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 (PK) VARCHAR2(25) NO
Sequence Name: The name used to describe a grouping of devices within the SNS facility.

DSGN_GLBL_COORD_X 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 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 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 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 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 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 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 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 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 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 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 NUMBER(12, 6) YES
Actual Global Coordinate Theta: The global coordinate Theta in meters representing the installed location of the device.

DIST_FROM_STRT 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 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 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 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 EPICS_TS

PctFree 10

PCTUSED 40

MinExtents 1

MaxExtents 2147483645

Initial 64

Next 64

PctIncrease 0

InitTrans 1

MaxTrans 255

Organization Heap

Cache NO

Logging Logged

Parallel NO

Parallel Degrees

Parallel Instances

FREELISTS 1

FREELIST GROUPS 1

Buffer Pool DEFAULT

Table Compression NO

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 1861

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

ColumnName	Domain	Datatype	NULL	Definition
DVC_ID		VARCHAR2(40)	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.
DSGN_GLBL_COORD_X		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		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		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		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		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		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		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		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		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		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		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		NUMBER(12, 6)	YES	Actual Global Coordinate Theta: The global coordinate Theta in meters representing the installed location of the device.
DIST_FROM_STRT		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		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		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.

Key Name	Key Type	Keys
BEAM_LINE_DVC_LOC_PK	PrimaryKey	DVC_ID, SEQ_NM

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
DVC	Identifying	One To Zero or More	BEAM_LINE_DVC_DVC_RF			DVC_ID	NO	NO	NO

STORAGE OPTION	STORAGE VALUE
TABLESPACE	EPICS_TS
PctFree	10
PCTUSED	40
MinExtents	1
MaxExtents	2147483645
Initial	64
Next	64
PctIncrease	0
InitTrans	1
MaxTrans	255
Organization	Heap
Cache	NO
Logging	Logged
Parallel	NO
Parallel Degrees
Parallel Instances
FREELISTS	1
FREELIST GROUPS	1
Buffer Pool	DEFAULT
Table Compression	NO
Row Movement	Disabled

TABLE METRIC	TABLE METRIC VALUE
Current Row Count	1861
Growth	Static
Growth Type	N/A
Growth Period	N/A
Maximum Rows	0
Average Row Size	0

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

Model	Submodel Usage
Logical	Main Model
Logical	EPICS
Logical	XAL Optics
EPICS (Oracle)	Main Model
XAL_OPTICS (Oracle)	Main Model