|
Checkout bibliographic details and details of patron demographics by date and location (not count of patrons, but list of patrons)
This query needs a list of patrons, along with all patron information including patron department, and all information about the checked-out items (loans) including item barcode, title etc. (all item information), item location and "owning" library, and also loan date. The date filter is based on the loan due date (or the check-out date), so include both types of dates as a filter.
A patron may have multiple entries in the result. For Cornell, since we don’t keep patron information on returned items, the report would only get current checkouts that met the due date criteria.
Will likely combine ACRL Circulation report (or loans_items derived table) with Patron List report
|