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] web: http://EquinoxInitiative.org On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin <[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 <(919)%20807-7424> > > [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]] > *Sent:* Friday, September 01, 2017 12:20 PM > *To:* 'Evergreen Discussion Group' <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. > > > > Jim >
