JOB_STREAM_REFS_V

The JOB_STREAM_REFS_V view displays information about job streams.
Table 1. The JOB_STREAM_REFS_V view
Column name Description Type Length
Workstation_identifier The identifier of the workstation where the job stream is defined. character 16
Workstation_name The name of the workstation where the job stream is defined. string 16
Job_stream_folder_id The identifier of the folder containing the job stream for which you want information displayed. character 16
Job_stream_folder_name The name of the folder containing the job stream for which you want information displayed. string 801
Job_stream_identifier The identifier of the job stream for which you want information displayed. character 16
Job_stream_name The name of the job stream for which you want information displayed. string 16
Job_stream_valid_from The starting date from which the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Job_stream_valid_to The last date that the job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Calendar_identifier The identifier of the non-working days calendar. character 16
Calendar_name The name of the non-working days calendar. string 16
Calendar_folder_id The identifier of the folder where the calendar is stored. character 16
Calendar_folder_name The name of the folder where the calendar is stored. string 801
Workstation_folder_id The identifier of the folder in which the workstation of the job stream is defined. character 16
Workstation_folder_name The name of the folder in which the workstation of the job stream is defined. string 801
Workstation_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream. string 16