BIP Output Repository Table Relationship for Bursted Output (F95630, F95631)

BOster

BOster

Legendary Poster
It is pretty easy to determine the relationship between F95630 and F95631 for a single BIP output. I.e there is one data xml record in F95630 and one report output (pdf, rtf, etc.) record in F95631.

However, for a BIP bursted report I am failing to see the relationship between a specific data xml record in F95630 to the resulting output report record in F95631 for a given job. Is there some way to relate these two records?
 
From what I can see

F95630.XDRPDUOGUD links to F95631.XORPDOUGUD and XORPDFUSS1
 
This is the Job GUID and it gets all records in total for a job but for a bursted report it doesn't show a link for a specific 630->631 record.


Example of what I am seeing:
RPDOUGUD = Job
RPDUOGUD = UbeOutput
RPDORGUD = RecordGUID

Code:
F9563110  (control table)
Job                    UbeOutput
------------------- -----------------------------
AAA                   BBB

F95630 (Data Rep)
UbeOutput
----------------------------
BBB
CCC
DDD
EEE

F95631 (Report Rep)
RecordGUID                 Job                      RPDFUSS1 (Links RPDUOGUD)
----------------------- -------------------     --------------------------------------------
123                        AAA                             BBB
456                        AAA                             BBB
789                        AAA                             BBB
999                        AAA                             BBB
 
Last edited:
See attached for a real world example of what I am seeing for bursted output.
 

Attachments

  • BipRepositoryDbSchema.JPG
    BipRepositoryDbSchema.JPG
    433.2 KB · Views: 34
Back
Top