SGNL_REC 
Logical Entity Name  SGNL_REC 
Default Table Name  SGNL_REC 
Oracle Temporary Table  NO 
Physical Only  NO 
Do Not Generate  False 
Owner  EPICS 
Definition  
Signal Record: The master list of valid EPICS Records.
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE EPICS.SGNL_REC(
     SGNL_ID            VARCHAR2(75)      NOT NULL,
     DVC_ID             VARCHAR2(40),
     EPICS_GRP_ID       VARCHAR2(120),
     REC_TYPE_ID        VARCHAR2(20)      NOT NULL,
     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,
     MOD_BY_UID         VARCHAR2(64),
     MOD_DTE            DATE,
     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,
     SGNL_ID_DESC       VARCHAR2(255),
     CONSTRAINT SGNL_REC_PK PRIMARY KEY (SGNL_ID)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE EPICS_INDEX_TS
         LOGGING
         STORAGE(INITIAL 64K
                 NEXT 64K
                 MINEXTENTS 1
                 MAXEXTENTS UNLIMITED
                 PCTINCREASE 0
                 FREELISTS 1
                 FREELIST GROUPS 1
                 BUFFER_POOL DEFAULT
                 ),
     CONSTRAINT DVC_SGNL_REC_RF FOREIGN KEY (DVC_ID)
     REFERENCES EPICS.DVC(DVC_ID),
     CONSTRAINT EPICS_GRP_SGNL_REC_RF FOREIGN KEY (EPICS_GRP_ID)
     REFERENCES EPICS.EPICS_GRP(EPICS_GRP_ID),
     CONSTRAINT SGNL_REC_TYPE_RF FOREIGN KEY (REC_TYPE_ID)
     REFERENCES EPICS.SGNL_REC_TYPE(REC_TYPE_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
         NEXT 64K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         FREELISTS 1
         FREELIST GROUPS 1
         BUFFER_POOL DEFAULT
         )
NOCACHE
NOCOMPRESS
;



CREATE UNIQUE INDEX EPICS.SGNL_ID_ALIAS_IDX ON EPICS.SGNL_REC(SGNL_ID_ALIAS)
     PCTFREE 10
     INITRANS 2
     MAXTRANS 255
     TABLESPACE EPICS_INDEX_TS
     LOGGING
     STORAGE(INITIAL 64K
             NEXT 64K
             MINEXTENTS 1
             MAXEXTENTS UNLIMITED
             PCTINCREASE 0
             FREELISTS 1
             FREELIST GROUPS 1
             BUFFER_POOL DEFAULT
             )
;
 
PostSQL   

SGNL_REC Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SGNL_ID(PK)    VARCHAR2(75)  NO  
Signal Identifier:
 
DVC_ID(FK)    VARCHAR2(40)  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.
 
EPICS_GRP_ID(FK)    VARCHAR2(120)  YES 
 
REC_TYPE_ID(FK)    VARCHAR2(20)  NO  
Epics Record Type:  A text field used to categories different EPICS records.
 
MCHN_PROT_IND    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    CHAR(1)  NO  
Multimode Indicator:  Default is "N"
 
INVALID_ID_IND    CHAR(1)  NO 
 
SGNL_NM    VARCHAR2(50)  YES  
Signal Name:  This field is parsed from the signal identifier and verified against the DVC Type Sgnl table.
 
SGNL_ID_ALIAS    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    CHAR(1)  NO  
Bulk Indicator:  A signal that provides field set for multiple devices.  Default is "N."
 
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.
 
ARCH_IND    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    CHAR(1)  NO  
Cabling Complete Indicator:  Indicates that the cable on which the signal traverses has been pulled and signed off.
 
ALARM_IND    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.
 
SGNL_ID_DESC    VARCHAR2(255)  YES 
 

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 
DVC  Non-Identifying  Zero or One to Zero or More  DVC_SGNL_REC_RF      DVC_ID  NO  NO  NO 
EPICS_GRP  Non-Identifying  Zero or One to Zero or More  EPICS_GRP_SGNL_REC_RF      EPICS_GRP_ID  NO  NO  NO 
SGNL_REC_TYPE  Non-Identifying  One To Zero or More  SGNL_REC_TYPE_RF      REC_TYPE_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
ALARM_LOG  Identifying  One To Zero or More  FK_ALARM_LOG_SGNL_REC        NO  NO  NO 
CHMK_DAILY_STAT  Identifying  One To Zero or More  FK_CHMK_DAILY_STAT_SGNL_REC        NO  NO  NO 
DUPL_SGNL  Identifying  One To Zero or More  FK_DUPL_SGNL_SGNL_REC        NO  NO  NO 
MPS_DAILY_STAT  Identifying  One To Zero or More  FK_MDS_TO_SGNL_REC        NO  NO  NO 
PV_SNAPSHOT_GRP_SGNL  Identifying  One To Zero or More  FK_PSGS_SGNL_REC        NO  NO  NO 
SGNL_FLD  Identifying  One To Zero or More  FK_SGNL_FLD_SGNL_REC        NO  NO  NO 
IOC_DB_FILE_ASGN_SGNL  Identifying  One To Zero or More  SGNL_ID_SGNL_REC_RF        NO  NO  NO 

SGNL_REC Check Constraints 
Check Constraint Name  CheckConstraint 

SGNL_REC Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  EPICS_TS 
PctFree  10 
PCTUSED   40 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  64 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging  Logged 
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS  1 
FREELIST GROUPS  1 
Buffer Pool  DEFAULT 
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  559116 
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
Does Not Exist 		 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)
Does Not Exist 		 NO       
XF_ADMIN (Oracle)
Does Not Exist 		 NO       

SGNL_REC Where Used - Submodel Usage 
Model  Submodel Usage 
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 

SGNL_REC Data Movement Rules 
Name  Type  Rule Text/Value