Reporting: LDP-based Reports
(UXPROD-1319)
|
|
| Status: | Closed |
| Project: | UX Product |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None | Parent: | Reporting: LDP-based Reports |
| Type: | New Feature | Priority: | TBD |
| Reporter: | Sharon Beltaine | Assignee: | Angela Zoss |
| Resolution: | Done | Votes: | 0 |
| Labels: | po-mvp, report-cluster, reporting, team-mvp | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Issue links: |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Epic Link: | Reporting: LDP-based Reports | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Back End Estimate: | XXL < 30 days | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Development Team: | Reporting | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Report Functional Area(s): |
Resource Access
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: Chalmers (Impl Aut 2019): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: Chicago (MVP Sum 2020): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: Cornell (Full Sum 2021): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: Duke (Full Sum 2021): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: 5Colleges (Full Jul 2021): | R4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: FLO (MVP Sum 2020): | R2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: GBV (MVP Sum 2020): | R4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: Lehigh (MVP Summer 2020): | R2 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: MO State (MVP June 2020): | R4 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: TAMU (MVP Jan 2021): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Rank: U of AL (MVP Oct 2020): | R1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description |
|
This is a very general cluster that includes a variety of related reports on collections use. The queries most likely to be helpful for these reports are:
Note: we still cannot effectively report on specific dates of renewals.
|
| Comments |
| Comment by Angela Zoss [ 22/Aug/19 ] |
|
Data elements required across reports: |
| Comment by Angela Zoss [ 16/Sep/19 ] |
|
Compare to existing query for Circulation Item Detail: |
| Comment by Cheryl Malmborg [ 27/Sep/19 ] |
|
It looks like almost all the elements mentioned in these reports are covered in circ item detail (or are in the comment as not included).
|
| Comment by Erin Nettifee [ 13/Jan/20 ] |
|
Is there a report about in-house usage captured? If so, it should be part of this cluster. |
| Comment by Angela Zoss [ 24/Jan/20 ] |
|
Hi Erin Nettifee - you mention in-house usage here. Is that captured in FOLIO? Where would that be? |
| Comment by Erin Nettifee [ 24/Jan/20 ] |
|
It's in development - https://folio-org.atlassian.net/browse/UXPROD-81 - Emma is the PO. |
| Comment by Angela Zoss [ 24/Jan/20 ] |
|
|
| Comment by Marie Widigson [ 16/Dec/20 ] |
|
Not sure we understand our previous R5-ranking, changing it to R1 (even if we are currently using EBSCO Analytics for this purpose). |
| Comment by Angela Zoss [ 01/Feb/21 ] |
|
Development completed as part of milestone 1.0 of the LDP. https://github.com/folio-org/folio-analytics/tree/main/sql/report_queries/loans_and_renewals_counts |
| Comment by Angela Zoss [ 16/Feb/21 ] |
|
Note: renewal date blocker has potential workaround with loan history table. Could create a derived table to unpack loan history, then query to get renewals with dates. |