14.1 sp152_job_sho_periods

This table defines periods where an SLA job's service hours pattern does not apply.

The service hours that do apply within these periods are specified in table sp149_job_serv_hours_overrides.

If there's an underlying pattern, then records in this table will start at the end of the last unaffected underlying service hours, and end at the start of the next unaffected service hours. If there's no underlying pattern, then a single record will be added to this table that starts at the start of the first override and ends at the end of the last override.

Table Definition

Field	Type	Default	Nullable
job_no	number(9)
overridden_period_start	date
overridden_period_end	date

Keys 

foreign key (job_no) references 14.1 sp111_jobs (job_no)

Column Descriptions