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

    Items set to Lost status prematurely

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

    Description:
    One of our professors (patron id: 37772) had over 50 of her books set to Long Overdue [Lost] status on our production machine on 6/21. The items were due on June 9 and based on logs I keep in in u20_1/abc50/print/sent only 1 overdue notice was sent on 6/15 even though the z36 record indicates that 3 notices had been sent.
    Based on our tab32 entry for item status 01 it is not clear to me how these items could already be set to Long Overdue status.

    Resolution:
    Below are the results of an SQL query of the z309 (Circ Logger) table for one of the items (000013969-000010) on loan to patron 37772. The events are in chronological order.

    I would note in particular these events:

    201005251617
    Web renewal. New due date 01/22/11 12:00 AM.

    201101230719
    Overdue letter number 01 created

    201102070728
    Overdue letter number 02 created

    201102071500
    Due date changed to 06/09/11 12:00 AM from original due date 01/22/11.

    201106070718
    Loan notice letter created.

    201106150708
    Overdue letter number 03 created

    As you can see, overdue letter #1 was sent in Jan. 2011 and letter #2 in Feb. 2011.

    Apparently it is your staff's expectation that the "Due date changed to 06/09/11" on 2011-02-07 would reset the z36_letter_number back to zero. As described in KB 8192-4858, the Renew function resets this counter, but the "Change Date" button on the patron "List of Loans" does *not*.

    Staff should use the Renew option in order to make the z36_letter_number be set back to zero.

    <begin SQL query:>

    SQL> select Z309_DATE_X, Z309_DATA from z309 where Z309_REC_KEY_3 = '000013969000010' and z309_rec_key like '37772%' order by Z309_DATE_X asc;

    Z309_DATE_X
    ------------
    Z309_DATA
    --------------------------------------------------------------------------------
    200806201226
    Regular loan, due date 01/17/09 12:00 AM.

    200812021040
    Loan notice letter created.

    200812021145
    Loan notice letter created.


    200812161157
    Loan notice letter created.

    200901121634
    Web renewal. New due date 06/12/09 12:00 AM.

    200905131105
    Loan notice letter created.

    200905261804
    Web renewal. New due date 01/15/10 12:00 AM.

    200912091314
    Loan notice letter created.

    201001130728
    Loan notice letter created.

    201001131301
    Loan notice letter created.

    201001131738
    Web renewal. New due date 06/11/10 12:00 AM.

    201005041545
    Loan notice letter created.

    201005181338
    Loan notice letter created.

    201005251617
    Web renewal. New due date 01/22/11 12:00 AM.

    201005251618
    Web renewal. New due date 01/22/11 12:00 AM.

    201101111130
    Loan notice letter created.

    201101111218
    Loan notice letter created.

    201101200729
    Loan notice letter created.

    201101230719
    Overdue letter number 01 created

    201102070728
    Overdue letter number 02 created

    201102071500
    Due date changed to 06/09/11 12:00 AM from original due date 01/22/11.

    201106070718
    Loan notice letter created.

    201106150708
    Overdue letter number 03 created

    201106210832
    Cash (Debit:30.00) transaction created for Lost material-Handling. Net Amount:30
    .00, VAT:0.00.


    201106210832
    Cash (Debit:65.00) transaction created for Lost material-Replacement. Net Amount
    :65.00, VAT:0.00.

    201106210833
    Loan declared lost

    201106221003
    Late return, Original due date:06/09/11 12:00 AM. Actually returned on: 06/22/11
    10:03 AM

    201106221003
    Lost material-Handling. Receipt number:000112791, Remaining debit:0.00.

    201106221003
    Lost material-Replacement. Receipt number:000112790, Remaining debit:0.00.


    201106221016
    Regular loan, due date 06/21/12 12:00 AM.

    <end SQL query results>


    • Article last edited: 10/8/2013