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. How to locate duplicate patron records

    How to locate duplicate patron records

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We are finding cases of duplicate patron records in our system. Is there a way we can systematically check for such cases?

    Resolution:
    If the $usr_library tab100 has CHECK-UNIQUE-NAME-BIRTH=Y, then the check_z303 program will automatically check for duplicates, issuing the following message: "A user with the same name and birth date is already in the system" and preventing the duplicate from being created. See KB 8192-2109 for more on this message.

    But if you have CHECK-UNIQUE-NAME-BIRTH=N (which is the default), then, though the system will prevent the addition of a barcode or any additional ID which already exists, it will not prevent the creation of the patron.

    If you populate the z303_birth_date field, the check on unique name-birthdate should work well and we suggest setting CHECK-UNIQUE-NAME-BIRTH to "Y".

    If you have CHECK-UNIQUE-NAME-BIRTH=N, you can check for duplicates with the following SQL:

    SQL> set heading off
    SQL> select substr (z303_name,1,80), z303_birth_date, z303_home_library, z303_rec_key from z303 where z303_rec_key in (select z303_rec_key from z303 where z303_name in (select z303_name from z303 group by z303_name having count(*) >1 ))
    order by substr (z303_name,1,80);

    You can create a file with patron record keys you want to delete and use it as input to p_cir_23.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to load MARC records into a MAB library
      • How to look at z00r records: util f/4? SQL?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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