*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Please note that the Excel file downloads "Excel File Download" columns below are automatically updated every morning by 108: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) Metadb 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.
...
Collection Management Excel Downloads
| Index Number | Name | Description | Excel File Download by Level |
|---|
| SQL Query Code |
|---|
| MCR170 | Item Status in Process | This query finds "In Process" item status books that appear to be fully cataloged and should be checked in the stacks to see if they have arrived at the library without the status being updated (record cleanup). Excludes any items with "In process", "On order", "Cancelled" or "OC" in the call number and excludes those records without a barcode, and e-resource records. | MCR170 Item Status in Process Excel download Report shows Item Status for all libraries. | |
| MCR204 |
| 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. |
Excel file 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. | MCR204 query | |||
| MCR219B | 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. | MCR219B Uris all floors Excel Download CR219_Uris_3B_Q-QA 8 CR219_Uris_2B_QA9-R704 CR219_Uris_B_R705-TA 646 | MCR219B SQL Query |
| 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_all_floors CR219_Olin_3rd_A-DC CR219_Olin_4th_DD-GV CR219_Olin_5th_H-JF CR219_Olin_6th_JK-PN CR219_Olin_7th_PQ-PZ | 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 |