SGNL_ID 
Base Object  SGNL 
Attribute Name  Sgnl Id 
ColumnName  SGNL_ID 
Logical Rolename   
RoleName   
Domain  Signal Id 
Physical Only  NO 
Definition 
Signal Identifier: The unique identifier for a signal.
 
Note 
 

SGNL_ID Column Properties 
Datatype  VARCHAR2(75) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

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
SGNL_ID 
NO     
EPICS (Oracle)
SGNL
SGNL_ID 
NO     
MPS (Oracle)
SGNL
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 


DVC_ID 
Base Object  SGNL 
Attribute Name  Device Identifer 
ColumnName  DVC_ID 
Logical Rolename   
RoleName   
Domain  Device Id 
Physical Only  NO 
Definition 
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.
 
Note 
 

DVC_ID Column Properties 
Datatype  VARCHAR2(50) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

DVC_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  40 
Percent Null 

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

DVC_ID Security Types 
Name  Current Value 

DVC_ID Bound Attachments 
Name  Current Value 

DVC_ID Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Device Identifer 
NO     
EPICS (Oracle)
SGNL
DVC_ID 
NO     
MPS (Oracle)
SGNL
DVC_ID 
NO     

DVC_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_ADDR_1 
Base Object  SGNL 
Attribute Name  Dvc Addr 1 
ColumnName  DVC_ADDR_1 
Logical Rolename   
RoleName   
Domain  Device Address 
Physical Only  NO 
Definition 
Device Address 1

 
Note 
 

DVC_ADDR_1 Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

DVC_ADDR_1 Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

DVC_ADDR_1 Security Types 
Name  Current Value 

DVC_ADDR_1 Bound Attachments 
Name  Current Value 

DVC_ADDR_1 Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_ADDR_1 Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Addr 1 
NO     
EPICS (Oracle)
SGNL
DVC_ADDR_1 
NO     
MPS (Oracle)
SGNL
DVC_ADDR_1 
NO     

DVC_ADDR_1 Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_1 Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_1 Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_1 Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_ADDR_2 
Base Object  SGNL 
Attribute Name  Dvc Addr 2 
ColumnName  DVC_ADDR_2 
Logical Rolename   
RoleName   
Domain  Device Address 
Physical Only  NO 
Definition 
Device Address 2

 
Note 
 

DVC_ADDR_2 Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

DVC_ADDR_2 Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

DVC_ADDR_2 Security Types 
Name  Current Value 

DVC_ADDR_2 Bound Attachments 
Name  Current Value 

DVC_ADDR_2 Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_ADDR_2 Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Addr 2 
NO     
EPICS (Oracle)
SGNL
DVC_ADDR_2 
NO     
MPS (Oracle)
SGNL
DVC_ADDR_2 
NO     

DVC_ADDR_2 Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_2 Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_2 Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_2 Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_ADDR_3 
Base Object  SGNL 
Attribute Name  Dvc Addr 3 
ColumnName  DVC_ADDR_3 
Logical Rolename   
RoleName   
Domain  Device Address 
Physical Only  NO 
Definition 
Device Address 3
 
Note 
 

DVC_ADDR_3 Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

DVC_ADDR_3 Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

DVC_ADDR_3 Security Types 
Name  Current Value 

DVC_ADDR_3 Bound Attachments 
Name  Current Value 

DVC_ADDR_3 Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_ADDR_3 Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Addr 3 
NO     
EPICS (Oracle)
SGNL
DVC_ADDR_3 
NO     
MPS (Oracle)
SGNL
DVC_ADDR_3 
NO     

DVC_ADDR_3 Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_3 Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_3 Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ADDR_3 Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_OPT 
Base Object  SGNL 
Attribute Name  Dvc Opt 
ColumnName  DVC_OPT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Device Options
 
Note 
 

DVC_OPT Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

DVC_OPT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

DVC_OPT Security Types 
Name  Current Value 

DVC_OPT Bound Attachments 
Name  Current Value 

DVC_OPT Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_OPT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Opt 
NO     
EPICS (Oracle)
SGNL
DVC_OPT 
NO     
MPS (Oracle)
SGNL
DVC_OPT 
NO     

DVC_OPT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_OPT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_OPT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_OPT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_FUNC 
Base Object  SGNL 
Attribute Name  Dvc Func 
ColumnName  DVC_FUNC 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Device Function: Values may include T-Tie down, O-Originate
 
Note 
 

DVC_FUNC Column Properties 
Datatype  CHAR(1) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

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

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

DVC_FUNC Security Types 
Name  Current Value 

DVC_FUNC Bound Attachments 
Name  Current Value 

DVC_FUNC Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_FUNC Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Func 
NO     
EPICS (Oracle)
SGNL
DVC_FUNC 
NO     
MPS (Oracle)
SGNL
DVC_FUNC 
NO     

DVC_FUNC Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_FUNC Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_FUNC Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_FUNC Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DVC_CHAN 
Base Object  SGNL 
Attribute Name  Dvc Chan 
ColumnName  DVC_CHAN 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Device Channel
 
Note 
 

DVC_CHAN Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 

DVC_CHAN Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

DVC_CHAN Security Types 
Name  Current Value 

DVC_CHAN Bound Attachments 
Name  Current Value 

DVC_CHAN Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_CHAN Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Signal
Dvc Chan 
NO     
EPICS (Oracle)
SGNL
DVC_CHAN 
NO     
MPS (Oracle)
SGNL
DVC_CHAN 
NO     

DVC_CHAN Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_CHAN Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_CHAN Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_CHAN Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description