sp157_job_time_dependencies

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.