sp257_band_lists

This table defines one or more ordered lists of time bands to be used in appointment offering.

Table Definition

Field	Type	Default	Nullable
`list_name`	`varchar2(2)`
`band_name`	`varchar2(4)`
`sequence`	`number(2)`

primary key (list_name, band_name)
foreign key (band_name) references sp259_time_bands (band_name)
foreign key (list_name) references sp256_promise_set_descriptions (list_name)

Field Description

list_name

List identifier.

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

band_name

Time band identifier.

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

sequence Not used internally but available for ordering the time bands for display.