I will be presenting a related Sierra query at IUG as part of the “4 Perspectives on Using Holds Data with SQL” panel discussion Tuesday morning March 26 at 9:00. The Sierra query displays one row per branch and has columns for holds checked out, holds filled from the local collection, holds transited in from other branches, INN-Reach inbound holds, INN-Reach outbound holds and percentages of everything.
As compared to your study of patron behavior Daniel, my report 's primary purpose is to show how well-tuned a branch’s collection is to suit the requests for pickup at that branch.
Update 6/27/2025: Find the aforementioned query here. Again, this is a Sierra query batch, not Polaris.