Document toolboxDocument toolbox

14.1 sp144_job_acc_hours_patterns

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table defines Access Hours Patterns for SLA and Maintenance jobs. Access Hours are defined as the times during which the operative has access to a customer's site.


The Access Hours for each day-of-the-week are defined in table sp145_acc_hours_pattern_days.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

 

Table Definition

Field
Type
Default
Nullable
job_no number(9) (error)
grace_period  number(4) (tick)
is_shpnumber(1) (error)
tz_nonumber(2)0(error)

Keys 

primary key (job_no) 
foreign key (job_no) references 14.1 sp111_jobs (job_no)

Column Descriptions

FieldDescription
job_no The job to which this Access Hours Pattern applies.  
grace_period If this Access Hours Pattern was derived from a Service Hours Pattern, then this is the grace period from the Service Hours Pattern (see sp140_job_serv_hours_patterns.grace_period). If this Access Hours Pattern was not derived from a Service Hours Pattern, then this is null.  
is_shpIf this Access Hours Pattern was derived from a Service Hours Pattern then this value is set to 1, otherwise it is set to 0.
tz_noIs the timezone number that the Access Hours Pattern was created from.