INNReach Reports (Sierra)

Monthly Statistics Reports


OhioLink: http://198.30.120.21/manage
SearchOhio: http://ohpir.westervillelibrary.org/manage

INNReach Reports on Sierra

Sierra reports.jpg

Go to the INNReach Screen by clicking on Function drop down menu. INNReach functions are found under the Circulation category. 

Removing Virtual Records – Using Create Lists


Description of report: This process creates a list of broken virtual records. This process allows you to remove those records that read as ‘returned too long’, but are actually reading ‘available’ at your location.

Frequency: Once a month

Step 1: Creating the list

  1. In the Create Lists function select an empty list and click ‘Search Records.’
  2. Name the review file appropriately.
  3. Select ‘Item’ from the drop-down menu next to Store Record Type.
  4. The first term should be:
    • Type: Item
    • Field: VirtualRec
    • Condition: Exist
  5. The second term should be:
    • Operator: And
    • Type: Item
    • Field: Status
    • Condition: Equal to
    • Value A: – (Available)
  6. The last term should be:
    • Operator: And
    • Type: Item
    • Field: Due Date
    • Condition: Less than
    • Value A: Today’s date
  7. You can also add another term
    • Operator: And
    • Type: Item
    • Field: Hold
    • Condition: Exists.
  8. This will weed out anything that’s checked out but has an SearchOhio or OhioLink hold as well as items that have been requested long ago but were never filled.
  9. Click ‘Search.’ Be aware that the search may take awhile to compile.
  10. Once the search is complete, select your list and click on ‘Show Records.’
    • Tip: Copy and paste the list to an Excel file. This way you can have Sierra open alongside it and delete those you’re done with as you go.


Step 2: Cleaning up the records. Follow these steps for each record:

  1. In the Search/Holds function, enter the barcode.
  2. Change the status to ‘Off-Campus’ (@).
  3. Save.
  4. Go to the Check-In function.
  5. Enter the barcode and press enter.
  6. You should get this message: “Item has status Off-Campus and has been cleared.” Click ‘OK.’
  7. You may next get this message: “F>Fines will NOT be assessed.” Click ‘OK.’ Check the item in a second time to clear up the record.
  8. When you look some items up in the Search/Holds function you’ll see the INN-Reach request info in the Message field, like this:
  9. Just follow the same procedure listed in steps 2 through 7 above and it should go away. If not, edit the record and delete it manually.
  10. Run the list again with the same to clear up any that might have been missed.

Notes:

  1. You may have items that are long overdue to a local patron but have an old INN-Reach request. Handle these according to your local policies.
  2. Additionally, you may have old SearchOhio or OhioLINK requests in your list that just never got filled. Handle these according to your local policies.

Paged too Long

Description of Report: Allows the Library to create a list of all items that have been requested and paged, but have not changed status for more than three days.

Frequency: Twice a month.

Report Type: Paged too Long
Minimum Days: Recommended 3 days
Sort by: Item Location
Click Prepare.

The list will be displayed in item location order.

Paged.jpg

To produce a list in Call Number order for checking the stacks:
Highlight the rows of items belonging to your library.
Do a <CONTROL C> to copy the list.
Open a spreadsheet and in the first cell <CONTROL V> to paste the list into the spreadsheet.
To sort the list by call number:
Select all of the cells in the spreadsheet.
Go to Data in the Top Menu.
Go to Sort.
In the dropdown menu select the Column that has the call #.
This will sort the list in call number order.
Print this list and check the stacks for these items.
If any are found they should be processed, banded, and sent out.
If you have multiple locations or branches the lists can be e-mailed for them to check and process their items.
Note: Occasionally some III test records may appear on the list. Do not delete these items.

Returned too Long

Description of report: This report creates a list of INN-Reach items requested by other libraries that have had the status Returned for more than three days. These are items that have not been checked in at the owning library

Frequency: Once a month – This includes the removal of invalid virtual items.

Report Type: Returned too Long
Minimum Days: Recommended 3 days
Sort by: Patron Home Library
Click Prepare.

Returned.jpg




If you cut and paste the list from this screen it will not include the barcode. To include the barcode in the list that you send to other libraries you will have to print from this screen.

Note: As a part of the annual clean-up in June and INN-Reach overdues in December owning libraries should be checking the stacks for items more than 60 days overdue. The owning library checks the stacks and checks in any materials that are found. Materials with the status OhioLINK Returned for more than 6 months may be checked in at the owning library at any time and made missing. The owning library may put a note in the item record indicating the item status was OhioLINK Returned.

Email Language ex: (feel free to copy)
Hello,

This is the Returned Too Long list generated for Westerville. Please check your shelves or catalog to see if the item has been returned. If you find it, please check it in. If the item has a return date of more than 60 days, please check the item in so that it comes off borrowing patron’s account and make it missing.

If your records indicate that it’s available or already checked out to another patron, please let me know so that I can delete the broken link. As these items are listed as Ret’d on our end, I will be manually deleting these virtual records at the end of the month

In Transit too Long

Description of report: This report shows items that have been In Transit to Your Patron for more than 3 days. It locates books that have been put on the Hold shelf without being checked in.

Frequency: Once a week -late in the week to avoid weekend transit delays.

Report Type: In Transit too Long
Minimum Days: Recommended 3 days
Sort by: Patron Home Library
Click Prepare.

In transit.jpg

Locate the items in the results list that are in Transit to your library. Check the Hold Shelf to see if the items are there. If the material is found on the hold shelf check it in and then return the item to the hold shelf. The patron will then get the notice that the item is ready for pickup.
Email Language ex: (feel free to copy)
Hello,
This is the In Transit Report for Westerville. These items have not been received at our location. Please check your shelves for the item. If you do not find the item you may want to mark it as ‘missing’ in the catalog until it can be located.

I will remove the record (checking it in and deleting the virtual record) from our patron’s account at the end of the month.

Please contact me if you have any questions.

Requested too Long

Description of Report: Allows the library to create a list of all items that have been requested by their patrons and have been unfilled for more than three days from the date the request was placed. This report will allow you to give excellent service to your patrons.

Frequency: Once a month or bi-monthly


Report Type: Requested too Long
Minimum Days: 3, keep in mind weekends and holidays
Sort by: Patron Home Library
Click Prepare.

Requested too long.jpg


This list can be used to locate items that might be used to fill the patron requests. Locate the items in the OhioLINK catalog and request them from another lender.

Received too Long

Description of Report: This report lists the items with the status OhioLINK Received for more than three days. It helps to locate items that seem to be missing from the hold shelf.

Frequency: Monthly or bi-monthly


Report Type: Received too Long
Minimum Days: 3
Sort by: Patron Home
Click Prepare.

Received too long.jpg

Check to see that all of the items on this list are on your hold shelf. If an item is not found, contact the owning library to see if the item is there.


Email Language ex: (feel free to copy)
Hello,
This is the Received Too Long report for (your library). These items are no longer on our hold shelves, but are still listed as Received/Held. Please check your shelves for the item. If you do not find the item you may want to mark it as ‘missing’ in the catalog until it can be located.

I am removing the record (checking it in and deleting the item record) from our patron’s account at the end of the month.

  1. Institutional Overdue Reports[edit]
  • Description of Report: These reports are created twice a year to check shelves for materials that may have been returned, but not checked in. The clean-up guidelines are used once a year to clear items from patron records. The report can be run as often as time permits at the owning library. Reports are shared with other libraries only twice a year.
  • Frequency: Twice yearly. (December & June)
  • Report Type: Institutional Overdues Minimum Days: 60
    Maximum: 9999
    Sort by: Item Location & Call Number
    Click Prepare.
    Location: All.
  • Generate institutional overdues report for main library and branches for all items more than 60 days overdue. Select Sort by item location and call number. Search the stacks of the main library and all branches for all items on the list. Check in any items that are found.


Institutional Overdue Reports

Description of Report: These reports are created twice a year to check shelves for materials that may have been returned, but not checked in. The clean-up guidelines are used once a year to clear items from patron records. The report can be run as often as time permits at the owning library. Reports are shared with other libraries only twice a year.

Frequency: Twice yearly. (December & June)

Report Type: Institutional Overdues Minimum Days: 60
Maximum: 9999
Sort by: Item Location & Call Number
Click Prepare.
Location: All.

Generate institutional overdues report for main library and branches for all items more than 60 days overdue. Select Sort by item location and call number. Search the stacks of the main library and all branches for all items on the list. Check in any items that are found.

Generate the report again with the sort in order of patron home library. Copy and paste the information about each schools’ items into and e-mail to the p-circ contact at the patrons’ institution. Or mail a paper copy of the the appropriate portion to the pcirc contact at each institution.

 


While you are doing these lists, other institutions will be preparing lists of items that are overdue from your patrons. When you receive these lists, check the patron records and current status of each item on any lists you receive. Return the lists with any notes you have about the status of the book to the p-circ contact at the owning library.

Note. Any items on patron records that are more than 700 days overdue with the following status codes (Received, Returned, In Transit, Lost & Billed, Cancelled) should be cleared after the June Institutional Overdues are reviewed. The report can be run with 700 as the minimun number of days. Individual institutions may decide that 700 days overdue may be too long before marking items missing. This process can be done earlier. The 700 day mark was set-up by OhioLINK.

Email language ex: (feel free to copy)
Hello,

These are the institutional overdues for Westerville. This item should be on your patron’s record as a billed item. Please add this item as a manual fine and then check the item in. Please reply back when you have done that so that we can remove the item from our catalog.

If you have any questions, or if the item is not on your patron’s account, please let me know.