sp099_sa_travel_modes

This table defines the available travel modes for standard activities.

Table Definition

Field	Type	Default	Nullable
mode_no	number
short_name	varchar2(15)
description	varchar2(40)
field_id	varchar2(100)

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

Field	Description
mode_no	Number that represents the mode of travel0 = no travel.1 = travel mode is ETS.2 = travel mode is ETA.
short_name	Short name for travel mode, 'NONE', 'ETS', 'ETA'.
description	Travel mode description.
field_id	key to language translations in sp900 for description