PLAN_JOB_STREAM_SUCCESSORS_V

The PLAN_JOB_STREAM_SUCCESSORS_V view displays information about jobs and job streams successors of a job stream in the plan.
Table 1. The PLAN_JOB_STREAM_SUCCESSORS_V view
Column name Description Type Length
Job_stream_name The name of the job stream on which the successor is defined. string 16
Job_stream_wks_id The identifier of the workstation of the job stream on which the successor 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 successor is defined. character 16
Job_stream_folder_name The name of the folder containing the job stream on which the successor is defined. string 801
Job_stream_id The identifier of the job stream on which the successor is defined. character 16
Job_stream_succ_id The identifier of the job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_succ_js_wks_id The identifier of the workstation of the job's job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_succ_js_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job's job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_succ_js_wks_original_name The name of the workstation of the job's job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_succ_js_wks_folder_name The name of the folder containing the workstation of the job's job stream that follows the job stream specified in the Job_stream_id column. string 801
Job_succ_js_wks_folder_id The identifier of the folder containing the workstation of the job's job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_succ_js_name The name of the job's job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_succ_js_sched_time The input arrival time of the job's job stream that follows the job stream specified in the Job_stream_id column. timestamp 10
Job_succ_wks_id The identifier of the workstation of the job that follows the job stream specified in the Job_stream_id column. character 16
Job_succ_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job that follows the job stream specified in the Job_stream_id column. string 16
Job_succ_wks_original_name The name of the workstation of the job that follows the job stream specified in the Job_stream_id column. string 16
Job_succ_wks_folder_name The name of the folder containing the workstation of the job that follows the job stream specified in the Job_stream_id column. string 801
Job_succ_wks_folder_id The identifier of the folder containing the workstation of the job that follows the job stream specified in the Job_stream_id column. character 16
Job_succ_name The name of the job that follows the job stream specified in the Job_stream_id column. string 40
Job_stream_succ_wks_id The identifier of the workstation of the job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_stream_succ_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_stream_succ_wks_orig_name The name of the workstation of the job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_stream_succ_wks_fol_name The name of the folder containing the workstation of the job stream that follows the job stream specified in the Job_stream_id column. string 801
Job_stream_succ_wks_folder_id The identifier of the folder containing the workstation of the job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_stream_succ _folder_id The identifier of the folder containing the job stream that follows the job stream specified in the Job_stream_id column. character 16
Job_stream_succ _folder_name The name of the folder containing the job stream that follows the job stream specified in the Job_stream_id column. string 801
Job_stream_succ_name The name of the job stream that follows the job stream specified in the Job_stream_id column. string 16
Job_stream_succ_sched_time The input arrival time of the workstation of the job stream that follows 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