sp354_fru_capacity_overrides

This table allows the capacity levels applicable at FRU level, defined in a capacity pattern, to be overridden on a particular date in an FRU.

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. So for example if a team in the FRU has a team capacity pattern assignment defined then it is overridden by records in this table.

The set of records for a particular FRU/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%.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

Field	Type	Default	Nullable
capacity_category_no	number(9)
fru_no	number(9)
override_date	date
reserve	number(3)
limit	number(3)

Keys

primary key sp354_pk (capacity_category_no, fru_no, override_date)
foreign key sp354_fk_sp058 (fru_no) references sp058_responsibility_units(resp_unit_no)
foreign key sp354_fk_sp350 (capacity_category_no) references sp350_capacity_categories(capacity_category_no)

Column Descriptions

Field	Description
capacity_category_no	The capacity category number.
fru_no	The FRU identifier.
override_date	The date on which the override applies (FRU time zone).
reserve	The percentage reserved.
limit	The percentage limit.