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 |