Purpose:

  • Run annually, the ARL Statistics survey requests the following counts that can be provided through FOLIO:
    • Titles held
    • Physical volumes held (including ebooks)
    • E-books
    • Total library materials expenditures
      • One-time library materials expenditures
      • Ongoing library materials expenditures
      • Collection support
        • Shipping for new materials
        • Binding
      • Initial circulations (excluding reserves)
    • This Readme takes you through those measures and indicates which reports you can use to get each.
    • You can see CUL’s latest full submission, along with the survey instructions at this Confluence page .

Work still to be done:

  • Expenditures: need to review queries for CUL’s ARL needs, and write documentation.
  • Title counts:
    • Need to add to queries removing PDA/DDA unpurchased counts from physical and electronic.
    • Can we eventually get a non-duplicative HathiTrust count from FOLIO?
  • Circulation: need to write documentation.

Which queries to use for the different measures:

Title count:

  • Add together the results of multiple sets of queries, and then add some counts from outside of FOLIO. ARL indicates that titles should not be deduplicated between formats. [Here I am assuming we can remove any unpurchased pda/dda items in the queries; not yet done.]:
    • Add together the results of Title_count_non-micro-physical_adc_stats (CR162) and Title_count_micro_adc_stats (CR163) and Title_count_servremo_ads_stats (CR164). Then add:
      • A count of HathiTrust volumes; at this time, that is a set number not gotten through FOLIO ( contact A&P).
      • A count of images Ithaca cataloged in Arstor (contact A&P)

Volumes held (including e-books):

  • Use the following query to get the count of volumes held: Volume_count_adc_stats (use the grand total) (coming soon). Then add e-book and e-music title counts using Title_count_servremo_adc_stats (CR164).  [Here I am assuming we can remove any unpurchased pda/dda items in the queries; not yet done.] You will also need to add a count of HathiTrust book titles; at this time, that is a set number not gotten through FOLIO (contact A&P).

E-books:

  • Use e-book and e-music title counts from Title_count_servremo_adc_stats (CR164). [Here I am assuming we can remove any unpurchased pda/dda items in the queries; not yet done.] You will also need to add a count of HathiTrust book titles; at this time, that is a set number not gotten through FOLIO (contact A&P).

Materials expenditures:

  • Documentation coming soon.

Initial circulations (excluding reserves):

  • Documentation coming soon.
  • No labels