PLAN_PROMPTS_V

The PLAN_PROMPTS_V view displays information about prompts in the plan.
Table 1. The PLAN_PROMPTS_V view
Column name Description Type Length
Prompt_id The identifier of the prompt. character 16
Prompt_name The name of the prompt. string 148
Prompt_number The number of the prompt. integer 10
Workstation_id The workstation identifier. 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
Asked_time The time on which the prompt is asked. timestamp 10
Status The prompt status. Possible values are:
A
Available
N
Not_available
U
Undecided
character 1
Message_text Text of the message. string 200
Prompt_type The prompt type. Possible values are:
L
Local
G
Global
R
Restart
character 1