What are borrowernumbers and how to find them
What is a borrowernumber?
Borrowernumber are unique numbers that are automatically applied to new patron records by the Koha site as they are created. The borrowernumber must be unique and it cannot be edited from within the Koha application. The function of a borrowernumber is to act as an identification number for the patron record.
How can a borrowernumber be identified?
Patron Account
On a patron record, the borrowernumber can be seen in the Library use section of the patron account.
Reports
There are many different reports that can bring back the borrowernumber on records. A basic setup would be:
SELECT borrowernumber
FROM borrowers
LIMIT 10
This report will bring back results similar to the image below:
This basic report can be limited in an almost unlimited number of ways, including by patron category, registration date and home branch.
As all patron accounts will have a borrowernumber an unlimited report should not be run as the resources used to bring back the result might slow the site
For assistance in creating a report to bring back a specific borrowernumber or range of borrowernumbers, please contact Interleaf Technology directly.
| Version | Date | Detail | Author |
| 1.0 | 09/01/26 | Document created | Holly Cooper |
Related Articles
How to batch delete GONE borrowers using the reports module
This document will outline how to delete GONE borrowers from Scooter. Run the Borrowers requiring manual deletion report. Go to Reports > Guided reports click Use saved and you will be brought to a new page with a table of all the reports currently ...How to create a paton list
It is possible to save patron information in a list format on Koha, which can then be used by a variety of functions within Koha, such as the batch patron modification tool, or can be downloaded so patron information can be viewed outside of the Koha ...How to Run Reports on SIP2Surf WiFi
How to Run Reports on SIP2Surf WiFi To run reports on your SIP2Surf. Connect to the interface through your web browser. https://sip2surf.interleaf.ie:8443/admin From here enter the username and password you were given during installation. You will ...What are patron cardnumbers and how to find them
What is a cardnumber? Cardnumbers are unique numbers that are manually applied to new patron records by the staff member creating the patron record. They do not necessarily need to come from a physical card. The cardnumber must be unique but it can ...22.05 - How to change the default sort order of the saved reports table
This document will outline how to set the default sort order of the saved reports table by the preferred column. For more information on the saved reports table in general, please check our Help Centre or submit a ticket with any specific questions ...