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 jephr...@roanoketexas.com From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Bill Ott Sent: Thursday, December 30, 2010 7:54 PM To: open-ils-general@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 jephr...@roanoketexas.com