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. Deleting inactive barcodes (z308 type 01)

    Deleting inactive barcodes (z308 type 01)

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Why can't inactive barcodes (z308 type 01 with z308_status=NA) be deleted through the gui?

    Are they needed for some reason? We have some SSN data for such records.

    Can we safely delete these via SQL?

    Resolution:
    The system requires that each patron have a z308 type 01 barcode record. You can't delete it.

    You could use SQL to change it from, for instance, 1234567 to DEL1234567, but note that the z353 (which contains the z308 barcodes) would need to be rebuilt -- by running p_cir_25 -- after making such a change via SQL.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Deleting Empty, Unlinked Headings
      • Deleting items from Course Reserves
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      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