| TEMPLATE_ID |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Template Identifier |
| ColumnName | TEMPLATE_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Template Identiifer: Unique identifier for the email template. |
| Note |
| TEMPLATE_ID Column Properties |
| Datatype | NUMBER(3, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMPLATE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| TEMPLATE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMPLATE_ID Security Types |
| Name | Current Value |
| TEMPLATE_ID Bound Attachments |
| Name | Current Value |
| TEMPLATE_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMPLATE_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Template Identifier |
NO | ||
| 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_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMPLATE_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_TMPL_TYPE_ID |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Email Template Type Identifier |
| ColumnName | EMAIL_TMPL_TYPE_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMAIL_TMPL_TYPE_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_TMPL_TYPE_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| EMAIL_TMPL_TYPE_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| 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 Template Type Identifier |
NO | ||
| 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 |
| TEMPLATE_NM |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Template Name |
| ColumnName | TEMPLATE_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEMPLATE_NM Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMPLATE_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 30 |
| Percent Null | 0 |
| 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 Name |
NO | ||
| 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 |
| FROM_EMAIL_ADDR |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | From Email Address |
| ColumnName | FROM_EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| FROM_EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(200) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FROM_EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 200 |
| Percent Null | 0 |
| FROM_EMAIL_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FROM_EMAIL_ADDR Security Types |
| Name | Current Value |
| FROM_EMAIL_ADDR Bound Attachments |
| Name | Current Value |
| FROM_EMAIL_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| FROM_EMAIL_ADDR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template From Email Address |
NO | ||
| Logical Email Template From Email Address |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE FROM_EMAIL_ADDR |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE FROM_EMAIL_ADDR |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE FROM_EMAIL_ADDR |
NO |
| FROM_EMAIL_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FROM_EMAIL_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FROM_EMAIL_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FROM_EMAIL_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR |
| Base Object | EMAIL_TEMPLATE |
| 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 | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| 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 Description |
NO | ||
| 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 Object | EMAIL_TEMPLATE |
| Attribute Name | Subject |
| ColumnName | SUBJ |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Subject: The subject of the email. |
| Note |
| SUBJ Column Properties |
| Datatype | VARCHAR2(250) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBJ Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 250 |
| Percent Null | 0 |
| 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 Subject |
NO | ||
| 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 Object | EMAIL_TEMPLATE |
| Attribute Name | Text |
| ColumnName | TEXT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TEXT Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEXT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| 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 | ||
| 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 |
| NOTE |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Note |
| ColumnName | NOTE |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| NOTE Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| NOTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NOTE Security Types |
| Name | Current Value |
| NOTE Bound Attachments |
| Name | Current Value |
| NOTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Email Template Note |
NO | ||
| Logical Email Template Note |
NO | ||
| CNMS_PRPSL (Oracle) EMAIL_TEMPLATE NOTE |
NO | ||
| EXPRESS (Oracle) EMAIL_TEMPLATE NOTE |
NO | ||
| XF_ADMIN (Oracle) EMAIL_TEMPLATE NOTE |
NO |
| NOTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ACTIVE_IND |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Active Indicator |
| ColumnName | ACTIVE_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Active Indicator: Indicates whether or not the email is currently active and can be sent out. |
| Note |
| ACTIVE_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACTIVE_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| ACTIVE_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'Y' |
| Bound Default |
| ACTIVE_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| 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 Indicator |
NO | ||
| 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 |
| ACT_ID |
| Base Object | EMAIL_TEMPLATE |
| Attribute Name | Activity Identifier |
| ColumnName | ACT_ID |
| Logical Rolename | Activity Identifier |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal. |
| Note |
| ACT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ACT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| 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 Activity Identifier |
NO | ||
| 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 |