Table Definition

Field	Type	Default	Nullable
job_no	number(9)
day_number	number(1)
sh_start	number(4)
sh_end	number(4)

Keys

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

Field	Description
job_no	The 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_start	Start 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_end	End 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).