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 | 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 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 |
Email Template Type Identifier |
Base Entity | Email Template |
Attribute Name | Email Template Type Identifier |
Logical Rolename | |
ColumnName | EMAIL_TMPL_TYPE_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Email Template Type Identifier Logical Attribute Properties |
Logical Attribute Name | Email Template Type Identifier |
Datatype | CHAR(1) |
Nullable | NO |
Email Template Type Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Email Template Type Identifier Security Types |
Name | Current Value |
Email Template Type Identifier Bound Attachments |
Name | Current Value |
Email Template Type Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Email Template Type Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Email Template Type Identifier |
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 Template Type Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Template Type Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Template Type Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Email Template Type Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Template Name |
Base Entity | Email Template |
Attribute Name | Template Name |
Logical Rolename | |
ColumnName | TEMPLATE_NM |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Template Name Logical Attribute Properties |
Logical Attribute Name | Template Name |
Datatype | VARCHAR(30) |
Nullable | YES |
Template Name Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Template Name Security Types |
Name | Current Value |
Template Name Bound Attachments |
Name | Current Value |
Template Name Data Movement Rules |
Name | Type | Rule Text/Value |
Template Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Template Name |
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 Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Template Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Template Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Template Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
From Email Address |
Base Entity | Email Template |
Attribute Name | From Email Address |
Logical Rolename | |
ColumnName | FROM_EMAIL_ADDR |
RoleName | |
Domain | Email Addr |
Logical Only | NO |
Definition | Email Address: |
Note |
From Email Address Logical Attribute Properties |
Logical Attribute Name | From Email Address |
Datatype | VARCHAR(200) |
Nullable | YES |
From Email Address Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
From Email Address Security Types |
Name | Current Value |
From Email Address Bound Attachments |
Name | Current Value |
From Email Address Data Movement Rules |
Name | Type | Rule Text/Value |
From Email Address Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Address Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
From Email Address Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
From Email Address Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
From Email Address Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | Email Template |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
Nullable | YES |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Description |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TEMPLATE DESCR |
NO | ||
EXPRESS (Oracle) EMAIL_TEMPLATE DESCR |
NO | ||
XF_ADMIN (Oracle) EMAIL_TEMPLATE DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Subject |
Base Entity | Email Template |
Attribute Name | Subject |
Logical Rolename | |
ColumnName | SUBJ |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Subject: The subject of the email. |
Note |
Subject Logical Attribute Properties |
Logical Attribute Name | Subject |
Datatype | VARCHAR(250) |
Nullable | NO |
Subject Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Subject Security Types |
Name | Current Value |
Subject Bound Attachments |
Name | Current Value |
Subject Data Movement Rules |
Name | Type | Rule Text/Value |
Subject Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Subject |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TEMPLATE SUBJ |
NO | ||
EXPRESS (Oracle) EMAIL_TEMPLATE SUBJ |
NO | ||
XF_ADMIN (Oracle) EMAIL_TEMPLATE SUBJ |
NO |
Subject Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Subject Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Subject 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(4000) |
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 |
Note |
Base Entity | Email Template |
Attribute Name | Note |
Logical Rolename | |
ColumnName | NOTE |
RoleName | |
Domain | Note |
Logical Only | NO |
Definition | |
Note |
Note Logical Attribute Properties |
Logical Attribute Name | Note |
Datatype | VARCHAR(4000) |
Nullable | YES |
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 | ||
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 Indicator |
Base Entity | Email Template |
Attribute Name | Active Indicator |
Logical Rolename | |
ColumnName | ACTIVE_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Active Indicator: Indicates whether or not the email is currently active and can be sent out. |
Note |
Active Indicator Logical Attribute Properties |
Logical Attribute Name | Active Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Active Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'Y' |
Bound Default |
Active Indicator 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 Indicator Security Types |
Name | Current Value |
Active Indicator Bound Attachments |
Name | Current Value |
Active Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Active Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Active Indicator |
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 Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Active Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Active Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Active Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier |
Base Entity | Email Template |
Attribute Name | Activity Identifier |
Logical Rolename | |
ColumnName | ACT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal. |
Note |
Activity Identifier Logical Attribute Properties |
Logical Attribute Name | Activity Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Activity Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Activity Identifier Security Types |
Name | Current Value |
Activity Identifier Bound Attachments |
Name | Current Value |
Activity Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Activity Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Template Activity Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_TEMPLATE ACT_ID |
NO | ||
EXPRESS (Oracle) EMAIL_TEMPLATE ACT_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_TEMPLATE ACT_ID |
NO |
Activity Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |