FILE_REFS_V

The FILE_REFS_V view displays information about jobs and job streams that depend on a file.
Table 1. The FILE_REFS_V view
Column name Description Type Length
Workstation_identifier The identifier of the workstation where the file is defined. character 16
Workstation_name The name of the workstation where the file is defined. string 16
File_identifier The identifier of the file on which jobs and job streams depend. character 16
File_name The name of the file on which jobs and job streams depend. string 148
File_fol_id The identifier of the folder where the file is stored. character 16
File_fol_name The name of the folder where the file is stored. string 801
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the file specified in the File_name column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the file specified in the File_name column is defined. string 16
Dep_job_stream_folder_id The identifier of the folder containing the job stream that depends on the file specified in the File_identifier column. character 16
Dep_job_stream_folder_name The name of the folder containing the job stream that depends on the file specified in the File_identifier column. string 801
Dep_job_stream_identifier The identifier of the job stream that depends on the file specified in the File_identifier column. character 16
Dep_job_stream_name The name of the job stream that depends on the file specified in the File_name column. string 16
Dep_job_stream_valid_from The starting date from which the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_stream_valid_to The last date that the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_wks_identifier The identifier of the workstation where the job that depends on the file specified in the File_identifier column is defined. If this field is not displayed, the job does not depend on any file. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the file specified in the File_name column is defined. If this field is not displayed, the job does not depend on any file. string 16
Dep_job_folder_id The identifier of the folder containing the job that depends on the file specified in the File_identifier column. character 16
Dep_job_folder_name The name of the folder containing the job that depends on the file specified in the File_identifier column. string 801
Dep_job_identifier The identifier of the job that depends on the file specified in the File_identifier column. If this field is not displayed, the job does not depend on any file. character 16
Dep_job_name The name of the job that depends on the file specified in the File_name column. If this field is not displayed, the job does not depend on any file. string 40
Dep_job_definition_identifier The identifier of the job definition of the job that depends on the file specified in the File_identifier column. If this field is not displayed the job does not depend on a file. character 16
Dep_job_definition_name The name of the job definition of the job that depends on the file specified in the File_name column. If this field is not displayed, the job does not depend on a file. 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
Dep_job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream that depends on the file specified in the File_id column. character 16
Dep_job_stream_wks_folder_name The name of the folder containing the workstation of the job stream that depends on the file specified in the File_id column. string 801
Dep_job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream that depends on the file specified in the File_id column. string 16
Dep_job_wks_folder_id The identifier of the folder containing the workstation of the job that depends on the file specified in the File_id column. character 16
Dep_job_wks_folder_name The name of the folder containing the workstation of the job that depends on the file specified in the File_id column. string 801
Dep_job_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job that depends on the file specified in the File_id column. string 16