I have a more general, but related, question. Is there a schema or something published somewhere where we can tell which tables contain what information, and what the fields/columns are if we can't figure that out by their names? There ought to be something we can refer to to build queries that aren't addressed by AM reports and couldn't find anything like that in the documentation. Is there a diagram somewhere?
For example, I based my WHERE statement on SO_JOB_COND, but couldn't join to another table based on SO_JOB_COND.SO_OBJECT_SEQ, because I couldn't figure out how or where to relate it to get process flow name, job or task name, or how to exclude flows/chains if they were inactive or had inactive schedules or whose schedules were past their end dates.