[OPEN-ILS-GENERAL] circulation

Bill Ott bott at grpl.org
Thu Dec 30 20:53:54 EST 2010


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/29fe5611/attachment.htm 


More information about the Open-ils-general mailing list