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. Old patron records (z305) gives wrong privileges

    Old patron records (z305) gives wrong privileges

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Problem Symptoms:
    * A patron's hold request triggers a recall though it shouldn't
    * There are old patron records (z305) having a different borrower status

    Can the old z305 be deleted without deleting the patron's loans or cause any other problems?
    Example 
    Old z305:
    z305_rec_key=PID000000112
    z305_last_update_date='19990226'
    z305_expiry_date=20020201
    z305_bor_status='02'    This gives the patron the wrong privileges
    z305_last_activity_date='00000000'

    New z305 (the one shown in the GUI):
    z305_rec_key=PID000000112XXX50
    z305_last_update_date='20121101'

    z305_expiry_date='20141002'
    z305_bor_status='14'    Correct privileges
    z305_last_activity_date='20121101'

     

    Cause:
    Old patron records contain wrong borrower status

     

    Resolution:
    * patrons without sublibrary are not in use and can be deleted

    Example
    885 occurrences of z305 records having blank (' ') instead of valid sublibrary
    xxx50@ALEPH18> select distinct(substr(z305_rec_key,13,5)),count(*) from z305
    2 group by substr(z305_rec_key,13,5);
    **** Hit return to continue ****

    (SUBSTR(Z305_REC_KEY COUNT(*)
    -------------------- ----------
    885
    RBRIK 759
    RIK50 14095
    RRRIK 29

    NOTE: There is no service to remove these patrons automatically. If you delete the patrons outside of Aleph, please make sure to export the relevant table (p_file_03 for z305) and update the tables when no one accesses these tables (use aleph_shutdown to ensure this).
     

     

     


    • Article last edited: 17-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Old Indexed Headings Retained in OPAC & GUI Browse Display
      • Old Z30 fields in ADM records (put there by the Store function)
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    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