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 A hexadecimal identifier used in the Symphony file to identify the workstation. string 16
Workstation_original_name The workstation name. string 16
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
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