Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AlertID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each alert configuration, auto-incrementing integer |
|
| AlertName | varchar | 250 | null |
|
|
Alert display name - Human-readable name for the alert used in administration and notifications (required field) |
||
| fkReportID | int | 4 | null |
|
|
Data source reference - Foreign key linking to report or data source that provides metrics for alert evaluation (required field) |
||
| fkCalculationConfigID | int | 4 | null |
|
|
Calculation reference - Foreign key linking to calculation configuration defining how alert values are computed (required field) |
||
| ConditionType | varchar | 3 | null |
|
|
Alert condition - Type of condition for alert triggering (e.g., greater than, less than, equals, not equals) defining when alert fires (required field) |
||
| ConditionValue | decimal | 20,2 | null |
|
|
Threshold value - Numeric threshold that triggers the alert when condition is met (required field) |
||
| ButtonText | varchar | 50 | √ | null |
|
|
Action button label - Text displayed on action buttons in alert notifications for user interaction |
|
| ButtonColor | varchar | 50 | √ | null |
|
|
Button styling - Color code for action buttons to indicate alert severity or type |
|
| ButtonIcon | varchar | 50 | √ | null |
|
|
Button icon - Icon identifier for action buttons to provide visual context |
|
| Description | varchar | 2147483647 | √ | null |
|
|
Alert description - Detailed explanation of what the alert monitors and why it’s important |
|
| HideIfNoAlert | bit | 1 | √ | ((0)) |
|
|
Visibility control - Boolean flag to hide alert display when no alert condition is active |
|
| ActionAlert | bit | 1 | √ | ((0)) |
|
|
Action required flag - Boolean indicating if alert requires user action or is informational only |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created the alert configuration for accountability |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the alert was first configured for audit trail |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier user ID - Reference to user who made the most recent update |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - Most recent update to alert configuration |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Soft delete timestamp - When alert was logically deleted while preserving configuration history |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Market layer reference - Optional reference to specific market or layer context for alert scope |
|
| AlertText | varchar | 2147483647 | √ | null |
|
|
Alert message - Text displayed when alert condition is active for user notification |
|
| NoAlertText | varchar | 2147483647 | √ | null |
|
|
Normal state message - Text displayed when alert condition is not active |
|
| AlertFormat | varchar | 3 | ('IC') |
|
|
Alert format type - Format specification for alert display (defaults to ‘IC’ format) |
||
| EnableNotification | bit | 1 | √ | null |
|
|
Notification enabled - Boolean flag controlling whether alert sends notifications when triggered |
|
| NotificationFromUserIds | varchar | 2147483647 | √ | null |
|
|
Notification senders - List of user IDs who can send notifications for this alert |
|
| NotificationPriority | varchar | 50 | √ | null |
|
|
Notification priority - Priority level for alert notifications affecting delivery and display |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Alert | Primary key | Asc | AlertID |