*** 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 by Linda Rae Habetler Miller on Oct 02, 2024
2 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 |
|---|---|---|---|---|---|---|
| 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 |
| MCR184 | Access Services | High | 6/24/24 | loans_and_renewals | Loans and Renewals by fiscal year. This query uses the loans_renewal_dates from local_shared. Change to folio_derived once the derived table is fixed. | jl41 |
| MCR184B | Annual Data Collection | High | 9/12/24 | orig_locs_for_phys_collections_no_library_charges | For counts in MCR184 with locations as "removed locations" or "no library," use this report to see what the locations now retired originally were. | lm15, jl41 |
| MCR193 | Access Services | High | 5/8/24 | filled_delivery_requests | This query provides a count of all contactless delivery and circulation desk pickup requests, by fiscal year. Patron group, material type, request type, and location details are included. | jl41 |
| MCR222 | Troubleshooting | 8/29/24 | metadb_key_counts | This query counts instances, holdings, items, loans, srs marctab instances, srs marctab records with "001" fields, srs marctab records with "999" fields that include "i" subfields, and srs record instances on the Metadb database. | slm5, jl41 | |
| 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 | |