Collection Management

Circ Modifier: Items with Selected Circ Modifiers
Circ Modifier: Copies without Circ Modifier
Inventory - Scanned Items Count by Shelving Location
Inventory - Un-scanned Items
Overdues Within Time Span - General (Based on Checkout Library)
Shelving Location and Circ Modifier: Items with Selected Shelving Location and Circ Modifier
Shelving Location: Items with Selected Shelving Location
Status: All Items with Selected Item Status
Title & Item Count by Shelving Location and Circulation Modifier
Weeding - Copies Circulated Fewer Times since a Selected Date OVER 2 Years ago
Weeding - Copies Never Circulated after a Selected Date

Circ Modifier: Items with Selected Circ Modifiers

Found under Shared Folders → Templates → Sitka_templates → Collection → Item List by Item Attributes.

Recommended Recurrence Interval: None, run as needed

  1. Enter a name that reflects what circulation modifiers you are reporting on.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Circulating Library = select your library.

      images/report/appendix/filter-in-list-circ-library.png
    2. Code = select the circulation modifier(s) for which you would like a list of items using the modifier(s).

      images/report/appendix/filter-in-list-circ-mod.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Circ Modifier: Copies without Circ Modifier

Found under Shared Folders → Templates → Sitka_templates → Collection → Item List by Item Attributes.

Recommended Recurrence Interval: None, run as needed

  1. Enter a name. You may wish to include a date.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Circulating Library = select your library and/or your branch(es)

      images/report/appendix/filter-in-list-circ-library.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Inventory - Scanned Items Count by Shelving Location

Found under Shared Folders → Templates → Sitka_templates → Inventory.

Recommended Recurrence Interval: None, run as needed

  1. Enter a descriptive name that includes the date on which you ran the report. You will likely run this report several times over the course of performing inventory.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Circulating Library = select your library.
    2. Latest Inventory Date = enter the date on which you started doing inventory.

      images/report/appendix/inventory-scanned-count-by-location-2.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Inventory - Un-scanned Items

Found under Shared Folders → Templates → Sitka_templates → Inventory.

Recommended Recurrence Interval: None, run as needed

  1. Enter a descriptive name.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Circulating Library = select your library.

      images/report/appendix/inventory-un-scanned-2.png
    2. Location ID = add the shelving location(s) you want included in your report.

      images/report/appendix/inventory-un-scanned-3.png
    3. Enter the date on which you started doing inventory.

      images/report/appendix/inventory-un-scanned-4.png
    4. ID = add the on-shelf statuses for your library such as Available and Reshelving. With this report you are looking for items in these statuses that should have been on the shelf and scanned for inventory but were not.

      images/report/appendix/inventory-un-scanned-5.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Overdues Within Time Span - General (Based on Checkout Library)

Found under Shared Folders → Templates → Sitka_templates → Circulation → Overdue.

Recommended Recurrence Interval: Weekly

  1. Enter a name that doesn’t include a specific date as this report will run every week. For example, "Items 7 to 21 Days Overdue" , not "Overdues for January 9th to 23rd".

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Due Date/Time = check the box for Relative time value and enter the time range you would like to report on. The earliest date (bigger number) goes first. If running as a weekly report it can be handy to use increments of 7.

      images/report/appendix/overdues-within-time-span-general-1.png
    2. Organizational Unit ID = select your library and/or your branch(es).

      images/report/appendix/filter-in-list-org-unit-id.png
  3. Check the box for Recurring Report.

    1. Set the Recurrence Interval to 1 Week(s).
  4. Check the radio button for Schedule Report For Later.

    1. Set the date to the first time you want the report to run. The report will run on the same day of the week every week; the example report will run every Wednesday.
    2. Set the time to between 1:00am PT and 4:00am PT.

      images/report/appendix/overdues-within-time-span-general-2.png

Shelving Location and Circ Modifier: Items with Selected Shelving Location and Circ Modifier

Found under Shared Folders → Templates → Sitka_templates → Collection → Item List by Item Attributes.

Recommended Recurrence Interval: None, run as needed

  1. Enter a name that reflects what shelving location and circulation modifier you are reporting on.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Location ID = select the shelving location for which you would like a list of items using the location.

      images/report/appendix/filter-in-list-shelving-location.png
    2. Code = select the circulation modifier(s) for which you would like a list of items using the modifier(s).

      images/report/appendix/filter-in-list-circ-mod.png
    3. Organizational Unit ID = select your library and/or your branch(es).

      images/report/appendix/filter-in-list-org-unit-id.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Shelving Location: Items with Selected Shelving Location

Found under Shared Folders → Templates → Sitka_templates → Collection → Item List by Item Attributes.

Recommended Recurrence Interval: None, run as needed

  1. Enter a name that reflects what shelving location(s) you are reporting on.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Location ID = select the shelving location for which you would like a list of items using the location.

      images/report/appendix/filter-in-list-shelving-location.png
    2. Circulating Library = select your library.

      images/report/appendix/filter-in-list-circ-library.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Status: All Items with Selected Item Status

Found under Shared Folders → Templates → Sitka_templates → Collection → Item List by Item Attribues.

Recommended Recurrence Interval: Monthly

  1. Enter a name that doesn’t include a specific date as this report will run every month. For example, "Items Currently Damaged, Lost or Missing", not "January Damaged, Lost, or Missing Items".

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Organizational Unit ID = select your library and/or your branch(es).

      images/report/appendix/filter-in-list-org-unit-id.png
    2. ID = add the status(es) you want included in your report.

      images/report/appendix/items-with-selected-status-3.png
  3. Check the box for Recurring Report.

    1. Set the Recurrence Interval to 1 Month(s).
  4. Check the radio button for Schedule Report For Later.

    1. Set the date to the first of the next month and the time to between 1:00am PT and 4:00am PT.

      images/report/appendix/recurring-report-monthly.png

Tip

Libraries may wish to set up multiple recurring reports, each for a different item status, or a single report that includes multiple statuses.

Title & Item Count by Shelving Location and Circulation Modifier

Found under Shared Folders → Templates → Sitka_templates → Collection → Item and Title Count.

Recommended Recurrence Interval: None, run as needed

  1. Enter a name that includes a specific date as this report will show a snapshot of your collection at the moment the report is run.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Organizational Unit ID = select your library.

      images/report/appendix/title-item-count-shelving-circ-mod-2.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Weeding - Copies Circulated Fewer Times since a Selected Date OVER 2 Years ago

Found under Shared Folders → Templates → Sitka_templates → Collection → Weeding.

Recommended Recurrence Interval: None, run as needed

  1. Enter a descriptive name.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Circulating Library = select your library.

      images/report/appendix/filter-in-list-circ-library.png
    2. Active Date/Time = enter the date after which new items should be excluded. If you don’t want to include items catalogued in the current calendar year enter January 1st of the current year.

      images/report/appendix/filter-before-active-date.png
    3. Location ID = select the shelving location(s) in which items should be included.

      images/report/appendix/filter-in-list-shelving-location.png
    4. Checkout Date/Time = enter a date after which to count circulations. Circulations before this date will not be used to calculate whether an item meets the threshold entered in the next filter.

      images/report/appendix/filter-onorafter-checkout-date.png
  3. Circ ID = enter a threshold. Items that have circulated fewer times than the threshold, after the date selected for Checkout Date/Time, will be included in your report output.

    images/report/appendix/filter-lessthan-circ-id.png
  4. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Note

For this example, the items that will be included in the report output are items catalogued before January 1st 2026 (Active Date/Time), that have the shelving location Juvenile DVD, and have circulated fewer than 2 times since January 1st 2022.

Weeding - Copies Never Circulated after a Selected Date

Found under Shared Folders → Templates → Sitka_templates → Collection → Weeding.

Recommended Recurrence Interval: None, run as needed

  1. Enter a descriptive name.

    images/report/appendix/name-your-report.png
  2. On the Filters tab, enter values for the filters.

    1. Active Date/Time = enter the date after which new items should be excluded. If you don’t want to include items catalogued in the current calendar year enter January 1st of the current year.

      images/report/appendix/filter-before-active-date.png
    2. Circulating Library = select your library.

      images/report/appendix/filter-in-list-circ-library.png
    3. Location ID = select the shelving location(s) in which items should be included.

      images/report/appendix/filter-in-list-shelving-location.png
    4. Last Circulation Date = enter a date for last checkout. Items that have not been checked out since this date will be included in your output.

      images/report/appendix/filter-before-last-circ-date.png
  3. On the Layout and Scheduling tab, ensure the box is checked for Run Report Now.

    images/report/appendix/run-report-now.png

Note

For this example, the items that will be included in the report output are items catalogued before January 1st 2026 (Active Date/Time), that have the shelving location Juvenile DVD, and have not circulated since January 1st 2025 (Last Circulation Date).

Copyright © 2008-2018, BC Libraries Cooperative