14.1 sp158_job_oper_dependencies

Each record in this table represents an operative dependency between two jobs in the schedule. The operative constraint indicates whether both jobs in the dependency should be assigned to the same, different or any operative.

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)
operative_constraint	number(1)
dependency_group_no	number(9)

Keys

primary_key(dependency_group_id, target_job_no, dependent_job_no)
foreign key(dependency_group_no) references 14.1 sp156_job_dependency_groups(dependency_group_no)
foreign key (target_job_no) references 14.1 sp111_jobs (job_no)
foreign key(dependent_job_no) references sp111_jobs(job_no)

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.
operative_constraint	Specifies whether the target and dependent job must be carried out by the same or different operatives or whether any operative assignment is okay. 0 – None. 1 – Same. 2 – Different
dependency_group_no	Cross-references sp156_job_dependency_groups. dependency_group_no.