14.1 sp254_team_unavailability

This table is used to define periods of time during which a team is unavailable for work.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

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

foreign key (team_no) references sp250_teams (team_no)
foreign key (reason_no) references sp294_team_unav_reasons (reason_no)

Field	Description
team_no	ServiceOptimizer team identifier.
reason_no	Number denoting reason for unavailability.
start_date	Date and time at which the team becomes unavailable. Uses sp083.tz_default.
end_date	Date and time at which the team ceases to be unavailable. A null value indicates that the team is unavailable indefinitely. Uses sp083.tz_default.