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.

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