Table relationships
Table 1 | Table 2 | Key Field | Join Type |
|---|---|---|---|
| Aleph Circulation History | Aleph Items | ADM ID + Sequence |
| Right Outer | ||
| Aleph Items | Alma Items | Barcode |
| 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 |