PLAN_JOB_STREAM_PREDECESSORS_V

The PLAN_JOB_STREAM_PREDECESSORS_V view displays information about job and job stream predecessors of a job stream in the plan.
Table 1. The PLAN_JOB_STREAM_PREDECESSORS_V view
Column name Description Type Length
Job_stream_id The identifier of the job stream on which the dependency is defined. character 16
Job_stream_wks_id The identifier of the workstation of the job stream on which the dependency is defined. character 16
Job_stream_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job stream on which the dependency is defined. string 16
Job_stream_wks_original_name The name of the workstation of the job stream on which the dependency is defined. string 16
Job_stream_wks_folder_name The name of the folder in which the workstation of the job stream is defined. The job stream being that on which the dependency is defined. string 801
Job_stream_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation being that of the job stream on which the dependency is defined. character 16
Job_stream_folder_id The identifier of the folder containing the job stream on which the dependency is defined. character 16
Job_stream_folder_name The name of the folder containing the job stream on which the dependency is defined. string 801
Job_stream_name The name of the job stream on which the dependency is defined. string 16
Job_stream_pred_id The identifier of the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_id The identifier of the job that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_js_wks_id The identifier of the workstation of the job's job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_js_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job's job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_js_wks_original_name The name of the workstation of the job's job stream that depends on the job stream specified in the Job_stream_id column. string 16
job_pred_js_wks_folder_name The name of the folder in which the workstation of the job's job stream is defined. The job stream being that which depends on the job stream specified in the Job_stream_id column. string 801
job_pred_js_wks_folder_id The identifier of the folder in which the workstation of the job's job stream is defined. The workstation being that of the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_js_name The name of the job's job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_js_sched_time The input arrival time of the job's job stream that depends on the job stream specified in the Job_stream_id column. timestamp 10
Job_pred_wks_id The identifier of the workstation of the job that depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_wks_name The name used in the Symphony file to identify the workstation of the job that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_wks_orig_name The name of the workstation of the job that depends on the job stream specified in the Job_stream_id column. string 16
Job_pred_wks_folder_name The name of the folder in which the workstation of the job is defined. The job being that which depends on the job stream specified in the Job_stream_id column. string 801
Job_pred_wks_folder_id The identifier of the folder in which the workstation of the job is defined. The job being that which depends on the job stream specified in the Job_stream_id column. character 16
Job_pred_name The name of the job that depends on the job stream specified in the Job_stream_id column. string 40
Job_stream_pred_wks_id The identifier of the workstation of the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_stream_pred_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_stream_pred_wks_orig_name The name of the workstation of the job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_stream_pred_wks_fol_name The name of the folder in which the workstation of the job stream is defined. The job stream being that which depends on the job stream specified in the Job_stream_id column. string 801
Job_stream_pred_wks_folder_id The identifier of the folder in which the workstation of the job stream is defined. The job stream being that which depends on the job stream specified in the Job_stream_id column. character
Job_stream_pred_folder_id The identifier of the folder containing the job stream that depends on the job stream specified in the Job_stream_id column. character 16
Job_stream_pred_folder_name The name of the folder containing the job stream that depends on the job stream specified in the Job_stream_id column. string 801
Job_stream_pred_name The name of the job stream that depends on the job stream specified in the Job_stream_id column. string 16
Job_stream_pred_sched_time The input arrival time of the job stream that depends on the job stream specified in the Job_stream_id column. timestamp 10
Satisfied If the job stream's dependency is satisfied. Possible values are:
Y
Yes
N
No
character 1
Status The job stream's dependency status. Possible values are:
S
Satisfied
N
Not_satisfied
U
Undecided
character 1
Dependency_type The job stream's dependency type. Possible values are:
I
Internal
J
External_job
S
External_job_stream
N
Internetwork
character 1
Is_conditional_dependecy The job stream's dependency is a conditional dependency. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_success The condition is on SUCCESS. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_abend The condition is on ABEND. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_fail The condition is on FAIL. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_execute The condition is on EXECUTE. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Cond_dep_on_suppress The condition is on SUPPRESS. Valid only if the Is_conditional_dependency column is set to Y. Possible values are:
Y
Yes
N
No
character 1
Join_name The name of the container of more of one conditional dependency. Valid only if the Is_conditional_dependency column is set to Y. string 16
Join_quantity The number of dependencies that must be satisfied in the join specified in Join_name. Valid only if the Is_conditional_dependency column is set to Y. integer 5
Output_cond_list The list of output conditions for this job stream dependency. Valid only if the Is_conditional_dependency column is set to Y. string 2000