sp250_teams
- Jason Andrew
Each record in this table represents a team - that is, a grouping of crews and individuals for display and reporting purposes. (Crews are groupings of individuals for scheduling purposes, so a crew is a schedulable entity. A team is not a schedulable entity.)
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| team_no | number(9)Â | Â |  Â |
| team_type | varchar2(4)Â | Â | Â |
| team_name | varchar2(40)Â | Â | |
| is_capacity_per_op | number(1)Â | Â | Â |
| capacity_release_mode | number(1)Â Â | Â 1 | Â |
| capacity_release_time  | varchar2(4) |  |  |
| capacity_release_days | number(3)Â | Â 0 | Â |
Keys
Primary key (team_no)
Unique (team_name)
Foreign key (team_type) references sp251_team_types (team_type)
Primary Key Referenced From
- sp252_team_locations
- sp253_ru_teams
- sp255_user_teams
- sp112_postings
- sp207_dispatch_messages
- sp355_team_cap_assignments
Â
Column Descriptions
| Field | Description |
|---|---|
| team_no | ServiceOptimizer unique identifier . |
| team_type | Team type |
| team_name | Team name |
| is_capacity_per_op  | Determines whether capacity for this team is checked for the whole team (value 0) or individually for the operatives in the team (value 1). This value is only relevant if the FRU has capacity checking per-team enabled (reference sp083 parameter 'fru_capacity_checking_value'). |
| capacity_release_mode | Indicates whether capacity checking is disabled (that is, capacity is "released") at a particular time of day today. Only effective if sp083 parameter fru_capacity_checking_unit is "Team". 0 = Capacity is not released today in this team 1 = FRU-level capacity release configuration is used to determine capacity release for this team. 2 = A specific capacity release time is configured for this team. See capacity_release_time. |
| capacity_release_time | Time of day today at which capacity is released (format is "HHmm"). See capacity_release_mode.  |
| capacity_release_days | Days in advance to release capacity. |