This table maintains a catalog of email templates.
Attention: Starting in Version 9.5, email templates
are no longer used. Email customization is now done by using the ARSODF.XML
file. See the
Content Manager OnDemand Distribution Facility Installation
and Reference for more information on the ARSODF.XML file.
Table 1. Email template table (ARSDFEML)Column Name |
Data Type |
Description |
EML_UPR_RCPT_TO_EMAIL |
VARCHAR(254) |
Recipient to email address in uppercase |
EML_RCPT_TO_EMAIL |
VARCHAR(254) |
Recipient to email address |
EML_RCPT_TO_NAME |
VARCHAR(120) |
Recipient to name |
EML_RCPT_FROM_EMAIL |
VARCHAR(254) |
Recipient from email address |
EML_RCPT_FROM_NAME |
VARCHAR(120) |
Recipient from name |
EML_NOTIFICATION |
CHAR(1) |
Notification flag |
EML_SYSTEM |
VARCHAR(63) |
System |
EML_STATUS |
CHAR(1) |
Status |
EML_SUBJECT |
VARCHAR(63) |
Subject line of email |
EML_BODY_LINES1 |
VARCHAR(76) |
Body of email line 1 |
EML_BODY_LINES2 |
VARCHAR(76) |
Body of email line 2 |
EML_BODY_LINES3 |
VARCHAR(76) |
Body of email line 3 |
EML_BODY_LINES4 |
VARCHAR(76) |
Body of email line 4 |
EML_BODY_LINES5 |
VARCHAR(76) |
Body of email line 5 |
EML_BODY_LINES6 |
VARCHAR(76) |
Body of email line 6 |
EML_BODY_LINES7 |
VARCHAR(76) |
Body of email line 7 |
EML_BODY_LINES8 |
VARCHAR(76) |
Body of email line 8 |
EML_BODY_LINES8 |
VARCHAR(76) |
Body of email line 9 |
EML_BODY_LINES10 |
VARCHAR(76) |
Body of email line 10 |
EML_UPD_USERID |
VARCHAR(128) |
Last user to update the email template |
EML_UPD_DATE |
BIGINT |
Date and time email template was last updated |
Table 2. Indexes for email template table (ARSDFEML)Index name |
Columns in index |
Type of index |
ARSDFEML_IDX1 |
EML_UPR_RCPT_TO_EMAIL, EML_NOTIFICATION |
unique cluster index |