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

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