Signal Record: The master list of valid EPICS Records.

Full Name:  EPICS Record

Description:

Sgnl_Rec Columns

ColumnName	Domain	Datatype	NULL	Definition
SGNL_ID	Signal Id	VARCHAR2(75)	NO	Signal Identifier:
DVC_ID	Device Id	VARCHAR2(50)	YES	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.
SGNL_ID_DESC	Description	VARCHAR2(255)	YES	Description: Often used in validation tables accompanying an abbreviated identifer.
Mchn Prot Ind	Indicator	CHAR(1)	NO	Machine Protection Indicator: Default is "N"
Ext Src		VARCHAR2(200)	YES	External Source: The originating tool from which the signal was created in cases where the signal was imported from an external source.
Multimode Ind	Indicator	CHAR(1)	NO	Multimode Indicator: Default is "N"
INVALID_ID_IND		CHAR(1)	NO
Sgnl Nm	Signal Name	VARCHAR2(50)	YES	Signal Name: This field is parsed from the signal identifier and verified against the DVC Type Sgnl table.
Sgnl Id Alias	Signal Id	VARCHAR2(75)	YES	Signal Identifier Alias: This field is used to the "to-be" signal identifier. Currently non-standard signal identifiers are stored in the signal identifier field. The alias field is used to store the signal identifier that will later become the actual identifier for the signal.
Bulk Ind	Indicator	CHAR(1)	NO	Bulk Indicator: A signal that provides field set for multiple devices. Default is "N."
Arch Ind	Indicator	CHAR(1)	NO	Archive Indicator: Indicates that this signal is to be included in the channel archiver, archived at the interval specified in the arch_freq attribute if the arch_type is Periodic.
Arch Freq		NUMBER(6, 2)	NO	Archive Frequency: The interval in seconds or fractions of seconds at which the channel archiver will save the process variable value when in periodic mode. (e.g. .5)
Arch Type		VARCHAR2(10)	NO	Archiver Type: Indicates whether the signal should be archived as Periodic or Monitor.
Cbl Cmplt Ind	Indicator	CHAR(1)	NO	Cabling Complete Indicator: Indicates that the cable on which the signal traverses has been pulled and signed off.
Alarm Ind	Indicator	CHAR(1)	NO	Alarm Indicator: Indicates that the signal can be alarmed.
ACTIVE_IND		CHAR(1)	NO	Active Indicator: Indicates that the signal is currently in use in the control system.
Mod By Uid	Mod By Uid	VARCHAR2(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.

Sgnl_Rec Primary and Unique Keys

Key Name	Key Type	Keys
sgnl_rec_pk	PrimaryKey	SGNL_ID

Sgnl_Rec Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
DVC	Non-Identifying	Zero or One to Zero or More	dvc_sgnl_rec_rf			DVC_ID	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Sgnl_Rec Check Constraints

Check Constraint Name

CheckConstraint

Sgnl_Rec 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

Sgnl_Rec Partitions

PARTITION PROPERTY

PARTITION PROPERTY VALUE

Sgnl_Rec 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

Sgnl_Rec Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Sgnl_Rec Security Types

Name	Current Value

Sgnl_Rec Bound Attachments

Name	Current Value

Sgnl_Rec Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical Signal Record	NO
ALARM_MYSQL (MySQL) Does Not Exist	NO
ALARM_ORACLE (Oracle) Does Not Exist	NO
BICS (Oracle) Does Not Exist	NO
BLM (Oracle) SGNL_REC	NO
BYPASS_REQ (Oracle) Does Not Exist	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) Does Not Exist	NO
DIAG (Oracle) SGNL_REC	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) SGNL_REC	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) Sgnl_Rec	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Sgnl_Rec Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	BLM
Logical	Diagnostics
Logical	EPICS
Logical	Machine Mode
Logical	PV Logger
Logical	XAL Optics
BLM (Oracle)	Main Model
DIAG (Oracle)	Main Model
PV_LOGGER (Oracle)	Main Model
XAL_OPTICS (Oracle)	Main Model

Sgnl_Rec Data Movement Rules

Name

Type

Rule Text/Value