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 be edited at any time through the staff side of Koha. The function of a cardnumber is to act as an identification number for the patron record and the hook to complete and track circulation actions through.
How can a cardnumber be identified?
Patron Account
On a patron record, the cardnumber can be seen in the Library use section of the patron account.
Reports
There are many different reports that can bring back the cardnumbers on records. A basic setup would be:
SELECT cardnumber
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 cardnumber 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 cardnumber or range of cardnumbers, please contact Interleaf Technology directly.
| Version | Date | Detail | Author |
| 1.0 | 29/01/26 | Document created | Holly Cooper |
Related Articles
Overview of some SQL Report Functions
Overview of SQL Report Functions This FAQ is an example of a simple report describing the “anatomy” of the SQL code used. Details about the different functions are outlined in the table below the report. Some functions are mandatory to use in order ...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 Batch Edit Extended Patron Attributes
This document outlines how to perform a batch patron modification for extended patron attributes. Extended patron attributes capture non - standard information about patrons and for more information about them please see our Help Centre. Step 1 - ...Running the overdue report with filters
This document will outline how to use filters for the Overdues report under the Circulation module. This document assumes that the FilterBeforeOverdueReport system preference has been set to Require. This document is intended to outline how these ...How to create a template for predefined notes on patron accounts
As well as being able to type notes manually into the patron account it is also possible to define default templates to populate the note field. Step 1 - Find the Bor_Notes Authorised Value Go to KOHA administration > Basic parameters > Authorized ...