sp252_team_locations

This table is used to record the allocations of teams to offices or depots. A team may be assigned to only one office / depot on any given day.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

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

Keys

primary key (team_no, start_date)
foreign key (team_no) references sp250_teams (team_no)
foreign key (location_no) references sp118_work_locations (location_no)

Column Descriptions

Field	Description
team_no	ServiceOptimizer team identifier.
location_no	ServiceOptimizer office or depot identifier.
start_date	Start date for the allocation of the team to the office / depot. Uses location's region Time Zone.
end_date	End date for the allocation. A null value indicates that the team belongs to the office / depot indefinitely. Uses location's region Time Zone.