Integrated Control Systems Communication Device:

ICS Communication Device Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Device Identifer	Device Id	VARCHAR(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.
IP Address		VARCHAR(50)	YES	Internet Protocol Address: The internet protocol address assigned to the ICS Comm Device.
Ethernet Address		VARCHAR(30)	YES	Ethernet Address: The Media Access Descriptor (MAC) Address for a network device.
Network Mask	Net Mask	VARCHAR(50)	YES	Network Mask: The network mask for the device.
Network Domain	Net Domain	VARCHAR(50)	YES	Net Domain: Network Domain Name.
VLAN Number	VLAN Nbr	VARCHAR(30)	YES	Virtual Local Area Network Number:
ICS Network Name	ICS Net Nm	VARCHAR(50)	YES	Integrated Control Systems Network Name: Internal name for controls devices attached to the network.
Sw 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.
Sw Port Nbr		NUMERIC(0, 0)	YES	Switch Port: The switch port to which the IOC connects.
TSrv 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.
TSrv Port Nbr		VARCHAR(50)	YES
RPC 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.
RPC Address		VARCHAR(30)	YES	RPC Address: The address in the chain the RPC is located.
Notes		VARCHAR(2000)	YES
Dsgn Cab Slot Bgn	Cab Slot	NUMERIC(3, 0)	YES	Design Cabinet Beginning Slot Number: The first slot the equipment occupies in the cabinet.
Dsgn Cab Slot End	Cab Slot	NUMERIC(3, 0)	YES	Design Cabinet Ending Slot Number: If more than one slot is required for equipment, this field indicates the last slot number used.
Dsgn Cab Slot Pos Ind	Cab Slot Ind	CHAR(1)	NO	Design Cabinet Slot Position Indicator: Used to indicate how the device is installed into the cabinet. Valid values include "F - Front" or "B-Back".
Pos Within Slots		NUMERIC(3, 0)	YES	Position Within Slots: Indicates the relative position of the device in a slot where more than one device is used.
IOC Boot Server Indicator	Indicator	CHAR(1)	NO
Operating Status Indicator	Indicator	CHAR(1)	NO

ICS Communication Device Keys

Key Name	Key Type	Keys
ics_comm_dvc_pk	PrimaryKey	Device Identifer

ICS Communication Device Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Device	Identifying	One To Zero or More				Device Identifer	YES
Device	Non-Identifying	Zero or One to Zero or More				RPC Dvc Id	YES
Device	Non-Identifying	Zero or One to Zero or More				Sw Dvc Id	YES
Device	Non-Identifying	Zero or One to Zero or More				TSrv Dvc Id	YES

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

ICS Communication Device Check Constraints

Check Constraint Name

CheckConstraint

ICS Communication Device Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

ICS Communication Device Security Types

Name	Current Value

ICS Communication Device Bound Attachments

Name	Current Value

ICS Communication Device Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.ICS Communication 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.ICS_COMM_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

ICS Communication Device Where Used - Submodel Usage

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

ICS Communication Device Data Movement Rules

Name

Type

Rule Text/Value