*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Sharon Helen Markus, last updated on Jul 29, 2024
1 minute read
Canned report SQL queries written to run on the Metadb reporting database
All Reports
All Reports | ||||||
| Report Code and Link to Query | Functional Area | Priority | Last Updated or Target Date | Report Name | Description | Assignment |
|---|---|---|---|---|---|---|
| MCR101 | Collection Development | Medium | fund_expenditures_by_po_line_invoice_payments | shows fund expenditures by purchase order line within a given invoice payment date range | slm5 | |
| MCR106 | Access Services | High | missing_or_lost_items | creates a list of missing or lost items at a given library | jl41 | |
| MCR107 | Access Services | High | 6/24/24 | patron_requests_by_type_and_status | list of patron requests within a specified date range by request type and status | jl41 |