14.1 sp841_inspection_targets
- Billy Sewell (Unlicensed)
This table is specific to the functionality required for the ABS inclusions to SERVICEManager and will therefore not be added to the standard SERVICEPower schema. It is used to provide default values for the number of days and hours by which to offset the target inspection time from the user specified contract earliest time of SLA jobs. The business or technical consultant for the pilot project will be responsible for populating this table.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| analysis_no | number(6,0) |  | |
| target_days | number(3,0) | | |
| target_hrs | number(2,0) |  | |
| target_time | date | | |
| default_offerappts_importance | number(1,0) | | |
| default_bookappt_importance | number(1,0) | | |
| default_extra_duration | number(8,0) | |
Keys
primary key (analysis_no)
unique (analysis_no)
foreign key (analysis_no) references sp070_activity_standards
Column Descriptions
| Field | Description |
|---|---|
analysis_no | Identifier of a job analysis (activity standard) which specifies the Inspection Target. |
target_days | The default number of days to add to the specified contract earliest date of the SLA job in order to compute the default contract latest date displayed on the booking screen, If not specified then the abs.default.InspTargetDays value set in the service_manager.properties file will be used. If that value is missing then a value of zero days will be used as the offset i.e. the target date will be set to the same date as the start date and should be changed by the user |
target_hrs | May be null, in which case target_time should be specified. target_hrs is the default number of hours to add to the specified contract earliest time of the SLA job to compute the default contract latest displayed on the booking screen. If both target_hrs and target_time are null then the abs.default.InspTargetHrs value set in the service_manager.properties file will be used. If that value is missing then a value of zero hours will be used as the offset i.e. the target time will be set to the same time as the start time and should be changed by the user. If both target_hrs and target_time are not null, then tis value takes precedence. |
target_time | May be null, in which case target_hrs should be specified. target_time is the default contract latest time of the SLA job being booked. See target_hrs for more details. |
default_offerappts_importance | May be null; if provided supplies the default importance value setting in the Request Appointment page for the selected job type. |
default_bookappt_importance | May be null; if provided supplies the default importance value setting in the Book Appointment page for the job type that was originally specified in the Request Appointment page. This enables the user to book the appointment with a different importance to that originally specified in the appointment request. |
default_extra_duration | May be null; if provided supplies the default extra duration value setting in the Request Appointment and Book Inspection entry forms. |