14.1 sp142_predef_sh_patterns
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 | Nullable |
|---|---|---|---|
| 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. |