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

    Difference between the "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

    • Circulation transactions are recorded in CIRC_TRANSACTIONS until the item is discharged, after which they are moved to CIRC_TRANS_ARCHIVE.
    • Consequently, the discharge… fields in CIRC_TRANSACTIONS are always blank.
    • When a transaction is archived, the value of circ_transaction_id is changed.
    • In both tables, circ_transaction_id is assigned sequentially as a record is added.
    • Nonetheless, you can join either table to REQUEST_HISTORY by circ_transaction_id.  
    • In CIRC_TRANS_ARCHIVE the Due_date is the due date at the time the item was initially charged out. If the item was renewed, the new date is not stored in this table.  
    • If you want to count renewals, use these two tables.  If you need to know when or how renewals occurred, you'll need the RENEW_TRANS* tables.
    • The patron_id field in CIRC_TRANS_ARCHIVE will always be 0 unless you have checked "Retain Patron ID" for Circ History in SysAdmin.  
    • For many circulation statistics, you will want to combine data from these two tables. Voyager provides an Access query called “Circulation Transactions (Charges)” which does this for you. From an Add Tables window in Access, click the Queries tab and you’ll find it

    See also the Voyager Data Dictionaries and ER Diagrams.

     

     


    • Article last edited: 03-May-2020
https://knowledge.exlibrisgroup.com/Voyager/Knowledge_Articles/Difference_between_the_%22CIRC_TRANSACTIONS%22_and_%22CIRC_TRANS_ARCHIVE%22_tables_in_Voyager_PrePackaged_Reports
knowledge.exlibrisgroup.com
crawl=CC-MAIN-2020-40
107917
application/http; msgtype=response
sha1:TLVO43M6ZHZLHADRBDXSW4OOXJROO5WI
<urn:uuid:f826f618-96ed-4ca3-809e-87717d1c5866>
2020-09-26T18:15:12Z
13.249.43.73
text/html
sha1:JIVD6XEOLOFE75FZ3NKRKU7EPL2B6OZP
<urn:uuid:4958f538-43f9-429a-bbf3-dd133c8aa4c6>
https://knowledge.exlibrisgroup.com/Voyager/Knowledge_Articles/Difference_between_the_%22CIRC_TRANSACTIONS%22_and_%22CIRC_TRANS_ARCHIVE%22_tables_in_Voyager_PrePackaged_Reports
response
<urn:uuid:752999da-8afb-4a03-9d7e-3497641ef4c6>
isPartOf: CC-MAIN-2020-40
publisher: Common Crawl
description: Wide crawl of the web for September 2020
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-70.ec2.internal
software: Apache Nutch 1.17 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.2-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/