Table relationships
Table 1 | Table 2 | Key Field | Join Type |
|---|---|---|---|
| Aleph Circulation History | Aleph Items | ADM ID + Sequence | InnerRight Outer |
| Aleph Items | Alma Items | BarcodeInner | Right Outer |
| Alma Items | Alma Holdings | Holding ID | Inner |
| Alma Holdings | Alma Bibs | MMSID | Inner |
| Aleph Circulation History | LKUP Aleph Item Process Status | Process Status code | Inner |
| Aleph Circulation History | LKUP Item Status | Item Status code | Inner |
| Aleph Circulation History | LKUP Borrower Status | Borrower Status code | Inner |
| Aleph Circulation History | LKUP Borrower Type | Borrower Type code | Inner |