Device Sequence Name:   The master list of sequence names used to group devices.

DVC_SEQ_NM Columns

ColumnName	Domain	Datatype	NULL	Definition
Seq Nm		VARCHAR2(25)	NO	Sequence Name: The name used to describe a grouping of devices within the SNS facility.
Total Seq Lngth		NUMBER(12, 6)	YES	Total Sequence Length: The total length for a specific sequence of devices.
PREV_SEQ_NM		VARCHAR2(25)	YES	Previous Sequence Name: The name used to describe a previous grouping of devices within the SNS facility.
ALT_SEQ_NM		VARCHAR2(25)	YES	Alternate Sequence Name: The name used to describe an alternate grouping of devices within the SNS facility.
Dvc Seq Desc	Description	VARCHAR2(255)	YES	Description: Often used in validation tables accompanying an abbreviated identifer.

DVC_SEQ_NM Primary and Unique Keys

Key Name	Key Type	Keys
dvc_seq_nm_pk	PrimaryKey	Seq Nm

DVC_SEQ_NM Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
BEAM_LINE_DVC_LOC	Identifying	One To Zero or More					NO	NO	YES

DVC_SEQ_NM Check Constraints

Check Constraint Name

CheckConstraint

DVC_SEQ_NM 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

DVC_SEQ_NM Partitions

PARTITION PROPERTY

PARTITION PROPERTY VALUE

DVC_SEQ_NM 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

DVC_SEQ_NM Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

DVC_SEQ_NM Security Types

Name	Current Value

DVC_SEQ_NM Bound Attachments

Name	Current Value

DVC_SEQ_NM Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.Device Sequence Name	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.DVC_SEQ_NM	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.DVC_SEQ_NM	NO
XF_ADMIN (Oracle) Does Not Exist	NO

DVC_SEQ_NM Where Used - Submodel Usage

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

DVC_SEQ_NM Data Movement Rules

Name

Type

Rule Text/Value