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