[AWA] Which table in UC4 SQL database that holds Variable & Prompt settings for jobplan?

book

Article ID: 109872

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction



Which table in UC4 database that holds the "Variable & Prompt" values for jobplan? 

Environment

Release:
Component: AAUTEN

Resolution

The "Variable" information is stored in OV table, and "Prompt" information is stored in OPU table.
The reference keys to OH_Idnr (of jobplan) are OV_OH_Idnr and OPU_OH_Idnr. 

Another referent information:
- The default value of the prompt itself will be in OPSE 
- Value of prompt if defined on object level will be in OPUD 
- Value is overwritten in JOBP - value will be within JPPV