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

    Del-Information in BIB and item record

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

    Question

     In which Oracle table/field do I find the DEL=Y value for BIB and item records?  

    Answer

    In BIB record the DEL=Y field is embedded in the Z00 record as all other BIB fields are too.

     

    The Z30 record is actually deleted when the item record is deleted. The "Deletion" is reported in the Z30H (history) record the following way:

     

        02     02 z30h_history \

          03 h_date .....................20161228

          03 h_hour .....................1336

          03 h_reason ...................Deleted

          03 h_cataloger ................MASTER

          03 h_reason_type ..............DELETE

        02 z30h_upd_time_stamp ..........201612281336478

        02 z30h_ip_last_return_v6 .......

     

    This is only working when parameter CREATE-Z30H in tab100 is set to "Y" and a Z30H record is created.

     

     

     


    • Article last edited: 28-DEC-2016
    • Was this article helpful?