Parent topic: Tables

AgilePoint Database Schema / Tables

WF_MAIL_DELIVERABLES

Description

Contains information about the email notification.

Columns

For the descriptions in this table, the term item refers to a mail deliverable.

Column Name	Data Type	Size	Description
ID	nvarchar	32	(Primary key) The unique item ID.
STATUS	nvarchar	32	The status of the mail deliverables. Sent: Indicates email has been sent to the SMTP server. Failed: Indicates email failed to be sent to the SMTP server. Created: Indicates email is created to preprocess. Canceled: Indicates email is canceled. Deferred: Indicates email does not need to be sent immediately.
PROC_INST_ID	varchar	32	(Foreign key to WF_PROC_INSTS table) The process instance ID.
ACTIVITY_INST_ID	varchar	32	(Foreign key to WF_ACTIVITY_INSTS table) Represents the ID of the activity instance this item is associated with.
REASON	nvarchar	2048	The reason the mail deliverable failed and was canceled.
DELIVERY_TIME	int	4	The number of times the server tried to deliver the mail deliverable.
NEXT_SENDING_DATE	datetime	8	The date the server will try to re-deliver the mail deliverable.
CREATED_DATE	datetime	8	The date the item was created.
SESSION_	int	4	Indicates the number of times the item has been completed or attempted.

Relationships

Table Name	Relationship
WF_PROC_INSTS	n – 1
WF_ACTIVITY_INSTS	n – 1