Versions Compared

Old Version 4

changes.mady.by.user Nassib Nassar

Saved on

compared with

New Version 5

changes.mady.by.user Sharon Markus

Saved on

Key

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

Date

Attendees


Present?

Name

Organization

Present?

Name

Organization


Sharon BeltaineCornell University
Sara ColglazierMount Holyoke College/Five Colleges

Elizabeth BerneyDuke University
Erin NettifeeDuke University

Joyce ChapmanDuke University
Karen NewberyDuke University

Jean PajerekCornell University
Tod OlsonUniversity of Chicago

Claudius Herkt-JanuschekSUB Hamburg
Scott PerryUniversity of Chicago


Doreen HeroldLehigh University
Stefan StadtherrMPIL Heidelberg

Sarah ParkDuke University
Simona TabacaruTexas A&M

Clint BellangerAuburn University
Kevin WalkerThe University of Alabama

Ingolf Kusshbz
Christie ThomasUniversity of Chicago

Joshua LambertMissouri State

Andi Bihler

Munich Technical University Library

Joanne LearyCornell University
Cheryl MalmborgUniversity of Chicago

Michael PatrickThe University of Alabama
Vandana ShahCornell University

Nassib NassarIndex Data
Angela Zoss

Duke University


Veit KöppenUniversity Magdeburg
Lisa DeCarolisSmith College/Five Colleges

Linda MillerCornell University
Elena O'Malley

Emerson


Matt HarringtonDuke University     Holly MistlebauerCornell University

Cathy TuohyEmmanuel College (FLO)
Nancy BolducCornell University

Shirley MoentnishMissouri State
Eric PenningtonTexas A&M

Stefan DombekLeipzig University
Axel DoerrerUniversity Mainz

Natalya PikulikCornell University
Owen StephensK-Int

Eliana LimaFenway Library Organization
Marcia BorensztajnEBSCO

Harry KaplanianEBSCO
Molly DriscollEBSCO

Amelia SuttonU. Massachusetts
Heather LoehrHanover College

Mary MorganGrand Valley State University
Jennifer EusticeU. Massachusetts Amherst / Five College

...

Item

Who

Notes

Attendance & NotesSharon

Attendance & Notes

  • Today's attendance-taker: Linda Miller
  • Today's note-takers:  Team Leads for project updates
Review Results of Reporting Clusters JIRA Issue Ranking ConversionUpdate from Tod on Jira ranking conversionsTod?

Please note that JIRA rankings for UXPROD and REP issues were converted by Holly to the new ranking system R1 (urgent) to R5 (not needed).

  • Update from Tod on JIRA ranking conversions?
  • See Ranking JIRA Issues page in wiki for recent updates
  • Reminder: As of 2020, the Reporting SIG is only ranking reporting cluster issues, such as "UXPROD-2029 RA-Requests Cluster." You can find report clusters by using the label  "report-cluster" in your JIRA search.
  • Individual report requirements are captured in JIRA issues that start with "REP," such as "REP-275 Curbside Pickup Report." 


Abbreviation List

Tod Olson


Tod et al. will draft a proposed list of standard abbreviations for naming

https://docs.google.com/document/d/16gIDaslANA93u6AiPbigmge82Rl1SL8H3qRBah0R0OY/edit?usp=sharing
Updates from Various Reporting Related Groups and EffortsCommunity & Coordination, Reporting Subgroup Leads

Project updates

The Reporting SIG is using small working groups to address priorities and complete our work.  Each week, we will provide updates to the Reporting SIG from these various reporting-related groups and efforts. Please include updates on specific JIRA issues for prototype or query development workflow.


Additional JIRA tickets for Angela to create for prototypes or queries

  • ?

Community & Coordination: 

  • reporting survey entries are complete!
  • Aliasing for reports


Questions

  • Should we remove WITH clauses in our derived table queries?


FOLIO Reporting development

RA/UM Working Group

  • RA/UM derived table demo
  • rows 25, 28, 29 shown so far

MM Working Group

  • MM derived table demo
  • changing queries to remove the WITH and to use CROSS JOIN
  • demo of holdings_electronic_access_v2 (in progress)

ERM Working Group

  • identifying derived tables in agreements and knowledge base
  • Khalilah Gambrel will attend the next ERM meeting to find out how eHoldings data can be loaded in LDP
  • verifying the latest reports ranking (rank renaming) to match with the current development roadmap
  • for latest updates, see ERM Prototype and Query Development Status

RM Working Group

  • RM Derived Table demos
    • rows 11, 21 shown so far
    • demo of local.invoice_lines_fund_distributions, needs to be updated for the new way to extract json arrays
    • WITH allows you to create a subquery (intermediate table "funds_distr" is created); locally-scoped table that exists for 

External Statistics Working Group


Topics for Future MeetingsAll

Review and update Topics for Future Reporting SIG Meetings 


...