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.

Invalid Device Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
DVC_ID		VARCHAR(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.
SYS_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".
SUBSYS_ID		VARCHAR(10)	YES	Subsystem Identifier: This Subsystem to which the device is assigned. This field is validated against the Subsystem table. If the value is not found then the Invalid Sub Sys Ind field is set to "Y".
DVC_TYPE_ID		VARCHAR(25)	YES	Device Type Identifier: This Device Type to which the device is assigned. This field is validated against the Dvc Type table. If the value is not found then the Invalid Dvc Type Ind field is set to "Y".
DVC_INST		VARCHAR(25)	YES	Device Instance:
DVC_DESC		VARCHAR(255)	YES	Device Description: A free form text field used to describe a device.
PARENT_DVC_ID	Device Id	VARCHAR(50)	YES	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.
BL_DVC_IND		CHAR(1)	NO	Beam Line Device Indicator: Default is "N"
VIRTUAL_DVC_IND		CHAR(1)	NO
INVALID_ID_IND		CHAR(1)	NO	Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards.
DVC_ID_ALIAS		VARCHAR(40)	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 i
ACT_DVC_IND		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		CHAR(1)	NO	Machine Protection System Device Indicator: Indicates that the device is part of or protected by the MPS.
DVC_DRW_NBR		VARCHAR(50)	YES	Device Drawing Number: The number of the drawing for which the device is documented.
DRW_DVC_ID		VARCHAR(40)	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_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.
OWNER_CAT_ID		VARCHAR(10)	YES	Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories.

Invalid Device Keys

Key Name	Key Type	Keys
PK_INVALID_DVC	PrimaryKey	DVC_ID

Invalid Device Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
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

Invalid Device Check Constraints

Check Constraint Name

CheckConstraint

Invalid Device Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Invalid Device Security Types

Name	Current Value

Invalid Device Bound Attachments

Name	Current Value

Invalid Device Where Used - Model Usage

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

Invalid Device Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	EPICS
EPICS (Oracle)	Main Model

Invalid Device Data Movement Rules

Name

Type

Rule Text/Value