sp356_team_capacity_overrides
- Jason Andrew
This table allows the capacity levels applicable at team level, defined in a capacity pattern, to be overridden on a particular date in a team.Â
The levels that are being overridden could be defined by a team capacity pattern assignment in sp355_team_cap_assignments or an FRU capacity pattern assignment in sp353_fru_cap_assignments.Â
The set of records for a particular team/date make up the levels that apply on that date. Records are expected to be present for each capacity category. However, if any records are missing then ServiceOptimizer will assume a reserve value of 0% and a limit of 100%.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| capacity_category_no | number(9) | Â |  |
| team_no | number(9) | Â | |
| override_date | date | Â | |
| reserve | number(3) | Â | |
| limit | number(3) | Â | |
Keys
primary key sp356_pk (capacity_category_no,team_no,override_date)Â
foreign key sp356_fk_sp250 (team_no) references sp250_teams(team_no)Â
foreign key sp356_fk_sp350 (capacity_category_no) references sp350_capacity_categories(capacity_category_no)
Column Descriptions
| Field | Description |
|---|---|
|  capacity_category_no |  The capacity category number |
|  team_no |  The Team identifier. |
| override_date | The date on which the override applies (FRU time zone) |
| reserve | The percentage reserved |
| limit | The percentage limit. |