[OPEN-ILS-GENERAL] Looking for field definitions for item records

[Boggs, John]

Thanks, Brian. I'll spend some time with that schema today.

-John
________________________________________
From: open-ils-general-bounces at list.georgialibraries.org [open-ils-general-bounces at list.georgialibraries.org] on behalf of bfeifarek at q.com [bfeifarek at q.com]
Sent: Friday, October 07, 2011 4:37 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Looking for field definitions for item records

Hi John,

I have not seen definitive descriptions of the fields, and would be happy if somebody can indicate if this exists.

What I use to find my way around the Evergreen tables is mostly the Evergreen 1.6 schema<http://open-ils.org/documentation/evergreen-schema-1.6.0.1.html>, which does not have column descriptions but tracing through foreign key relationships (which are very helpfully hyperlinked) helps quite a bit.  To tease out what a particular column gets used for may also require some searching through source code to see where it gets used, but that can become a daunting undertaking.

Brian

________________________________
From: "John Boggs" <boggs at plsinfo.org>
To: "Evergreen Discussion Group (open-ils-general at list.georgialibraries.org)" <open-ils-general at list.georgialibraries.org>
Sent: Friday, October 7, 2011 3:36:58 PM
Subject: [OPEN-ILS-GENERAL] Looking for field definitions for item records

Hi all,

I’ve searched the documentation, the source code, and Google, and I can’t turn up definitions of the various item fields in Evergreen. Some are obvious, like barcode. Others less so (to me), like “circulate as MARC type.”

Is there a list anywhere that defines all the various item fields? I’m working on a migration from Millennium and need to figure out what to map to where.

Thanks!

John D. Boggs, PLAN Database Manager
Peninsula Library System
2471 Flores Street
San Mateo, CA  94403-2273
(650)571-6799 x3062
boggs at plsinfo.org<about:blank>