SGNL_REC 
Logical Entity Name  Signal Record 
Default Table Name  SGNL_REC 
Oracle Temporary Table  NO 
Physical Only  NO 
Do Not Generate  False 
Owner   
Definition  
Signal Record: The master list of valid EPICS Records.
 
Note  
Full Name:  EPICS Record

Description:
 
PreSQL   
DDL Code  CREATE TABLE SGNL_REC(
     SGNL_ID            VARCHAR2(75)      NOT NULL,
     SGNL_ID_DESC       VARCHAR2(255),
     MCHN_PROT_IND      CHAR(1)           DEFAULT 'N' NOT NULL,
     EXT_SRC            VARCHAR2(200),
     MULTIMODE_IND      CHAR(1)           DEFAULT 'N' NOT NULL,
     INVALID_ID_IND     CHAR(1)           DEFAULT 'N' NOT NULL,
     SGNL_NM            VARCHAR2(50),
     SGNL_ID_ALIAS      VARCHAR2(75),
     BULK_IND           CHAR(1)           DEFAULT 'N' NOT NULL,
     ARCH_IND           CHAR(1)           DEFAULT 'Y' NOT NULL,
     ARCH_FREQ          NUMBER(6, 2)      DEFAULT 60 NOT NULL,
     ARCH_TYPE          VARCHAR2(10)      DEFAULT 'Monitor' NOT NULL,
     CBL_CMPLT_IND      CHAR(1)           DEFAULT 'N' NOT NULL,
     ALARM_IND          CHAR(1)           DEFAULT 'N' NOT NULL,
     ACTIVE_IND         CHAR(1)           DEFAULT 'Y' NOT NULL,
     MOD_BY_UID         VARCHAR2(64),
     MOD_DTE            DATE,
     CONSTRAINT SGNL_REC_PK PRIMARY KEY (SGNL_ID)
     USING INDEX
TABLESPACE chan_arch_ts
         LOGGING
)
PCTFREE 0
TABLESPACE diag_ts
LOGGING
NOPARALLEL
STORAGE(INITIAL 256K
         NEXT 256K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         )
NOCACHE
NOCOMPRESS
;



CREATE UNIQUE INDEX SGNL_ID_ALIAS_IDX ON SGNL_REC(SGNL_ID_ALIAS)
TABLESPACE chan_arch_ts
     LOGGING
;
 
PostSQL   

SGNL_REC Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SGNL_ID(PK)  Signal Id  VARCHAR2(75)  NO  
Signal Identifier:
 
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_ID_ALIAS_IDX  Index  SGNL_ID_ALIAS 

SGNL_REC Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
PV_SGNL_ID_ASSC  Non-Identifying  Zero or One to Zero or More  FK_PV_SGN_ID_ASSC_SGNL_REC        NO  NO  NO 

SGNL_REC Check Constraints 
Check Constraint Name  CheckConstraint 

SGNL_REC Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  diag_ts 
PctFree  0 
PCTUSED    
MinExtents  1 
MaxExtents  2147483645 
Initial  256 
Next  256 
PctIncrease  0 
InitTrans   
MaxTrans   
Organization  Heap 
Cache  NO 
Logging   
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool   
Table Compression  NO 
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)
EPICS.SGNL_REC 		 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.SGNL_REC 		 NO       
Logbook (Oracle)
Does Not Exist 		 NO       
Magnet (Oracle)
Does Not Exist 		 NO       
MPS (Oracle)
SGNL_REC 		 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 
EPICS (Oracle)  Main Model 
IRMISBase (Oracle)  Main Model 
MPS (Oracle)  Main Model 
PV_LOGGER (Oracle)  Main Model 
XAL_OPTICS (Oracle)  Main Model 

SGNL_REC Data Movement Rules 
Name  Type  Rule Text/Value