Subject Area : 096 - Email Notification |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 096 - Email Notification | The email notification system uses table to manage processing of items. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | email_notifn | Email Notification | false | An email notification entry. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | email_notifn_attch | Email Notification Attachment | false | A link to an email attachment used for a notification email. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | email_notifn_type | Email Notification Type | false | Details.. | ||||||||||||||||||||||||||||||||||||||||||||||
. | notifn_recipient_status | Notification Recipient Status | false | Manages the sent and received status of the distribution list of contacts for a notification. | Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 22 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | 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 |