p_cir_03: "ITEM NOT LOANED TO DEPOSITORY " message
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
Why is the "ITEM NOT LOANED TO DEPOSITORY " message generated for items being returned to the depository (offsite storage) after a patron loan?
Resolution:
The message "ITEM NOT LOANED TO DEPOSITORY" occurs when the ./butil/b_cir_03_a program goes to look for a z36 (loan) record for a barcode from the input file and either
(a) doesn't find any z36 or
(b) finds a z36 whose z36_id doesn't match the item's z30_depository_id field.
In this case, it is occurring because it is not finding any z36 loan record.
In the case of barcode 31142000039571, which gets the message "ITEM BARCODE SUCCESSFULY IMPORTED", we see this:
abc50@ALEPH1> select z30_rec_key from z30 where z30_barcode = '31142000039571';
**** Hit return to continue ****
Z30_REC_KEY
---------------
002937515000010
abc50@ALEPH1> select z36h_loan_date from z36h where z36h_id = 'ABCRS' and z36h_rec_key = '002937515000010';
**** Hit return to continue ****
Z36H_LOAN_DATE
--------------
20080915
20090507
But in the case of barcode 31142045505800, which gets the "ITEM NOT LOANED TO DEPOSITORY", we see this:
abc50@ALEPH1> select z30_rec_key from z30 where z30_barcode = '31142045505800';
**** Hit return to continue ****
Z30_REC_KEY
---------------
000373992000730
abc50@ALEPH1> select z36h_loan_date from z36h where z36h_id = 'ABCRS' and z36h_rec_key = '000373992000730';
no rows selected
abc50@ALEPH1> select z36_loan_date from z36 where z36_id = 'ABCRS' and z36_rec_key = '000373992000730';
no rows selected
It *seems* that these barcodes were, for some reason, included in the input file when the items were not actually on loan.
- Article last edited: 10/8/2013