/
14.1 sp355_team_cap_assignments
Document toolboxDocument toolbox

14.1 sp355_team_cap_assignments

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

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  (error)
capacity_pattern_no  (error)
start_datedate (error)
end_datedate (error)

Keys

primary key sp355_pk (team_no,capacity_pattern_no,start_date) 
foreign key sp355_fk_sp250 (team_no) references /wiki/spaces/SCH141/pages/27001323(team_no) 
foreign key sp355_fk_sp351 (capacity_pattern_no) references 14.1 sp351_capacity_patterns(capacity_pattern_no)

Column Descriptions

FieldDescription
team_no The team identifier.
capacity_pattern_noThe pattern to be applied. 
start_date The start of the period that this FRU has this pattern applied (FRU time zone).
end_dateThis 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).

Related content

sp355_team_cap_assignments
sp355_team_cap_assignments
ServiceScheduling 13.3
More like this
14.1 sp353_fru_cap_assignments
14.1 sp353_fru_cap_assignments
ServiceScheduling 14.1
More like this