Thank you very much. This is very helpful. Wish I could have found it in the documentation and not bothered anyone. One day I will figure out how to find stuff in the documentation 😊
Jim -----Original Message----- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Friday, September 1, 2017 4:15 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Aged_Circulation On 09/01/2017 04:50 PM, Jim Taylor wrote: > 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? There is no duplication. The action.aged_circulation is for statistical reporting while breaking the link to the patron who had the item checked out. Circulations get moved under three circumstances in stock Evergreen: 1. A patron is deleted. This moves all of the patron's circulations from action.circulation to action.aged_circulation 2. A row or row(s) in action.circulation are deleted. The action.age_circ_on_delete trigger moves deleted action.circulations to action.aged_circulation. 3. The action.purge_circulations function is run. This function is meant to be run periodically to enforce patron privacy. It's behavior is controlled by two internal flags: history.circ.retention_age and history.circ.retention_count. The purge_circulations function is often run from cron via the purge_circulations.srfsh script. NOTE: This function will take a *long* time to run for the first time on a system that has had much activity. The srfsh script will likely time out before the database function finishes and nothing will get moved. If you have not been doing 2 or 3, then the aged_circulation entries you see are likely because of 1. You can delete rows from action.aged_circulation if you wish. Keep in mind that this could lead to the loss of statistical information depending on what reports you use. HtH, Jason > > > > Jim > > > > *From:* Open-ils-general > [ <mailto:open-ils-general-boun...@list.georgialibraries.org> > mailto:open-ils-general-boun...@list.georgialibraries.org] *On Behalf > Of *Rogan Hamby > *Sent:* Friday, September 1, 2017 1:54 PM > *To:* Evergreen Discussion Group > < <mailto:open-ils-general@list.georgialibraries.org> > 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 privacy. > > > > > > > Rogan Hamby > > Data and Project Analyst > > Equinox Open Library Initiative > > phone: 1-877-OPEN-ILS (673-6457) > > email: <mailto:ro...@equinoxinitiative.org> ro...@equinoxinitiative.org > < <mailto:ro...@equinoxinitiative.org> mailto:ro...@equinoxinitiative.org> > > web: <http://EquinoxInitiative.org> http://EquinoxInitiative.org > > > > On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin > < <mailto:benjamin.mur...@ncdcr.gov%20%3cmailto:benjamin.mur...@ncdcr.gov> > benjamin.mur...@ncdcr.gov <mailto:benjamin.mur...@ncdcr.gov>> 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> tel:(919)%20807-7424> > > <mailto:benjamin.mur...@ncdcr.gov> benjamin.mur...@ncdcr.gov < > <mailto:benjamin.mur...@ncdcr.gov> mailto: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> 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> > 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. > > > > Jim > > >
