This table is used to map a set of user-defined codes onto a ServiceScheduling task type, as defined in sp070. (This mapping is used during the appointment booking process to allow the task type to be determined prior to the creation of an appropriate record in sp108.) User-oriented descriptions of the columns user_code_01, user_code_02 etc. are held in table sp295.

Table Definition

Field	Type	Default	Nullable
mapping_no	number(4)
analysis_no	number(6)
user_code_01	varchar2(10)
user_code_02	varchar2(10)
user_code_03	varchar2(10)
user_code_04	varchar2(10)
user_code_05	varchar2(10)
user_code_06	varchar2(10)
user_code_07	varchar2(10)
user_code_08	varchar2(10)
user_code_09	varchar2(10)
user_code_10	varchar2(10)

Keys

primary key (mapping_no)
foreign key (analysis_no) references 14.1 sp070_activity_standards (analysis_no)

Column Descriptions

Field	Description
mapping_no	Unique identifier, generated using sequence mapping_no.
analysis_no	ServiceOptimizer task type identifier.
user_code_01	User code 1 ...
user_code_01
user_code_01
user_code_01
user_code_01
user_code_01
user_code_01
user_code_01
user_code_01
user_code_01	... User code 10

Browser not supported