[OPEN-ILS-GENERAL] Aged_Circulation

[Rogan Hamby]

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
web:  http://EquinoxInitiative.org

On Fri, Sep 1, 2017 at 1:15 PM, Murphy, Benjamin <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>
>
> 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]
> *Sent:* Friday, September 01, 2017 12:20 PM
> *To:* 'Evergreen Discussion Group' <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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20170901/b2831cef/attachment-0001.html>