Filtering Data to Obtain Specific Counts - Materials counts

VOLUMES HELD

Filter CR214 to:

VOLUMES -- ITEM RECORDS ADDED IN FY23 (added for new materials, or for materials barcoded long after they were sent to the stacks)

Filter CR214 to:

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: 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 CR215 to:

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” 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

Filter CR216 to:

Remove “Serial,” “Serial – Computer file,” and “Serial – [any other bib format present]” from folio_format_type_adc_groups
Note: All microform titles are included in national counts even though some overlap with print title counts
(Pam S. said there is no danger of Joanne’s additional criteria finding accompanying microforms instead of real microforms. That usage was later than microforms.)

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

Filter CR216 to:

Select “Serial,” “Serial – Computer file,” and “Serial – [any other format present]” from folio_format_type_adc_groups
Note: All 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:

Select “e-book” from ematerial_format for the e-books title count (The annual data collection figure also includes an estimate of HathiTrust counts to be included. Contact Linda Miller for more information.)
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

Page tree