I know we have made the point several times in our SIG meetings that when it comes to what data we need from FOLIO for reports, we say, “we need all of it.” Given that there has always been substantial agreement on that point in the SIG, I wonder why we are trying to put together a list of MARC fields that are necessary in the reporting system. I feel the correct answer is that they are all necessary. We can’t choose which MARC fields we will need because we can’t anticipate future needs; based on the examples in the master spreadsheet and our demos I believe we have documented that we currently use all fields in MARC bibliographic and holdings records and many in the authority records also.
I’m very much afraid that if we don’t have complete MARC records available in the FOLIO reporting system, that we’ll end up having to build that data someplace else and keep it updated there. Or even worse, that when we need a report where the data appears only in a 5xx field ( such as which items in Texas A&M’s Special Collections were acquired as “part of the personal Science Fiction/Fantasy library of Anne McCaffrey”) we’ll have to export the whole MARC bib record database and scan the records one-by-one to get the information. Let’s just say we need our MARC records complete in our reporting system, structured so that individual fields are easy to access. And be done with it.