14.1 sp356_team_capacity_overrides
- Billy Sewell (Unlicensed)
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. |