[OPEN-ILS-GENERAL] Aged_Circulation

Tue Sep 12 14:51:39 EDT 2017

If you have circulations in both tables and want a complete picture, then
yes.  If you are on a version with the action.all_circulation view then it
combines data from both for a single reporting source.

Rogan Hamby

Data and Project Analyst

Equinox Open Library Initiative

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

email:  rogan at EquinoxInitiative.org
web:  http://EquinoxInitiative.org

On Tue, Sep 12, 2017 at 2:37 PM, <jmundy at tcpclibrary.org> wrote:

> So, if I run a circulation report for a month from a few years ago, do I
> need to run an aged report too to get all the relevant data?
>
>
>
> Thanks,
> John
>
>
>
> -----Original Message-----
> From: "Kathy Lussier" <klussier at masslnc.org>
> Sent: Friday, September 1, 2017 4:47pm
> To: open-ils-general at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-GENERAL] Aged_Circulation
>
> Hi Jim,
>
> It's likely that this information is not available in the documentation,
> but if anyone has the inclination to essentially copy what Jason said into
> Asciidoc so that it can be included, I'm sure others would appreciate it!
>
> If anyone is interested, I would happy to work with you on it to point you
> in the right direction for how the documentation gets done.
>
> Have a nice weekend!
>
> Kathy
>
> On 09/01/2017 05:41 PM, Jim Taylor wrote:
>
> 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-
> bounces at list.georgialibraries.org
> <open-ils-general-bounces at list.georgialibraries.org>] On Behalf Of Jason
> Stephenson
> Sent: Friday, September 1, 2017 4:15 PM
> To: open-ils-general at 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-bounces at list.georgialibraries.org
> <open-ils-general-bounces at list.georgialibraries.org>] *On Behalf
>
> > Of *Rogan Hamby
>
> > *Sent:* Friday, September 1, 2017 1:54 PM
>
> > *To:* Evergreen Discussion Group
>
> > <open-ils-general at 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:  rogan at EquinoxInitiative.org
>
> > <mailto:rogan at EquinoxInitiative.org <rogan at EquinoxInitiative.org>>
>
> >
>
> > web:  http://EquinoxInitiative.org
>
> >
>
> >
>
> >
>
> > On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin
>
> > <Benjamin.Murphy at ncdcr.gov <mailto:Benjamin.Murphy at 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 <(919)%20807-7424> <tel:(919)%20807-7424
> <%28919%29%20807-7424>>
>
> >
>
> >     Benjamin.Murphy at ncdcr.gov <mailto:Benjamin.Murphy at ncdcr.gov
> <Benjamin.Murphy at 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:jtaylor at jtdata.com <jtaylor at jtdata.com>
>
> >     <mailto:jtaylor at jtdata.com <jtaylor at jtdata.com>>]
>
> >     *Sent:* Friday, September 01, 2017 12:20 PM
>
> >     *To:* 'Evergreen Discussion Group'
>
> >     <open-ils-general at list.georgialibraries.org
>
> >     <mailto:open-ils-general at list.georgialibraries.org
> <open-ils-general at 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
>
> >
>
> >
>
> >
>
>
>
>
> -- Kathy Lussier Project Coordinator Massachusetts Library Network
> Cooperative (508) 343-0128 klussier at masslnc.org Twitter:
> http://www.twitter.com/kmlussier
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170912/239fab00/attachment-0001.html>