Batch-Session relationship in metadata

[sallymay]

Hello,
I'm looking at the metadata in the repository and I can't seem to find the relationship between batches and sessions. The table opb_batch_session seems like it would be the one to refer to, however, that table is empty. I'm using INFA 5.1. Any advice would be greatly appreciated.

 

[blom0344]

There is a relationtable OPB_BATCH_OBJECT that relates OPB_LOAD_SESSION with OPB_LOAD_BATCH:

OPB_BATCH_OBJECT.PARENT_ID = OPB_LOAD_BATCH.BATCH_ID

OPB_LOAD_SESSION.SESSION_ID = OPB_BATCH_OBJECT.OBJECT_ID AND
OPB_LOAD_SESSION.SUBJ_ID = OPB_BATCH_OBJECT.SUBJECT_ID

T. Blom
Information analyst
tbl@shimano-eu.com

 

[sallymay]

Thanks for the response. I was able to figure that out, but as I was doing that, I ran into a problem of determining sub-batches. I know there is a recursive join in OPB_BATCH_OBJECT, but I am having difficulty defining it. I want to be able to have a list of the batches, its sessions and its sub-batches. I have determined that a sub-batch can be the SIBLING_ID, but I'm not sure where to go next. Any advice would be greatly appreciated. Thanks!

 

[blom0344]

I think that you may want to look into a bit of Recursive SQL to unravel the parent - child relation between batches and subbatches. Since I have no sub-batches, I never ventured into this area, but I do have some example-stuff.....

T. Blom
Information analyst
tbl@shimano-eu.com