For more detailed information about using these queries for the annual data collection see:


CIRCULATION CHARGES AND RENEWALS

Filter CR184A to:
•    Pick fiscal year wanted
•    Exclude “SPEC (Library Dept Card)” from patron_group_name
•    Exclude “BD*” and “ILL*” from collection_type

Note: FOLIO figures exclude any manual charges reported. Contact A&P.


ILL AND BD CHARGES AND RENEWALS OF CUL MATERIALS LOANED TO OTHER INSTITUTIONS

Filter CR184A to:

  • Limit patron_group_name to ‘Borrow Direct’ and/or ‘Interlibrary Loan’
  • Shouldn’t have to limit collection_type to ‘regular’
  • Shouldn’t have to remove ‘BD MATERIAL’ AND ‘ILL MATERIAL’ from material_type_name


LIBRARY TO LIBRARY DELIVERY

Filter CR193 to:
•    Pick fiscal year wanted
•    Select only “Page” from request_type
•    Exclude “SPEC (Library Dept Card)” from patron_group_name


CONTACTLESS PICKUP

Filter CR193 to:
•    Pick fiscal year wanted
•    Select only “Contactless pickup” from pickup_type
•    Exclude “SPEC (Library Dept Card)” from patron_group_name



  • No labels