This table defines a predefined pair of Service Hours for a day of the week. The collection of records for a specific pattern_name comprise that predefined Service Hours Pattern. A pattern can have more than one pair of Service Hours on any given day of the week. See sp142_predef_sh_patterns.

Table Definition

Field	Type	Default	Nullable
pattern_id	varchar2(10)
day_number	number(1)
sh_start	number(4)
sh_end	number(4)

Keys

primary_key (pattern_id, day_number, sh_start)
foreign key (pattern_id) references sp142_predef_sh_patterns (pattern_id)

Column Descriptions

Field	Description
pattern_id	The predefined Service Hours Pattern of which this record is part.
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 customer local time zone.
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 customer local time zone.

Browser not supported