*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Annex_items_with_nonCirculating_loan_types
...
This query creates a list of items at the Annex that have a "non-circulating" permanent loan type, excluding rare and special collections. It also finds items with an hourly loan type.
...
patron_requests_by_type_and_status
...
services_usage
...
daily_approved_invoice_exported
...
daily_appr_inv_vendor
...
payable_inv_not_fed_notes
...
borrow_direct_interlibrary_loan_recalls
...
This query finds books that are on loan to BD and ILL, were recalled and are now overdue...
Borrow_direct_interlibrary_loan_overdue_items...
yesterday_YTD_acct_bal_by_ledger_univ_acct
...
current_YTD_acct_bal_by_ledger_univ_acct
...
approved_invoices_bib_data
...
sum_appr_inv_ledger_scct
...
lost_bursared_returned
...
Physical and E-reserve statistics
...
funds_and_teams_with_expense_class
...
funds_and_teams
...
item_status_in_process
...
BD_ILL_loans_to_Cornell_patrons
...
ILL_BD_items_lent_to_others
...
ILL_BD_counts_loaned_to_others
...
BD/ILL loans and renewals counts of items loaned BY CUL to others (CUL is LENDER)...
ILL_BD_counts_borrowed_by_CUL
...
ILL and BD counts of items where CUL is the BORROWER...
split_funds
...
annex_items_to_be_accessioned
...
circ_counts_by_instanceHRID_for_Voyager_and_Folio
...
laptop_circ_counts
...
This query counts laptop circs and renewals by library, date, loan type, and laptop type (Mac or PC). Also
counts how many laptops were used on any given day....
loans_and_renewals
...
orig_locs_for_phys_collections_no_library_charges
...
This query finds ceased or cancelled titles at the holdings level for a specified owning library and LC class, and shows if there are holdings at the Annex. Results will include any title (of any holdings type) that has a holdings receipt status or holdings note that indicates the title is no longer received or is ceased or cancelled.
...
This query finds ceased or cancelled titles at the item level, for a specified owning library and LC class, and shows if there are holdings at the Annex. Results will include any title (of any holdings type) that has a holdings receipt status or holdings note that indicates the title is no longer received or is ceased or cancelled.
...
This query finds expired patrons with open fines. This query references the CIT file of patrons, Please check which schema this file resides in and make changes as needed to the schema name.
...
This query extracts holdings administrative note data to allow counts of physical items withdrawn by location AND to allow the identification of transfers that go from endowed to contract units, and vice-versa. These counts are used for volumes withdrawn figures needed by the Division of Financial Services each quarter.
...
This query provides item counts of physical materials, by format type. It excludes microforms (counted separately).
...
This query provides counts of unique titles (instances) of physical items, by format type. It excludes microforms (counted separately).
...
This query provides counts of microform titles, by format type.
...
This query provides counts of ematerials, by format type. Formats are taken from 948 field, and if missing then taken from the stat code, and if both these fields are missing, formats are taken from the MARC format code. Titles with multiple codes are assinged based on the priority listed in the CASE clause.
...
This query finds the the most recent checkouts and browses by date range, location and LC class (total checkouts and most recent checkout in Voyager and in Folio)....
Collection Management
...
This query finds shelf list inventory information by library location. The full MCR219A version has more data fields than the brief MCR219B version, which is used for manual shelf list inventory work.
...
This query finds shelf list inventory information by library location. The full MCR219A version has more data fields than the brief MCR219B version, which is used for manual shelf list inventory work.
...
Voyager and Folio circ counts with parameters
...
This query finds total Voyager and Folio circ usage for given parameters: LC class, library, title, instance hrid and/or language.
...
metadb_key_counts
...
This query counts instances, holdings, items, loans, srs marctab instances, srs marctab records with "001" fields, srs marctab records with "999" fields that include "i" subfields, and srs record instances on the Metadb database.
...
approvals_and_firm_orders
...
This query finds all orders (not just approvals) showing the "bill to" and "ship to" locations in the purchase order or invoice.
...
purchase_requests_with_days_elapsed_till_checkout ...
This query finds the number of days between when a firm-ordered (one-time) fully-received item was ordered (item record created), then received at LTS, then received at the unit library and then first checked out (Folio only). If item was not discharged at the unit library upon receipt, or item did not have an "In process" status prior to discharge, time elapsed will show null. Includes bibliographic info, order info and fund information and can be limited to just requested purchases.
...
funds_for_stewardship
...
This query was modified from CR134 to accommodate alumni affairs needs for information on stewarded funds. It provides the list of approved invoices within a date range along with primary contributor name, publisher name, publication date, publication place, vendor name, LC classification, LC class, LC class number,
finance group name, vendor invoice number, fund details, purchase order details, language, instance subject, fund type, and expense class.
...
inventory_by_call_number_range
...
This query gets the holdings-level inventory for a library/location/call number range and shows item count and circ count since 2015.
...
collection_inventory_by_date_range
...
This query finds all items in a given location or library, and shows all charges and browses within the specified date range. It Shows all record component locations, which is helpful for record cleanup.
...
lts_receiving
...
TS Acquisition Statistic Dashboard, LTS Receiving Story
This report gets serials received by LTS personal, on which day it was received, with bill_to location "Law Technical Services not included",
item format as "Physical, receiving status as "received", po_number, po_number prefix, order_format, ship_to location
...
inst_updated_date
...
This query pulls the updated_by_userid and the updated_date field data from the inventory instance record JSONB data array. This data is then joined to the MARC 245/a field to get the instance title and instance HRID.
...
adc_location_translation_table
...
CR233 and MCR233 is used to help update the lm_adc_location_translation_table. It pulls location code, location name, and shelving location names data from FOLIO’s inventory_locations and inventory_libraries tables, and corresponding data from the lm_adc_location_translation table. In Excel, one can then ensure the translation table data matches that from the FOLIO tables, and that no fields are blank.
...
get_instance_records
...
This report uses metadb function and gets MARC record field content for a particular subfield. After function is created it can be called by using provided call statement example at the end of the report.
...
metadb_key_created_counts_date_series
...
This query counts holdings, instances, items, and srs_records, then displays each set of counts in a date series.
...
calendar_settings_by_service_point_and_semester
...
This query displays the calendar settings for a given service point and semester. Service points using a "Universal" calendar.
...
clean_up_100e
...
This report gets 100 field subfiled "e" value to check for the wrongly entered entries of the subfield.
...
loan_policies_used_in_laptop_charges
...
This query can be used for the annual data collection to see which loan policy types units used for laptop charges, how frequently.
...
create_circ_snapshot
...
Creates the initial snapshot of loans, capturing patron demographics for each circ tranasaction
...
update_circ_snapshot
...
This query creates the "insert into" portion of the circ_snapshot4 query. Updates the file created by MCR403.
...
items_with_content_by_MARC_field
...
hathitrust_903_mappings
...
This query creates a table of mapping for instances with 903 values and publishes it to the local_digpres schema. It is automated to run daily at 5am.
...
Fine_Arts_ser_curr_rec_NAAB
...
This query estimates the number of physical serial titles currently received in the Mui Ho Fine Arts Library. It used two queries that search via purchase order and via holding records notes, combines instance HRIDs, and then dedupes. Used in fall of 2024 for NAAB reporting.
...
previous_day_appr_vouchers
...
This dashboard query creates a list of vouchers approved the previous day. Used in FBO Daily Reports dashboard
...