HCL Workload Automation, Version 9.4

PLAN_RESOURCES_V

The PLAN_RESOURCES_V view displays information about resources in the plan.
Table 1. The PLAN_RESOURCES_V view
Column name Description Type Length
Resource_id The identifier of the resource. character 16
Resource_name The name of the resource. string 148
Resource_number The number of the resource. integer 10
Workstation_id The identifier of the workstation. character 16
Workstation_name The name of the workstation. string 16
Status The resource status. Possible values are:
A
Available
N
Not_available
U
Undecided
character 1
Available The number of units available for the resource specified in the Resource_id column. integer 4
Not_used The number of units for the resource specified in the Resource_id column that are not used. integer 4
In_use The number of units in use for the resource specified in the Resource_id column. integer 4