sp290_dispatch_types

Look up table of earmark types (as used in sp100). Current contents of this table are:

0	automatic	Automatic is anything eamarked as a side effect of another operation e.g. ABS, Gantt allocation, Gantt move.
1	batch	Batch is anything earmarked by the batch scan.
2	user	User is the explicit change from tentative/fixed to earmarked on the Gantt.
3	Real Time Earmark	Real Time Earmark is anything earmarked by the real-time scan (or the scan by the optimizer on completion).

Table Definition

Field	Type	Default	Nullable
dispatch_type	number(2)
description	varchar2(20)
field_id	varchar2(100)

primary key (dispatch_type)
foreign key (field_id) references sp900_language_translation (field_id)

Field	Description
dispatch_type	Primary key: unique identifier of the type.
description	Deprecated - Short description of the type.
field_id	Key to language translation for description.