System Identifier 
Base Entity  System 
Attribute Name  System Identifier 
Logical Rolename   
ColumnName  SYS_ID 
RoleName   
Domain  System Id 
Logical Only  NO 
Definition 
System Code: The unique identifier for the Spalation Neutron Source Project System.
 
Note 
 

System Identifier Logical Attribute Properties 
Logical Attribute Name  System Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

System Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

System Identifier Security Types 
Name  Current Value 

System Identifier Bound Attachments 
Name  Current Value 

System Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

System Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
System
System Identifier 
NO     
EPICS (Oracle)
SYST
SYS_ID 
NO     

System Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

System Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

System Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

System Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sys Nm 
Base Entity  System 
Attribute Name  Sys Nm 
Logical Rolename   
ColumnName  Sys Nm 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
System Name: The name of the system associated with the system code.
 
Note 
 

Sys Nm Logical Attribute Properties 
Logical Attribute Name  Sys Nm 
Datatype  VARCHAR(120) 
Nullable  NO 

Sys Nm Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sys Nm Security Types 
Name  Current Value 

Sys Nm Bound Attachments 
Name  Current Value 

Sys Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Sys Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
System
Sys Nm 
NO     
EPICS (Oracle)
SYST
Sys Nm 
NO     

Sys Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Accum Path Lngth 
Base Entity  System 
Attribute Name  Accum Path Lngth 
Logical Rolename   
ColumnName  Accum Path Lngth 
RoleName   
Domain  Distance 
Logical Only  NO 
Definition 
Accumulated Path Length: The accumulated path length from the start.
 
Note 
 

Accum Path Lngth Logical Attribute Properties 
Logical Attribute Name  Accum Path Lngth 
Datatype  NUMERIC(12, 6) 
Nullable  YES 

Accum Path Lngth Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Accum Path Lngth Security Types 
Name  Current Value 

Accum Path Lngth Bound Attachments 
Name  Current Value 

Accum Path Lngth Data Movement Rules 
Name  Type  Rule Text/Value 

Accum Path Lngth Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
System
Accum Path Lngth 
NO     
EPICS (Oracle)
SYST
Accum Path Lngth 
NO     

Accum Path Lngth Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accum Path Lngth Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accum Path Lngth Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Accum Path Lngth Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sys Seq Nbr 
Base Entity  System 
Attribute Name  Sys Seq Nbr 
Logical Rolename   
ColumnName  Sys Seq Nbr 
RoleName   
Domain   
Logical Only  NO 
Definition 
System Sequence Number:  Used to order systems for reporting purposes.
 
Note 
 

Sys Seq Nbr Logical Attribute Properties 
Logical Attribute Name  Sys Seq Nbr 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Sys Seq Nbr Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sys Seq Nbr Security Types 
Name  Current Value 

Sys Seq Nbr Bound Attachments 
Name  Current Value 

Sys Seq Nbr Data Movement Rules 
Name  Type  Rule Text/Value 

Sys Seq Nbr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
System
Sys Seq Nbr 
NO     
EPICS (Oracle)
SYST
Sys Seq Nbr 
NO     

Sys Seq Nbr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Seq Nbr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Seq Nbr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sys Seq Nbr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description