sp841_inspection_targets

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.