SUBSYS_ID 
Base Object  SUBSYS 
Attribute Name  SUBSYS_ID 
ColumnName  SUBSYS_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Subsystem Identifier: The unique identifier for a SNS subsystem.
 
Note 
 

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

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

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

SUBSYS_ID Security Types 
Name  Current Value 

SUBSYS_ID Bound Attachments 
Name  Current Value 

SUBSYS_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SUBSYS_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Subsystem
Subsystem Identifer 
NO     
EPICS (Oracle)
SUBSYS
SUBSYS_ID 
NO     

SUBSYS_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SUBSYS_NM 
Base Object  SUBSYS 
Attribute Name  SUBSYS_NM 
ColumnName  SUBSYS_NM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Subsystem Name: The name associated with the SNS subsystem.
 
Note 
 

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

SUBSYS_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  24 
Percent Null 

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

SUBSYS_NM Security Types 
Name  Current Value 

SUBSYS_NM Bound Attachments 
Name  Current Value 

SUBSYS_NM Data Movement Rules 
Name  Type  Rule Text/Value 

SUBSYS_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Subsystem
SUBSYS_NM 
NO     
EPICS (Oracle)
SUBSYS
SUBSYS_NM 
NO     

SUBSYS_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBSYS_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description