I'm trying to query the underlying database to find the values of prompt elements for a set of jobs. I decided to start with a specific job, but when I look in the OPUD table, not all the values for that job's promptset are listed there. The value I'm looking for is a text field. The promptset has 16 values, 7 text fields, 6 radio buttons, and 3 number choices. The values that show up when I query the OPUD table are 5 text fields values, and 2 radio values. I'm looking for the rest (or more specifically, one of the other text fields).
Can someone tell me what tables I should be looking at to see all the values that a job has stored for it's promptset?
Also is there a better description of the tables and what is contained in them, than the data dictionary that is provided by Automic?