Alma Metadata Data model details
Note: Alma Portfolios are not yet in Production
Table relationships
Table 1 | Table 2 | Key Field | Join Type |
|---|---|---|---|
Alma Items | Alma Holdings | Holding ID | Outer |
Alma Holdings | Alma Bibs | MMSID | Outer |
Alma Bibs | Alma Bib Fields | MMSID | Inner |
Alma Portfolios | Alma Bibs | MMSID | Outer |
Alma Portfolios | Portfolio Coverage | Portfolio ID | Outer |
Alma Portfolios | Portfolio Embargo | Portfolio ID | Outer |
Alma Holdings | Alma Holdings Fields | Holding ID | Inner |
Alma Items | HD Items | Barcode | Outer |
Alma Items | ReCAP Items | Barcode | Outer |
HD Items | LKUP HD Owner | HD Owner code | Inner |
ReCAP Items | LKUP ReCAP Owner | ReCAP Owner | Inner |