Versions Compared

Old Version 24

changes.mady.by.user Vandana Suresh Shah

Saved on

compared with

New Version 25

changes.mady.by.user Vandana Suresh Shah

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Collection Development                                                                                                                                                                                                                                  





CUL Report Code
and Link to Query		Last
Updated		Report NameDescription~Time to runRelated JIRA
REP Issues		Setup





CR101 11/29/21fund_expenditures_by_po_line_invoice_paymentsshows fund expenditures by purchase order line within a given invoice payment date range. For each purchase order line number, the fund data attributes are shown alongside the purchase order line transaction amount.
REP-157, REP-285slm5





CR122

9/13/21

fund_detailprovides fund details summary for active funds
REP-98nb299





CR123

9/22/21 

open_ordersprovides a list of open purchase orders and their encumbrance and/or amount paid, broken down by purchase order lines
REP-283nb299





CR125

8/20/21 

appr_invoices_vendor_fundsProvides the list of approved invoices within a date range along with vendor name, invoice number, fund group and fund used.
REP-82nb299





CR130

9/9/21 

fund_expenditures_by_po_lineShows fund expenditures by purchase order line. Fund data attributes such as fund group, fund type, fund code, transaction type, and transaction type are provided.
REP-157, REP-285slm5





CR131

9/24/21 

duplicate instances on ISBNs

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.


REP-281np55





CR134

3/21/22

appr_invoices_bib_data

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.


REP-39, REP-83, REP-287nb299





CR13811/5/21

orders_split_funds


This query provides the list of split funds purchases for a purchase order line that has multiple funds used along with the transaction amount for each fund and the percentage spent.
REP-98nb299





AHR10302/02/2022bd_with_annexThis query searches for holdings note type 'Bound with item data' and related item records matched on BC.

np55





CR15703/08/22Funds_and_teams_with_expense_classProvides a detailed current date report of funds and teams with amounts spent, encumbered, and remaining. It also shows the expense class.
Newjl41, vp25





CR16503/08/22funds_and_teamsProvides a current date report of funds and teams with amounts spent, encumbered, and remaining. This report does not include expense class (see CR157).
Newjl41, vp25





CR1715/23/22BD_ILL_selectors_report -Part 1Lists title, patron group and department (where available) for items borrowed by CUL patrons from other universities on Borrow Direct and Interlibrary Loan. Parameters for loan date range included. a few secondsREP-156jl41





CR1725/24/22BD_ILL_selectors_report - Part 2Lists item details for items borrowed from CUL by other universities' patrons on Borrow Direct and Interlibrary Loan. Parameters for loan date range included. a few secondsREP-156jl41, vp25





CR1735/24/22Patron_purchase_requestsLists patron requests to purchase items, including requestor netid or other requestor information (where available) and item details including location name (from PO lines), fund name, fund code, and total circulation  count (all currently only for data in Folio). a few secondsNEWjl41, vp25


















...