Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Cash transactions lack item and bibliographic information

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

    Problem Symptoms:
    Two "Active Cash" transactions (from 2005) for patron 1234567 lack item and bib information.

    Cause:
    The bib information comes from the z13 (Short Bibliographic Record) of the bib the item is linked to.
    In this case, the Cash transactions are for a Lost item. The Loan history record has been deleted and the item, its associated bib, and its z13 have been deleted -- thus, no bib info. (See Additional Information below for details.)

    Resolution:
    1. There is no way to determine the title of the item in such cases.

    2. To prevent such cases in the future, avoid deleting bib and item records which have open Cash transactions linked to them.

    Additional Information

    Checking the z31 (Cash transactions) via SQL, these are Lost items which have not been paid for:

    SQL> select z31_rec_key, z31_description, z31_status, z31_key from z31 where z31_rec_key like '1234567%' and z31_date_x like '2005%';

    1234567 200507130916425 Lost item -Processing fee O
    000014564000010 000037598 200507130911200508010911

    1234567 200507130916550 Lost item -Replacement charge O
    000014564000010 000037598 200507130911200508010911

    {See Article 000007154 ("Structure of Z31-KEY field*].} The item# is 000014564-10. The z31_status of "O" indicates that the cash transactions are Open/unpaid.

    "000037598" is supposed to match the z36h (loan history) loan number of the loan transaction, but we see that it does not:

    xxx50@ALEPH21> select z36h_id from z36h where z36h_number = '000014564';

    no rows selected

    xxx50@ALEPH21> select z36_id from z36 where z36_number = '000014564';

    no rows selected

    It seems that the loan history records from 2005 were removed at some point.

    This item history record shows that item 000014564-10 was deleted in 2013-08-30:

    02 z30h_rec_key
    03 doc_number .................000014564
    03 item_sequence ..............000010
    03 sequence ...................000019
    02 z30h_barcode .................39323000151226
    02 z30h_sub_library .............UIPST
    02 z30h_material ................BOOK
    ...
    ...
    02 z30h_history
    03 h_date .....................20130830
    03 h_hour .....................1421
    03 h_reason ...................Deleted
    03 h_cataloger ................LFIELDS
    03 h_reason_type ..............DELETE
    02 z30h_upd_time_stamp ..........201308301421068

    The bib record was likely xxx01 000014564, but that bib record has also been deleted, so there's no way for the system to get the item's bib info.


    • Article last edited: 3/31/2014
    //doorbell.io feedback widged