Template Identifier 
Base Entity  Email Template Proposal Type Status Association 
Attribute Name  Template Identifier 
Logical Rolename   
ColumnName  TEMPLATE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Template Identiifer: Unique identifier for the email template.
 
Note 
 

Template Identifier Logical Attribute Properties 
Logical Attribute Name  Template Identifier 
Datatype  NUMERIC(3, 0) 
Nullable  NO 

Template Identifier Domain Restrictions 

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

Template Identifier Bound Attachments 
Name  Current Value 

Template Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Template Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Template Proposal Type Status Association
Template Identifier 
NO     
XF_ADMIN (Oracle)
EMAIL_TMPL_PRPSL_TYPE_ST_ASSC
TEMPLATE_ID 
NO     

Template Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Template Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Proposal Type Identifer 
Base Entity  Email Template Proposal Type Status Association 
Attribute Name  Proposal Type Identifer 
Logical Rolename   
ColumnName  PRPSL_TYPE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Proposal Type Idenitifer: Abbreviated identifer for the type of proposal.
 
Note 
 

Proposal Type Identifer Logical Attribute Properties 
Logical Attribute Name  Proposal Type Identifer 
Datatype  VARCHAR(20) 
Nullable  NO 

Proposal Type Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Proposal Type Identifer Security Types 
Name  Current Value 

Proposal Type Identifer Bound Attachments 
Name  Current Value 

Proposal Type Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Type Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Template Proposal Type Status Association
Proposal Type Identifer 
NO     
XF_ADMIN (Oracle)
EMAIL_TMPL_PRPSL_TYPE_ST_ASSC
PRPSL_TYPE_ID 
NO     

Proposal Type Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Status Identifier 
Base Entity  Email Template Proposal Type Status Association 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Status Identifer: Abbreviated idenfifer for the given status.
 
Note 
 

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

Status Identifier Domain Restrictions 

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

Status Identifier Bound Attachments 
Name  Current Value 

Status Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Status Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Template Proposal Type Status Association
Status Identifier 
NO     
XF_ADMIN (Oracle)
EMAIL_TMPL_PRPSL_TYPE_ST_ASSC
STAT_ID 
NO     

Status Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description