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 |
| AHR103 | 4/27/22 | bd_with_annex | Script is looking for records that have note_type_name 'Bound with item data' and not have item record created for that holding. Then it matches on an item with a matching barcode. If there is a matching item record then it looks at the parent item permanent_location which should be an "annex" location | np55 |
| AHR104 | 4/27/22 | OKU materials by LC Class and year acquired | Finds the last five fiscal years (7/1/16 - 6/30/21) of newly acquired items in OKU (Voyager data). Groups by LC class, bib format, year acquired, number of volumes and total checkouts. | jl41 |
| AHR105 | 08/03/22 | ILR Kneel Collection clean up | Gets the data for certain collection and puts subjects by column. | |
| AHR106 | 6/8/22 | east_asia_lang_subject | This report provides a list of titles for east Asia languages and subjects along with different formats. | np55 |
| AHR107 | 7/29/22 | item_level_details_with_circ_count | This report provides item-level details as well as total circulation counts (Voyager and Folio) for items based on location, LC class, LC class number, or title filter. | jl41, vp25 |
| AHR108 | 7/29/22 | summary_circ_counts_with_subject_level_details | This report finds the summary of the number of volumes, the primary subject heading, pub date, year acquired and total circulation counts (Voyager and Folio) for all titles based on an LC class and/or location filter. | jl41, vp25 |
| AHR109 | 7/29/22 | mann_bee_collection_by_century | This query finds all items in two specific call number ranges related to the study of bees, located in Mann Library (all locations), Mann Annex or Geneva. It shows the century of publication. (Specialized ad-hoc report, created for a collection analysis project.) | jl41, vp25 |
| AHR110 | 7/29/22 | mann_bee_collection_group_and_sum | This query first finds all Mann Bee Collection items (see AHR109 for detailed description), then groups them by various fields (LC Class, Class Number, primary subject heading, century of publication, language, etc.) and counts the number of items in each group. | jl41, vp25 |
| AHR111 | 7/29/22 | voyager_purchases_by_fund_code | This query finds all Voyager purchases by fund code, order type and fiscal year. | jl41, vp25 |
| AHR112 | 12/16/22 | patron_purchase_requests_Folio | This report was created specifically for collection development needs and includes the following fields: requestor netid or other requestor information (where available), fiscal year of payment, title, instance hrid, subject, fund code, days until fulfilled, and total circ count in Folio. | jl41, vp25 |
| AHR113 | 12/16/22 | patron_purchase_requests_Voyager | This report was created specifically for collection development needs and includes the following fields: requestor netid or other requestor information (where available), fiscal year of payment, title, instance hrid, subject, fund code, days until fulfilled, and total circ count in Voyager. | jl41, vp25 |
| AHR114 | 1/6/23 | microforms_counts_details | This query was developed for the 2023 Olin Basement move project, and includes details of microform bibliographic information to help selectors make decisions about moving or de-accessioning the materials. | jl41 |
| AHR115 | 2/28/23 | olin_microforms_with_circ_counts | This is the second of three queries developed for the 2023 Olin Basement move project, and includes details of Olin and Kroch microforms, including bibliographic information and Voyager and Folio circ counts, to help selectors make decisions about moving or de-accessioning the materials. | jl41 |
| AHR116 | 2/28/23 | olin_microforms_with_circs_and_srs_marctab_fields | This is the third of three queries developed for the 2023 Olin Basement move project, and includes details of microform bibliographic information, srs marctab fields, and circ counts to help selectors make decisions about moving or de-accessioning the materials. | jl41 |