TEMPLATE_ID |
Base Object | EMAIL_TMPL_TAG |
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 | 2 |
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 Tag Template Identifier |
NO | ||
Logical Email Template Tag Template Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TMPL_TAG TEMPLATE_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_TMPL_TAG 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 |
TAG_ID |
Base Object | EMAIL_TMPL_TAG |
Attribute Name | Tag Identifier |
ColumnName | TAG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Tag Identifier: The tag embedded in the email text that will be replaced with a database derived set of text. |
Note |
TAG_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TAG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
TAG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TAG_ID Security Types |
Name | Current Value |
TAG_ID Bound Attachments |
Name | Current Value |
TAG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
TAG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Tag Tag Identifier |
NO | ||
Logical Email Template Tag TAG_ID |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TMPL_TAG TAG_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_TMPL_TAG TAG_ID |
NO |
TAG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_SRC |
Base Object | EMAIL_TMPL_TAG |
Attribute Name | Tag Source |
ColumnName | TAG_SRC |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Tag Source: The source of the Tag substitution value. (i.e SQL statement) |
Note |
TAG_SRC Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TAG_SRC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
TAG_SRC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TAG_SRC Security Types |
Name | Current Value |
TAG_SRC Bound Attachments |
Name | Current Value |
TAG_SRC Data Movement Rules |
Name | Type | Rule Text/Value |
TAG_SRC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Tag Tag Source |
NO | ||
Logical Email Template Tag TAG_SRC |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TMPL_TAG TAG_SRC |
NO | ||
XF_ADMIN (Oracle) EMAIL_TMPL_TAG TAG_SRC |
NO |
TAG_SRC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_SRC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_SRC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TAG_SRC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |