• 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