14.1 sp149_job_serv_hours_overrides

This table defines Service Hours for SLA jobs within the periods where the underlying Service Hours Pattern has been overridden (ref. sp152_job_sho_periods).

There can be 0, 1 or many overrides defined for a Job. The Job's underlying Service Hours Pattern is defined in sp140_job_serv_hours_patterns and sp141_serv_hours_pattern_days). Each override has a start date and time and an end date and time which defines a period of any length.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

Table Definition

Field	Type	Default	Nullable
job_no	number(9)
override_start_time	date
override_end_time	date

Keys

foreign key (job_no) references 14.1 sp111_jobs (job_no)

Column Descriptions

Field	Description
job_no	The job to which override applies.
override_start_time	Customer local date and time on which the override starts.
override_end_time	Customer local date and time on which the override ends.