...
| Index Number | Name | Description | Excel File Download by Level | 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 | 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 SQL Query | |
| 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. | CR219_Kroch_all_floors | |
| CR219 | Olin Uris Kroch Visual | This query finds items with the material type "visual" from owning libraries Olin, Uris, and Kroch Library Asia. | CR219_Olin_Uris_Kroch_Visual | |
| CR219 | Olin DVDs | This query finds DVDs with an owning library name of Olin library | ||
| CR219 | Uris DVDs | This query finds DVDs with an owning library name of Uris library | CR219_Uris_AV | CR219 SQL Query |
| CR219 | Kroch DVDs | This query finds DVDs with an owning library name of Kroch Asia Collections | ||
| 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 |
...