2.4.1.1 1. OpenRS items borrowed by your patrons
Got to the Requests App and select "Holds" and "Closed - Filled"
On the top right click on "Actions and then "export search results to CSV"
Sort the "Current due date" by A- to Z
Make sure to choose "Expand the selection"
Lines that show a library of DCB and a due date in the future are current checkouts:
They will show patron information but not which library the book came from.
Items showing in transit:
For the most part are returns but can also include broken links and records checked out after they expired on the hold shelf.
2.4.1.2 2. OpenRS items lent by your library
Go to the Request App and select "Pages" and "Closed - Filled"
Go to the Actions menu on the top right and select "Export search results to CSV"
Sort the "Pickup Service Point" column by A to Z, also expanding the selection:
All Service Points beginning with DCB are OpenRS
Delete the service point rows for your library from the spreadsheet.
Sort the "Current due date" column by A to Z also expanding the selection:
Those entries with current due dates should still be checked out. The "Requestor barcode" column can show the barcode for the owning library to identify the patron, and the "Pickup service point" will show which library.
Contact information can be found on the Circ and ILL contact list:
https://mobiusconsortium.org/circulation-and-ill-contact-list