Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    p_cir_23: deleting patron records and patron ids

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I need to delete patrons because the ids associated with the records have errors. I delete the patrons using cir-23 and the patrons records are gone. Then I load corrected records and the ids that have errors in them have come back and are included in the record along with the corrected ids - so I have records with 2 id 99s. How can I get these ids to go away

    Resolution:
    The help for cir-23 says that if you don't specify "All" as the sublibrary then only the Z305s (Patron's Local Information) are deleted. The Patron IDs (Z308), addresses (Z304), and global patron info (Z303) are not deleted.

    When we re-loaded the patrons, it found the still-existing IDs in the Z308 table because they are still linked to the primary ID.

    We changed the sublibrary to "All" and it deleted the IDs.

    Note: You can *not* delete cash records with sublibrary "All". See KB 16394-2625 in this regard.

    • Article last edited: 10/8/2013