SGNL_ID 
Base Object  SGNL_REC 
Attribute Name  Sgnl Id 
ColumnName  SGNL_ID 
Logical Rolename   
RoleName   
Domain  Signal Id 
Physical Only  NO 
Definition 
Signal Identifier:
 
Note 
 

SGNL_ID Column Properties 
Datatype  VARCHAR2(75) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SGNL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  75 
Percent Null 

SGNL_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SGNL_ID Security Types 
Name  Current Value 

SGNL_ID Bound Attachments 
Name  Current Value 

SGNL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SGNL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Sgnl Id 
NO     
BLM (Oracle)
SGNL_REC
SGNL_ID 
NO     
DIAG (Oracle)
SGNL_REC
SGNL_ID 
NO     
EPICS (Oracle)
SGNL_REC
SGNL_ID 
NO     
IRMISBase (Oracle)
SGNL_REC
SGNL_ID 
NO     
MPS (Oracle)
SGNL_REC
SGNL_ID 
NO     
PV_LOGGER (Oracle)
SGNL_REC
SGNL_ID 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
SGNL_ID 
NO     

SGNL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SGNL_ID_DESC 
Base Object  SGNL_REC 
Attribute Name  Signal Identifer Description 
ColumnName  SGNL_ID_DESC 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

SGNL_ID_DESC Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SGNL_ID_DESC Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

SGNL_ID_DESC Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SGNL_ID_DESC Security Types 
Name  Current Value 

SGNL_ID_DESC Bound Attachments 
Name  Current Value 

SGNL_ID_DESC Data Movement Rules 
Name  Type  Rule Text/Value 

SGNL_ID_DESC Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Signal Identifer Description 
NO     
BLM (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
DIAG (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
EPICS (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
IRMISBase (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
MPS (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
PV_LOGGER (Oracle)
SGNL_REC
SGNL_ID_DESC 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
SGNL_ID_DESC 
NO     

SGNL_ID_DESC Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_DESC Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_DESC Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_DESC Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MCHN_PROT_IND 
Base Object  SGNL_REC 
Attribute Name  Mchn Prot Ind 
ColumnName  MCHN_PROT_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Machine Protection Indicator: Default is "N"
 
Note 
 

MCHN_PROT_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

MCHN_PROT_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MCHN_PROT_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

MCHN_PROT_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

MCHN_PROT_IND Security Types 
Name  Current Value 

MCHN_PROT_IND Bound Attachments 
Name  Current Value 

MCHN_PROT_IND Data Movement Rules 
Name  Type  Rule Text/Value 

MCHN_PROT_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Mchn Prot Ind 
NO     
BLM (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
DIAG (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
EPICS (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
MPS (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
MCHN_PROT_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Mchn Prot Ind 
NO     

MCHN_PROT_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MCHN_PROT_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MCHN_PROT_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MCHN_PROT_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EXT_SRC 
Base Object  SGNL_REC 
Attribute Name  Ext Src 
ColumnName  EXT_SRC 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
External Source: The originating tool from which the signal was created in cases where the signal was imported from an external source.
 
Note 
 

EXT_SRC Column Properties 
Datatype  VARCHAR2(200) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

EXT_SRC Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  200 
Percent Null 

EXT_SRC Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EXT_SRC Security Types 
Name  Current Value 

EXT_SRC Bound Attachments 
Name  Current Value 

EXT_SRC Data Movement Rules 
Name  Type  Rule Text/Value 

EXT_SRC Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Ext Src 
NO     
BLM (Oracle)
SGNL_REC
EXT_SRC 
NO     
DIAG (Oracle)
SGNL_REC
EXT_SRC 
NO     
EPICS (Oracle)
SGNL_REC
EXT_SRC 
NO     
IRMISBase (Oracle)
SGNL_REC
EXT_SRC 
NO     
MPS (Oracle)
SGNL_REC
EXT_SRC 
NO     
PV_LOGGER (Oracle)
SGNL_REC
EXT_SRC 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Ext Src 
NO     

EXT_SRC Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXT_SRC Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXT_SRC Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXT_SRC Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MULTIMODE_IND 
Base Object  SGNL_REC 
Attribute Name  Multimode Ind 
ColumnName  MULTIMODE_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Multimode Indicator:  Default is "N"
 
Note 
 

MULTIMODE_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

MULTIMODE_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MULTIMODE_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

MULTIMODE_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

MULTIMODE_IND Security Types 
Name  Current Value 

MULTIMODE_IND Bound Attachments 
Name  Current Value 

MULTIMODE_IND Data Movement Rules 
Name  Type  Rule Text/Value 

MULTIMODE_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Multimode Ind 
NO     
BLM (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
DIAG (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
EPICS (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
MPS (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
MULTIMODE_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Multimode Ind 
NO     

MULTIMODE_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MULTIMODE_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MULTIMODE_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MULTIMODE_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INVALID_ID_IND 
Base Object  SGNL_REC 
Attribute Name  Invalid Id Ind 
ColumnName  INVALID_ID_IND 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

INVALID_ID_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INVALID_ID_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

INVALID_ID_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

INVALID_ID_IND Security Types 
Name  Current Value 

INVALID_ID_IND Bound Attachments 
Name  Current Value 

INVALID_ID_IND Data Movement Rules 
Name  Type  Rule Text/Value 

INVALID_ID_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Invalid Id Ind 
NO     
BLM (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
DIAG (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
EPICS (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
MPS (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
INVALID_ID_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
INVALID_ID_IND 
NO     

INVALID_ID_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVALID_ID_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVALID_ID_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INVALID_ID_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SGNL_NM 
Base Object  SGNL_REC 
Attribute Name  Sgnl Nm 
ColumnName  SGNL_NM 
Logical Rolename   
RoleName   
Domain  Signal Name 
Physical Only  NO 
Definition 
Signal Name:  This field is parsed from the signal identifier and verified against the DVC Type Sgnl table.
 
Note 
 

SGNL_NM Column Properties 
Datatype  VARCHAR2(50) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SGNL_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

SGNL_NM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SGNL_NM Security Types 
Name  Current Value 

SGNL_NM Bound Attachments 
Name  Current Value 

SGNL_NM Data Movement Rules 
Name  Type  Rule Text/Value 

SGNL_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Sgnl Nm 
NO     
BLM (Oracle)
SGNL_REC
SGNL_NM 
NO     
DIAG (Oracle)
SGNL_REC
SGNL_NM 
NO     
EPICS (Oracle)
SGNL_REC
SGNL_NM 
NO     
IRMISBase (Oracle)
SGNL_REC
SGNL_NM 
NO     
MPS (Oracle)
SGNL_REC
SGNL_NM 
NO     
PV_LOGGER (Oracle)
SGNL_REC
SGNL_NM 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Sgnl Nm 
NO     

SGNL_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SGNL_ID_ALIAS 
Base Object  SGNL_REC 
Attribute Name  Sgnl Id Alias 
ColumnName  SGNL_ID_ALIAS 
Logical Rolename   
RoleName   
Domain  Signal Id 
Physical Only  NO 
Definition 
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.
 
Note 
 

SGNL_ID_ALIAS Column Properties 
Datatype  VARCHAR2(75) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SGNL_ID_ALIAS Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  75 
Percent Null 

SGNL_ID_ALIAS Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SGNL_ID_ALIAS Security Types 
Name  Current Value 

SGNL_ID_ALIAS Bound Attachments 
Name  Current Value 

SGNL_ID_ALIAS Data Movement Rules 
Name  Type  Rule Text/Value 

SGNL_ID_ALIAS Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Sgnl Id Alias 
NO     
BLM (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
DIAG (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
EPICS (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
IRMISBase (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
MPS (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
PV_LOGGER (Oracle)
SGNL_REC
SGNL_ID_ALIAS 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Sgnl Id Alias 
NO     

SGNL_ID_ALIAS Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_ALIAS Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_ALIAS Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SGNL_ID_ALIAS Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BULK_IND 
Base Object  SGNL_REC 
Attribute Name  Bulk Ind 
ColumnName  BULK_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Bulk Indicator:  A signal that provides field set for multiple devices.  Default is "N."
 
Note 
 

BULK_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

BULK_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

BULK_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

BULK_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

BULK_IND Security Types 
Name  Current Value 

BULK_IND Bound Attachments 
Name  Current Value 

BULK_IND Data Movement Rules 
Name  Type  Rule Text/Value 

BULK_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Bulk Ind 
NO     
BLM (Oracle)
SGNL_REC
BULK_IND 
NO     
DIAG (Oracle)
SGNL_REC
BULK_IND 
NO     
EPICS (Oracle)
SGNL_REC
BULK_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
BULK_IND 
NO     
MPS (Oracle)
SGNL_REC
BULK_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
BULK_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Bulk Ind 
NO     

BULK_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BULK_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BULK_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BULK_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ARCH_IND 
Base Object  SGNL_REC 
Attribute Name  Arch Ind 
ColumnName  ARCH_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
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.
 
Note 
 

ARCH_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ARCH_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ARCH_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'Y' 
Bound Default   

ARCH_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

ARCH_IND Security Types 
Name  Current Value 

ARCH_IND Bound Attachments 
Name  Current Value 

ARCH_IND Data Movement Rules 
Name  Type  Rule Text/Value 

ARCH_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Arch Ind 
NO     
BLM (Oracle)
SGNL_REC
ARCH_IND 
NO     
DIAG (Oracle)
SGNL_REC
ARCH_IND 
NO     
EPICS (Oracle)
SGNL_REC
ARCH_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
ARCH_IND 
NO     
MPS (Oracle)
SGNL_REC
ARCH_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
ARCH_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Arch Ind 
NO     

ARCH_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ARCH_FREQ 
Base Object  SGNL_REC 
Attribute Name  Arch Freq 
ColumnName  ARCH_FREQ 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
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)
 
Note 
 

ARCH_FREQ Column Properties 
Datatype  NUMBER(6, 2) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ARCH_FREQ Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ARCH_FREQ Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  60 
Bound Default   

ARCH_FREQ Security Types 
Name  Current Value 

ARCH_FREQ Bound Attachments 
Name  Current Value 

ARCH_FREQ Data Movement Rules 
Name  Type  Rule Text/Value 

ARCH_FREQ Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Arch Freq 
NO     
BLM (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
DIAG (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
EPICS (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
IRMISBase (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
MPS (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
PV_LOGGER (Oracle)
SGNL_REC
ARCH_FREQ 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Arch Freq 
NO     

ARCH_FREQ Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_FREQ Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_FREQ Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_FREQ Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ARCH_TYPE 
Base Object  SGNL_REC 
Attribute Name  Arch Type 
ColumnName  ARCH_TYPE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Archiver Type:  Indicates whether the signal should be archived as Periodic or Monitor.
 
Note 
 

ARCH_TYPE Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ARCH_TYPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

ARCH_TYPE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'Monitor' 
Bound Default   

ARCH_TYPE Security Types 
Name  Current Value 

ARCH_TYPE Bound Attachments 
Name  Current Value 

ARCH_TYPE Data Movement Rules 
Name  Type  Rule Text/Value 

ARCH_TYPE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Arch Type 
NO     
BLM (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
DIAG (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
EPICS (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
IRMISBase (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
MPS (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
PV_LOGGER (Oracle)
SGNL_REC
ARCH_TYPE 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Arch Type 
NO     

ARCH_TYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_TYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_TYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ARCH_TYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CBL_CMPLT_IND 
Base Object  SGNL_REC 
Attribute Name  Cbl Cmplt Ind 
ColumnName  CBL_CMPLT_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Cabling Complete Indicator:  Indicates that the cable on which the signal traverses has been pulled and signed off.
 
Note 
 

CBL_CMPLT_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CBL_CMPLT_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

CBL_CMPLT_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

CBL_CMPLT_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

CBL_CMPLT_IND Security Types 
Name  Current Value 

CBL_CMPLT_IND Bound Attachments 
Name  Current Value 

CBL_CMPLT_IND Data Movement Rules 
Name  Type  Rule Text/Value 

CBL_CMPLT_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Cbl Cmplt Ind 
NO     
BLM (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
DIAG (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
EPICS (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
MPS (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
CBL_CMPLT_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Cbl Cmplt Ind 
NO     

CBL_CMPLT_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CBL_CMPLT_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CBL_CMPLT_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CBL_CMPLT_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ALARM_IND 
Base Object  SGNL_REC 
Attribute Name  Alarm Ind 
ColumnName  ALARM_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Alarm Indicator: Indicates that the signal can be alarmed.
 
Note 
 

ALARM_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ALARM_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ALARM_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

ALARM_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

ALARM_IND Security Types 
Name  Current Value 

ALARM_IND Bound Attachments 
Name  Current Value 

ALARM_IND Data Movement Rules 
Name  Type  Rule Text/Value 

ALARM_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Alarm Ind 
NO     
BLM (Oracle)
SGNL_REC
ALARM_IND 
NO     
DIAG (Oracle)
SGNL_REC
ALARM_IND 
NO     
EPICS (Oracle)
SGNL_REC
ALARM_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
ALARM_IND 
NO     
MPS (Oracle)
SGNL_REC
ALARM_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
ALARM_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Alarm Ind 
NO     

ALARM_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ALARM_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ALARM_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ALARM_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACTIVE_IND 
Base Object  SGNL_REC 
Attribute Name  Active Ind 
ColumnName  ACTIVE_IND 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Active Indicator: Indicates that the signal is currently in use in the control system.
 
Note 
 

ACTIVE_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ACTIVE_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ACTIVE_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'Y' 
Bound Default   

ACTIVE_IND Security Types 
Name  Current Value 

ACTIVE_IND Bound Attachments 
Name  Current Value 

ACTIVE_IND Data Movement Rules 
Name  Type  Rule Text/Value 

ACTIVE_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Active Ind 
NO     
BLM (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
DIAG (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
EPICS (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
IRMISBase (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
MPS (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
PV_LOGGER (Oracle)
SGNL_REC
ACTIVE_IND 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
ACTIVE_IND 
NO     

ACTIVE_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACTIVE_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACTIVE_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACTIVE_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MOD_BY_UID 
Base Object  SGNL_REC 
Attribute Name  Mod By Uid 
ColumnName  MOD_BY_UID 
Logical Rolename   
RoleName   
Domain  Mod By Uid 
Physical Only  NO 
Definition 
Modified by Userid:  The database userid of the person who inserted or update a record in the table.
 
Note 
 

MOD_BY_UID Column Properties 
Datatype  VARCHAR2(64) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

MOD_BY_UID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null 

MOD_BY_UID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MOD_BY_UID Security Types 
Name  Current Value 

MOD_BY_UID Bound Attachments 
Name  Current Value 

MOD_BY_UID Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_BY_UID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Mod By Uid 
NO     
BLM (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
DIAG (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
EPICS (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
IRMISBase (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
MPS (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
PV_LOGGER (Oracle)
SGNL_REC
MOD_BY_UID 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Mod By Uid 
NO     

MOD_BY_UID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_BY_UID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MOD_DTE 
Base Object  SGNL_REC 
Attribute Name  Mod Dte 
ColumnName  MOD_DTE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Modify Date: The date the record was created or modified.
 
Note 
 

MOD_DTE Column Properties 
Datatype  DATE 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

MOD_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

MOD_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MOD_DTE Security Types 
Name  Current Value 

MOD_DTE Bound Attachments 
Name  Current Value 

MOD_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal Record
Mod Dte 
NO     
BLM (Oracle)
SGNL_REC
MOD_DTE 
NO     
DIAG (Oracle)
SGNL_REC
MOD_DTE 
NO     
EPICS (Oracle)
SGNL_REC
MOD_DTE 
NO     
IRMISBase (Oracle)
SGNL_REC
MOD_DTE 
NO     
MPS (Oracle)
SGNL_REC
MOD_DTE 
NO     
PV_LOGGER (Oracle)
SGNL_REC
MOD_DTE 
NO     
XAL_OPTICS (Oracle)
Sgnl_Rec
Mod Dte 
NO     

MOD_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description