Canned report SQL queries written to run on the Metadb reporting database
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 |