HD Data model details

Table relationships

Table 1Table 2Key FieldJoin Type 
HD ItemAlma ItemsBarcodeOuter
Alma ItemsAlma HoldingsHolding IDOuter
Alma HoldingsAlma BibsMMSIDOuter
HD Item HD TrayTray IDInner
HD TrayHD LocationLocation IDInner
HD ItemHD History LastBarcodeInner
HD History LastHD History AllBarcode + SequenceOuter
HD ItemHD History LastBarcodeOuter