[IUG] What do you do with your billed (aka long overdue) items?

["Fifarek, Aimee" <afifarek at scottsdaleaz dot gov>]

I'm hoping that someone can share their database maintenance workflow
with me.  We have a monthly schedule for purging item records that have
statuses of missing, lost, lost&paid, withdrawn:

*	Items with a status of w (withdrawn) for more than 30 days are
purged.
*	Items with status m (missing) for more than 30 days are updated
to status l (lost).
*	Items with status l or $ (lost & paid) for more than 90 days are
purged.

However we realized recently that we have not worked items with status
of billed into our purge cycle.  Sometimes people get their bill and
bring back or renew the items so the status is cleared.  However the
rest - which may or may not have the customer go into collections - are
just sitting there.  We are currently just suppressing them.  
 
I'd like to hear how you are handling these long overdue items to get
some ideas.  Any feedback is appreciated.
 
-- Aimee
    
 
Aimee Fifarek
Technologies & Content Manager
Scottsdale Public Library
3839 N. Drinkwater Blvd.
Scottsdale, AZ 85251
480-312-7060
480-312-7993
afifarek at scottsdaleaz dot gov
 


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---