"Lost Items Discharged Today" Report

(updated 7/31/2015)

About this Report

  • Voyager 9.1.1 introduced four new options for processing lost items at the time of discharge. Because the new options invite alternate workflows, libraries may want to use this report to double-check those workflows and to verify that all transactions followed library policy and I-Share best practices for lost item processing.
    • The report will be especially useful to libraries with multiple Voyager Reporter processing locations. It provides each library with a comprehensive list of lost items that were charged or discharged during the day, at any location.
    • Use the report to review any fines or fees forgiven, and to perform bursar refunds, as appropriate.
    • This report is different from the Item-related Exceptions Report that the Voyager Reporter client prints because this report contains the associated patron's information and is limited to just the lost item transactions.
  • CARLI generates the Lost Items Discharged Today report daily, and places it into your library's FTP account with the filename LostItemsDischargedToday_xxx_yyyymmdd.txt.
    • The report will still be generated even if no lost items were charged or discharged; on those days, the report will be blank.
    • Since the report usually runs in the early morning hours (around 1:30 am), a discharged lost item may be in the report with the next day's timestamp. Review the TRANS_EXC column described below in "Report Columns."
  • The Lost Items Discharged Today report selects data from the CIRC_TRANS_EXCEPTION table, where the exception type is "Lost Item Charged" or "Lost Item Discharged."
    • CARLI runs the report immediately before CircJob 24: "Transactions Exceptions Report for a library."

Using this Report

Opening the Report

  • For best results, open this report in Excel.
    • When you import, choose "delimited" as the file type; choose the the pipe "|" (vertical bar) character. 
    • Format the Patron Barcode column as text, and the TRANS_EXC column as a date. Other columns may be left as the "General" format.

Report Columns

  1. LIB: Your library's 3 letter code.
  2. TRANS_EXC: The date on which the transaction exception occurred, that is, when the lost item was charged or discharged.
  3. ZERO_MEANS_UBDISCHARGE: The LOCATION_ID of the location where the item was charged or discharged. A zero value means the location was at another I-Share library. The location name is in the next field.
  4. DISCHARGE_LOCATION: The name of the location where the item was charged or discharged. A blank field means it was at another I-Share library.
  5. TRANS_EXCE: The library operator who charged or discharged the lost item. If at another I-Share library, the operator will be SYS-UB.
  6. EXCEPTION_DESC: Lists whether it was a Lost Item Discharged or a Lost Item Charged transaction.
  1. LAST_NAME: The associated patron's last name.
  2. FIRST_NAME: The associated patron's first name, if entered.
  3. MIDDLE_NAME: The associated patron's middle name, if entered.
  4. PATRON_BARCODE: The associated patron's patron barcode, if entered. A single patron may not have an associated patron barcode, or may have more than one patron barcode. Use this field in conjunction with the PATRON_BARCODE_STATUS field, described next, to determine the barcode status.
  5. PATRON_BARCODE_STATUS: The patron barcode's status. A status of 1 = Active, 2 = Lost, 3 = Stolen, 4 = Expired, 5 = Other.
  6. INSTITUTION_ID: The patron's institution id, if entered.
  1. ITEM_ID: The Voyager internal ITEM_ID for the lost item.
  2. ITEM_BARCODE: The barcode for the lost item. A single item may not have an item barcode or may have more than one item barcode. Use this field in conjunction with the ITEM_BARCODE_STATUS field, described next, to determine which barcode is the active barcode.
  3. ITEM_BARCODE_STATUS: The item barcode's status. A status of 1 = Active, 2 = Inactive.
  1. LOCAL_PATRON_IF_0: If the value is zero, the patron is a local patron. If the value is not zero, look for the patron's home library name in the next field.
  2. PATRON_HOME_LIBRARY: If the patron is a UB patron, the patron's home library's name will display in this field.

Tips for USING THE Report

  • Most transactions reported will have the associated patron's information. Use this information to double-check fines and fees forgiven,  and lost item counters decremented, and to make bursar refunds, as applicable.
  • If no patron information is included, it may be possible to track the patron through outstanding fines or fees.
    1. Open Voyager Circulation.
    2. Retrieve the item record.
    3. Click on the Item menu.
    4. Select "Outstanding Fines" from the drop-down menu (if not greyed-out).
    5. If the item has outstanding fines/fees, the patron name will be in the list of results. Click Patron Fines to view/forgive the fines/fees.
  • If you need to know the location of a UB discharge, email with the rows from the report.

Additional information

Follow the I-Share Best Practices: LOST Item Procedure when dealing with lost items.

Send any questions to .