2020-10-19 Reporting SIG Meeting notes

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

Tod Olson

University of Chicago

Claudius Herkt-Januschek

SUB Hamburg

Scott Perry

University of Chicago

Doreen Herold

Lehigh University

Stefan Stadtherr

MPIL Heidelberg

Sarah Park

Duke University

Simona Tabacaru

Texas A&M

Clint Bellanger

Auburn University

Kevin Walker

The University of Alabama

Ingolf Kuss

hbz

Christie Thomas

University of Chicago

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

Vandana Shah

Cornell University

Nassib Nassar

Index Data

Angela Zoss

Duke University

Veit Köppen

University Magdeburg

Lisa DeCarolis

Smith College/Five Colleges

Linda Miller

Cornell University

Elena O'Malley

Emerson

Matt Harrington

Duke University

Holly Mistlebauer

Cornell University

Cathy Tuohy

Emmanuel College (FLO)

Nancy Bolduc

Cornell University

Shirley Moentnish

Missouri State

Eric Pennington

Texas A&M

Stefan Dombek

Leipzig University

Axel Doerrer

University Mainz

Natalya Pikulik

Cornell University

Owen Stephens

K-Int

Eliana Lima

Fenway Library Organization

Marcia Borensztajn

EBSCO

Harry Kaplanian

EBSCO

Molly Driscoll

EBSCO

Amelia Sutton

U. Massachusetts

Heather Loehr

Hanover College

Mary Morgan

Grand Valley State University

Jennifer Eustice

U. Massachusetts Amherst / Five College

Attendance & Notes

Sharon

Attendance & Notes

• Today's attendance-taker: Linda Miller

• Today's note-takers:  Team Leads for project updates

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

• Where are there needs for abbreviations?

• 63-character limit (postgres) for index names and column names

• JSON extraction statements get too long

• long names are cumbersome to type

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

• new derived tables for fees and fines

MM Working Group

• moving to hour-long, weekly meetings

• finished derived tables

ERM Working Group

• 5 derived tables has been developed in own ERM branch

• Highlevel sketch of how eHoldings data can be loaded in to LDP
  More detailed outline of that function to be finalized

• ERM Cost Query on FOLIO Livesystem by Stefan Dombek (Leipzig)

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 line eresources and physical material type

  • 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