8/8/2022: Please note that all dashboards and automated reports impacted by changes to the data structure after the FY22-FY23 Fiscal Year rollover have been reviewed and updated where needed by the reporting team. Report result datasets are now divided into separate fiscal years.The following reports are automatically updated every morning by 9:00am. The reports include data that was current in the FOLIO system at the end of the previous business day.
These dashboards are restricted to selectors and other authorized staff members. To inquire about access to these dashboards, please submit a request through the Requesting Reporting Help form and specify that you would like access to selector dashboards.
...
Accessing and Using Data Dashboards - Detailed Instructions
Description | Tableau Dashboard | Excel Downloads | SQL Code for Source Query |
|---|---|---|---|
| This |
| dashboard 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. As well, it separately shows funds with $0.00 available balance. |
| It also provides a detailed current date report of funds and teams with expense class information |
| . A fiscal year filter is included. |
| Provides the list of approved invoices along with invoice payment date, vendor name, invoice number, and other details. |
| CR134 SQL query |
| Provides year to year comparisons of details of e-journals usage by title, publisher, and platform. |
| N/A | |||
| Provides counts as well as details of BD/ILL loans from CUL to other universities, and from other universities to CUL. For loans to CUL, title names are available, but no further information about the title is available. Patron group and department names are included when available. | Borrow Direct/Interlibrary Loans Counts and Details |
CR 172 Excel download
CR 174 Excel download
(forthcoming)
CR 171Lists patron purchase requests since 7-1-22. Details include fund code, LC class, subject, title, holdings location, PO line number, receipt date, request date, and amount. Filters include PO line receipt status and PO line payment status. Note: Requester name is not included to protect patron privacy, also it is often not available in the data. | Patron Purchase Requests | ||
| Provides annual cost data for selected publishers/providers, with comparisons of annual changes, and of shares in total material expenditures. Bar graphs as well as tables provide different levels of detail; a forecast view at the end shows projected increases. | Cost by Publisher and Annual Material Expenditures, 2014 - 2023 | N/A | |
| Provides counts of research output (faculty and affiliated staff publications) of all Ivies for 2023, by Big 5 publishers (Elsevier, Springer, Taylor & Francis, Wiley, Sage). Open Access type details are also included. | Ivies' Research Output by Big 5 Publishers, 2023 | N/A | |
| Shows Big 5 publisher/provder costs as a percent of total material expenditures, Cornell research output by top 10 publishers, as well as costs, usage, and research output by all publishers. | N/A |