Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AlertID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each alert configuration |
|
| AlertName | varchar | 250 | null |
|
|
Alert name - Descriptive name for the alert |
||
| fkReportID | int | 4 | null |
|
|
Report reference - Links to the report that provides data for this alert |
||
| fkCalculationConfigID | int | 4 | null |
|
|
Calculation config reference - Links to the calculation configuration for alert evaluation |
||
| ConditionType | varchar | 3 | null |
|
|
Condition type - Type of condition for alert triggering (e.g., ‘>’, ‘<’, ‘=’) |
||
| ConditionValue | decimal | 20,2 | null |
|
|
Condition value - Threshold value that triggers the alert |
||
| ButtonText | varchar | 50 | √ | null |
|
|
Button text - Text displayed on alert action buttons |
|
| ButtonColor | varchar | 50 | √ | null |
|
|
Button color - Color styling for alert action buttons |
|
| ButtonIcon | varchar | 50 | √ | null |
|
|
Button icon - Icon displayed on alert action buttons |
|
| Description | varchar | 2147483647 | √ | null |
|
|
Alert description - Detailed description of the alert purpose and usage |
|
| HideIfNoAlert | bit | 1 | √ | ((0)) |
|
|
Hide if no alert - Flag to hide the alert when conditions are not met |
|
| ActionAlert | bit | 1 | √ | ((0)) |
|
|
Action alert flag - Indicates if this alert triggers specific actions |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this alert |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date and time when the alert was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified this alert |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date and time of the last modification |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| LayerItemMarketId | int | 4 | √ | null |
|
|
Layer item market reference - Links to market-specific layer item for targeted alerts |
|
| AlertText | varchar | 2147483647 | √ | null |
|
|
Alert text - Text message displayed when alert conditions are met |
|
| NoAlertText | varchar | 2147483647 | √ | null |
|
|
No alert text - Text message displayed when alert conditions are not met |
|
| AlertFormat | varchar | 3 | ('IC') |
|
|
Alert format - Format type for alert display (IC=iCentral, etc.) |
||
| EnableNotification | bit | 1 | √ | null |
|
|
Enable notification flag - Controls whether notifications are sent for this alert |
|
| NotificationFromUserIds | varchar | 2147483647 | √ | null |
|
|
Notification from users - Comma-separated list of UserIDs that can send notifications for this alert |
|
| NotificationPriority | varchar | 50 | √ | null |
|
|
Notification priority - Priority level for alert notifications (High, Medium, Low) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Alert | Primary key | Asc | AlertID |
Relationships
Close relationships within degrees of separation
