TMPL_ID 
Base Object  TEMPLATE 
Attribute Name  TMPL_ID 
ColumnName  TMPL_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

TMPL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  15 
Percent Null 

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 Object  TEMPLATE 
Attribute Name  TMPL_DESC 
ColumnName  TMPL_DESC 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

TMPL_DESC Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  100 

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 Object  TEMPLATE 
Attribute Name  EXT_SRC_FILE_NM 
ColumnName  EXT_SRC_FILE_NM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

EXT_SRC_FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  81 
Percent Null 

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 Object  TEMPLATE 
Attribute Name  EXT_SRC_FILE_MOD_DTE 
ColumnName  EXT_SRC_FILE_MOD_DTE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

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

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