Page Comparison

Date

05 Oct 2020

...

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
	Jean Pajerek	Cornell University	X	Tod Olson	University of Chicago
X	Claudius Herkt-Januschek	SUB Hamburg	X	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	X	Kevin Walker	The University of Alabama
	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		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

...

Item	Who	Notes
Attendance & Notes	Sharon	Attendance & Notes Today's attendance-taker: Linda Miller Today's note-takers: Team Leads for project updates
Update from Tod on Jira ranking conversions	Tod?	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 Implementation Group 2020-09-22 Meeting notes. 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 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: reporting survey entries are complete! Aliasing for reports Questions Should we remove WITH clauses in our derived table queries? may or may not be used, case by case FOLIO Reporting development The derived table spreadsheet: https://docs.google.com/spreadsheets/d/1GL5XssOJaBMuKOrM0H_0lhht0G4ApDNr72SVLGV0JT0/edit?usp=sharing This is now superseded by issues in GitHub: https://github.com/folio-org/folio-analytics/issues This week: query development groups take another look at what additional tables may be needed to support ad hoc querying Draft starter list of proposed column names important to keep using the "json_extract_path_text()" latest model queries for using JSON arrays https://github.com/folio-org/folio-analytics/tree/master/sql/derived_tables JSON array examples: https://github.com/library-data-platform/ldp/blob/master/doc/User_Guide.md#7-json-arrays 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 discussion about what ERM data come from what storage (diagram) two approaches of getting eHoldings data to get in use for reporting eHoldings app to be enhanced to provide the data for reporting LDP will be enhanced to pull in the data out of eHoldings for latest updates, see ERM Prototype and Query Development Status RM Working Group for latest updates, see RM Prototype and Query Development Status 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 Recategorize External Statistics REP Issues
Topics for Future Meetings	All	Review and update Topics for Future Reporting SIG Meetings

...

Versions Compared

Old Version 6

New Version 7

Key

Date