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

    Deleting type 02 (ssn) z308's via SQL

    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    We want to eliminate Social Security numbers from ALEPH. Can we delete all type 02 IDs from z308 (directly via SQL)?

    Resolution:
    This is OK.... You, of course, need to make sure that you have some other type z308 for a match point in doing the PLIF load (and, of course, that that other type z308 is added *before* you delete the type 02), but there is no reason that the deletion of the type 02 z308's would cause a problem for ALEPH.

    As a precaution, we recommend backing up the z308 with p_file_03 before doing such a deletion.

    Note: This is *not* true of the type 01 (barcode) z308's. The system requires a type 01 z308. Also, the type 01 z308 is included in the z353 patron ID index, while the type 02-up are not.


    • Article last edited: 10/8/2013
    • Was this article helpful?
https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/Deleting_type_02_(ssn)_z308's_via_SQL
knowledge.exlibrisgroup.com
CC-MAIN-2024-26
isPartOf: CC-MAIN-2024-26
publisher: Common Crawl
description: Wide crawl of the web for June 2024
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-80
software: Apache Nutch 1.20 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.5-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: https://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/