This page provides a list of each of the SQL query directories created and maintained by the CUL FOLIO Reporting Team to support CUL staff reporting needs. "Canned" reports are queries that can be used with multiple parameters (e.g., locations, fiscal years, item statuses, etc.) to generate reports that use those different parameters to limit the results set. "Ad Hoc" reports are "one-off" queries written to generate a specific results set without providing different parameters.
| Directory | Description |
|---|---|
| Metadb Canned Report SQL Query Directory | Canned report SQL queries written to run on the Metadb reporting database |
| Metadb Ad Hoc Report SQL Query Directory | Ad Hoc report SQL queries written to run on the Metadb reporting database |
| LDP Canned Report SQL Query Directory | Canned report SQL queries written to run on the LDP reporting database |
| LDP Ad Hoc Report SQL Query Directory | Ad Hoc report SQL queries written to run on the LDP reporting database |
| LDP Archive SQL Query Directory | Archive of canned and ad hoc SQL report queries written to run on the LDP reporting database that are no longer actively used and maintained |