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