sp147_job_acc_hours_overrides

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

There can be 0, 1 or many overrides defined for a Job. The Job does not have to have an assigned Access Hours Pattern to have overrides (if there is one it's in sp144_job_acc_hours_patterns and sp145_acc_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 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.

ServiceScheduling 13.3

sp147_job_acc_hours_overrides

Analytics

Table Definition

Keys

Column Descriptions

Related content