What are item numbers and how can they be identified?
What are item numbers?
Item numbers are unique internal database numbers applied to all items on a KOHA system. Unlike barcodes, which are assigned by the library, these are automatically generated by the system as items are created. These numbers do not show in the item record, unless their field is set to appear, which it is strongly advised not to do.
What are they used for?
The main use for item numbers is to link different tables within the SQL database.
How can they be found?
It is not usually possible to search the catalogue by item number as it is not something that most users think about and seek to identify, however they can be found by running particular SQL queries. An example of such a report is:
SELECT items.itemnumber, items.barcode
FROM items
It should be noted that this is the report at its most basic and if there are many items on the catalogue it could slow the system searching for them.
For advice about the different ways to limit reports, please check our Help Centre for report information or contact Interleaf Technology directly.
Related Articles
How to transfer an item record from one bibliographic record to another
If an item is attached to the incorrect bibliographic record it is possible to move it from one to another without needing to delete the original item record created. Step 1- Identify the item record to be moved and the bibliographic record to which ...A tour of the Add Item form
This document is intended to outline the different fields that can be set to appear on the Add item form. Before looking at the functions of the different fields, there are a few points to keep in mind: It should be noted that just because a field ...How to group item types using parent item types
Item types are used by the fine and circulation rules to determine how many items can be checked out and by which patrons. It is possible to link item types to each other by assigning a parent item type which allows libraries greater control over ...How to allow item level holds on the OPAC
This document will outline the options for using item level holds on the OPAC. An item level hold means students can place a hold on a specific copy of an item, rather than needing to place a hold on the title and take whichever copy the library ...How to address GONE patrons with items checked out
Summary of the issue Once a year patron accounts are updated so students move on one year and new first years are added to the site. At this time any students that were in their final year of study will be sent to GONE, indicating they are no longer ...