sp157_job_time_dependencies
- Jason Andrew
Each record in this table represents a time dependency between two jobs in the schedule. The fields specify how the dependent job can be placed in the schedule relative to the placement time of the target job in the schedule.
HouseKeeping
This table is tidied by sp_dbtidy's Job group.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| target_job_no | number(9) |  | |
| dependent_job_no | number(9) | | |
| target_time | number(6) |  | |
| earliest_time | number(6) | | |
| latest_time | number(6) | | |
| target_time_relative_to | number(1) | | |
| dependent_job_uses_time | number(1) | | |
| target_time_units | number(1) | | |
| earliest_time_units | number(1) | | |
| latest_time_units | number(1) | | |
| cost_category | number(6) | | |
| dependency_group_no | number(9) | |
Keys
primary_key(dependency_group_no, target_job_no, dependent_job_no, target_time_relative_to, dependent_job_uses_time)
foreign key(dependency_group_no) references sp156_job_dependency_groups(dependency_group_no)
foreign key (target_job_no) references sp111_jobs (job_no)
foreign key(dependent_job_no) references sp111_jobs(job_no)
foreign key(cost_category) references sp159_dependency_cost_category(category)
Column Descriptions
| Field | Description |
|---|---|
| target_job_no | The job number for the target job in the dependency. |
| dependent_job_no | The job number for the dependent job in the dependency. |
| target_time | The target time relative to the target job when the dependent job should be placed in the schedule. The interpretation of this as a time or date in the schedule is governed by the target_time_units column. The actual date or time is derived from the target job ETA or ETF using the value specified in the target_time_relative_to field. |
| earliest_time | The earliest time relative to the target job ETA or ETF that the dependent job could be placed. The interpretation of this as a time or date in the schedule is governed by the target_time_relative_to and earliest_time_units columns. Can be NULL for a time dependency if the job was booked with an earliest_time of SP_IntNoValue. |
| latest_time | The latest time relative to the target job ETA or ETF that the dependent job could be placed. The interpretation of this as a time or date in the schedule is governed by the target_time_relative_to and latest_time_units columns. Can be NULL for a time dependency if the job was booked with an latest_time of SP_IntNoValue. |
| target_time_relative_to | Specifies whether the target time is relative to the ETA or ETF of the target job. 0 – ETA 1 - ETF |
| dependent_job_uses_time | Specifies whether the dependent job should be placed at the target time using its ETA or ETF. 0 – ETA 1 - ETF. |
| target_time_units | Specifies whether the target_time column value is in minutes, hours or days. 0 – minutes 1 – hours 2 - days. |
| earliest_time_units | Specifies whether the earliest_time column value is in minutes, hours or days. 0 – minutes 1 – hours 2 - days. |
| latest_time_units | Specifies whether the latest_time column value is in minutes, hours or days. 0 – minutes 1 – hours 2 - days. |
| cost_category | The category of cost weighting to be applied for costing when a dependent job in the dependency cannot meet the target time constraint. |
| dependency_group_no | Cross-references sp156_job_dependency_groups. dependency_group_no. |