[OPEN-ILS-GENERAL] Aged_Circulation

[Jim Taylor]

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: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> 

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 <tel:(919)%20807-7424> 

 <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 <mailto: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> >
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/d8906444/attachment.html>