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

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

    • 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