- Article Type: General
- Product: Aleph
- Product Version: 18.01
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.
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