sp253_ru_teams

This table is used to define which teams belong to which responsibility units. A team may belong to only one responsibility unit. There can only be one entry in this table per team.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

Field	Type	Default	Nullable
team_no	number(9)
resp_unit_no	number(4)
start_date	date
end_date	date

Keys

primary key (team_no, start_date)
foreign key (resp_unit_no) references sp058_responsibility_units (resp_unit_no)
foreign key (team_no) references sp250_teams (team_no)

Column Descriptions

Field	Description
team_no	ServiceOptimizer team identifier.
resp_unit_no	Responsibility unit identifier.
start_date	Start date for the allocation of the team to the responsibility unit. Uses RU Time Zone. Not currently used.
end_date	End date for the allocation. A null value indicates that the team belongs to the unit indefinitely. Uses RU Time Zone. Not currently used.