Dear Koha Community, I am working in a private university library where students enrolled for a academic session only. Their library enrollment is limited to 4-5 years. After this academic year, they have to take library clearance to get their certificate. After that time we normally delete their patron records to prevent using the library.Till now we are managing the library clearance in such way. *The problems I am facing is:* 1. If we want to generate a library clearance report in every month it is very difficult to generate. It is possible but not a clear one. 2. Information of Patron with his circulation history got cleared also. *I have checked following scenarios and possibilities but i didn't find any of them appropriate: * 1. If we make them *expired*, someone may click on renew to renew them. 2. If we *make a note* to their message, Someone may not see the message. 3. If we make them *restricted*, They may be unrestricted someone with permission. *In above cases staff training and maintaining is so much difficult.* ............................................................................................................................. I just wondering if there is any system or menu link like in Patron Detail Page > More > *Clearance*. It will be nice. My application to you that, if that *Clearance *works as : a. Staff click on the *clearance *link b. A page with *clearance *will appear with following options 1. Account Summary [If any due, it will show the account link] 2. If check out(s) [Show the list of books to be submitted before *clearance*] 3. Date of expiration [Show the nearest date to be automatically expired] 4. *Clearance Button [Only *shown if 1-2 conditions were cleared *]* *Activity of clearance button should be: * 1. Create a new row in a new table named *clearance*. 2. Move all the remaining data from borrowers and activity table (i.e. circulation history, modification history) and pasted to the *clearance *table. It will be very helpful for us if you give me a suggestion regarding this simple problem. I am looking forward to your kind attention please. *Best wishes.--------------------Md. Mubassir Ahsan* BA & MA in ISLM (DU) MPhil Researcher (DU) *Library Officer (IT)* Daffodil International University Office Phone: 01811458818 Email: mubassir@daffodilvarsity.edu.bd ------------------------------------- Website:Sothik.com *-----------------------------Mobile+Viber: 01916303060* Email: mahsandu@gmail.com Facebook: mmahsan <http://facebook.com/mmahsan> Skype: mahsandu Twitter: mahsandu *"Proud to be a LIS Professional*" *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace, Greenstone), N/W Admin, DBA.*