ODF email template table (ARSDFEML)

This table maintains a catalog of email templates.

Attention: Start of change 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. End of change
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