About the Data
Please note that the Excel file downloads "Excel File Download" columns below are automatically updated every morning by 10:00am. The data shown was current in the FOLIO system at the end of the previous business day (yesterday's data).
All Cornell Library staff who have approval to access to the Library Data Platform (LDP) reporting database have access to view this data. If you have questions about this data, please submit a request through the Requesting Reporting Help form.
Documentation
- Filtering and Sorting Data in Excel Downloads - Detailed Instructions
- TD = Tableau Dashboard, CR = Canned Report, AHR = Ad Hoc Report
Collection Management Excel Downloads
| 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 |