For information about standards for contributing report queries to the CUL FOLIO Canned Reports Directory, please
refer to the CUL FOLIO Report Development Standards.
Click the link below to go to the reports list you wish to view.
Filter Directory (In Progress)
For a list of parameters (options to use as a filter), see the Filter Directory. Options for filtering your report results are typically entered in the WITH statement at the top of the query. For example, to get report results associated with a specific location, such as items stored at Olin Library, you would enter "Olin" as the location parameter option in the WITH statement. This would limit your results set to items in Olin Library.
| Table of Contents |
|---|
All Reports
...
All Reports
...
~Time to run
...
shows a list of items that patrons claim they have returned, but are not showing as checked in by the system (where the item status is 'claimed returned').
...
missing_items
...
item count
*WARNING: long-running query!
...
provides a summary of item and piece counts for non-electronic resources cataloged in the Inventory, by various filters
...
10/12/21
...
9/13/21
...
Provides the list of all active funds along with their ledger, fund group and fund type. It also provides allocations, transfers, encumbrances, expenditures, fund balance and percentage spent for each fund.
...
9/22/21
...
lost_paid_returned
NOTE: under review; contact jl41 or vp25
...
vp25
jl41
...
8/20/21
...
vp25
jl41
...
...
jl41, vp25
...
9/24/21
...
Shows all holdings in a specified location along with holdings for the same titles in other libraries.
NOTE: Results are tricky to interpret; please contact jl41 or vp25
...
3/21/22
...
This query provides the list of approved invoices within a date range along with vendor name, finance group name, vendor invoice number, fund details, purchase order details, language, instance subject, and bibliographic format.
...
11/5/21
...
10/4/21
...
This query searches for duplicate invoices within 360 days with $1,000+ total amount of the invoice accordingly.
...
orders_split_funds
NOTE: UNDER REVIEW
...
hathitrust_serial_holdings
Note: long-running query, results post to local schema
...
hathitrust_monograph_holdings
Note: long-running query, results post to local schema
...
hathitrust_multivolume_holdings
Note: long-running query, results post to local schema
...
CR144 - BY REQUEST - please use the Request Form to get this report
-update to CR144_A
...
volume_count_held_stats
Note: long-running query, results post to local schema
...
This report shows items where the item status is 'Missing'. It is different from CR106 in that it includes parameters for filtering results by the last 2 weeks, the last 6 months, the last year, the last 2 years, and a freeform start date and end date.
...
slm5,
vp25,
jl41
...
Reserve statistics for a given semester, for both e-reserve and print reserve. Requires separate queries to pull out data from Ares, which is then imported into the LDP.
NOTE: This query is for Fall 2021, and needs to be updated for Spring 2022, as it needs fresh ARES data for each semester.
...
Historical_charges_from_Voyager
...
Checkouts of the last month by library, patron group, and material type.
...
Compilation of requests grouped by date, owning library, location, type of requests, status of requests, pickup point, type of service point, patron group name, and material type.
...
Access Services Reports
...
shows a list of items that patrons claim they have returned, but are not showing as checked in by the system (where the item status is 'claimed returned').
...
missing_items
...
provides a summary of item and piece counts for non-electronic resources cataloged in the Inventory, by various filters
...
lost_paid_returned
NOTE: under review; contact jl41 or vp25
...
...
jl41, vp25
...
Reserve statistics for a given semester, for both e-reserve and print reserve. Requires separate queries to pull out data from Ares, which is then imported into the LDP.
NOTE: This query cannot be run unless data from ARES are imported into the LDP.
...
Historical_charges_from_Voyager
...
Checkouts of the last month by library, patron group, and material type.
...
Compilation of requests grouped by date, owning library, location, type of requests, status of requests, pickup point, type of service point, patron group name, and material type.
...
Accounting Reports
...
10/12/21
...
9/13/21
...
9/22/21
...
8/20/21
...
9/9/21
...
10/26/2021
...
10/4/21
...
10/4/21
...
Acquisitions Reports
...
CUL Report Code
and Link to Query
...
9/22/21
...
Annual Statistics Reports
Documentation (in progress) on how these reports are being used for the CUL annual data collection and for national reporting is available on the FOLIO Annual Statistics Documentation page.
...
CUL Report Code
and Link to Query
...
volume_count_stats
Note: long-running query, results post to local schema
...
newly created and total existing volume count statistics for Cornell annual statistics reports by unit and on campus versus the annex
...
np55
...
title_count_non-micr-physical_adc_stats
Note: some results post to local schema
...
title_count_micro_adc_stats
Note: some results post to local schema
...
title_count_servremo_adc_stats
Note: some results post to local schema
...
Cataloging Reports
...
provides a summary of item and piece counts for non-electronic resources cataloged in the Inventory, by various filters
...
Collection Development Reports
...
9/13/21
...
9/22/21
...
8/20/21
...
9/9/21
...
9/24/21
...
This report checks existing instances created within the last 5 days for duplicate records in the system. It shows duplicate records with date created for new duplicates along with local identifiers (899 and 773 MARC fields). It shows both valid and invalid ISBNs.
...
3/21/22
...
This query provides the list of approved invoices within a date range along with vendor name, finance group name, vendor invoice number, fund details, purchase order details, language, instance subject, and bibliographic format.
...
orders_split_funds
NOTE: UNDER REVIEW
...
HathiTrust
...
HathiTrust Reports
...
hathitrust_serial_holdings
Note: long-running query, results post to local schema
...
hathitrust_monograph_holdings
Note: long-running query, results post to local schema
...
hathitrust_multivolume_holdings
Note: long-running query, results post to local schema
...