14.1 sp350_capacity_categories
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
- 14.1 sp371_opday_capacity
- 14.1 sp070_activity_standards
- 14.1 sp111_jobs
- 14.1 sp352_capacity_pattern_levels
- 14.1 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. |