Signal Field Definition:

Signal Field Definition Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Rec Type ID		VARCHAR(20)	NO	Epics Record Type: A text field used to categories different EPICS records.
Fld Id		VARCHAR(50)	NO	Field Identifier:
Fld Type Id		VARCHAR(50)	YES	Field Type Identifier
Prmpt Ord		NUMERIC(4, 0)	YES	Prompt Order
Fld Desc		VARCHAR(200)	YES	Field Description: A free form text field used to describe a signal field definition.
Fld Asl		CHAR(6)	YES	Field Asl
Fld Init		VARCHAR(50)	YES	Field Initial
Fld Prmt Grp		VARCHAR(50)	YES	Field Prompt Group
Fld Prmt		VARCHAR(50)	YES	Field Prompt
Fld Special		VARCHAR(50)	YES	Field Special
Fld PP		VARCHAR(50)	YES	Field PP
Fld Int		NUMERIC(4, 0)	YES	Field Int
Fld Base		CHAR(10)	YES	Field Base
Fld Size		NUMERIC(38, 0)	YES	Field Size
Fld Extra		VARCHAR(50)	YES	Field Extra
Sgnl Fld Menu ID		VARCHAR(50)	YES	Signal Field Menu Identifier
Fld Menu Val		VARCHAR(50)	YES	Field Menu Value

Signal Field Definition Keys

Key Name	Key Type	Keys
sgnl_fld_def_pk	PrimaryKey	Rec Type ID, Fld Id

Signal Field Definition Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Signal Field Menu	Non-Identifying	Zero or One to Zero or More				Sgnl Fld Menu ID, Fld Menu Val	NO
Signal Record Type	Identifying	One To Zero or More				Rec Type ID	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Process Variable Snapshot Signal	Non-Identifying	One To Zero or More					NO
Template Signal Field	Identifying	One To Zero or More					NO
Signal Field	Identifying	One To Zero or More					NO

Signal Field Definition Check Constraints

Check Constraint Name

CheckConstraint

Signal Field Definition Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Signal Field Definition Security Types

Name	Current Value

Signal Field Definition Bound Attachments

Name	Current Value

Signal Field Definition Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical KAY.Signal Field Definition	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) Does Not Exist	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

Signal Field Definition Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	EPICS

Signal Field Definition Data Movement Rules

Name

Type

Rule Text/Value