This table defines predefined Service Hours Patterns for SLA and Maintenance jobs. See 14.1 sp140_job_serv_hours_patterns for more detail on Service Hours.

The predefined Service Hours Patterns defined in this table can be specified by a caller of SP_BookJob() as an alternative to supplying the full Service Hours Pattern in the call.

The Service Hours for each day-of-the-week are defined in table 14.1 sp143_predef_sh_pattern_days.

Table Definition

Field	Type	Default
pattern_id	varchar2(10)
pattern_name	varchar2(30)
grace_period	number(4)	0
field_id	varchar2(100)

Keys

primary key (pattern_name)
foreign key (field_id) references sp900_language_translation (field_id)

Column Descriptions

Field	Description
pattern_id	The unique identifier for this Service Hours Pattern. Passed to ServiceOptimizer via the API when the job is booked.
pattern_name	Deprecated - Description for this Service Hours Pattern. A memorable name for this SH pattern.
grace_period	Represented as a number of minutes. Defaults to zero.
field_id	Key to language translations for pattern_name.

Browser not supported