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