Subject Area : 096 - Email Notification
Subject Area Name Definition
096 - Email Notification The email notification system uses table to manage processing of items.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
email_notifn Email Notification false An email notification entry.
Physical Name Attribute/Column Name Definition Physical Data Type
email_notifn_id Email Notification Id The automatically generated primary key of the email_notifn table. bigint
from_name From Name From Name. nvarchar(max)
reply_addr Reply Address Reply Address nvarchar(max)
plain_text_body Plain Text Body Plain Text Body nvarchar(max)
html_body HTML Body HTML Body nvarchar(max)
subject Subject Subject nvarchar(max)
schdd_date Scheduled Date Scheduled Date of the mass email. datetime
email_notifn_name Email Notification Name The name of the Email Notification. varchar(255)
email_notifn_descr Email Notification Description A descriptive name of the Email Notification. This descriptive name may be localized. varchar(512)
time_before_break Time Before Break Whether to send all emails at once, or send them at specified intervals. int
msgs_per_batch Messages Per Batch How many messages to send Per Batch. int
delay_between_batches Delay Between Batches Delay Between Batches int
create_date Create Date Create Date datetime
create_user Create User Create User int
plain_text_auto Plain Text Auto Plain Text Auto bit
priority Priority Email importance set in the rule ( low-5, normal-3, high-1) varchar(10)
addr_book Address Book Address Book id used for mass emails. bigint
item_type Item Type The item definition id, used for mass emails. bigint
selected_field Selected Field The Selected Field for id lookup, used for mass emails. bigint
email_notifn_type_id Email Notification Type Id The unique identifier for an instance of Email Notification Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
protocol_id Protocol Id The unique identifier for an instance of Email Notification. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
start_mail_sent Start Mail Sent Indicates if Start Mail Sent. bit
email_notifn_attch Email Notification Attachment false A link to an email attachment used for a notification email.
Physical Name Attribute/Column Name Definition Physical Data Type
email_notifn_attch_id Email Notification Attachment Id The automatically generated primary key of the email_notifn_attch table. bigint
email_attch_uri Email Attachment URI The value of a Email Notification Attachment, stored as a string. nvarchar(4000)
email_notifn_id Email Notification Id The automatically generated primary key of the email_notifn table. bigint
email_notifn_type Email Notification Type false
Physical Name Attribute/Column Name Definition Physical Data Type
email_notifn_type_id Email Notification Type Id The unique identifier for an instance of Email Notification Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
email_notifn_type_name Email Notification Type Name The unique string identifier for an instance of Email Notification Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
notifn_recipient_status Notification Recipient Status false Manages the sent and received status of the distribution list of contacts for a notification.
Physical Name Attribute/Column Name Definition Physical Data Type
recipient_status_id Recipient Status Id The automatically generated primary key of the notification_recipient_status table. The name is shortened for convenience. bigint
email_notifn_id Email Notification Id A Foreign Key to the Email Notification table. bigint
recipient_contact Recipient Contact The value of a Notification Recipient Status, stored as a string. nvarchar(4000)
retries_ct Retries Ct The value of a Notification Recipient Status stored as boolean. integer
schdd_date Scheduled Date The date that the Notification Recipient Status was created. datetime
completed_date Completed Date Completed Date. datetime
notifn_status_code Notification Status Code The unique identifier for an instance of Notification Recipient Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer