Skip to main content
Ex Libris Knowledge Center

Finding loans with improbable/incorrect due dates

  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local



How can we find loans with improbable/incorrect due dates?


The following SQL can be used for for analyzing loan dates and due dates:

> s+ xxx50
xxx50@ALEPH20> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ z36_loan_date, z36_original_due_date, z36_due_date, count(*) from z36 where z36_loan_date > '20161124' and z36_due_date > '20161220' group by z36_loan_date, z36_due_date, z36_original_due_date having count(*) > 1 order by z36_loan_date, z36_due_date, z36_original_due_date; 

A difference between the z36_original_due_date and the (current) z36_due_date indicates that either the item was renewed or the due date was changed manually.



  • Article last edited: DD-Mmm-YYYY
  • Was this article helpful?