What is the function of the "itemnumber" field in the "items" table in Koha? Where does it come from? How is it used? In the MARC/Koha cross reference document on http://www.koha.org/wiki (which I realize is woefully out of date) the "itemnumber" field references MARC tag 890, subfield "c", which, as far as I can tell is not used elsewhere in Koha. In fact, neither MARC21 nor UNIMARC define tag 890 at all (see http://www.loc.gov/marc/bibliographic/ and http://www.ifla.org/VI/3/p1996-1/sec-uni.htm for tag definitions under MARC21 and UNIMARC, respectively). I have tried to put together a cross reference spreadsheet based not only on the cross reference document noted above, but also by reference to fields defined in Koha. Any information I can get on this or related questions will be appreciated. Thanks, Tom Madron Tom Madron Enterprise-Wide Computing, Inc. 1023 15th Avenue, South Nashville, TN 37212 Telephone: 1-615-259-2771 URL: http://www.ewcnet.com mailto:tmadron@ewc-inc.com
On Sat, Jan 24, 2004 at 08:25:32AM -0600, Tom Madron said:
What is the function of the "itemnumber" field in the "items" table in Koha? Where does it come from? How is it used?
Hi Tom Its an internal koha number, its the unique identifier for an item. Koha uses it in the issues table. We dont use barcode as an item may for whatever reason (damage, etc) get a new barcode. So its the primary key of the items table, its what koha uses to track items. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Hi Don The key to IRC is to stay on a bit longer if you can :-) Good times if you want the NZ folks is 9am-5pm Mon-fri our time (ie work days) and then sort of 7pm - midnight our time as which is a bit more hit and miss, but if people are there then they usually have more time to chat. The very high strike rate time of day is when the USA and NZ are awake at the same time - then you get a range of people. Cheers R_____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org
participants (3)
-
Chris Cormack -
Rachel Hamilton-Williams -
Tom Madron