SGNL_REC 
Logical Entity Name  Sgnl Rec 
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,
     DVC_ID               VARCHAR2(50)      NOT NULL,
     SGNL_ID_ALIAS        VARCHAR2(75),
     REC_TYPE_ID          VARCHAR2(20)      NOT NULL,
     SGNL_NM              VARCHAR2(50),
     BULK_IND             CHAR(1)           DEFAULT 'N' NOT NULL,
     MCHN_PROT_IND        CHAR(1)           DEFAULT 'N' NOT NULL,
     MULTIMODE_IND        CHAR(1)           DEFAULT 'N' NOT NULL,
     CBL_CMPLT_IND        CHAR(1)           DEFAULT 'N' NOT NULL,
     INV_ID_IND           CHAR(1)           DEFAULT 'N' NOT NULL,
     ARCH_IND             CHAR(1)           DEFAULT 'Y' NOT NULL,
     ALARM_IND            CHAR(1)           DEFAULT 'N' NOT NULL,
     EXT_SRC              VARCHAR2(200),
     ARCH_FREQ            NUMBER(6, 2)      DEFAULT .5 NOT NULL,
     ARCH_TYPE            VARCHAR2(10)      DEFAULT Monitor NOT NULL,
     MOD_DTE              DATE              NOT NULL,
     MOD_BY_UID           VARCHAR2(64)      NOT NULL,
     EPICS_DVC_GRP_ID     VARCHAR2(120),
     CONSTRAINT SGNL_REC_PK PRIMARY KEY (SGNL_ID)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE OPER_INDEX_TS
         LOGGING
         STORAGE(INITIAL 64K
                 NEXT 64K
                 MINEXTENTS 1
                 MAXEXTENTS UNLIMITED
                 PCTINCREASE 50
                 ),
     CONSTRAINT DVC_SGNL_REC_RF FOREIGN KEY (DVC_ID)
     REFERENCES DVC(DVC_ID),
     CONSTRAINT EPICS_DVC_GRP_ITEM_SGNL_REC_RF FOREIGN KEY (EPICS_DVC_GRP_ID)
     REFERENCES EPICS_DVC_GRP_ITEM(EPICS_DVC_GRP_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
         NEXT 64K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 50
         )
NOCACHE
NOCOMPRESS
;
 
PostSQL   

SGNL_REC Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SGNL_ID(PK)  Signal Id  VARCHAR2(75)  NO  
Signal Identifier
 
DVC_ID(FK)  Device Id  VARCHAR2(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.
 
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.
 
REC_TYPE_ID    VARCHAR2(20)  NO  
Epics Record Type:  A text field used to categories different EPICS records.
 
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.
 
BULK_IND  Indicator  CHAR(1)  NO  
Bulk Indicator:  A signal that provides field set for multiple devices.  Default is "N."
 
MCHN_PROT_IND  Indicator  CHAR(1)  NO  
Machine Protection Indicator: Default is "N"
 
MULTIMODE_IND  Indicator  CHAR(1)  NO  
Multimode Indicator:  Default is "N"
 
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.
 
INV_ID_IND  Indicator  CHAR(1)  NO  
Invalid Signal Record Indicator:  Indicates that the imported signal id is not parsable.  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.
 
ALARM_IND  Indicator  CHAR(1)  NO  
Alarm Indicator: Indicates that the signal can be alarmed.
 
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.
 
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.
 
MOD_DTE  Modify Date  DATE  NO  
Modify Date: The date the entity values were were created or modified.
 
MOD_BY_UID  Mod By Uid  VARCHAR2(64)  NO  
Modified by Userid:  The database userid of the person who inserted or update a record in the table.
 
EPICS_DVC_GRP_ID(FK)    VARCHAR2(120)  YES  
Epics Device Group Identifier:  The unique identifier for an Epics devide group.
 

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  One To Zero or More  DVC_SGNL_REC_RF      DVC_ID  NO  NO  NO 
EPICS_DVC_GRP_ITEM  Non-Identifying  Zero or One to Zero or More  EPICS_DVC_GRP_ITEM_SGNL_REC_RF      EPICS_DVC_GRP_ID  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
MPS_DAILY_STAT  Identifying  One To Zero or More          NO  NO  YES 
MPS_DAILY_STAT  Identifying  One To Zero or More          NO  NO  NO 
SGNL  Identifying  One To Zero or More  SGNL_REC_SGNL_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  50 
InitTrans  1 
MaxTrans  255 
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 

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