[OPEN-ILS-DEV] Question about Evergreen database

[Brandon W. Uhlman]

Hi, Scott.

I am not a EG developer yet, but as a humble sysadmin, I can take a  
stab at your questions.

The short answer to all of them is 'yes'. When a book is circulated, a  
record (or tuple, if you prefer) is created in the action.circulation  
table of the Postgres data. The tuple includes:

- the borrower (actor.usr)
- the item (asset.copy)
- the time the item circulated
- the staff person who circulated it
- the location where it was circulated

The item type is determined from the circ_modifier in asset.copy, the  
duration of the loan is determined in circ_item_config.js (in  
/Open-ILS/src/javascript/backend/circ in the source, and in  
$EG_HOME/var/circ in the compiled install) using with data in  
config.rule_circ_duration, and the result is also stored as the due  
date.

When the item is returned, the return location (actor.org_unit),  
return staff person, and return time are all stored in the tuple as  
well.

The database does retain this information for historical use. The  
staff client does have some already-included functionality for viewing  
this data, particularly for the scenario you mention in [2]. The  
reporting interface would let (staff) answer the questions in both [1]  
and [2].

It's worth noting, though, that some jurisdictions prohibit storing  
this information under privacy legislation without the borrower's  
consent, or, in some cases, at all. British Columbia, where our  
installation is, is one of the former, so over time, we'll be  
developing processes to vacuum this information from our database to  
comply.

Happy Turkey Day.

~B

Quoting Scott McKellar <mck9 at swbell.net>:

> Not being a librarian, and knowing little about how libraries work,
> I haven't paid a lot of attention to the OILS-specific parts of the
> code base.  However I do have a question.
>
> Suppose I check out a book, and return it a week later.  Does
> Evergreen remember that I checked it out at one time?  Or does it
> just note that the book is back in circulation, available to be lent
> to another patron?
>
> To address the issue a different way: is it possible (either through
> existing tools or through customized ad hoc queries) to answer
> questions such as the following:
>
> 1. Who checked out Moby Dick over the last year?
>
> 2. What books, or other items, did Suzie Grimshaw check out in March
> of 2007?
>
> I am not asking so much about the existing tools, but about whether
> the database retains this kind of patron-level usage history in the
> first place.
>
> Scott McKellar
> http://home.swbell.net/mck9/ct/
>
>



======================================
Brandon W. Uhlman, Systems Consultant
Public Library Services Branch
Ministry of Education
Government of British Columbia
605 Robson Street, 5th Floor
Vancouver, BC  V6B 5J3

Phone: (604) 660-2972
E-mail: brandon.uhlman at gov.bc.ca
         brandon.uhlman at bclibrary.ca