14.1 sp148_job_aho_periods

This table defines periods where an SLA job's access hours pattern (if there is one) does not apply. If a job has no access hours pattern (or service hours pattern acting as an access hours pattern) then there must be at least one record in this table, defining where access hours overrides apply.

The access hours that do apply within these periods are specified in table sp147_job_acc_hours_overrides.

If there's an underlying pattern, then records in this table will start at the end of the last unaffected underlying access hours, and end at the start of the next unaffected access 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.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

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

Field	Description
job_no	The job to which this overridden period applies.
overridden_period_start	Customer local start of overridden period. If the overridden period has no specific start this is set to NULL.
overridden_period_end	Customer local end of overridden period. If the overridden period has no specific end this is set to NULL.