Reporting: LDP-based Reports (UXPROD-1319)

[UXPROD-3083] RA/UM-Circulation with Patron Details Created: 25/May/21  Updated: 07/Dec/21

Status: Open
Project: UX Product
Components: None
Affects versions: None
Fix versions: None
Parent: Reporting: LDP-based Reports

Type: New Feature Priority: TBD
Reporter: Angela Zoss Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: report-cluster, reporting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Relates
relates to REP-197 List of borrowers with items for spec... Open
Epic Link: Reporting: LDP-based Reports
Development Team: Reporting
Report Functional Area(s):
Resource Access, User Management
PO Rank: 0
Rank: Cornell (Full Sum 2021): R1

 Description   

Checkout bibliographic details and details of patron demographics by date and location (not count of patrons, but list of patrons)

This query needs a list of patrons, along with all patron information including patron department, and all information about the checked-out items (loans) including item barcode, title etc. (all item information), item location and "owning" library, and also loan date. The date filter is based on the loan due date (or the check-out date), so include both types of dates as a filter.
A patron may have multiple entries in the result. For Cornell, since we don’t keep patron information on returned items, the report would only get current checkouts that met the due date criteria.

Will likely combine ACRL Circulation report (or loans_items derived table) with Patron List report


Generated at Fri Feb 09 00:29:13 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.