[OPEN-ILS-GENERAL] Holds / Circulation question

Wed Mar 4 10:32:07 EST 2020

Just to over-specify a little bit, here’s some db field names and what they’re called in the client and why that can be confusing:

asset.call_number.owning_lib - Owning Library. The branch that purchased the item (usually). This one is set at cataloging time and doesn’t change unless done manually.

asset.copy.circ_lib - Circulating Library. The library where the item is normally kept. This is frequently the same as the call number owning library, but if you have Floating enabled it may change to the checkin library when it’s circulated.

action.circulation.circ_lib - Checkout / Renewal Library. Used to also be called Circulating Library! Reusing that name has caused some confusion with reporting in the past. This is the library that checked out the item to a user, regardless of the value of the item’s circ_lib field. This is the one you want to filter on for circ reports to determine what items passed over your desk(s) regardless of where they may have came from. 

So, to get back to Stuart’s original question, the Checkout / Renewal Library from the Circulation source is probably what you want if you want to count circs at your location(s) regardless of where the item came from. More filtering can be done on the item Circulating Library field for things like how many of your own items circ to your users vs items from elsewhere, and how many of your items circ elsewhere in a consortium, etc.

Jason

-- 
Jason Boyer
Senior System Administrator
Equinox Open Library Initiative
phone:  +1 (877) Open-ILS (673-6457)
email:  JBoyer at EquinoxInitiative.org
web:  https://EquinoxInitiative.org/

> On Mar 4, 2020, at 10:10 AM, Kate Coleman <kcoleman at jeffcolib.org> wrote:
> 
> Ruth, I didn't even think of that! Thanks! Going back and looking at those libraries that do that, they do in fact have it defaulted to whatever they put in the Owning Library field. 
> 
> 
> Kate Coleman
> Jefferson County Library - Central Services
> Technical Services Specialist
> 5678 State Rd. PP
> High Ridge, MO 63049
> 636-677-8689
> Fax: 636--677-1769
> kcoleman at jeffcolib.org <mailto:kcoleman at jeffcolib.org>
> 
> 
> 
> 
> On Wed, Mar 4, 2020 at 9:07 AM Frasur, Ruth <RFrasur at library.in.gov <mailto:RFrasur at library.in.gov>> wrote:
> Attributes that aren’t set in templates or edited use defaults set up in library settings and other places.
> 
>  
> 
> Ruth Frasur
> 
> Evergreen Development and Support Administrator
> 
> Indiana State Library
> 
> 140 N. Senate Ave.
> 
> Indianapolis, IN 46204
> 
> (317) 460-7556
> 
>  
> 
> From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org <mailto:open-ils-general-bounces at list.georgialibraries.org>] On Behalf Of Kate Coleman
> Sent: Wednesday, March 4, 2020 10:04 AM
> To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org <mailto:open-ils-general at list.georgialibraries.org>>
> Subject: Re: [OPEN-ILS-GENERAL] Holds / Circulation question
> 
>  
> 
> **** This is an EXTERNAL email. Exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email. ****
> 
> Rogan and all,
> 
>  
> 
> The screenshot below is what I mean. We have libraries in our consortium that do this at this time and I'm wondering if it will cause issues. It certainly seems like it would cause statistical issues, but maybe some others as well?
> 
>  
> 
> <image001.jpg>
> 
>  
> 
> 
> 
> Kate Coleman
> Jefferson County Library - Central Services
> Technical Services Specialist
> 5678 State Rd. PP
> High Ridge, MO 63049
> 636-677-8689
> Fax: 636--677-1769
> kcoleman at jeffcolib.org <mailto:kcoleman at jeffcolib.org>
> 
> 
>  
> 
>  
> 
> On Wed, Mar 4, 2020 at 8:55 AM Rogan Hamby <rhamby at equinoxinitiative.org <mailto:rhamby at equinoxinitiative.org>> wrote:
> 
> Hi Kate,
> 
>  
> 
> If I'm undestanding your question correctly it's not possible.  The circulating library is an item attribute and requires an org unit id or it can't save the entry in the database.  The owning library as others have noted is a volume / call number attribute and has the same restriciton to not allow null values.  
> 
>  
>  
> 
> On Wed, Mar 4, 2020 at 9:46 AM Kate Coleman <kcoleman at jeffcolib.org <mailto:kcoleman at jeffcolib.org>> wrote:
> 
> Speaking of brains unwilling to compute...
> 
>  
> 
> If a multi-branch system (which additionally belongs to a large consortium) chooses to only use the owning library section for their items and leave the circulating library blank, are their negative repercussions for that?
> 
> 
> 
> Kate Coleman
> Jefferson County Library - Central Services
> Technical Services Specialist
> 5678 State Rd. PP
> High Ridge, MO 63049
> 636-677-8689
> Fax: 636--677-1769
> kcoleman at jeffcolib.org <mailto:kcoleman at jeffcolib.org>
> 
> 
>  
> 
>  
> 
> On Wed, Mar 4, 2020 at 8:18 AM Frasur, Ruth <RFrasur at library.in.gov <mailto:RFrasur at library.in.gov>> wrote:
> 
> Stuart,
> 
>  
> 
> The “circulation library” is the library that owns the material.  This doesn’t change (unless someone cedes ownership).  The “checkout/renew library” is the library that is circulating that item at any given moment.  The labeling for libraries is confusing.
> 
>  
> 
> Ruth Frasur
> 
> Evergreen Development and Support Administrator
> 
> Indiana State Library
> 
> 140 N. Senate Ave.
> 
> Indianapolis, IN 46204
> 
> (317) 460-7556
> 
>  
> 
> From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org <mailto:open-ils-general-bounces at list.georgialibraries.org>] On Behalf Of Forrest, Stuart
> Sent: Wednesday, March 4, 2020 9:04 AM
> To: Group, Evergreen <open-ils-general at list.georgialibraries.org <mailto:open-ils-general at list.georgialibraries.org>>
> Subject: [OPEN-ILS-GENERAL] Holds / Circulation question
> 
>  
> 
> **** This is an EXTERNAL email. Exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email. ****
> 
> Hi
> 
>  
> 
> This may sound a simple question to some, but my brain seems unwilling to compute!
> 
>  
> 
> So if a book that has been placed on hold that has a Circulating Library of ‘LibraryA’ is then transitted to ‘LibraryB’ where the hold is being fulfilled. Does the circulating library temporarily change to ‘LibraryB’ so that library gets the circulation? I’m thinking of circ reports now. Or would it be better to use Checkout Library instead to capture all circulations at ‘LibraryB’
> 
>  
> 
> Hopes this makes sense to someone as I am not quite understanding it.
> 
>  
> 
> Thanks
> 
> Much
> 
> Stuart
> 
>  
> 
> ------------------------------------------------------------------------------------------
> 
> Stuart Forrest, Library IT Manager/Analyst Beaufort County Library System
> 
> 311 Scott Street, Beaufort, SC 29902
> 
> 843 255 6450
> 
> sforrest at bcgov.net <mailto:sforrest at bcgov.net>
> beaufortcountylibrary.org <http://beaufortcountylibrary.org/>
>  
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20200304/aeb8c6a3/attachment-0001.html>