[AWA] Which table in UC4 SQL database that holds Variable & Prompt settings for jobplan?
Article ID: 109872
CA Automic Workload Automation - Automation EngineAUTOMIC WORKLOAD AUTOMATION
Which table in UC4 database that holds the "Variable & Prompt" values for jobplan?
Release: Component: AAUTEN
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