Circulation Reports

These are reports based on circulations.

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)