Device:  A collection of one or more types of  equipment used to perform a function.  A device is "generic" in that it's parameters are static.  Equipment components may be swapped in and out without changing the overall device parameters.  A device may consist of one equipment component or be composed of multiple pieces of equipment.

Device Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Device Identifer	Device Id	VARCHAR(50)	NO	Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
System Identifier	System Id	VARCHAR(10)	YES	System Identifier: This System to which the device is assigned. This field is validated against the System table. If the value is not found then the Invalid Sys Ind field is set to "Y".
Subsystem Identifer	Subsystem Identifier	VARCHAR(10)	YES
Dvc Type Id		VARCHAR(25)	YES	Device Type Identifier: The unique identifier for a device type.
Dvc Inst		VARCHAR(25)	YES	Device Instance
Parent Dvc Id	Device Id	VARCHAR(50)	YES	Parent Device Identifier: If the device is part of another device this field will contain the device identifier for the parent device.
Dvc Desc	Description	VARCHAR(255)	YES	Device Description: A free form text field used to describe a device.
BL Dvc Ind	Indicator	CHAR(1)	NO	Beam Line Device Indicator: Default is "N"
Virtual Dvc Ind		CHAR(1)	NO
Invalid Id Ind	Indicator	CHAR(1)	NO	Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards.
Dvc Id Alias		VARCHAR(75)	YES	Device Identifier Alias: This field is used to the "to-be" device identifier. Currently non-standard device identifiers are stored in the device identifier field. The alias field is used to store the device identifier that will later become the actual identifier for the device.
Act Dvc Ind	Indicator	CHAR(1)	YES	Active Device Indicator: Indicates that the device is in active use. (i.e. If device is still in design and not yet functional the indicator will be set to N)
MPS Dvc Ind	Indicator	CHAR(1)	NO	Machine Protection System Device Inidcator: Indicates the device is part of the MPS or is protected by the MPS.
Criticality Identifier		VARCHAR(6)	NO
Owner Cat Id		VARCHAR(10)	YES	Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories.
Owner Badge Number	Badge Number	VARCHAR(10)	YES
ORNL Property Number		VARCHAR(10)	YES	ORNL Property Number: The property number assigned to ORNL porperty which falls into certain categories and which are above a certain value . This attribute rightly belongs to the equipment entity but has been added to the Device as a concession.
Dvc Drw Nbr		VARCHAR(50)	YES	Device Drawing Number: The number of the drawing for which the device is documented.
Drw Dvc Id	Device Id	VARCHAR(50)	YES	Drawing Device Id: The device id as it was specified on the drawing. The device very well may have been renamed since it was defined on a drawing.
Mod Dte		DATE	YES	Modify Date: The date the record was created or modified.
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.

Device Keys

Key Name	Key Type	Keys
Device_pk	PrimaryKey	Device Identifer
DVC_ID_ALIAS_IDX	Alternate Key	Dvc Id Alias
PRNT_DVC_ID	Inversion Entry	Parent Dvc Id

Device Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Device Criticality	Non-Identifying	One To Zero or More				Criticality Identifier	NO
Device Type	Non-Identifying	Zero or One to Zero or More				Dvc Type Id	NO
Subsystem	Non-Identifying	Zero or One to Zero or More				Subsystem Identifer	NO
System	Non-Identifying	Zero or One to Zero or More				System Identifier	NO
Device	Non-Identifying	Zero or One to Zero or More				Parent Dvc Id	YES

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Magnet Device	Non-Identifying	One To Zero or More					NO
Operations Checklist	Non-Identifying	One To Zero or More					NO
Communications Device	Identifying	One To Zero or More					NO
Communications Device	Non-Identifying	One To Zero or More					NO
Diagnostics Motor Drive Device	Identifying	One To Zero or More					YES
Diag Elex Dvc	Identifying	One To Zero or More					YES
MPS Channel Audit	Non-Identifying	One To Zero or More					NO
MPS Channel Audit	Non-Identifying	One To Zero or More					NO
Beam Loss Monitor Device	Identifying	One To Zero or More					YES
Neutron Detector Device	Identifying	One To Zero or More					YES
High Voltage Power Supply Device	Identifying	One To Zero or More					YES
MPS Interface Device	Identifying	One To Zero or More					YES
Digital Input Output Device	Identifying	One To Zero or More					YES
Analog Digital Conversion Device	Identifying	One To Zero or More					YES
Analog Front End Device	Identifying	One To Zero or More					YES
Digital Analog Converter Device	Identifying	One To Zero or More					YES
Internet Protocol Carrier Device	Identifying	One To Zero or More					YES
Beam Loss Monitor Device	Non-Identifying	One To Zero or More					NO
MPS Interface Device	Non-Identifying	One To Zero or More					NO
Machine Mode	Non-Identifying	One To Zero or More					NO
Bypass Device	Identifying	One To Zero or More					NO
IOC Configuration File	Identifying	One To Zero or More					NO
ICS Communication Software	Identifying	One To Zero or More					NO
Digital Analog Converter Device	Non-Identifying	One To Zero or More					NO
Device Outage	Identifying	One To Zero or More					NO
Device Outage Affected Devices	Non-Identifying	One To Zero or More					NO
Laser Transfer Line Control Device	Identifying	One To Zero or More					YES
Camera Control Unit Device	Identifying	One To Zero or More					YES
Chipmunk Device	Identifying	One To Zero or More					YES
Beam Line Device Location	Identifying	One To Zero or More					NO
Beam Line Device Energy	Identifying	One To Zero or More					NO
Beam Position Monitor Device	Identifying	One To Zero or More					YES
Device Setting	Identifying	One To Zero or More					NO
EPICS Group	Non-Identifying	One To Zero or More					NO
Device Physical Location	Identifying	One To Zero or More					NO
Signal Record	Non-Identifying	One To Zero or More					NO
Equipment Device Assignment	Identifying	One to One or More					NO
Analog Front End Device	Non-Identifying	One To Zero or More					NO
Beam Loss Monitor Device	Non-Identifying	One To Zero or More					NO
Beam Loss Monitor Device	Non-Identifying	One To Zero or More					NO
Beam Loss Monitor Device	Non-Identifying	One To Zero or More					NO
Device Device Type Software Association	Identifying	One To Zero or More					NO
Device Port Assignment	Identifying	One To Zero or More					NO
ICS Communication Device	Identifying	One To Zero or More					YES
ICS Communication Operation Environment	Identifying	One To Zero or More					NO
IOC DBD File Asgn	Identifying	One To Zero or More					NO
Input Output Controller Device	Identifying	One To Zero or More					YES
Machine Mode	Non-Identifying	Zero or One to Zero or More					NO
Neutron Detector Device	Non-Identifying	One To Zero or More					NO
Neutron Detector Device	Non-Identifying	One To Zero or More					NO
Neutron Detector Device	Non-Identifying	One To Zero or More					NO
Invalid Device	Non-Identifying	One To Zero or More					NO
Device Port Assignment	Identifying	One To Zero or More					NO
Functional Device Group Item	Identifying	One To Zero or More					NO
Functional Device Group Item	Identifying	One To Zero or More					NO
ICS Communication Device	Non-Identifying	One To Zero or More					NO
ICS Communication Device	Non-Identifying	One To Zero or More					NO
ICS Communication Device	Non-Identifying	One To Zero or More					NO
ICS Multiport Communications Device	Identifying	One To Zero or More					YES
ICS Multiport Communications Device	Non-Identifying	One To Zero or More					NO
ICS Multiport Communications Device	Non-Identifying	One To Zero or More					NO
ICS Multiport Communications Device	Non-Identifying	One To Zero or More					NO
IOC Device Assignment	Identifying	One To Zero or More					NO
IOC Device Assignment	Identifying	One To Zero or More					NO
Input Output Controller Device	Non-Identifying	Zero or One to Zero or More					NO
Input Output Controller Device	Non-Identifying	One To Zero or More					NO
Input Output Controller Device	Non-Identifying	One To Zero or More					NO
Machine Mode	Non-Identifying	One To Zero or More					NO
Magnet Device	Identifying	One To Zero or More					YES
MPS Signal Parameter	Identifying	One To Zero or More					NO
Device	Non-Identifying	One To Zero or More					NO
Power Supply Device	Identifying	One To Zero or More					YES
Power Supply Controller Device	Identifying	One To Zero or More					YES
Power Supply Interface Device	Identifying	One To Zero or More					YES
Power Supply Interface Device	Non-Identifying	One To Zero or More					NO
Power Device	Identifying	One To Zero or More	pwr_dvc_dvc_rf				NO
Power Device	Non-Identifying	One To Zero or More	pwr_to_dvc_dvc_rf				NO
Radio Frequency Cavity Device	Identifying	One To Zero or More					YES
Signal	Identifying	One To Zero or More					NO

Device Check Constraints

Check Constraint Name

CheckConstraint

Device Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Device Security Types

Name	Current Value

Device Bound Attachments

Name	Current Value

Device Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.Device	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) EPICS.DVC	NO
ENGA (Oracle) Does Not Exist	NO
EPICS (Oracle) EPICS.DVC	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) EPICS.DVC	NO
Logbook (Oracle) Does Not Exist	NO
Magnet (Oracle) Does Not Exist	NO
MPS (Oracle) DVC	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	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Device Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Diagnostics
Logical	Diagnostics MPS
Logical	EPICS
Logical	Machine Mode
Logical	Power Supply
Logical	XAL Optics
DIAG_MPS (Oracle)	Main Model
EPICS (Oracle)	Main Model
IRMISBase (Oracle)	Main Model
MPS (Oracle)	Main Model
XAL_OPTICS (Oracle)	Main Model

Device Data Movement Rules

Name

Type

Rule Text/Value