Document toolboxDocument toolbox

sp258_band_types

This table is used to define time band types - e.g. two hour time bands, half day time bands etc.


 

Table Definition

Field
Type
Default
Nullable
band_typevarchar2(2)   (error)
descriptionvarchar2(15)   (error)
sequencenumber(2)   (error) 
field_idvarchar2(100)   (error) 

Keys

primary key (band_type) 
unique (description)

Primary Key Referenced From

Column Descriptions

FieldDescription
band_type  

Band type identifier.

(warning) This column does not support wide (i.e. multibyte) characters.

descriptionBand type description.
sequence  Sequence number; used internally to order the time bands within the list for deletion of duplicates; the lowest sequence number is kept.