2020-10-26 Reporting SIG Meeting notes

Date

26 Oct 2020

Attendees

Present?	Name	Organization	Present?	Name	Organization
X	Sharon Beltaine	Cornell University		Sara Colglazier	Mount Holyoke College/Five Colleges
	Elizabeth Berney	Duke University		Erin Nettifee	Duke University
	Joyce Chapman	Duke University		Karen Newbery	Duke University
X	Jean Pajerek	Cornell University	X	Tod Olson	University of Chicago
X	Claudius Herkt-Januschek	SUB Hamburg		Scott Perry	University of Chicago
	Doreen Herold	Lehigh University		Stefan Stadtherr	MPIL Heidelberg
X	Sarah Park	Duke University	X	Simona Tabacaru	Texas A&M
	Clint Bellanger	Auburn University		Kevin Walker	The University of Alabama
X	Ingolf Kuss	hbz		Christie Thomas	University of Chicago
X	Joshua Lambert	Missouri State		Andi Bihler	Munich Technical University Library
	Joanne Leary	Cornell University		Cheryl Malmborg	University of Chicago
	Michael Patrick	The University of Alabama	X	Vandana Shah	Cornell University
X	Nassib Nassar	Index Data	X	Angela Zoss	Duke University
	Veit Köppen	University Magdeburg		Lisa DeCarolis	Smith College/Five Colleges
X	Linda Miller	Cornell University	X	Elena O'Malley	Emerson
	Matt Harrington	Duke University		Holly Mistlebauer	Cornell University
	Cathy Tuohy	Emmanuel College (FLO)	X	Nancy Bolduc	Cornell University
	Shirley Moentnish	Missouri State	X	Eric Pennington	Texas A&M
	Stefan Dombek	Leipzig University	X	Axel Doerrer	University Mainz
X	Natalya Pikulik	Cornell University		Owen Stephens	K-Int
X	Eliana Lima	Fenway Library Organization		Marcia Borensztajn	EBSCO
	Harry Kaplanian	EBSCO	X	Molly Driscoll	EBSCO
X	Amelia Sutton	U. Massachusetts		Heather Loehr	Hanover College
	Mary Morgan	Grand Valley State University	X	Jennifer Eustice	U. Massachusetts Amherst / Five College

Discussion Items

Item	Who	Notes
Attendance & Notes	Sharon	Attendance & Notes Today's attendance-taker: Linda Miller Today's note-takers: Team Leads for project updates
External data	Nassib	Request for specific use cases from the community on integrating non-FOLIO data with FOLIO data
Updates from Various Reporting Related Groups and Efforts	Community & 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: no meeting this past week FOLIO Reporting development Track progress via recent pull requests: https://github.com/folio-org/folio-analytics/pulls?q=is%3Apr+is%3Aclosed RA/UM Working Group Strong need for additional sql developers for this area Current status of RA/UM clusters: https://drive.google.com/file/d/1yQkPb7ORop5dzrdtSnU68c8YXu-jFSMN/view?usp=sharing Working on fees/fines derived tables MM Working Group ? ERM Working Group Outline of approach on harvest eHoldings data for ERM reports To create a prototype test data is needed which point to eHoldings resources → Sharon volunteered to ask Cornell RM Working Group rewriting queries to point to new derived tables RM-Title Count Cluster RM- Item Count Cluster → Example on GitHub RM- Costs Cluster derived tables purchase order materials type: po_lines_phys_mat_type po_lines_er_mat_type NOTE: material type on the PO has not been developed in the orders app yet, so this derived table takes material type from the inventory_material_types table po_purchase_orders_acq_unit_ids External Statistics Working Group Recategorize External Statistics REP Issues
Topics for Future Meetings	All	Review and update Topics for Future Reporting SIG Meetings