2020-10-19 Reporting SIG Meeting notes

Owned by Sharon Markus
Last updated: Oct 19, 2020 by lm15@cornell.edu

Date

Attendees

Present?

Name

Organization

Present?

Name

Organization

XSharon BeltaineCornell University
Sara ColglazierMount Holyoke College/Five Colleges

Elizabeth BerneyDuke University
Erin NettifeeDuke University

Joyce ChapmanDuke University
Karen NewberyDuke University

Jean PajerekCornell UniversityXTod OlsonUniversity of Chicago
XClaudius Herkt-JanuschekSUB Hamburg
Scott PerryUniversity of Chicago


Doreen HeroldLehigh University
Stefan StadtherrMPIL Heidelberg
XSarah ParkDuke UniversityXSimona TabacaruTexas A&M

Clint BellangerAuburn University
Kevin WalkerThe University of Alabama

Ingolf Kusshbz
Christie ThomasUniversity of Chicago
XJoshua LambertMissouri State

Andi Bihler

Munich Technical University Library

Joanne LearyCornell University
Cheryl MalmborgUniversity of Chicago
XMichael PatrickThe University of AlabamaXVandana ShahCornell University
XNassib NassarIndex DataXAngela Zoss

Duke University


Veit KöppenUniversity Magdeburg
Lisa DeCarolisSmith College/Five Colleges
XLinda MillerCornell UniversityXElena O'Malley

Emerson


Matt HarringtonDuke University     Holly MistlebauerCornell University

Cathy TuohyEmmanuel College (FLO)
Nancy BolducCornell University

Shirley MoentnishMissouri StateXEric PenningtonTexas A&M
XStefan DombekLeipzig UniversityXAxel DoerrerUniversity Mainz
XNatalya PikulikCornell University
Owen StephensK-Int
XEliana LimaFenway Library Organization
Marcia BorensztajnEBSCO

Harry KaplanianEBSCO
Molly DriscollEBSCO

Amelia SuttonU. Massachusetts
Heather LoehrHanover College

Mary MorganGrand Valley State UniversityXJennifer EusticeU. Massachusetts Amherst / Five College


Discussion Items

Item

Who

Notes

Attendance & NotesSharon

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 dataNassibRequest for specific use cases from the community on integrating non-FOLIO data with FOLIO data
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: 

  • no meeting this past week


FOLIO Reporting development

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
  • derived tables
    • purchase order line eresources and physical material type
    • po_purchase_orders_acq_unit_ids

External Statistics Working Group


Topics for Future MeetingsAll

Review and update Topics for Future Reporting SIG Meetings 


Action items