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 |
| MCR132 | Accounting | High | 8/12/24 | ytd_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. This is an accounting report used for monthly reconciliation. | slm5, ama8 |
| MCR243 | Troubleshooting | 8/27/24 | metadb_key_created_counts_date_series | This query counts holdings, instances, items, and srs_records, then displays each set of counts in a date series. | slm5 | |