Tracking Patron's Last Checkout/Renewal Date

Bug #1691246 reported by Jason Stephenson
34
This bug affects 7 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Wishlist
Unassigned

Bug Description

It would be useful for automated removal of inactive patrons if the user activity tracking added in bug 942631 would include the date (not the time) of a patron's last chekout or renewal activity.

This would be useful for processes like remove all expired patrons who have had no activity in X years. If you are currently aging circulations, you can see the last time a patron used SIP or logged into the OPAC, but not the last time that they checked out an item.

Revision history for this message
Jason Stephenson (jstephenson) wrote :

I think this should have a setting to control the granularity of the data stored, i.e. down to the day, the month, or just the year.

And/or an option to enable the feature with it being disabled by default.

Some preference has been expressed in IRC for the former.

Elaine Hardy (ehardy)
tags: added: patron
Revision history for this message
Michele Morgan (mmorgan) wrote :

Including checkout and renewal (but not autorenewal?) activity in the user activity table would allow counting activity by unique patron. Counting circulation activity by unique patron is currently not possible for aged circulations as a unique identifier for the patron is not retained.

Changed in evergreen:
status: New → Confirmed
tags: added: circ-checkout
Revision history for this message
Mike Rylander (mrylander) wrote :

Michele, I think that's an awesome idea. As for autorenewal, it can be recorded with a separate activity type so it can be ignored as necessary. We'd probably want to track in-house-use and non-cat circs as well.

Revision history for this message
Galen Charlton (gmc) wrote :

As it happens, the config.usr_activity_type already includes values for "circ", "hold", and "search", so a bit of of the infrastructure for this was anticipated.

If we add a column to config.usr_activity_type to specify the desired precision of the timestamp and sprinkle in the user activity logging calls in the right places, I think that would suffice. I think that the precision should be set at the activity type level rather than bothering with library settings -- and I think there's benefit in forcing a consortium to come to a consensus. Doing it that way would also make it a bit easier for a trigger to do the truncation of the timestamp.

I would advocate for the 'circ' and 'hold' event types to be both transient and inactive by default with the timestamp precision set to year and month by default.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.