TEMPLATE_ID 
Base Object  EMAIL_PREV 
Attribute Name  Template Identifier 
ColumnName  TEMPLATE_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

TEMPLATE_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TEMPLATE_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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 Preview
Template Identifier 
NO     
Logical
Email Preview
Template Identifier 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
TEMPLATE_ID 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
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 


SEQ_ID 
Base Object  EMAIL_PREV 
Attribute Name  Sequence Identitifer 
ColumnName  SEQ_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

SEQ_ID Column Properties 
Datatype  NUMBER 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SEQ_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

SEQ_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SEQ_ID Security Types 
Name  Current Value 

SEQ_ID Bound Attachments 
Name  Current Value 

SEQ_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SEQ_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Sequence Identifer 
NO     
Logical
Email Preview
Sequence Identitifer 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
SEQ_ID 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
SEQ_ID 
NO     

SEQ_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SEQ_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RECPT_EMAIL_ADDR 
Base Object  EMAIL_PREV 
Attribute Name  Receipt Email Address 
ColumnName  RECPT_EMAIL_ADDR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

RECPT_EMAIL_ADDR Column Properties 
Datatype  VARCHAR2(2000) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RECPT_EMAIL_ADDR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2000 
Percent Null 

RECPT_EMAIL_ADDR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RECPT_EMAIL_ADDR Security Types 
Name  Current Value 

RECPT_EMAIL_ADDR Bound Attachments 
Name  Current Value 

RECPT_EMAIL_ADDR Data Movement Rules 
Name  Type  Rule Text/Value 

RECPT_EMAIL_ADDR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Recipient Email Address 
NO     
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     

RECPT_EMAIL_ADDR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RECPT_EMAIL_ADDR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RECPT_EMAIL_ADDR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RECPT_EMAIL_ADDR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


FROM_EMAIL_ADDR 
Base Object  EMAIL_PREV 
Attribute Name  From Email Address 
ColumnName  FROM_EMAIL_ADDR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
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 

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 Preview
From Email Address 
NO     
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_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 


EMAIL_SUBJ 
Base Object  EMAIL_PREV 
Attribute Name  Email Subject 
ColumnName  EMAIL_SUBJ 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

EMAIL_SUBJ Column Properties 
Datatype  VARCHAR2(2000) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

EMAIL_SUBJ Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  500 
Percent Null 

EMAIL_SUBJ Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EMAIL_SUBJ Security Types 
Name  Current Value 

EMAIL_SUBJ Bound Attachments 
Name  Current Value 

EMAIL_SUBJ Data Movement Rules 
Name  Type  Rule Text/Value 

EMAIL_SUBJ Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Email Subject 
NO     
Logical
Email Preview
Email Subject 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
EMAIL_SUBJ 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
EMAIL_SUBJ 
NO     

EMAIL_SUBJ Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_SUBJ Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_SUBJ Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EMAIL_SUBJ Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EMAIL_TEXT 
Base Object  EMAIL_PREV 
Attribute Name  Email Text 
ColumnName  EMAIL_TEXT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

EMAIL_TEXT Column Properties 
Datatype  VARCHAR2(4000) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

EMAIL_TEXT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null 

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     
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 


CC_EMAIL_ADDR 
Base Object  EMAIL_PREV 
Attribute Name  Carbon Copy Email Address 
ColumnName  CC_EMAIL_ADDR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

CC_EMAIL_ADDR Column Properties 
Datatype  VARCHAR2(4000) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CC_EMAIL_ADDR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null 

CC_EMAIL_ADDR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

CC_EMAIL_ADDR Security Types 
Name  Current Value 

CC_EMAIL_ADDR Bound Attachments 
Name  Current Value 

CC_EMAIL_ADDR Data Movement Rules 
Name  Type  Rule Text/Value 

CC_EMAIL_ADDR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Carbon Copy Email Address 
NO     
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     

CC_EMAIL_ADDR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CC_EMAIL_ADDR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CC_EMAIL_ADDR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CC_EMAIL_ADDR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PRPSL_ID 
Base Object  EMAIL_PREV 
Attribute Name  Proposal Identifier 
ColumnName  PRPSL_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

PRPSL_ID Column Properties 
Datatype  NUMBER(10, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PRPSL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

PRPSL_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PRPSL_ID Security Types 
Name  Current Value 

PRPSL_ID Bound Attachments 
Name  Current Value 

PRPSL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Proposal Identifier 
NO     
Logical
Email Preview
Proposal Identifier 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
PRPSL_ID 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
PRPSL_ID 
NO     

PRPSL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SUBMISS_NBR 
Base Object  EMAIL_PREV 
Attribute Name  Submission Number 
ColumnName  SUBMISS_NBR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

SUBMISS_NBR Column Properties 
Datatype  NUMBER(2, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SUBMISS_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

SUBMISS_NBR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SUBMISS_NBR Security Types 
Name  Current Value 

SUBMISS_NBR Bound Attachments 
Name  Current Value 

SUBMISS_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

SUBMISS_NBR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Submission Number 
NO     
Logical
Email Preview
Submission Number 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
SUBMISS_NBR 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
SUBMISS_NBR 
NO     

SUBMISS_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RUN_NBR 
Base Object  EMAIL_PREV 
Attribute Name  Run Number 
ColumnName  RUN_NBR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

RUN_NBR Column Properties 
Datatype  NUMBER(5, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RUN_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

RUN_NBR Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RUN_NBR Security Types 
Name  Current Value 

RUN_NBR Bound Attachments 
Name  Current Value 

RUN_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

RUN_NBR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Run Number 
NO     
Logical
Email Preview
Run Number 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
RUN_NBR 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
RUN_NBR 
NO     

RUN_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RUN_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RUN_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RUN_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


USERNM 
Base Object  EMAIL_PREV 
Attribute Name  User Name 
ColumnName  USERNM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

USERNM Column Properties 
Datatype  VARCHAR2(64) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

USERNM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  64 
Percent Null 

USERNM Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

USERNM Security Types 
Name  Current Value 

USERNM Bound Attachments 
Name  Current Value 

USERNM Data Movement Rules 
Name  Type  Rule Text/Value 

USERNM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
User Name 
NO     
Logical
Email Preview
User Name 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
USERNM 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
USERNM 
NO     

USERNM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

USERNM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

USERNM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

USERNM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INSTR_ID 
Base Object  EMAIL_PREV 
Attribute Name  Instrument Identifier 
ColumnName  INSTR_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Instrument Identifier: Abbreviated identier for the instrument.
 
Note 
 

INSTR_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INSTR_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

INSTR_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

INSTR_ID Security Types 
Name  Current Value 

INSTR_ID Bound Attachments 
Name  Current Value 

INSTR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INSTR_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Instrument Identifier 
NO     
Logical
Email Preview
Instrument Identifier 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
INSTR_ID 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
INSTR_ID 
NO     

INSTR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


APP_CD 
Base Object  EMAIL_PREV 
Attribute Name  Application Code 
ColumnName  APP_CD 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Application Code: Code which indicates from what application the email was generated from. (e.g. E - Express, I - IPTS)
 
Note 
 

APP_CD Column Properties 
Datatype  CHAR(1) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

APP_CD Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

APP_CD Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

APP_CD Security Types 
Name  Current Value 

APP_CD Bound Attachments 
Name  Current Value 

APP_CD Data Movement Rules 
Name  Type  Rule Text/Value 

APP_CD Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Email Preview
Application Code 
NO     
Logical
Email Preview
Application Code 
NO     
CNMS_PRPSL (Oracle)
EMAIL_PREV
APP_CD 
NO     
XF_ADMIN (Oracle)
EMAIL_PREV
APP_CD 
NO     

APP_CD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

APP_CD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

APP_CD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

APP_CD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current Date 
Base Object  EMAIL_PREV 
Attribute Name  Current Date 
ColumnName  Current Date 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Current Date Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

Current Date Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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     
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