RESOURCE_REFS_V

The RESOURCE_REFS_V view displays information about jobs and job streams that depend on a resource.
Table 1. The RESOURCE_REFS_V view
Column name Description Type Length
Workstation_identifier The identifier of the workstation where the resource is defined. character 16
Workstation_name The name of the workstation where the resource is defined. string 16
Resource_identifier The identifier of the resource on which the jobs and job streams depend. character 16
Resource_name The name of the resource on which the jobs and job streams depend. string 148
Resource_fol_id The identifier of the folder where the resource is stored. character 16
Resource_fol_name The name of the folder where the resource is stored. string 801
Resource_Symphony_id The Symphony ID of the folder where the resource is stored. string 16
Units_available The number of this resource available for allocation. integer 4
Units_allocated The number of this resource to be allocated to satisfy the dependency. integer 4
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the resource specified in the Resource_identifier column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the resource specified in the Resource_name column is defined. string 16
Dep_job_stream_folder_id The identifier of the folder containing the job stream that depends on the resource specified in the Resource_name column. character 16
Dep_job_stream_folder_name The name of the folder containing the job stream that depends on the resource specified in the Resource_name column string 801
Dep_job_stream_identifier The identifier of the job stream that depends on the resource specified in the Resource_identifier column. character 16
Dep_job_stream_name The name of the job stream that depends on the resource specified in the Resource_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 prompt specified in the Prompt_identifier column is defined. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the prompt specified in the Prompt_name column is defined. string 16
Dep_job_folder_id The identifier of the folder containing the job that depends on the resource specified in the Resource_name column. character 16
Dep_job_folder_name The name of the folder containing the job that depends on the resource specified in the Resource_name column string 801
Dep_job_identifier The identifier of the job that depends on the resource specified in the Resource_identifier column. character 16
Dep_job_name The name of the job that depends on the resource specified in the Resource_name column. string 40
Dep_job_definition_identifier The identifier of the job definition that depends on the resource specified in the Resource_identifier column. character 16
Dep_job_definition_name The name of the job definition that depends on the resource specified in the Resource_name column. string 40
Job_refs_js_id The identifier of the job's job stream that depends on the resource specified in the Resource_id column. character 16
Workstation_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job or job stream that depends on the resource specified in the Resource_id column. character 16
Workstation_folder_name The name of the folder in which the workstation of the job or job stream is defined. The job or job stream that depends on the resource specified in the Resource_id column. string 801
Workstation_symphony_id An identifier used in the Symphony file to identify the workstation of the job or job stream. The job or job stream that depends on the resource specified in the Resource_id column. string 16
Dep_job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream that depends on the resource specified in the Resource_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 resource specified in the Resource_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 resource specified in the Resource_id column. string 16
Dep_job_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job that depends on the resource specified in the Resource_id column. character 16
Dep_job_wks_folder_name The name of the folder in which the workstation is defined. The workstation is of the job that depends on the resource specified in the Resource_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 resource specified in the Resource_id column. string 16