Versions Compared

Key

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

...

  • Remove “couttspdbappr” from unpurchased
  • Remove “h” from micro_by_007
  • Select “Book,” “Serial,” and “Serial – Music” from folio_format_type_adc_groups
  • Select “FY 2023” for record_created_fiscal_year (note that FY21 includes item records created in Voyager)
  • Note: A&P runs additional queries to get estimates of the number of items added retrospectively. Contact Linda Miller for more information.

...

PHYSICAL TITLE COUNTS (excluding microforms)

 Filter  Filter CR215 to:

  • Remove “couttspdbappr” from unpurchased
  • Remove “h” from micro_by_007
  • Use to get specific format counts in the data collection:
    • Select “Book” from folio_format_type_adc_groups for the books title count
    • Select “Serial,” “Serial – Computer file,” and “Serial – [any other bib format present]” from folio_format_type_adc_groups for the serial title count  (add the serial microform count for the final count)
    • Select “Map” from folio_format_type_adc_groups for the map title count
    • Select “Sound recording” from folio_format_type_adc_groups for the sound recording title count
    • Select “Visual materials,” materials” and “Kit” from folio_format_type_adc_groups  for the visual materials title count (the “3-dimensional object” count is added for national reporting)

 

 NON-SERIAL MICROFORM TITLES

...

  • Remove “Serial,” “Serial – Computer file,” and “Serial – [any other bib format present]” from folio_format_type_adc_groups
  • Note: All micform microform titles are included in national counts even though some overlap with print title counts

 

 SERIAL MICROFORM TITLES (to be added to the physical serial count)

...

  • Select “Serial,” “Serial – Computer file,” and “Serial – [any other format present]” from folio_format_type_adc_groups
  • Note: All micform microform titles are included in national counts even though some overlap with print title counts. This count is added to the physical serial count.

 

 E-TITLES

Filter CR217 to:

  • Remove “DDA_pqecebks” and “PDA_casaliuniebkmu” from unpurchased
  • Use to get specific format counts in the data collection:
    • Select “e-book” from ematerial_format for the e-books title count
    • Select “e-journal” from ematerial_format for the e-serial title count
    • Select “e-video” from ematerial_format for the e-visual title count
    • Select “e-audio” from ematerial_format for the e-audio title count
    • Select “e-map” from ematerial_format for the e-map title count
    • Select “e-scores” from ematerial_format for the e-score title count
    • Select “e-databases” from ematerial_format for the e-database title count
    • (Those with “unknow” for ematerial_format will not be counted unless rules are set up for counting them; counts for “e-misc” are also not reported in the trends report)
    • (Note: e-images are counted through Artstor/JSTOR and not FOLIO)
    • (Note: All electronic titles are included in national counts even though some overlap with physical title counts)