This is a list of ad hoc reports used to retrieve data from the CUL FOLIO LDP reporting database system. Ad hoc reports are different from canned reports in that they are specialized, "one-off" reports. These reports are typically designed for specific units, purposes, etc.
All Ad-Hoc Reports | ||||
CUL Report Code and Link to Query | Last Updated | Report Name | Description | Setup |
---|---|---|---|---|
AHR100 | 12/15/21 | New and Noteworthy | This reports lists all 'New and Noteworthy' books (where the call number prefix ='New and Noteworthy'. NOTE: There are no filters for this report, dates are hard-coded. Adjust loan_date at end of query in order to run this query correctly. | jl41, vp25 |
AHR101 | 12/15/21 | Nestle Inventory | List all inventory in Nestle that is non-book, such as laptops, equipment, etc. NOTE: This query can be adjusted for other libraries. There are no filters. Adjust library name at end of query. | jl41, vp25 |
AHR102 | 12/17/21 | Collection growth over time | This query finds a specified collection (in this case, the QC and QD collection) and the record created date for all the items in the collection, so that the collection in that range can be analyzed. NOTE: The record created date is only available from the historical voyager records, and this field has to brought in as a local table and then matched to the Folio records. | jl41, vp25 |