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