ReCAP Data model details
Table relationships
Table 1 | Table 2 | Key Field | Join Type |
|---|---|---|---|
ReCAP Item | Alma Items | Barcode | Outer |
Alma Items | Alma Holdings | Holding ID | Outer |
Alma Holdings | Alma Bibs | MMSID | Outer |
ReCAP Item | ReCAP Tray | Tray ID | Inner |
ReCAP Tray | ReCAP Location | Location ID | Inner |
ReCAP Item | ReCAP History Last | Barcode | Inner |
ReCAP History Last | ReCAP History All | Barcode + Sequence | Outer |
ReCAP Item | ReCAP History Last | Barcode | Outer |