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

• ADC readme for CR184A
• ADC readme for CR193

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