14.1 sp211_resources

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)

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)

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.