sp355_team_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 team level.

It is expected that the set of records for a specific team 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%.

If a team is not assigned to a capacity pattern by record(s) in this table, it is expected that the team's parent FRU will be assigned to a capacity pattern by record(s) in sp353_fru_cap_assignments.
Assignments must not overlap.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

Table Definition

Field	Type	Default	Nullable
team_no number(9)not null
capacity_pattern_no
start_date	date
end_date	date

Keys

primary key sp355_pk (team_no,capacity_pattern_no,start_date)
foreign key sp355_fk_sp250 (team_no) references sp250_teams(team_no)
foreign key sp355_fk_sp351 (capacity_pattern_no) references sp351_capacity_patterns(capacity_pattern_no)

Column Descriptions

Field	Description
team_no	The team 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).