ReCAP Data model details

Table relationships

Table 1

Table 2

Key Field

Join Type 

ReCAP ItemAlma ItemsBarcodeOuter
Alma ItemsAlma HoldingsHolding IDOuter
Alma HoldingsAlma BibsMMSIDOuter
ReCAP Item ReCAP TrayTray IDInner
ReCAP TrayReCAP LocationLocation IDInner
ReCAP ItemReCAP History LastBarcodeInner
ReCAP History LastReCAP History AllBarcode + SequenceOuter
ReCAP ItemReCAP History LastBarcodeOuter