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.