| alert_objid | alert | objid | Alert internal record number | 3 (UNIQUE) |
| user_objid | user | objid | User internal record number | |
| login_name | user | login_name | User login name | |
| active | alert | active | Indicates whether alert is active; i.e., 0=inactive, 1=active. In order to fire, an alert must be both effective and active | |
| alert_text | alert | alert_text | Text of the alert message | |
| alert_end_date | alert | end_date | Last date the alert is effective | |
| alert_start_date | alert | start_date | Date the alert becomes effective | |
| alert_title | alert | title | The title of the alert | |
| alert_type | alert | type | The type of alert | |
| hot | alert | hot | Indicates whether alert is flagged as hot; i.e., 0=no, 1=yes | |