Userid 
Base Entity  Jeri User Properties 
Attribute Name  Userid 
Logical Rolename   
ColumnName  Userid 
RoleName   
Domain  Userid 
Logical Only  NO 
Definition 
 
Note 
 

Userid Logical Attribute Properties 
Logical Attribute Name  Userid 
Datatype  VARCHAR(64) 
Nullable  NO 

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

Userid Security Types 
Name  Current Value 

Userid Bound Attachments 
Name  Current Value 

Userid Data Movement Rules 
Name  Type  Rule Text/Value 

Userid Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
Userid 
NO     

Userid Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Userid Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Userid Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Userid Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Prop Cd 
Base Entity  Jeri User Properties 
Attribute Name  Prop Cd 
Logical Rolename   
ColumnName  Prop Cd 
RoleName   
Domain   
Logical Only  NO 
Definition 
Property Code:  Indicates what type of information is stored in this record.  (i.e. Filter, Java Property) Valid values: F - Legacy user defined. (treated as FU type); FU - User defined editor filter; FP - Public editor filter; BU - User defined builder filter; BP - Public builder filter.
 
Note 
 

Prop Cd Logical Attribute Properties 
Logical Attribute Name  Prop Cd 
Datatype  CHAR(2) 
Nullable  NO 

Prop Cd Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Prop Cd Security Types 
Name  Current Value 

Prop Cd Bound Attachments 
Name  Current Value 

Prop Cd Data Movement Rules 
Name  Type  Rule Text/Value 

Prop Cd Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
Prop Cd 
NO     

Prop Cd Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prop Cd Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Prop Cd Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Prop Cd Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Fltr Nm 
Base Entity  Jeri User Properties 
Attribute Name  Fltr Nm 
Logical Rolename   
ColumnName  Fltr Nm 
RoleName   
Domain   
Logical Only  NO 
Definition 
Filter Name:  The named assgined by the user to a saved data filter.
 
Note 
 

Fltr Nm Logical Attribute Properties 
Logical Attribute Name  Fltr Nm 
Datatype  VARCHAR(100) 
Nullable  YES 

Fltr Nm Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Fltr Nm Security Types 
Name  Current Value 

Fltr Nm Bound Attachments 
Name  Current Value 

Fltr Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Fltr Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
Fltr Nm 
NO     

Fltr Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Fltr Cont 
Base Entity  Jeri User Properties 
Attribute Name  Fltr Cont 
Logical Rolename   
ColumnName  Fltr Cont 
RoleName   
Domain   
Logical Only  NO 
Definition 
Filter Contents:  The data filter saved by the Jeri user under the name in the Fltr Nm attribute.
 
Note 
 

Fltr Cont Logical Attribute Properties 
Logical Attribute Name  Fltr Cont 
Datatype  CHAR(2000) 
Nullable  YES 

Fltr Cont Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Fltr Cont Security Types 
Name  Current Value 

Fltr Cont Bound Attachments 
Name  Current Value 

Fltr Cont Data Movement Rules 
Name  Type  Rule Text/Value 

Fltr Cont Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
Fltr Cont 
NO     

Fltr Cont Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Cont Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Cont Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Fltr Cont Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Java Prop 
Base Entity  Jeri User Properties 
Attribute Name  Java Prop 
Logical Rolename   
ColumnName  Java Prop 
RoleName   
Domain   
Logical Only  NO 
Definition 
Java Properties:  The contents of the Java Properties class of the Jeri user's session upon last exit.
 
Note 
 

Java Prop Logical Attribute Properties 
Logical Attribute Name  Java Prop 
Datatype  TEXT 
Nullable  YES 

Java Prop Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Java Prop Security Types 
Name  Current Value 

Java Prop Bound Attachments 
Name  Current Value 

Java Prop Data Movement Rules 
Name  Type  Rule Text/Value 

Java Prop Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
Java Prop 
NO     

Java Prop Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Java Prop Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Java Prop Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Java Prop Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


FLTR_TBL 
Base Entity  Jeri User Properties 
Attribute Name  FLTR_TBL 
Logical Rolename   
ColumnName  FLTR_TBL 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

FLTR_TBL Logical Attribute Properties 
Logical Attribute Name  FLTR_TBL 
Datatype  VARCHAR(32) 
Nullable  YES 

FLTR_TBL Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
FLTR_TBL Security Types 
Name  Current Value 

FLTR_TBL Bound Attachments 
Name  Current Value 

FLTR_TBL Data Movement Rules 
Name  Type  Rule Text/Value 

FLTR_TBL Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Jeri User Properties
FLTR_TBL 
NO     

FLTR_TBL Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FLTR_TBL Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FLTR_TBL Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FLTR_TBL Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description