sp156_job_dependency_groups

Each record in this table holds the group attributes for a collection of job dependencies. These define the collective start to completion time, and the type of group which determines the scheduling strategy that is used.

HouseKeeping

This table is tidied by sp_dbtidy's Job group.

Table Definition

Field	Type	Default	Nullable
dependency_group_id	varchar2(50)
earliest_start	date
latest_finish	date
dependency_group_type	number(1)
dependency_group_no	number(9)

Keys

primary_key(dependency_group_id)

Primary Key Referenced From

Column Descriptions

Field	Description
dependency_group_id	User supplied dependency group ID. Must be unique .
earliest_start	Earliest start time for the whole group – not currently used.
latest_finish	Latest finish time for the whole group – not currently used.
dependency_group_type	The type of the group 0 – Split 1 – other, such as part pick up or team.
dependency_group_no	Internally generated number that unique identifies this dependency group.