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

    What are the different due date fields in the Voyager Prepackaged Access Reports CIRC_TRANSACTIONS table?

    1. Last updated
    2. Save as PDF
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    What are the different due date fields in the Voyager CIRC_TRANSACTIONS table?

    Answer

    • The current_due_date is the due date that you normally want to use for queries. It is set when the item is initially charged and changed when the item is renewed or recalled.
    • The charge_due_date field is the due date at the time the item was initially charged; it never changes.
    • If the item was recalled, the new due date will be in recall_due_date.
    • If the item was renewed, the dates of each renewal will be in the RENEW* tables. 

     

     

    • Article last edited: 28-May-2020