2020-05-04 Reporting SIG Meeting notes

2020-05-04 Reporting SIG Meeting notes

Date

May 4, 2020

Attendees

Present?

Name

Organization

Present?

Name

Organization

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

 

Claudius Herkt-Januschek

SUB Hamburg

x

Scott Perry

University of Chicago

 

Doreen Herold

Lehigh University

 

Stefan Stadtherr

MPIL Heidelberg

 

Sarah Park

Duke University

X

Simona Tabacaru

Texas A&M

x

Clint Bellanger

Auburn University

x

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

x

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

x

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

 

 

 


Discussion Items

Item

Who

Notes

Item

Who

Notes

Attendance & Notes

Sharon

Attendance & Notes

  • Today's attendance-taker: Sharon Beltaine

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

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. Do we need to create any additional JIRA tickets?

  • Community & Coordination: 

    • planning for June FOLIO forum

    • circling back to REP issues that have not yet been clustered - will be reviewing those in Reporting SIG as time allows

    • need to revisit fix versions for clusters - current clusters assigned to Q2 2020 are not realistic, so we'll be re-evaluating those

    • C&C team will be meeting with functional area team leads to check on status and move development along

  • Development:

    • data documentation for ERM now included in FOLIO Schema Parser (thanks, Owen!) 

    • tables added for Fees and Fines

    • Microsoft Access working with Postgres LDP instances; Microsoft Access is version-specific (i.e., 2016 may be different from 2019)

RA/UM Working Group: 

  • No update for this week.

 

MM Working Group:

  • working on External Holdings reports cluster

 

RM Working Group: 

ERM Working Group:

 

 

Quick Review of RM Title, Item, and Subscription Count Cluster Prototypes

Nancy, Axel, Linda

The RM reports team would like feedback from members of the Reporting SIG on the following RM cluster prototypes:

Notes

  • should permanent location for holdings; do we also need temporary location, other locations, etc. (ask RM SIG) 

  • what is the best way to get subscription counts?

  • would it help to agree on a model library when writing the query?

  • when creating the best model for a cluster, think about the state of the data in the records in that area

  • there is a value in keeping a query simple enough that a person can modify it easily

 

Identifying LDP Tables for GDPR Compliance 

Nassib, Ingolf, Vandana, Joyce

Toward GDPR compliance in the LDP...

  • the LDP Data Privacy group will be identifying and documenting which tables have foreign keys that reference tables containing personal data 

  • personal data located in just a few tables in the LDP

  • does the group need assistance from other Reporting SIG members?

  • this process will help with the process of making the LDP GDPR-compliant by not storing any personal data

  • FOLIO Schema Parser can help, go into Data Element and Filter to ID to get the primary key of every table

 

Additional Topics?

All 

 

Topics for Future Meetings

All

Review and update Topics for Future Reporting SIG Meetings 

 

Action items