[OPEN-ILS-GENERAL] circulation

[Jesse Ephraim]

Bill;

 

That's exactly what I needed.  Thank you VERY much!

 

Jesse Ephraim

 

Director, Roanoke Public Library

308 S. Walnut

Roanoke, Texas 76262

(817) 491-2691

jephraim at roanoketexas.com

 

 

From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Bill Ott
Sent: Thursday, December 30, 2010 7:54 PM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] circulation

 

On 12/30/10 8:10 PM, Jesse Ephraim wrote: 

If I wanted to pull a list of all items that were checked out between
two dates, would I look at the table action.circulation?  


Yes.





Is each entry in that table an indication of an item being checked out,
or does it also include check-ins?  


Yes, and yes.





If the latter, how do I distinguish between the two?


The xact_start (transaction start) is the timestamp of checkout.  The
checkin_time is the timestamp of when the checkin occurs.  A null in
that column indicates that the item is still in circulation.

There are 3 columns noting renewal possibilities, desk_renewal,
opac_renewal, phone_renewal.  If you're looking for only original
checkouts, you'll want all 3 of these columns to be null.




 

Thanks!

 

Jesse Ephraim

 

Director, Roanoke Public Library

308 S. Walnut

Roanoke, Texas 76262

(817) 491-2691

jephraim at roanoketexas.com

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20101230/8aebb622/attachment-0001.htm