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

    Difference between RENEW_TRANSACTIONS and RENEW_TRANS_ARCHIVE tables in Voyager Prepackaged Access Reports

    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare



    What is the difference betweend the RENEW_TRANSACTIONS and RENEW_TRANS_ARCHIVE tables?


    • 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