Description
Information for managing automatic alerts and user-defined follow-ups.
Remarks
Alerts are automatically generated using the data in the RULES Table, while follow-ups are user-defined reminders that are set by the user.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| ALERT_IDX3 | |||
| ALERT_IX2 | |||
| AT_ENTITY_KEY_IDX | |||
| AT_PRIMARYKEY | | |
See Also