Identifier 
Base Entity  Additional Color Code 
Attribute Name  Identifier 
Logical Rolename   
ColumnName  ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Identifier Logical Attribute Properties 
Logical Attribute Name  Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

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

Identifier Security Types 
Name  Current Value 

Identifier Bound Attachments 
Name  Current Value 

Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Additional Color Code
Identifier 
NO     
EXPRESS (Oracle)
ADDL_COLOR_CODE
ID 
NO     

Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Description 
Base Entity  Additional Color Code 
Attribute Name  Description 
Logical Rolename   
ColumnName  DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Description Logical Attribute Properties 
Logical Attribute Name  Description 
Datatype  VARCHAR(255) 
Nullable  YES 

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

Description Security Types 
Name  Current Value 

Description Bound Attachments 
Name  Current Value 

Description Data Movement Rules 
Name  Type  Rule Text/Value 

Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Additional Color Code
Description 
NO     
EXPRESS (Oracle)
ADDL_COLOR_CODE
DESCR 
NO     

Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Color Code 
Base Entity  Additional Color Code 
Attribute Name  Color Code 
Logical Rolename   
ColumnName  COLOR_CODE 
RoleName   
Domain  Color Code 
Logical Only  NO 
Definition 
Color Code: Hexadecimal HTML color code.
 
Note 
 

Color Code Logical Attribute Properties 
Logical Attribute Name  Color Code 
Datatype  CHAR(7) 
Nullable  NO 

Color Code Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Color Code Security Types 
Name  Current Value 

Color Code Bound Attachments 
Name  Current Value 

Color Code Data Movement Rules 
Name  Type  Rule Text/Value 

Color Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Additional Color Code
Color Code 
NO     
EXPRESS (Oracle)
ADDL_COLOR_CODE
COLOR_CODE 
NO     

Color Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Color Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Color Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Color Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Text Color Code 
Base Entity  Additional Color Code 
Attribute Name  Text Color Code 
Logical Rolename   
ColumnName  TEXT_COLOR_CODE 
RoleName   
Domain  Color Code 
Logical Only  NO 
Definition 
Color Code: Hexadecimal HTML color code.
 
Note 
 

Text Color Code Logical Attribute Properties 
Logical Attribute Name  Text Color Code 
Datatype  CHAR(7) 
Nullable  YES 

Text Color Code Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Text Color Code Security Types 
Name  Current Value 

Text Color Code Bound Attachments 
Name  Current Value 

Text Color Code Data Movement Rules 
Name  Type  Rule Text/Value 

Text Color Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Additional Color Code
Text Color Code 
NO     
EXPRESS (Oracle)
ADDL_COLOR_CODE
TEXT_COLOR_CODE 
NO     

Text Color Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Text Color Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Text Color Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Text Color Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description