Table Definition

Field	Type	Default
job_no	number(9)
grace_period	number(4)
is_shp	number(1)
tz_no	number(2)	0

Keys

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

Field	Description
job_no	The job to which this Access Hours Pattern applies.
grace_period	If this Access Hours Pattern was derived from a Service Hours Pattern, then this is the grace period from the Service Hours Pattern (see sp140_job_serv_hours_patterns.grace_period). If this Access Hours Pattern was not derived from a Service Hours Pattern, then this is null.
is_shp	If this Access Hours Pattern was derived from a Service Hours Pattern then this value is set to 1, otherwise it is set to 0.
tz_no	Is the timezone number that the Access Hours Pattern was created from.