PROMPT_REFS_V

The PROMPT_REFS_V view displays information about jobs and job streams that depend on a prompt.
Table 1. The PROMPT_REFS_V view
Column name Description Type Length
Prompt_identifier The identifier of the prompt on which the jobs and job streams depend. character 16
Prompt_name The name of the prompt on which the jobs and job streams depend. string 148
Prompt_fol_id The identifier of the folder where the prompt is stored. character 16
Prompt_fol_name The name of the folder where the prompt is stored. string 801
Prompt_Symphony_id The Symphony ID of the folder where the prompt is stored. string 16
Prompt_text The text associated with the prompt. string 200
Dep_job_stream_wks_identifier The identifier of the workstation where the job stream that depends on the prompt specified in the Prompt_identifier column is defined. character 16
Dep_job_stream_wks_name The name of the workstation where the job stream that depends on the prompt specified in the Prompt_name column is defined. string 16
Dep_job_stream_folder_id The identifier of the folder containing the job stream that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_stream_folder_name The name of the folder containing job stream that depends on the prompt specified in the Prompt_identifier column. string 801
Dep_job_stream_identifier The identifier of the job stream that depends on the prompt specified in the Prompt_identifier column. string 16
Dep_job_stream_name The name of the job stream that depends on the prompt specified in the Prompt_name column. string 16
Dep_job_stream_valid_from The starting date from which the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_stream_valid_to The last date that the dependent job stream is included in a production plan if selected by a run cycle. date
10
In DB2®
9
In Oracle
Dep_job_wks_identifier The identifier of the workstation where the job that depends on the prompt specified in the Prompt_identifier column is defined. character 16
Dep_job_wks_name The name of the workstation where the job that depends on the prompt specified in the Prompt_name column is defined. string 16
Dep_job_name The name of the job that depends on the prompt specified in the Prompt_name column. string 40
Dep_job_identifier The identifier of the job that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_folder_id The identifier of the folder containing the job that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_folder_name The name of the folder containing job that depends on the prompt specified in the Prompt_identifier column. string 801
Dep_job_definition_identifier The identifier of the job definition that depends on the prompt specified in the Prompt_identifier column. character 16
Dep_job_definition_name The name of the job definition that depends on the prompt specified in the Prompt_name column. string 40
Dep_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_name column. character 16
Dep_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_name column. string 801
Dep_job_stream_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job stream that depends on the prompt specified in the Prompt_name column. string 16
Dep_job_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_name column. character 16
Dep_job_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_name column. string 801
Dep_job_wks_symphony_id An identifier used in the Symphony file to identify the workstation of the job that depends on the prompt specified in the Prompt_name column. string 16