sp058_responsibility_units

This table is used to give information about each responsibility unit. A responsibility unit is used as the basis of all scheduling. Each unit has a number of teams (see table sp253_ru_teams) and covers a number of regions (see table sp059_ru_regions).

Table Definition

Field	Type	Default
resp_unit_no	number(4)
resp_unit_ref	varchar2(8)
resp_unit_type	number(1)
description	varchar2(40)
owning_resp_unit_no	number(4)
preference_factor	number(2,1)	0
travel_time	number(11)
tz_no	number(2)
field_id	varchar2(100)

Keys

primary key (resp_unit_no)

unique (resp_unit_no, resp_unit_ref)

unique (resp_unit_ref)

foreign key (owning_resp_unit_no) references sp058_responsibility_units (resp_unit_no)

foreign key (resp_unit_type) references sp270_resp_unit_types (resp_unit_type)

foreign key (tz_no) references sp056_time_zones (tz_no)

foreign key (field_id) references sp900_language_translation (field_id)

Primary Key referenced From

Column Descriptions

Field	Description
resp_unit_no	ServiceOptimizer-generated unique identifier
resp_unit_ref	End users' unique identifier. There is a (temporary) restriction on resp_unit_refs that they cannot include wide characters.
resp_unit_type	0 - interim 1 - final 2 – root (owner of all final responsibility units)
description	Free text description.
owning_resp_unit_no	Identifier of owning responsibility unit.
preference_factor	Weighting to be used in selecting appropriate responsibility unit for appointment bookings. This value is used when there is more than one candidate responsibility unit to which a job might be booked. The value should be between 0 and 9, where 0 indicates that the responsibility unit is most preferred and 9 indicates that it is least preferred.
travel_time	Default travel time, in minutes, between any pair of regions in this responsibility unit for which no sp094_travel_times record exists.
tz_no	The time zone associated with a responsibility unit. This does not confine a responsibility unit to regions within a single time zone. If this field is null and resp_unit_type is 1 (final) then sp083 'tz_Default' is used. If this field is null and resp_unit_type is 0 (interim) then the time zone of the owning final RU is used.
field_id	key to language translations for description