Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Index NumberNameDescriptionTableau Dashboard Excel File DownloadDocumentationSQL Query Code
TD400 CR184A CR193

Physical Items Circulation Counts

Provides fiscal year counts of physical collections use (loans and renewals) with filters for owning library, patron group, material type, and collection type (regular, equipment, etc.). Also provides counts of patron filled requests. 

Physical Items Circulation Counts Dashboard 


ADC CR184A loans and renewals Excel download

ADC CR193 filled delivery requests Excel download

Filtering data to obtain specific counts

CR184A SQL Query

CR193 SQL Query

TD113

Physical Materials Counts

Provides fiscal year counts of physical collections by material type.

*Physical Materials Counts Dashboard (forthcoming)


CUL FOLIO Material Bib Format Display Table and Documentation

TD103

TD104

E-usage Counts

Eusage by Title - Annual data from EBSCO Consolidated files, received twice a year. Data not available in Folio. Data compiled by Sally Lockwood (sjl8) and made available in a BOX folder. 

Eusage by Platform - Annual data from EBSCO Consolidated files, received twice a year. Data not available in Folio. Data compiled by Sally Lockwood (sjl8) and made available in a BOX folder. 

E-usage Counts (forthcoming)

CR192

Withdrawn Items

This query finds the number of items withdrawn in the date range specified, as of 7-1-21 and going forward. From 7-1-21 through 8-14-22, the withdrawn information comes from the holdings note on specific holdings records. CR192 SQL QueryCR193

Filled Delivery Requests

This query provides a count of all contactless delivery and circulation desk pickup requests, by fiscal year. Patron group, material type, request type, and location details are included. ADC CR193 filled delivery requests Excel downloadCR193 SQL Query