Purpose:

• Run annually, the CUL annual data collection requires the following counts that hopefully can be provided through FOLIO. Note that there are some additional measures collected for ARL and for ACRL/NCES (which see):
  • Collections:
    • Physical volumes held by unit, and by unit at the Annex
      • Breakouts:
        • Physical volumes added new in FY, by unit and by unit at the Annex
        • Physical volumes added retrospectively in FY, by unit and by unit at the Annex
      • Physical videorecording pieces, by unit and by unit at the Annex
      • Physical soundrecording pieces, by unit and by unit at the Annex
      • E-books held
      • E-scores held
      • E-serials held
      • E-videorecordings held
      • E-soundrecordings held
      • E-maps held
      • E-other held
      • Serial titles currently received:
        • Physical
        • Electronic
        • Physical and electronic deduped
  • Circulation in FOLIO
    • Total charges, by unit shelved in
    • Total renewals, by unit shelved in
      • Breakouts by:
        • General collections; reserves; laptops; non-laptop equipment
          • Breakouts by:
            • user type (including traditional ILL and BD)
          • Collection delivery in FOLIO (most counts reflected in physical circulation)
            • Library-to-library Delivery filled requests, by unit shelved in, and by pickup location delivered to
            • Contactless Pickup, by unit shelved in, by pickup location delivery to
  • Materials expenditures:
    • Total library materials expenditures
      • Breakouts:
        • One-time
        • Ongoing
          • E-expenditures:
            • One-time
            • Ongoing
          • Expenditures tracked through the Office of Sponsored Programs
• This Readme takes you through those measures and indicates which reports you can use to get each.
• You can see CUL’s latest annual data collection Trends Report, along with collection definitions on Confluence at https://confluence.cornell.edu/x/JQDhAg .

Work still to be done:

• Rest of collection counts
  • Volumes added (have a set query for all added; looking further into separating out retrospectively added so have count of newly added)
• Expenditures: need to review queries for CUL’s ACRL needs, and write documentation
• Circulation: need to write documentation, and possibly queries that create exact sums needed for the annual data collection without using pivot tables
• Collection delivery

Which queries to use for the different measures:

Collections

• • Volumes held:

    • Use the following query to get the counts of volumes held by shelving location: Volume_count_stats  (CR144) (results from query 5).

  • Physical videorecording pieces, by unit and by unit at the Annex:

    • Use the following query SQL to get the counts of videorecording pieces held by shelving location: vidrec_piece_ct_adc (CR161) .

  • Physical soundrecording pieces, by unit and by unit at the Annex:

    • Use the following query SQL to get the counts of sound recording pieces held: soundrec_piece_ct_adc (CR160).

  • E-books:

    • Use the following query: Title_count_servremo_adc_stats (CR164). Sum the counts with the “bib_format_display” of “Book.” Add also the HathiTrust count from A&P. (Note that in some measures e-scores are added to this count.)

  • E-scores:

    • Use the following query: Title_count_servremo_adc_stats (CR164).  Sum the counts with the “bib_format_display” of “Music.”

  • E-serials:

    • Use the following query: Title_count_servremo_adc_stats (CR164). Sum the counts starting with the “bib_format_display” of “Serial” (includes all formats of serials).

  • E-videorecordings:

    • Use the following query: Title_count_servremo_adc_stats (CR164). Sum the counts with the “bib_format_display” of “Visual materials.”

  • E-soundrecordings:

    • Use the following query: Title_count_servremo_adc_stats (CR164). Sum the counts with the “bib_format_display” of “Recording: music” and “Recording:non-music.”

  • E-maps:

    • Use the following query: Title_count_servremo_adc_stats (CR164). Sum the counts with the “bib_format_display” of “Map.”

Filters:

See individual sets of queries.

Output:

See individual queries.