Reporting: LDP-based Reports (UXPROD-1319)

[UXPROD-2529] ES-Association of College and Research Libraries/IPEDS Report Created: 18/Jun/20  Updated: 10/Dec/21

Status: In Progress
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: Angela Zoss
Resolution: Unresolved Votes: 0
Labels: dwreport, multi-query, report-cluster, reporting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Defines
defines REP-29 Association of College and Research L... Closed
is defined by LDPQURY-8 SQL query for ACRL Collections Expend... Closed
is defined by LDPQURY-9 Prototype for ACRL Circulation Closed
is defined by LDPQURY-13 SQL query for ACRL Circulation Closed
is defined by LDPQURY-6 SQL query for ACRL Title Counts In Code Review
is defined by LDPQURY-7 SQL query for ACRL Volume Counts In Code Review
Relates
relates to REP-27 IPEDS reports Closed
relates to REP-245 FOLIO Datasets for LIBPAS Closed
relates to REP-41 Annual E-Resource Counts for ARL, ACR... Closed
relates to REP-94 Annual Statistics for the Council of ... Closed
relates to REP-97 Report based on Reporting Codes 01-08 Closed
Epic Link: Reporting: LDP-based Reports
Development Team: None
Report Functional Area(s):
External Statistics
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R2
Rank: Cornell (Full Sum 2021): R2
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R3
Rank: GBV (MVP Sum 2020): R4
Rank: Lehigh (MVP Summer 2020): R1
Rank: TAMU (MVP Jan 2021): R3
Rank: U of AL (MVP Oct 2020): R2

 Description   

The report requires multiple queries, each of which will go through separate prototype and query development workflows.

This issue will be completed when the queries are completed, documented, and shared. To complete this issue, create a markdown file in the "reports" folder of the GitHub repository to explain how to use multiple queries to fill the requirements of this report.

Note: the circulation component of this report is currently being updated to use LDP derived tables; see:
https://github.com/folio-org/folio-analytics/issues/190

The queries needed for this report include:

  • MM - ACRL Volume Count Query
  • MM - ACRL Title Count Query
  • RA - ACRL Circulation Query
  • RM - ACRL Collection Expenditures Query


 Comments   
Comment by Sharon Beltaine [ 06/Jan/21 ]

Do we need to add a separate ERM query to the multi-query list for this report or will the RM queries cover e-resources?

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