AlertReportConfig


Description

Alert report configuration defining the relationship between alerts and reports with notification settings. This table manages alert configurations including report associations, notification preferences, scheduling options, and condition definitions for automated alert processing.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
AlertMessage.AlertReportConfigId FK_AlertMessage_AlertReportConfig R
AlertValue.AlertReportConfigId FK_AlertValue_AlertReportConfig R

Primary key - Unique identifier for each alert report configuration
ReportId int 4 null

Report reference - Links to the report that provides data for alert evaluation
MessageNotify nvarchar 200 √ null

Notification message - Message content for alert notifications
ScheduleType int 4 √ null

Schedule type - Type of scheduling for alert evaluation (daily, weekly, on-demand)
CreateBy int 4 √ null

Created by user - UserID of the person who created this configuration
CreateDate datetime 16,3 √ null

Creation date - Date and time when the configuration was created
UpdateBy int 4 √ null

Updated by user - UserID of the person who last modified this configuration
UpdateDate datetime 16,3 √ null

Update date - Date and time of the last modification
IsNotifyByEmail bit 1 √ null

Email notification flag - Controls whether notifications are sent via email
IsNotifyByText bit 1 √ null

Text notification flag - Controls whether notifications are sent via text/SMS
ConditionContent nvarchar 400 √ null

Condition content - Detailed condition logic for alert triggering

Indexes

Constraint Name Type Sort Column(s)
PK_AlertReportConfig Primary key Asc Id

Relationships

Close relationships within degrees of separation