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

    Incorrect Due Time Assigned During Renewal

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

    Description:
    In tab16 column 22 we limit borrowers to a maximum 3 day loan for certain item statuses. The attached screen print shows a situation where a borrower checked out one of these items and renewed it repeatedly.

    While the system appropriately limited the total loan period to a 3 day maximum, it did not assign the correct due time. The due time Sundays through Thursdays is 23:29; the due time Fridays and Saturdays is 19:29. I do not see anything in tab_check_circ that specifically addresses a tab16 column 22 check.

    Resolution:
    I agree that this seems incorrect, but the following SQL gets no hits (apparently because of the change to tab17):

    abc50@ALEPH171> select z36_due_date, z36_rec_key from z36 where z36_due_hour = '1929' order by z36_due_date;

    The results for the current Fri/Sat time (1959) are all (correctly) for Saturday Dec. 6:

    abc50@ALEPH171> select z36_due_date, z36_rec_key from z36 where z36_due_hour = '1959' order by z36_due_date;

    If it seems that there are other cases where the system is assigning incorrect due times, please use such SQL (or some other method) to find them so we can investigate.

    [From site:] I will let you know if this happens again.


    • Article last edited: 10/8/2013