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

    Difference between "CIRC TRANSACTIONS" and "CIRC TRANS ARCHIVE" tables in Voyager PrePackaged Reports

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

     

    Question

    What is the difference between the CIRC_TRANSACTIONS and CIRC_TRANS_ARCHIVE tables in Voyager PrePackaged Reports?

    Answer

    • CIRC_TRANSACTIONS contains data for all currently circulated out titles. (Depending on your loan period and renewals, that could include titles that have been checked out quite a while).
    • Use CIRC_TRANS_ARCHIVE to get past transactions for each title. (There is a separate entry for each checkout. Renewals are recorded in the same record).

    Additional Information

    See the Voyager Data Dictionaries and ER Diagrams.

     

     


    • Article last edited: 03-May-2019