sp809_friendly_names_map

The ServiceScheduling system no longer uses this table, however, it has been retained as a convenient look-up for consultants – it will be withdrawn at a later date.

Table Definition

Field	Type	Default	Nullable
friendly_name	varchar2(20)
property_name	varchar2(50)
field_id	varchar2(100)

Keys

primary key (friendly_name)
foreign key (field_id) references sp900_language_translation (field_id)

Column Descriptions

Field	Description
friendly_name	Short synonym (e.g. 'SA') for a full property name.
property_name	Full property name referred to by the synonym (e.g. 'FRU.Team.Oper.SA').
field_id	Key to language translations for friendly_name.