Document toolboxDocument toolbox

sp261_task_mapping

Owned by Jason Andrew
Oct 02, 2024

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_nonumber(4)  (error)
analysis_nonumber(6)  (error) 
user_code_01  varchar2(10)  (tick)
user_code_02  varchar2(10)  (tick)
user_code_03  varchar2(10)  (tick)
user_code_04  varchar2(10)  (tick)
user_code_05  varchar2(10)  (tick)
user_code_06  varchar2(10)  (tick)
user_code_07  varchar2(10)  (tick)
user_code_08  varchar2(10)  (tick)
user_code_09  varchar2(10)  (tick)
user_code_10  varchar2(10)  (tick)

Keys

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

Column Descriptions

FieldDescription
mapping_noUnique identifier, generated using sequence mapping_no.
analysis_noServiceOptimizer task type identifier. 
user_code_01User 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