Information for managing automatic alerts and user-defined follow-ups.
Alerts are automatically generated using the data in the RULES Table, while follow-ups are user-defined reminders that are set by the user.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | AT_ID | The record ID. | int | 4 | ||
AT_USER | The owner of the alert or follow-up. | varchar | 60 | ![]() | ||
AT_ENTITY_TYPE | The name of the table containing the entity to which the alert applies. | varchar | 50 | ![]() | ||
AT_KEY1 | The ID of the entity in the table specified by AT_ENTITY_TYPE. | int | 4 | ![]() | ||
AT_KEY2 | For backward compatibility. Field may be removed in future version. | int | 4 | ![]() | ||
AT_KEY3 | For backward compatibility. Field may be removed in future version. | int | 4 | ![]() | ||
AT_DESCRIPTION | The description of the alert. | varchar | 16 | ![]() | ||
AT_DATE | Either the date and time the alert was sent or the date the follow-up is configured to be sent. | datetime | 4 | ![]() | ||
AT_SENT_BY_EMAIL | Indicates whether the follow-up was emailed. Y or N. | varchar | 1 | ![]() | ||
AT_ALERT_TYPE | The type of alert created. 0 for automatic alert. 1 for Follow-up. | int | 4 | ![]() | ||
AT_ALERT_STATUS | Indicates whether the alert has been read. 1 if read. 0 if still unread. | int | 4 | ![]() |