sp350_capacity_categories
- Jason Andrew
Owned by Jason Andrew
Oct 02, 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 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. |