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? Jim From: Open-ils-general [mailto:[email protected]] On Behalf Of Rogan Hamby Sent: Friday, September 1, 2017 1:54 PM To: Evergreen Discussion Group <[email protected]> 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 privacy. Rogan Hamby Data and Project Analyst Equinox Open Library Initiative phone: 1-877-OPEN-ILS (673-6457) email: [email protected] <mailto:[email protected]> web: http://EquinoxInitiative.org On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin <[email protected] <mailto:[email protected]> > wrote: I’d love to see this as well if it exists. Benjamin Benjamin Murphy Manager, NC Cardinal Program NC Dept. of Natural and Cultural Resources 919.807.7424 <tel:(919)%20807-7424> <mailto:[email protected]> [email protected] 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:[email protected] <mailto:[email protected]> ] Sent: Friday, September 01, 2017 12:20 PM To: 'Evergreen Discussion Group' <[email protected] <mailto:[email protected]> > 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. Jim
