I'm interested in this idea too - have fines entered your discussions? We have encountered patrons who had max fines as a juvenile, but their parents never paid the fines. We wouldn't want to automatically remove the parent's identifying info from the account in these cases since the parent is still responsible for those bad debts. Of course, we could probably just add an extra bit into the script to check for fines before updating all of that info - or maybe partially update, but add different info to the alert.
Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 [email protected] <div>-------- Original message --------</div><div>From: Justin Hopkins 📖 <[email protected]> </div><div>Date:06/10/2015 5:37 PM (GMT-05:00) </div><div>To: Evergreen Discussion Group <[email protected]> </div><div>Subject: Re: [OPEN-ILS-GENERAL] alert for once juvenile becomes adult </div><div> </div>Blake is going to put something together, for our own use if nothing else. Hopefully it will be useful for others :) Justin On 6/10/15 4:24 PM, Holly Brennan wrote: > > Thanks, Justin! Your messages were filtered to my junk – sorry for the > late reply! > > I can look at the whole database, but only change things I’m familiar > with (and this is not one). > > -Holly > > *From:*Open-ils-general > [mailto:[email protected]] *On Behalf > Of *Justin Hopkins ?? > *Sent:* Wednesday, June 10, 2015 12:11 PM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] alert for once juvenile becomes adult > > I should clarify that my previous suggestion was based on my > recollection that you have access to the database and could set this up. > > Justin > > On 6/10/15 3:09 PM, Justin Hopkins 📖 wrote: > > Holly, > > I think the simplest solution would be to run a script on a > nightly cron that updated the database as necessary. Flip the > Juvenile flag, change their profile, possibly remove the > grouping/ident2_value, and add an alert. I thought we might be > running something like that ourselves, but either I'm not finding > it, or it's just something we'd also talked about doing but never did. > > Justin > > On 6/10/15 3:00 PM, Holly Brennan wrote: > > We’d like to be alerted when a patron who was marked as > juvenile (the checkbox based on their birth date) is now over > 18. The goal would be to catch those now-adults and change > their library card type from Juvenile to Adult, so they are > now responsible for their library card rather than their > parent. We would also enter their ID information, and remove > the parent’s ID (typically their driver’s license). > > The staff notification could be just a alert message. We’d > like to avoid having to look at an expired account and > calculate whether that patron is now an adult, so please no > solutions involving math. J > > We’ve run a report for patrons who have Juvenile accounts but > are 18+, and there are hundreds. I’m guessing we’re on our own > fixing these ones, but maybe there is a miracle out there for > adding the alert to these accounts too? > > Thanks! > > Holly Brennan > > Library Technology Specialist > > Homer Public Library, Alaska > > [email protected] <mailto:[email protected]> > > 907-235-3180 (main) > > 907-435-3154 (direct) >
