Evergreen DokuWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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)