ENG_ID 
Base Object  SMPL_ENG 
Attribute Name  Engine Identifer 
ColumnName  ENG_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

ENG_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

ENG_ID Security Types 
Name  Current Value 

ENG_ID Bound Attachments 
Name  Current Value 

ENG_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ENG_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Engine
Engine Identifer 
NO     
CHAN_ARCH (Oracle)
SMPL_ENG
ENG_ID 
NO     

ENG_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENG_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ENG_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ENG_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NAME 
Base Object  SMPL_ENG 
Attribute Name  Name 
ColumnName  NAME 
Logical Rolename   
RoleName   
Domain  Name 
Physical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

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

NAME Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  120 
Percent Null 

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

NAME Security Types 
Name  Current Value 

NAME Bound Attachments 
Name  Current Value 

NAME Data Movement Rules 
Name  Type  Rule Text/Value 

NAME Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Engine
Name 
NO     
CHAN_ARCH (Oracle)
SMPL_ENG
NAME 
NO     

NAME Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NAME Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NAME Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NAME Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DESCR 
Base Object  SMPL_ENG 
Attribute Name  Description 
ColumnName  DESCR 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

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

DESCR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

DESCR Security Types 
Name  Current Value 

DESCR Bound Attachments 
Name  Current Value 

DESCR Data Movement Rules 
Name  Type  Rule Text/Value 

DESCR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Engine
Description 
NO     
CHAN_ARCH (Oracle)
SMPL_ENG
DESCR 
NO     

DESCR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DESCR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


URL 
Base Object  SMPL_ENG 
Attribute Name  Uniform Resource Locator 
ColumnName  URL 
Logical Rolename   
RoleName   
Domain  URL 
Physical Only  NO 
Definition 
Universal Resource Locator: The global address of documents and other resources on the web.
 
Note 
 

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

URL Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null 

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

URL Security Types 
Name  Current Value 

URL Bound Attachments 
Name  Current Value 

URL Data Movement Rules 
Name  Type  Rule Text/Value 

URL Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Engine
Uniform Resource Locator 
NO     
CHAN_ARCH (Oracle)
SMPL_ENG
URL 
NO     

URL Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

URL Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

URL Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

URL Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description