sp287_dispatch_statuses
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
Lookup table of possible delivery status for dispatch messages (used in sp100 and sp207). Current contents of this table are:
| 0 | pending dispatch |
| 1 | dispatched OK |
| 2 | failed dispatch |
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| dispatch_status | number(2)Â | Â | Â  |
| description | varchar2(20)Â | Â | Â |
| field_id | varchar2(100)Â | Â | Â |
Keys
primary key (dispatch_status)Â
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| dispatch_status | Primary key: unique identifier of the status . |
| description | Depreciated - Short description of the status. |
| field_id | Key to language translations for description. |