Document toolboxDocument toolbox

14.1 sp141_job_serv_hours_pattern_days

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table defines Service Hours for one day of the week. The collection of records for a specific job_no comprises that job's Service Hours Pattern. See sp140_job_serv_hours_patterns.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

 

Table Definition

Field
Type
Default
Nullable
job_nonumber(9)  (error)
day_numbernumber(1)  (error)
sh_startnumber(4)  (error)
sh_endnumber(4)  (error)

Keys 

primary_key (job_no, day_number, sh_start) 
foreign key (job_no) references 14.1 sp140_job_serv_hours_patterns (job_no)

Column Descriptions

FieldDescription
job_noThe job to which this Service Hours Pattern applies.
day_number Identifies the day of the week to which these Service Hours apply. Must be in the range 0..6 where day 0 is a Sunday, day 1 is a Monday and so on.
sh_startStart of the Service Hours on this day. This is specified as a number of minutes offset from "0000" and is in the range 0 to 1440 (i.e. "2400"). Uses the timezone that the job was booked in (sp140.tz_no).
sh_endEnd of the Service Hours on this day. This is specified as a number of minutes offset from "0000" and is in the range 0 to 2880 (i.e. "4800").This definition allows Service Hours to overlap midnight.Uses the timezone that the job was booked in (sp140.tz_no).