Statistics in Koha

Statistics in Koha

Does Changing An Item's Barcode Affect its Statistics?

Updating an item's barcode will not affect its checkout history or statistics. Each item in Koha has a corresponding itemnumber, a persistent, unique identifier in the database. That itemnumber is what populates data in reports, including in tables like the statistics table, issues/old_issues tables (checkouts and checkout history), or the reserves/old_reserves tables (holds and hold history), to name some of the most common few tables for circulation reporting.

Practically speaking, this means that if a barcode sticker comes off an item and the library needs to replace it, all the history of that item is tied to its itemnumber, not the individual barcode. The only limitation is that the new barcode cannot be a duplicate of any other barcode already in the system.

What Happens to the Statistics of a Deleted Branch?

Koha has guard rails around deleting important information like a branch code if it is in use, but once a branch's items are all transferred to a new location and no patron accounts remain using that branchcode, the branch can safely be deleted from Koha.

Statistics capture a snapshot of information at time of transaction, so the statistics.branchcode field of statistics reports will still retain the branchcode for historical circulation counts, even if the branch has been deleted. Statistics reports linking out to additional tables may need some adjustment in light of a deleted branch, but the statistics do still remain and can be reported on.
    • Related Articles

    • Koha Glossary of Terms

      Find the basics of Koha's vocabulary here This glossary is in alphabetical order. Use control+F to quickly search this page for specific terms. Authority Record: allows your library to control and search fields in your MARC records such as subject ...
    • Koha and Aspen Practice Exercises

      Whether your library is in implementation or you are training new staff, these exercises are a great place to start practicing procedures and workflows! For libraries in implementation, another effective way to learn is to keep track of what ...
    • Statistical Patron and Local Use

      One way to track the use of in house items is to “check out” the materials to a statistical patron. The “check out” process doesn’t check the book out but instead tracks an in house use of the item. You can create a statistical patron for tracking ...
    • Creating Bundles of Items in Koha

      In this tutorial, we will show you how to create bundles, or a group of items, in Koha. This allows libraries to create groups or kits, easier in Koha! If you are setting up a book club kit, binding journal volumes or even a group of Library of ...
    • Accidentally Delete a Report? These steps will show you how to recover it

      Action logs are your friend In this Koha tutorial we will walk you through recovering a deleted report. Reports in Koha are a way to gather data. Reports are used to generate statistics, member lists, shelving lists, or any list of data in your ...