HCL Workload Automation, Version 9.4

PLAN_RESOURCE_REFS_V

The PLAN_RESOURCE_REFS_V view displays information about jobs and job streams in the plan that depend on a resource.
Table 1. The PLAN_RESOURCE_REFS_V view
Column name Description Type Length
Resource_name The name of the resource on which the dependency is defined. string 148
Quantity_defined The total quantity defined on the resource specified in the Resource_id column. integer 4
Quantity_available The quantity of the resource specified in the Resource_id column that is not used. integer 4
In_use The quantity in use on the resource specified in the Resource_id column. integer 4
Resource_wks_id The identifier of the workstation on which the resource specified in the Resource_id column is defined. character 16
Resource_wks_name The name of the workstation on which the resource specified in the Resource_id column is defined. string 16
Resource_id The identifier of the resource on which the dependency is defined. character 16
Job_stream_refs_id The identifier of the job stream that depends on the resource specified in the Resource_id column. character 16
Job_refs_id The identifier of the job that depends on the resource specified in the Resource_id column. character 16
Job_refs_js_wks_name The name of the workstation of the job's job stream that depends on the resource specified in the Resource_id column. string 16
Job_refs_js_name The name of the job's job stream that depends on the resource specified in the Resource_id column. string 16
Job_refs_js_sched_time The input arrival time of the job's job stream that depends on the resource specified in the Resource_id column. timestamp 10
Job_refs_wks_id The identifier of the workstation of the job that depends on the resource specified in the Resource_id column. character 16
Job_refs_wks_name The name of the workstation of the job that depends on the resource specified in the Resource_id column. string 16
Job_refs_name The name of the job that depends on the resource specified in the Resource_id column. string 40
Job_stream_refs_wks_id The identifier of the workstation of the job stream that depends on the resource specified in the Resource_id column. character 16
Job_stream_refs_wks_name The name of the workstation of the job stream that depends on the resource specified in the Resource_id column. string 16
Job_stream_refs_name The name of the job stream that depends on the resource specified in the Resource_id column. string 16
Job_stream_refs_sched_time The input arrival time of the workstation of the job stream that depends on the resource specified in the Resource_id column. timestamp 10
Satisfied If the resource dependency is satisfied. Possible values are:
Y
Yes
N
No
character 1
Status The resource status. Possible values are:
A
Available
N
Not_available
N
Undecided
character 1