Tmpl Id 
Base Entity  Template 
Attribute Name  Tmpl Id 
Logical Rolename   
ColumnName  Tmpl Id 
RoleName   
Domain  Default Text 
Logical Only  NO 
Definition 
Template Identifier: The unique identifier for an EPICS template.
 
Note 
 

Tmpl Id Logical Attribute Properties 
Logical Attribute Name  Tmpl Id 
Datatype  VARCHAR(50) 
Nullable  NO 

Tmpl Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Tmpl Id Security Types 
Name  Current Value 

Tmpl Id Bound Attachments 
Name  Current Value 

Tmpl Id Data Movement Rules 
Name  Type  Rule Text/Value 

Tmpl Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Template
Tmpl Id 
NO     
EPICS (Oracle)
TEMPLATE
Tmpl Id 
NO     

Tmpl Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Tmpl Desc 
Base Entity  Template 
Attribute Name  Tmpl Desc 
Logical Rolename   
ColumnName  Tmpl Desc 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
Subsystem Name: The name associated with the SNS subsystem.
 
Note 
 

Tmpl Desc Logical Attribute Properties 
Logical Attribute Name  Tmpl Desc 
Datatype  VARCHAR(255) 
Nullable  YES 

Tmpl Desc Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Tmpl Desc Security Types 
Name  Current Value 

Tmpl Desc Bound Attachments 
Name  Current Value 

Tmpl Desc Data Movement Rules 
Name  Type  Rule Text/Value 

Tmpl Desc Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Template
Tmpl Desc 
NO     
EPICS (Oracle)
TEMPLATE
Tmpl Desc 
NO     

Tmpl Desc Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Desc Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Desc Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tmpl Desc Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Ext Src File Nm 
Base Entity  Template 
Attribute Name  Ext Src File Nm 
Logical Rolename   
ColumnName  Ext Src File Nm 
RoleName   
Domain   
Logical Only  NO 
Definition 
External Source File Name: If the template entry was imported from an existing template file, then this is the file name the template came from.
 
Note 
 

Ext Src File Nm Logical Attribute Properties 
Logical Attribute Name  Ext Src File Nm 
Datatype  VARCHAR(100) 
Nullable  YES 

Ext Src File Nm Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Ext Src File Nm Security Types 
Name  Current Value 

Ext Src File Nm Bound Attachments 
Name  Current Value 

Ext Src File Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Ext Src File Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Template
Ext Src File Nm 
NO     
EPICS (Oracle)
TEMPLATE
Ext Src File Nm 
NO     

Ext Src File Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Ext Src File Mod Dte 
Base Entity  Template 
Attribute Name  Ext Src File Mod Dte 
Logical Rolename   
ColumnName  Ext Src File Mod Dte 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
External Source File Modification Date: If the template was imported from an external file, this will be the modification date of that template file.
 
Note 
 

Ext Src File Mod Dte Logical Attribute Properties 
Logical Attribute Name  Ext Src File Mod Dte 
Datatype  DATE 
Nullable  YES 

Ext Src File Mod Dte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Ext Src File Mod Dte Security Types 
Name  Current Value 

Ext Src File Mod Dte Bound Attachments 
Name  Current Value 

Ext Src File Mod Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Ext Src File Mod Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Template
Ext Src File Mod Dte 
NO     
EPICS (Oracle)
TEMPLATE
Ext Src File Mod Dte 
NO     

Ext Src File Mod Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Mod Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Mod Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Ext Src File Mod Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description