*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
| Index Number | Name | Description | Excel File Download | SQL Query Code |
|---|---|---|---|---|
| CR219 | Olin Library Shelf List Inventory | This query finds shelf list inventory information for Olin Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | CR219_Olin_4th_DD-GV CR219_Olin_5th_H-JF CR219_Olin_6th_JK-PN CR219_Olin_7th_PQ-PZ | CR193 CR219 SQL Query |
| CR219 | Uris Library Shelf List Inventory | This query finds shelf list inventory information for Uris Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | ||
| CR219 | Kroch Asia Collections Shelf List Inventory | This query finds shelf list inventory information for Kroch Asia Collections. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently. | ||
| CR204 | Missing, Lost, Claimed, Returned Items | This query creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination. Sorts in call number order. To view results for a particular library, sort your Excel file on the library_name column. To view results for a particular item status (e.g., Missing, Aged to Lost, Lost and Paid), sort your Excel file on the status_name column. | Missing Lost Claimed Returned Excel Download | CR204 |
...