| Template Identifier |
| Base Entity | Email Template |
| 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 | VARCHAR(10) |
| 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 Template Identifier |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE TEMPLATE_ID |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE TEMPLATE_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE 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 |
| TEMPLATE_NM |
| Base Entity | Email Template |
| Attribute Name | TEMPLATE_NM |
| Logical Rolename | |
| ColumnName | TEMPLATE_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| TEMPLATE_NM Logical Attribute Properties |
| Logical Attribute Name | TEMPLATE_NM |
| Datatype | VARCHAR(30) |
| Nullable | YES |
| TEMPLATE_NM Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| TEMPLATE_NM Security Types |
| Name | Current Value |
| TEMPLATE_NM Bound Attachments |
| Name | Current Value |
| TEMPLATE_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMPLATE_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template TEMPLATE_NM |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE TEMPLATE_NM |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE TEMPLATE_NM |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE TEMPLATE_NM |
NO |
| TEMPLATE_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR |
| Base Entity | Email Template |
| Attribute Name | DESCR |
| Logical Rolename | |
| ColumnName | DESCR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| DESCR Logical Attribute Properties |
| Logical Attribute Name | DESCR |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| 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 Email Template DESCR |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE DESCR |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE DESCR |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE 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 |
| SUBJ |
| Base Entity | Email Template |
| Attribute Name | SUBJ |
| Logical Rolename | |
| ColumnName | SUBJ |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Subject: The subject of the email. |
| Note |
| SUBJ Logical Attribute Properties |
| Logical Attribute Name | SUBJ |
| Datatype | VARCHAR(2000) |
| Nullable | NO |
| SUBJ Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| SUBJ Security Types |
| Name | Current Value |
| SUBJ Bound Attachments |
| Name | Current Value |
| SUBJ Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBJ Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template SUBJ |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE SUBJ |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE SUBJ |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE SUBJ |
NO |
| SUBJ Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBJ Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT |
| Base Entity | Email Template |
| Attribute Name | TEXT |
| Logical Rolename | |
| ColumnName | TEXT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| TEXT Logical Attribute Properties |
| Logical Attribute Name | TEXT |
| Datatype | VARCHAR(max) |
| Nullable | NO |
| TEXT Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| TEXT Security Types |
| Name | Current Value |
| TEXT Bound Attachments |
| Name | Current Value |
| TEXT Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEXT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template TEXT |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE TEXT |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE TEXT |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE TEXT |
NO |
| TEXT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEXT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES |
| Base Entity | Email Template |
| Attribute Name | NOTES |
| Logical Rolename | |
| ColumnName | NOTES |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| NOTES Logical Attribute Properties |
| Logical Attribute Name | NOTES |
| Datatype | VARCHAR(max) |
| Nullable | YES |
| NOTES Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| NOTES Security Types |
| Name | Current Value |
| NOTES Bound Attachments |
| Name | Current Value |
| NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template NOTES |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE NOTES |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE NOTES |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE NOTES |
NO |
| NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM |
| Base Entity | Email Template |
| Attribute Name | EMAIL_ADDR_FROM |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR_FROM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| EMAIL_ADDR_FROM Logical Attribute Properties |
| Logical Attribute Name | EMAIL_ADDR_FROM |
| Datatype | VARCHAR(64) |
| Nullable | YES |
| EMAIL_ADDR_FROM Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| EMAIL_ADDR_FROM Security Types |
| Name | Current Value |
| EMAIL_ADDR_FROM Bound Attachments |
| Name | Current Value |
| EMAIL_ADDR_FROM Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_ADDR_FROM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template EMAIL_ADDR_FROM |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE EMAIL_ADDR_FROM |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE EMAIL_ADDR_FROM |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE EMAIL_ADDR_FROM |
NO |
| EMAIL_ADDR_FROM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR_FROM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID |
| Base Entity | Email Template |
| Attribute Name | EMAIL_TMPL_TYPE_ID |
| Logical Rolename | |
| ColumnName | EMAIL_TMPL_TYPE_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| EMAIL_TMPL_TYPE_ID Logical Attribute Properties |
| Logical Attribute Name | EMAIL_TMPL_TYPE_ID |
| Datatype | CHAR(1) |
| Nullable | NO |
| EMAIL_TMPL_TYPE_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'S' | ||
| Bound Default |
| EMAIL_TMPL_TYPE_ID Security Types |
| Name | Current Value |
| EMAIL_TMPL_TYPE_ID Bound Attachments |
| Name | Current Value |
| EMAIL_TMPL_TYPE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_TMPL_TYPE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template EMAIL_TMPL_TYPE_ID |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE EMAIL_TMPL_TYPE_ID |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE EMAIL_TMPL_TYPE_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE EMAIL_TMPL_TYPE_ID |
NO |
| EMAIL_TMPL_TYPE_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID |
| Base Entity | Email Template |
| Attribute Name | ACT_ID |
| Logical Rolename | |
| ColumnName | ACT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ACT_ID Logical Attribute Properties |
| Logical Attribute Name | ACT_ID |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| ACT_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ACT_ID Security Types |
| Name | Current Value |
| ACT_ID Bound Attachments |
| Name | Current Value |
| ACT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template ACT_ID |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE ACT_ID |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE ACT_ID |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE ACT_ID |
NO |
| ACT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD |
| Base Entity | Email Template |
| Attribute Name | CRITERIA_CD |
| Logical Rolename | |
| ColumnName | CRITERIA_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| CRITERIA_CD Logical Attribute Properties |
| Logical Attribute Name | CRITERIA_CD |
| Datatype | CHAR(1) |
| Nullable | YES |
| CRITERIA_CD Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| CRITERIA_CD Security Types |
| Name | Current Value |
| CRITERIA_CD Bound Attachments |
| Name | Current Value |
| CRITERIA_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| CRITERIA_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template CRITERIA_CD |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE CRITERIA_CD |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE CRITERIA_CD |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE CRITERIA_CD |
NO |
| CRITERIA_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRITERIA_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND |
| Base Entity | Email Template |
| Attribute Name | SINGLE_SEND_IND |
| Logical Rolename | |
| ColumnName | SINGLE_SEND_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| SINGLE_SEND_IND Logical Attribute Properties |
| Logical Attribute Name | SINGLE_SEND_IND |
| Datatype | CHAR(1) |
| Nullable | NO |
| SINGLE_SEND_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| SINGLE_SEND_IND Security Types |
| Name | Current Value |
| SINGLE_SEND_IND Bound Attachments |
| Name | Current Value |
| SINGLE_SEND_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SINGLE_SEND_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template SINGLE_SEND_IND |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE SINGLE_SEND_IND |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE SINGLE_SEND_IND |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE SINGLE_SEND_IND |
NO |
| SINGLE_SEND_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SINGLE_SEND_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACTIVE_IND |
| Base Entity | Email Template |
| Attribute Name | ACTIVE_IND |
| Logical Rolename | |
| ColumnName | ACTIVE_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| ACTIVE_IND Logical Attribute Properties |
| Logical Attribute Name | ACTIVE_IND |
| Datatype | CHAR(1) |
| Nullable | NO |
| ACTIVE_IND Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'Y' | ||
| Bound Default |
| ACTIVE_IND Security Types |
| Name | Current Value |
| ACTIVE_IND Bound Attachments |
| Name | Current Value |
| ACTIVE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| ACTIVE_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template ACTIVE_IND |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE ACTIVE_IND |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE ACTIVE_IND |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE ACTIVE_IND |
NO |
| ACTIVE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACTIVE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACTIVE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACTIVE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXP_TMPL_TYPE |
| Base Entity | Email Template |
| Attribute Name | EXP_TMPL_TYPE |
| Logical Rolename | |
| ColumnName | EXP_TMPL_TYPE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| EXP_TMPL_TYPE Logical Attribute Properties |
| Logical Attribute Name | EXP_TMPL_TYPE |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| EXP_TMPL_TYPE Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| EXP_TMPL_TYPE Security Types |
| Name | Current Value |
| EXP_TMPL_TYPE Bound Attachments |
| Name | Current Value |
| EXP_TMPL_TYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXP_TMPL_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template EXP_TMPL_TYPE |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE EXP_TMPL_TYPE |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE EXP_TMPL_TYPE |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE EXP_TMPL_TYPE |
NO |
| EXP_TMPL_TYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXP_TMPL_TYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXP_TMPL_TYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXP_TMPL_TYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |