sp353_fru_cap_assignments

Capacity patterns can be set at either FRU or team level for a given period: this table specifies those cases where these capacity values are assigned at the FRU level.

Records are expected to exist for every active FRU, unless all the teams in that FRU have levels configured at team-level (see sp355_team_cap_assignments). Furthermore, it is expected that the set of records for a specific FRU together cover the whole date-range of the ServiceOptimizer memory horizon. However, if any records are missing then ServiceOptimizer will assume a reserved value of 0% and a limit of 100%.
Assignments must not overlap.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

Field	Type	Default	Nullable
fru_no	number(9)
capacity_pattern_no	number(9)
start_date	date
end_date	date

Keys

primary key sp353_pk (fru_no, capacity_pattern_no, start_date)
foreign key sp353_fk_sp058 (fru_no) references sp058_responsibility_units(resp_unit_no)
foreign key sp353_fk_sp351 (capacity_pattern_no) references sp351_capacity_patterns(capacity_pattern_no)

Column Descriptions

Field	Description
fru_no	The FRU identifier.
capacity_pattern_no	The pattern to be applied.
start_date	The start of the period that this FRU has this pattern applied (FRU time zone).
end_date	This specifies the end of the period for which this pattern applies. If this column is NULL then the period is open-ended (FRU time zone).