Columns
| Column Name
| Definition |
|---|
ID |
- Function:
- The unique ID
for the email notification.
- Data Type:
- nvarchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- Yes
- Foreign Key:
- No
|
ACTIVITY_INST_ID |
- Function:
- The ID of the activity instance
associated with
the mail deliverable.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
-
|
CREATED_DATE |
- Function:
- The date the email notification was created.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DELIVERY_TIME |
- Function:
- The number of times the server tried to deliver the mail deliverable.
- Data Type:
- Int
- Size:
- 4
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
FORM_BASED_APP_NAME |
- Function:
- The name of the form-based app.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
NEXT_SENDING_DATE |
- Function:
- The date the server will try to redeliver the mail deliverable.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
PROC_INST_ID |
- Function:
- The process instance ID associated with the email notification.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
-
|
REASON |
- Function:
- The reason the mail deliverable failed and was cancelled.
- Values:
- An exception from the mail server when an email fails to send.
- Data Type:
- nvarchar
- Size:
- 2048
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
STATUS |
- Function:
- The status of the mail deliverables.
- Values:
-
- Sent - The email has been sent to the SMTP server.
- Failed - The email failed to be sent to the SMTP server.
- Created - The email is created to be sent.
- Cancelled - The email is cancelled.
- Deferred - The email does not need to be sent immediately.
- Suspended - The email is suspended.
- Data Type:
- nvarchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
SESSION_ |
- Function:
- The number of times the mail deliverable has been completed or attempted.
- Data Type:
- Int
- Size:
- 4
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
Relationships
| Table Name | Relationship |
|---|
|
WF_PROC_INSTS
| n:1 |
|
WF_ACTIVITY_INSTS
| n:1 |
