Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Batch deleting processing fees from patron accounts

    Batch deleting processing fees from patron accounts

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    The sublibrary SSSSS is going to stop charging processing fees for lost materials and wants to waive all such existing fines.
    SQL (see Additional Info below) finds 20,101 lost-book processing-fee (z31_type 040) records for sublibrary SSSSS in the Z31 (cash table) that are marked as Open. The plan is to change the z31_status of these z31's to "W" (Waived), and add a note to the z30_description field indicating what has been done.

    There's a concern that these z31 records may be connected to other records which may also need to be updated. Are they?

    Answer

    There's no place in Aleph that a patron's outstanding fines are totaled. {This is inconvenient when trying to get the fine sum with SQL. Article 000012398 ("SQL to find sum of what patrons owe") discusses this.} But it makes things easier for you: when the z31_status is changed from "O" to "W" (or “C”) there's no need to worry about the effect on other records.

    Additional Information

    SQL query:

    select Count(*)
    from xxx50.z31
    where z31_type ='0040' (0040 - Lost material - Handling)
    and z31_status ='O'
    and z31_sub_library ='SSSSS';

    Category: Circulation (500)


    • Article last edited: 2/14/2015
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Batch deleting patrons who have hold requests or items which have hold requests
      • Batch deletion of old/paid cash records
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Circulation (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved