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