14.1 sp140_job_serv_hours_patterns

This table defines Service Hours Patterns for SLA and Maintenance jobs.

Service Hours are defined as the times for which there is contractual entitlement for service. For example, a standard service contract / support agreement might entitle the consumer to service such as Monday-Friday 9:00AM-5:30PM, Saturday 9:00AM-1:00PM. Any equipment to be serviced under this contract should only be serviced inside these hours, and most significantly the "lateness" of the SLA job (costed as the Overdue Cost) is calculated against the Service Hours. Service Hours are, however, a "soft constraint" as a service organisation may choose to service a job outside these hours, or indeed there may be no impact of a job overrunning past the end time of any Service Hours period. But, there is a notional "impact" to the business for performing work outside the Service Hours.

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

HouseKeeping

This table is tidied by sp_dbtidy's Job group

Table Definition

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

Keys

primary key (job_no)
foreign key (job_no) references 14.1 sp111_jobs (job_no)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)

Primary Key Referenced From

14.1 sp141_job_serv_hours_pattern_days

Column Descriptions

Field	Description
job_no	The job to which this Service Hours Pattern applies.
grace_period	At the end of each period of Service Hours, there is typically a "grace period" into which the service operation is happy for work to 'overrun'. This grace period is really a transition between the period of no cost for servicing the job within its Service Hours, and the high cost of servicing the job outside its Service Hours. (Thus the Grace Period has no direct correlation to a job's overdue cost). It is more of a customer service allowance to reflect that it is kinder to complete a job today than wait until the next day, even if no contractual need. Represented as a number of minutes. Defaults to zero.
pattern_name	The predefined Service Hours Pattern (sp142) that supplied the Service Hours for this job. If this field is NULL then no predefined Service Hours Pattern was supplied with the job; a fully specified Service Hours Pattern was supplied instead.
pattern_id	The predefined Service Hours Pattern (sp142) that supplied the Service Hours for this job. If this field is NULL then no predefined Service Hours Pattern was supplied with the job; a fully specified Service Hours Pattern was supplied instead.
tz_no	The timezone number that the Service Hours Pattern was created from.
field_id	Key to language translations for pattern_name.