VARIABLE_TABLE_REFS_V

Table 1. The VARIABLE_TABLE_REFS_V view
The VARIABLE_TABLE_REFS_V view displays information about job streams, run cycles, and workstations that use variable tables.
Column name Description Type Length
Variable_table_identifier The identifier of the variable table that contains the variable. character 16
Variable_table The name of the variable table that contains the variable. string 80
Variable_table_folder_id The identifier of the folder where the variable table is stored. character 16
Variable_table_folder_name The name of the folder where the variable table is stored. string 801
Is_default If the variable table is the default variable table. Possible values are:
Y
Yes
N
No
character 1
Workstation_identifier The identifier of the workstation that uses the variable table or the name of the workstation on which the job stream that uses the variable table is defined. character 16
Workstation_name The name of the workstation that uses the variable table or the name of the workstation on which the job stream that uses the variable table is defined. string 16
Job_stream_folder_id The identifier of the folder that contains the job stream that uses the variable table. character 16
Job_stream_folder_name The name of the folder that contains the job stream that uses the variable table. string

4000  Oracle
4095  DB2

Job_stream_identifier The identifier of the job stream that uses the variable table. character 16
Job_stream_name The name of the job stream that uses the variable table. string 16
Job_stream_valid_from The starting date from which the job stream that uses the variable table 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 dependent job stream that uses the variable table is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Run_cycle_identifier The identifier of the run cycle that uses the variable table. character 16
Run_cycle_name The name of the run cycle that uses the variable table. string 40
Workstation_folder_id The identifier of the folder in which the workstation is defined. character 16
Workstation_folder_name The name of the folder in which the workstation is defined. string 801
Workstation_symphony_id An identifier used in the Symphony file to identify the workstation. string 16