Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Is it possible to find out what operator has charged out books?

    Is it possible to find out what operator has charged out books?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager

    Question

    Is it possible to find out what operator has charged out books?

    Answer

    Yes. Operator information associated with a transaction is stored in the database. CIRC_TRANSACTIONS and CIRC_TRANS_ARCHIVE store CHARGE_OPER_ID and DISCHARGE_OPER_ID associated with each transaction (in the case of CIRC_TRANSACTIONS, DISCHARGE_OPER_ID is empty as the transaction is still active/item has not been returned).

    Additional Information

    Example:

    With Prepackaged Reports (Reports.mdb) and an item barcode, a query can retrieve the operator for all past transactions for that item.

    select CTA.CHARGE_OPER_ID
    ,CTA.CHARGE_DATE
    from CIRC_TRANS_ARCHIVE CTA
    , ITEM_BARCODE IB
    where IB.ITEM_ID=CTA.ITEM_ID
    and IB.ITEM_BARCODE='{item barcode}';

    • Article last edited: 11-Oct-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Is it possible to change maximum connections for z39.50 server? How?
      • Is it possible to make changes in bulk to Acq data?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved