evergreen-reports:templates:circulation
Circulation Reports
These are reports based on circulations.
Circulation Report Based on 2 Custom Stat Cats
Submitted by PINES
Example use case: Libraries received items through a grant and need to report on circulations in a given time frame per grant and use type. Two stat cats were created to track 1) grant name and 2) use type. To create the report, fields/filters for the grant and type were added through the two different stat cat tables: Statistical Category Entries and Stat-Cat entry maps.
Source: Item
Display Fields:
- Item (Required) -> Barcode
- Item (Required) -> Circulating Library (Required) -> Circ Lib
- Item (Required) -> Call Number/Volume (Required) -> Bib Record (Required) -> Simple Record Extracts (Required) -> TCN Value
- Item (Required) -> Call Number/Volume (Required) -> Bib Record (Required) -> Simple Record Extracts (Required) -> Title Proper (normalized)
- Item (Required) -> Call Number/Volume (Required) -> Call Number Label
- Item (Required) -> Price
- Item (Required) -> OPAC Visible
- Item (Required) -> Is Reference
- Item (Required) -> Is Holdable
- Item (Required) -> Is Deleted
- Item (Required) -> Creation Date/Time
- Item (Required) -> Circulation Modifier -> Circ Mod
- Item (Required) -> Copy Status (Required) -> Copy Status
- Item (Required) -> Statistical Category Entries -> stat_cat_entry -> Project Name
- Item (Required) -> Stat-Cat entry maps -> stat_cat_entry -> Item Use
- Item -> Circulations -> Circs in Time Period
Filters:
- Item (Required) -> Shelving Location (Required) -> Owning Org Unit
- Item (Required) -> Stat-Cat entry maps -> stat_cat -> Stat Cat ID
- Item (Required) -> Statistical Category Entries (Required) -> stat_cat (Required) -> Stat Cat ID
- Item -> Circulations -> Checkout Date/Time (Date) (Between)
evergreen-reports/templates/circulation.txt · Last modified: 2025/08/20 09:45 by smorrison