Document toolboxDocument toolbox

sp143_predef_sh_pattern_days

Owned by Jason Andrew
Oct 02, 2024
1 min read

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_idvarchar2(10)   (error)
day_numbernumber(1)  (error) 
sh_startnumber(4)  (error)
sh_endnumber(4)  (error)

Keys 

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

Column Descriptions

FieldDescription
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_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 customer local time zone.
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 customer local time zone.