Document toolboxDocument toolbox

sp144_job_acc_hours_patterns

Owned by Jason Andrew
Oct 02, 2024
1 min read

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 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.