NotificationStatus Table

The NotificationStatus table stores the response status of notification shared to user.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for NotificationStatus table

Database Column

Details

NotificationStatusID

Type: integer. Key. Generated ID

Auto-generated Notification Status ID.

IsSuccess

Type: boolean

Column used to store the response Status Code.

SessionUID

Type: unique identifier

Column used to store response Message ID.

Message

Type: text

Column used to store response Message.

NotificationExecutionID

Type: text (max 50 characters)

Automation Execution ID of the notification returned from API

NotificationStagingID

Type: integer. Nullable

Notification Staging ID of the notification

RecipientEmailID

Type: text (max 200 characters)

Recipient Email ID of the notification

CreationDate

Type: datetime

Notification status record created datetime.