Okay.  Thanks.


So there is no duplication?   Everything in aged_circulation was once in 
circulation and is moved, not copied, to aged_circulation?  It just loses some 
of the info?  Or is it copied and everything in aged_circulation is still in 
circulation, assuming one hasn’t deleted rows in circulation?




From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan 
Sent: Friday, September 1, 2017 1:54 PM
To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Aged_Circulation


Hi Jim, Benjamin,


There are a number of differences that touch on aged versus not-aged 
circulations.  It's certainly true that circulations can be moved out of 
action.circulation to keep that table size down and that can be useful when we 
discuss things like tablespaces and Postgres.


However, to me the major difference is that the action.circulation table 
attaches back to the actor.usr table, i.e. there is a link between the patron 
and the circulation.  That link goes bye bye when a circ is moved to 
action.aged_circulation.  Some patron information is recorded in aged 
circulations for future statistical reporting purposes such as the user's post 
code, home org unit, profile group and birth year but the patron themselves is 
no longer identifiable.  Obviously, this can be of significant value for patron 



Rogan Hamby

Data and Project Analyst 

Equinox Open Library Initiative

phone:  1-877-OPEN-ILS (673-6457)

email:  ro...@equinoxinitiative.org <mailto:ro...@equinoxinitiative.org> 

web:  http://EquinoxInitiative.org


On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin <benjamin.mur...@ncdcr.gov 
<mailto:benjamin.mur...@ncdcr.gov> > wrote:

I’d love to see this as well if it exists.




Benjamin Murphy

Manager, NC Cardinal Program

NC Dept. of Natural and Cultural Resources

919.807.7424 <tel:(919)%20807-7424> 

 <mailto:benjamin.mur...@ncdcr.gov> benjamin.mur...@ncdcr.gov


Mail: 4640 Mail Service Center, Raleigh, NC 27699 | Office: 109 East Jones St. 
Raleigh, NC 27601


Email correspondence to and from this address is subject to the North Carolina 
Public Records Law and may be disclosed to third parties.




From: Jim Taylor [mailto:jtay...@jtdata.com <mailto:jtay...@jtdata.com> ] 
Sent: Friday, September 01, 2017 12:20 PM
To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org 
<mailto:open-ils-general@list.georgialibraries.org> >
Subject: [OPEN-ILS-GENERAL] Aged_Circulation


I am looking for a link to documentation that explains the purpose of each 
table.  I have found the schema documentation but nothing that explains the 
purpose.   Currently I am trying to determine the relationship of 
aged_circulation to circulation.   Since circulation contains records that are 
older than aged_circulation I assume it isn’t what the name might imply?



Thank you.




Reply via email to