PLAN_PROMPT_REFS_V

The PLAN_PROMPT_REFS_V view displays information about jobs and job streams in the plan that depend on a prompt.
Table 1. The PLAN_PROMPT_REFS_V view
Column name Description Type Length
Prompt The name of the prompt on which the dependency is defined. string 148
Prompt_number The number of the prompt specified in the Prompt_id column. integer 10
Message_text The text message of the prompt specified in the Prompt_id column. string 200
Prompt_id The identifier of the prompt on which the dependency is defined. character 16
Job_stream_refs_id The identifier of the job stream that depends on the prompt specified in the Prompt_id column. character 16
Job_refs_id The identifier of the job that depends on the prompt specified in the Prompt_id column. character 16
Job_refs_js_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the job's job stream that depends on the prompt specified in the Prompt_id column. string 16
Job_refs_js_wks_original_name The name of the workstation of the job's job stream that depends on the prompt specified in the Prompt_id column. string 16
Jobs_refs_js_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job's job stream that depends on the prompt specified in the Prompt_id column. character 16
Jobs_refs_js_wks_folder_name The name of the folder in which the workstation is defined. The workstation is of the job's job stream that depends on the prompt specified in the Prompt_id column. string 801
Job_refs_js_id The identifier of the job's job stream that depends on the prompt specified in the Prompt_id column. character 16
Job_refs_js_name The name of the job's job stream that depends on the prompt specified in the Prompt_id column. string 16
Job_refs_js_sched_time The input arrival time of the job's job stream that depends on the prompt specified in the Prompt_id column. timestamp 10
Job_refs_wks_id The identifier of the workstation of the job that depends on the prompt specified in the Prompt_id column. character 16
Job_refs_wks_name A hexadecimal identifier used in the Symphony file to identify the workstation of the of the job that depends on the prompt specified in the Prompt_id column. string 16
Job_refs_wks_original_name The name of the workstation of the job that depends on the prompt specified in the Prompt_id column. string 16
Jobs_refs_wks_folder_id The identifier of the folder in which the workstation is defined. The workstation is of the job that depends on the prompt specified in the Prompt_id column. character 16
Jobs_refs_wks_folder_name The name of the folder in which the workstation is defined. The workstation is of the job that depends on the prompt specified in the Prompt_id column. string 801
Job_stream_refs_folder_name The name of the folder in which the job stream is defined. The job stream that depends on the prompt specified in the Prompt_id column. string 801
Job_stream_refs_folder_id The identifier of the folder in which the job stream is defined. The job stream that depends on the prompt specified in the Prompt_id column. character 16
Job_refs_name The name of the job that depends on the prompt specified in the Prompt_id column. string 40
Job_stream_refs_wks_id The identifier of the workstation of the job stream that depends on the prompt specified in the Prompt_id column. character 16
Job_stream_refs_wks_name A hexiadecimal identifier used in the Symphony file to identify the workstation of the of the job stream that depends on the prompt specified in the Prompt_id. string 16
Job_stream_wks_original_name The name of the workstation of the job stream that depends on the prompt specified in the Prompt_id column. string 16
Job_stream_wks_folder_id The identifier of the folder containing the workstation of the job stream that depends on the prompt specified in the Prompt_id column. character 16
Job_stream_wks_folder_name The name of the folder containing the workstation of the job stream that depends on the prompt specified in the Prompt_id column. string 801
Job_stream_refs_name The name of the job stream that depends on the prompt specified in the Prompt_idcolumn. string 16
Job_stream_refs_sched_time The input arrival time of the job stream that depends on the prompt specified in the Prompt_id column. timestamp 10
Satisfied If the prompt dependency is satisfied. Possible values are:
Y
Yes
N
No
character 1
Prompt_type The prompt type. Possible values are:
L
Ad-hoc
G
Predefined
R
Restart
character 1
Status The prompt status. Possible values are:
A
Asked
T
Not_asked
Y
Answered_yes
N
Answered_no
character 1