Template Identifier |
Base Entity | Email Sent |
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 Sent Template Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT TEMPLATE_ID |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT TEMPLATE_ID |
NO | ||
Logbook (Oracle) EMAIL_SENT TEMPLATE_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 Identifer |
Base Entity | Email Sent |
Attribute Name | Sequence Identifer |
Logical Rolename | |
ColumnName | SEQ_ID |
RoleName | |
Domain | Sequence |
Logical Only | NO |
Definition | Sequence: A numerical primary key value derived from a Sequence. |
Note |
Sequence Identifer Logical Attribute Properties |
Logical Attribute Name | Sequence Identifer |
Datatype | INTEGER |
Nullable | NO |
Sequence Identifer Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sequence Identifer Security Types |
Name | Current Value |
Sequence Identifer Bound Attachments |
Name | Current Value |
Sequence Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Sequence Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Sent Sequence Identifer |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT SEQ_ID |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT SEQ_ID |
NO | ||
Logbook (Oracle) EMAIL_SENT SEQ_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT SEQ_ID |
NO |
Sequence Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sequence Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Recipient Email Address |
Base Entity | Email Sent |
Attribute Name | Recipient Email Address |
Logical Rolename | |
ColumnName | RECPT_EMAIL_ADDR |
RoleName | |
Domain | Email Addr |
Logical Only | NO |
Definition | Email Address: |
Note |
Recipient Email Address Logical Attribute Properties |
Logical Attribute Name | Recipient Email Address |
Datatype | VARCHAR(75) |
Nullable | NO |
Recipient Email Address Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Recipient Email Address Security Types |
Name | Current Value |
Recipient Email Address Bound Attachments |
Name | Current Value |
Recipient Email Address Data Movement Rules |
Name | Type | Rule Text/Value |
Recipient Email Address Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Sent Recipient Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT RECPT_EMAIL_ADDR |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT RECPT_EMAIL_ADDR |
NO | ||
Logbook (Oracle) EMAIL_SENT RECPT_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT RECPT_EMAIL_ADDR |
NO |
Recipient Email Address Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Recipient Email Address Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Recipient Email Address Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Recipient Email Address Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date |
Base Entity | Email Sent |
Attribute Name | Current Date |
Logical Rolename | |
ColumnName | CUR_DTE |
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 Sent Current Date |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT CUR_DTE |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT CUR_DTE |
NO | ||
Logbook (Oracle) EMAIL_SENT CUR_DTE |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT CUR_DTE |
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 |
Proposal Identifier |
Base Entity | Email Sent |
Attribute Name | Proposal Identifier |
Logical Rolename | |
ColumnName | PRPSL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Proposal Identifier: Unique identifer assigned to the proposal. |
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 Sent Proposal Identifier |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT PRPSL_ID |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT PRPSL_ID |
NO | ||
Logbook (Oracle) EMAIL_SENT PRPSL_ID |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 |
From Email Address |
Base Entity | Email Sent |
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 Sent From Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT FROM_EMAIL_ADDR |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT FROM_EMAIL_ADDR |
NO | ||
Logbook (Oracle) EMAIL_SENT FROM_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 Sent |
Attribute Name | Email Subject |
Logical Rolename | |
ColumnName | EMAIL_SUBJ |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Email Subject: The subject of the email. |
Note |
Email Subject Logical Attribute Properties |
Logical Attribute Name | Email Subject |
Datatype | VARCHAR(500) |
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 Sent Email Subject |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT EMAIL_SUBJ |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT EMAIL_SUBJ |
NO | ||
Logbook (Oracle) EMAIL_SENT EMAIL_SUBJ |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 Sent |
Attribute Name | Email Text |
Logical Rolename | |
ColumnName | EMAIL_TEXT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Email Text: The body of the email. |
Note |
Email Text Logical Attribute Properties |
Logical Attribute Name | Email Text |
Datatype | VARCHAR(4000) |
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 Sent Email Text |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT EMAIL_TEXT |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT EMAIL_TEXT |
NO | ||
Logbook (Oracle) EMAIL_SENT EMAIL_TEXT |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 Sent |
Attribute Name | Carbon Copy Email Address |
Logical Rolename | |
ColumnName | CC_EMAIL_ADDR |
RoleName | |
Domain | Email Addr |
Logical Only | NO |
Definition | Email Address: |
Note |
Carbon Copy Email Address Logical Attribute Properties |
Logical Attribute Name | Carbon Copy Email Address |
Datatype | VARCHAR(4000) |
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 Sent Carbon Copy Email Address |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT CC_EMAIL_ADDR |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT CC_EMAIL_ADDR |
NO | ||
Logbook (Oracle) EMAIL_SENT CC_EMAIL_ADDR |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT 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 |
Mod By Uid |
Base Entity | Email Sent |
Attribute Name | Mod By Uid |
Logical Rolename | |
ColumnName | MOD_BY_UID |
RoleName | |
Domain | Mod By Uid |
Logical Only | NO |
Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
Note |
Mod By Uid Logical Attribute Properties |
Logical Attribute Name | Mod By Uid |
Datatype | VARCHAR(64) |
Nullable | NO |
Mod By Uid Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Mod By Uid Security Types |
Name | Current Value |
Mod By Uid Bound Attachments |
Name | Current Value |
Mod By Uid Data Movement Rules |
Name | Type | Rule Text/Value |
Mod By Uid Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Email Sent Mod By Uid |
NO | ||
CNMS_PRPSL (Oracle) EMAIL_SENT MOD_BY_UID |
NO | ||
Instrument Logbook (Oracle) EMAIL_SENT MOD_BY_UID |
NO | ||
Logbook (Oracle) EMAIL_SENT MOD_BY_UID |
NO | ||
XF_ADMIN (Oracle) EMAIL_SENT MOD_BY_UID |
NO |
Mod By Uid Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |