14.1 sp352_capacity_pattern_levels

This table specifies the capacity levels that make up a capacity pattern (sp351_capacity_pattern).

The set of records for a particular capacity_pattern_no make up the levels for that pattern. Records are expected to be present for each pattern, for each day of the week (Sunday to Saturday) and for each capacity category. However, if any records are missing then ServiceOptimizer will assume a reserved value of 0% and a limit of 100%.

Table Definition

Field	Type	Default	Nullable
capacity_pattern_no	number(9)
capacity_category_no	number(9)
day_no	number(1)
reserve	number(3)
limit	number(3)

Keys

primary key sp352_pk (capacity_pattern_no, capacity_category_no, day_no),
foreign key sp352_fk_sp351 (capacity_pattern_no) references 14.1 sp351_capacity_patterns(capacity_pattern_no)
foreign key sp352_fk_sp350 (capacity_category_no) references 14.1 sp350_capacity_categories(capacity_category_no)

Column Descriptions

Field	Description
capacity_pattern_no	The capacity pattern identifier.
capacity_category_no	The capacity category identifier.
day_no	The day of the week starting from 0 (Sunday) to 6 (Saturday).
reserved	The amount of capacity that should be reserved for this category of job on this day of the week. This is a percentage and must be in the range 0 to 100.
limit	The limit of capacity that can be used by this category of job for the given day of the week. This is a percentage and must be in the range 0 to 100.