/
sp350_capacity_categories
sp350_capacity_categories
This table holds the capacity categories and associated id.
Table Definition
Field | Type | Default | Nullable |
---|---|---|---|
capacity_category_no | number(9) | ![]() | |
name | varchar2(20) | ![]() | |
job_nominal_duration | number(9) | ![]() | |
field_id | varchar2(100) | ![]() |
Keys
primary key (capacity_category_no)
unique key (name)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
- sp371_opday_capacity
- sp070_activity_standards
- sp111_jobs
- sp352_capacity_pattern_levels
- sp354_fru_capacity_overrides
Column Descriptions
Field | Description |
---|---|
capacity_category_no | ServiceOptimizer identifier. |
name | Customer identifier. |
job_nominal_duration | Used in reports to indicate the duration a 'typical' job takes for this capacity category. Specified in minutes. |
field_id | Key to language translations for name. |
, multiple selections available,
Related content
14.1 sp350_capacity_categories
14.1 sp350_capacity_categories
More like this
14.1 sp371_opday_capacity
14.1 sp371_opday_capacity
More like this
sp371_opday_capacity
sp371_opday_capacity
More like this