Template Identifier |
Base Entity | Email Preview |
Attribute Name | Template Identifier |
Logical Rolename | |
ColumnName | TEMPLATE_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
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 Preview Template Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV TEMPLATE_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV 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 |
Sequence Identitifer |
Base Entity | Email Preview |
Attribute Name | Sequence Identitifer |
Logical Rolename | |
ColumnName | SEQ_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Sequence Identitifer Logical Attribute Properties |
Logical Attribute Name | Sequence Identitifer |
Datatype | NUMERIC(0, 0) |
Nullable | NO |
Sequence Identitifer Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sequence Identitifer Security Types |
Name | Current Value |
Sequence Identitifer Bound Attachments |
Name | Current Value |
Sequence Identitifer Data Movement Rules |
Name | Type | Rule Text/Value |
Sequence Identitifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Sequence Identitifer |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV SEQ_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV SEQ_ID |
NO |
Sequence Identitifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identitifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identitifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identitifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Receipt Email Address |
Base Entity | Email Preview |
Attribute Name | Receipt Email Address |
Logical Rolename | |
ColumnName | RECPT_EMAIL_ADDR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Receipt Email Address Logical Attribute Properties |
Logical Attribute Name | Receipt Email Address |
Datatype | VARCHAR(2000) |
Nullable | NO |
Receipt Email Address Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Receipt Email Address Security Types |
Name | Current Value |
Receipt Email Address Bound Attachments |
Name | Current Value |
Receipt Email Address Data Movement Rules |
Name | Type | Rule Text/Value |
Receipt Email Address Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Receipt Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV RECPT_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV RECPT_EMAIL_ADDR |
NO |
Receipt Email Address Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Receipt Email Address Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Receipt Email Address Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Receipt Email Address Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
From Email Address |
Base Entity | Email Preview |
Attribute Name | From Email Address |
Logical Rolename | |
ColumnName | FROM_EMAIL_ADDR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
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 Preview From Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV FROM_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV 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 |
Email Subject |
Base Entity | Email Preview |
Attribute Name | Email Subject |
Logical Rolename | |
ColumnName | EMAIL_SUBJ |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Email Subject Logical Attribute Properties |
Logical Attribute Name | Email Subject |
Datatype | VARCHAR(2000) |
Nullable | NO |
Email Subject Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Email Subject Security Types |
Name | Current Value |
Email Subject Bound Attachments |
Name | Current Value |
Email Subject Data Movement Rules |
Name | Type | Rule Text/Value |
Email Subject Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Email Subject |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV EMAIL_SUBJ |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV EMAIL_SUBJ |
NO |
Email Subject Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Subject Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Subject Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Email Subject Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Email Text |
Base Entity | Email Preview |
Attribute Name | Email Text |
Logical Rolename | |
ColumnName | EMAIL_TEXT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Email Text Logical Attribute Properties |
Logical Attribute Name | Email Text |
Datatype | VARCHAR(max) |
Nullable | NO |
Email Text Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Email Text Security Types |
Name | Current Value |
Email Text Bound Attachments |
Name | Current Value |
Email Text Data Movement Rules |
Name | Type | Rule Text/Value |
Email Text Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Email Text |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV EMAIL_TEXT |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV EMAIL_TEXT |
NO |
Email Text Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Text Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Email Text Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Email Text Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Carbon Copy Email Address |
Base Entity | Email Preview |
Attribute Name | Carbon Copy Email Address |
Logical Rolename | |
ColumnName | CC_EMAIL_ADDR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Carbon Copy Email Address Logical Attribute Properties |
Logical Attribute Name | Carbon Copy Email Address |
Datatype | VARCHAR(max) |
Nullable | YES |
Carbon Copy Email Address Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Carbon Copy Email Address Security Types |
Name | Current Value |
Carbon Copy Email Address Bound Attachments |
Name | Current Value |
Carbon Copy Email Address Data Movement Rules |
Name | Type | Rule Text/Value |
Carbon Copy Email Address Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Carbon Copy Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV CC_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV CC_EMAIL_ADDR |
NO |
Carbon Copy Email Address Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Carbon Copy Email Address Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Carbon Copy Email Address Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Carbon Copy Email Address Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier |
Base Entity | Email Preview |
Attribute Name | Proposal Identifier |
Logical Rolename | |
ColumnName | PRPSL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Proposal Identifier Logical Attribute Properties |
Logical Attribute Name | Proposal Identifier |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
Proposal Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Proposal Identifier Security Types |
Name | Current Value |
Proposal Identifier Bound Attachments |
Name | Current Value |
Proposal Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Proposal Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Proposal Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV PRPSL_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV PRPSL_ID |
NO |
Proposal Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Proposal Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number |
Base Entity | Email Preview |
Attribute Name | Submission Number |
Logical Rolename | |
ColumnName | SUBMISS_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Submission Number Logical Attribute Properties |
Logical Attribute Name | Submission Number |
Datatype | NUMERIC(2, 0) |
Nullable | YES |
Submission Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Submission Number Security Types |
Name | Current Value |
Submission Number Bound Attachments |
Name | Current Value |
Submission Number Data Movement Rules |
Name | Type | Rule Text/Value |
Submission Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Submission Number |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV SUBMISS_NBR |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV SUBMISS_NBR |
NO |
Submission Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Run Number |
Base Entity | Email Preview |
Attribute Name | Run Number |
Logical Rolename | |
ColumnName | RUN_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Run Number Logical Attribute Properties |
Logical Attribute Name | Run Number |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
Run Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Run Number Security Types |
Name | Current Value |
Run Number Bound Attachments |
Name | Current Value |
Run Number Data Movement Rules |
Name | Type | Rule Text/Value |
Run Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Run Number |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV RUN_NBR |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV RUN_NBR |
NO |
Run Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Run Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Run Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Run Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Name |
Base Entity | Email Preview |
Attribute Name | User Name |
Logical Rolename | |
ColumnName | USERNM |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
User Name Logical Attribute Properties |
Logical Attribute Name | User Name |
Datatype | VARCHAR(64) |
Nullable | YES |
User Name Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
User Name Security Types |
Name | Current Value |
User Name Bound Attachments |
Name | Current Value |
User Name Data Movement Rules |
Name | Type | Rule Text/Value |
User Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview User Name |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV USERNM |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV USERNM |
NO |
User Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier |
Base Entity | Email Preview |
Attribute Name | Instrument Identifier |
Logical Rolename | |
ColumnName | INSTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Instrument Identifier: Abbreviated identier for the instrument. |
Note |
Instrument Identifier Logical Attribute Properties |
Logical Attribute Name | Instrument Identifier |
Datatype | VARCHAR(20) |
Nullable | YES |
Instrument Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Instrument Identifier Security Types |
Name | Current Value |
Instrument Identifier Bound Attachments |
Name | Current Value |
Instrument Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Instrument Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Instrument Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV INSTR_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV INSTR_ID |
NO |
Instrument Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Application Code |
Base Entity | Email Preview |
Attribute Name | Application Code |
Logical Rolename | |
ColumnName | APP_CD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Application Code: Code which indicates from what application the email was generated from. (e.g. E - Express, I - IPTS) |
Note |
Application Code Logical Attribute Properties |
Logical Attribute Name | Application Code |
Datatype | CHAR(1) |
Nullable | YES |
Application Code Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Application Code Security Types |
Name | Current Value |
Application Code Bound Attachments |
Name | Current Value |
Application Code Data Movement Rules |
Name | Type | Rule Text/Value |
Application Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Application Code |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV APP_CD |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV APP_CD |
NO |
Application Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Application Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Application Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Application Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date |
Base Entity | Email Preview |
Attribute Name | Current Date |
Logical Rolename | |
ColumnName | Current Date |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Current Date Logical Attribute Properties |
Logical Attribute Name | Current Date |
Datatype | DATE |
Nullable | NO |
Current Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Current Date Security Types |
Name | Current Value |
Current Date Bound Attachments |
Name | Current Value |
Current Date Data Movement Rules |
Name | Type | Rule Text/Value |
Current Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Preview Current Date |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_PREV CUR_DTE |
NO | ||
XF_ADMIN (Oracle) EMAIL_PREV Current Date |
NO |
Current Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |