I have created a first draft of a composite spreadsheet to map user elements from various systems to FOLIO. The link is:https://drive.google.com/open?id=1jiMJz-wTBhSkpVrJOFQh2tGmm9-AXATphu2dMcACkws

I took the liberty of copying in the equivalent data elements from Sierra and from LBS. The OLE spreadsheet was sufficiently complex that I didn't want to tackle it.

For the purposes of discussing missing patron record elements, the most important rows in this composite spreadsheet are 35 through 106. These contain the elements from each of the 3 systems that I did include that do not appear to have equivalent elements in FOLIO yet. I also tried to equate certain elements from those sources that are missing with missing elements from the Voyager records that I am familiar with, e.g Voyager patron.title with LBS borrower.person_titles. So Theodor and Uschi, please check those carefully. (It appears that in Google sheets you do view/freeze/ so that you keep the top row in view while looking at lower rows. I didn't know this, so I thought I'd pointed out in case it was useful to others.)


In addition, I changed the text color to red for a bunch of data elements that I think we could leave behind in Voyager. I still need to check these with our circulation folks, but many of these red elements are calculated based on circulation functions or are dependent on very Voyager-specific functionality. So those of you who work with other systems might want to take a look at doing the same for your data element lists.

Anyway, everybody please have a look and edit as necessary.

Anne L. Highsmith
Clinical Associate Professor
TAMU Libraries
5000 TAMU
College Station, TX   77843-5000
979 862 4234