[Koha] Patron Clearance Maintenance in Koha

[Mubassir Ahsan]

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 at daffodilvarsity.edu.bd
-------------------------------------
Website:Sothik.com

*-----------------------------Mobile+Viber: 01916303060*
Email: mahsandu at 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.*