| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AlertCode | Alert Code | Int | 11 | OALR | |||
| SendDate | Date | Date | 8 | - | |||
| SendTime | Time | Int | 6 | - | |||
| WasSent | Sent | VarChar | 1 | - | N | Y | Yes |
| N | No | ||||||
| UserSign | User Signature | Int | 6 | OUSR | |||
| Key | Unique | Field |
| PRIMARY | Yes | AlertCode |
| UserSign | ||
| USER | No | UserSign |