14.1 sp211_resources
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
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. |