-
Notifications
You must be signed in to change notification settings - Fork 7
Home
Jeremy Goldstein edited this page Aug 2, 2019
·
112 revisions
This is my attempt to organize my various queries, updated as time allows.
- Bad Item Barcodes
- Bad Price Fields
- Bibs With Duplicate Non-Repeating Fields
- Bibs With Paid Orders and no items at a library
- Course Reserves Items Off Reserve
- Duplicate Axis 360 Records
- Duplicate Bib Records (By Index)
- Duplicate Patron Records (by Name and bdate)
- Holds on Unavailable Titles
- Items Attached to Multiple Bibs
- Items Without Parents
- Itype Mattype Mismatches
- Old Order Records
- On the Fly Records
- Online Patron Conversion Errors
- Orders On Hold
- Order Records Outside of Scopes (Downloaded Without Grid)
- Patron Records with data entry errors
- Patrons with duplicate Online Renewal Charges
- Too Many Renewals
- Unused iTypes
- unused pTypes
- Volume Fields That Should Not Be Used
- Average Age of Collection By Scat
- Bibs with duplicate copies
- Collection Development by Language
- Collection Development by SCAT
- Cost Per Circ
-
Item / Order Collection Development
NOTE put results of two reports together by mattype columns - Collection Development Item report with Relative totals (total circ version)
- Collection Development Item report with Relative Totals (YTD circ version)
- High Utilization - Not Owned
- High Utilization - Owned
- Item Count By Location and Language
- Periodical circulation counts by title
- Purchase Alert With Orders
- Purchase Alert without Local Holds
- Network-wide Stats Query On Review File
- Top Requests List
- Underutilized Items
- Annual Items Added Summary
- ARIS Holdings by IType
- ARIS Holdings by Mat Type, Loc and IType
- Holdings By Status
- Holdings Loc by IType
- Items Added Loc By IType
- Magazine Count for ARIS
- Magazine Count by Checkin
- Magazine Count by Item
- Patron Count By Barcode Prefix
- Patron Count By PType
- Amount Spent Per Scat
- ARIS Holdings By IType
- ARIS Holdings By MatType
- Average Age by Last_checkout_date
- Average Patron
- Average Time to Pay Fine
- Bibs In a Subject With X Copies
- Bibs With Items Only Using 1 IType
- Blocked patron stats
- Call # Browse / Shelf List
- Check digit function
- Checkin Box Export
- Collection Value By Location and IType
- Comcat NCIP records
- Count Scat Usage
- Current SQL activity
- Fine ranges
- Fund Summary
- Invoice Summary
- Item Status Count
- Items In Transit Snapshot
- Last Issue Received
- Loan Rule Snapshot
- Loan Rule Snapshot with blocked patron stats
- Loan Rule Snapshot by Checkout
- Loan Rule Snapshot by Fine
- Mass Market Paperbacks
- Patron Count At a Location
- Patron Count By PType
- Patron Count By Barcode Prefix
- Patron Count By Zipcode
- Patrons created by hour
- Payments Against a Fund
- Random Sampling of Records
- Recent Circ Transactions By PNumber
- Record Counts
- Record Ranges
- Returning Patron Checkouts
- Review File to Booklist
- Shelf List
- Time On Holdshelf
- Transit snapshot
- Unique Patron Checkouts
- Users with SierraWeb option enabled
- User Permissions
- Value Calculator
- View Outstanding Holds
- World Language Print Ownership
-
NOTE Script developed by Gem Stone Logan and presented at 2017 IUG conference