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

    Difference between RENEW_TRANSACTIONS and RENEW_TRANS_ARCHIVE tables in Voyager Prepackaged Access Reports

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

     

    Question

    What is the difference betweend the RENEW_TRANSACTIONS and RENEW_TRANS_ARCHIVE tables?

    Answer

    • RENEW_TRANSACTIONS has a record for each time an item is renewed.
    • When the item is discharged, all of the renewal records get moved to RENEW_TRANS_ARCHIVE.
    • If you want to count renewals, you probably want to include records from both tables.

     

     

    • Article last edited: 27-May-2020