RESOURCES_V

The RESOURCES_V view displays information about resources.
Table 1. The RESOURCES_V view
Column name Description Type Length
Workstation_identifier The identifier of the workstation or workstation class associated with the resource. character 16
Workstation_name The name of the workstation or workstation class associated with the resource. string 16
Resource_name The name of the resource. 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
Resource_identifier The identifier of the resource. character 16
Resource_description The description associated with the resource. string 120
Resource_units The number of this resource available. integer 4
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