sp211_resources
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table contains a list of the various resource types - i.e. skills, spares and special resources.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| resource_no | number(9)Â | Â | Â  |
| resource_ref | varchar2(30) | Â | Â |
| type | number(1) | Â | Â |
| description | varchar2(35) | Â | Â |
| field_id | varchar2(100) | Â | Â |
KeysÂ
primary key (resource_no)Â
unique (resource_ref)Â
foreign key (type) references sp293_resource_types (type)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| resource_no | ServiceOptimizer-generated unique identifier. |
| resource_ref | End users' unique identifier. |
| type | Resource type: 0 - skill 1 - spare 2 - special |
| description | Depreciated - Resource description. |
| field_id | Key to language translation in sp900 for description. |