OCLC MARC holdings (LHRs)

[arthur-aguilera]

• [ ] Create Wiki Page for Report
• [ ] Add Wiki Page to Current Reports Directory
• [ ] Identify Fields Needed for Report
• [ ] Check FOLIO Analytics for exisiting reports or tables
• [ ] Check Cornell's Reports for exisiting reports or tables
• [ ] Build Query
• [ ] Query Needs Reviewed
• [ ] Add Query + ReadMe to Library Report github
• [ ] Update Wiki with "How to Run"

All checkin records that aren't suppressed and have MARC holdings (853/863 pairs), and are attached to a serials records that isn't part of Serials Solutions, isn't suppressed and has a numeric 001.

Quarterly. Needed to update our serials holdings in OCLC.

[blocke1]

Search string in Sierra:

CHECKIN SCODE3 not equal to "n" AND CHECKIN MARC Tag 863 has "|8" AND BIBLIOGRAPHIC CAT LEVEL not equal to "s" AND BIBLIOGRAPHIC BCODE3 not equal to "n" AND BIBLIOGRAPHIC ARL STATS equal to "s" AND BIBLIOGRAPHIC MARC Tag 001 greater than "" AND BIBLIOGRAPHIC MARC Tag 001 All Fields don't have "ucbserialset"

[steveellis]

Related to #55.

[steveellis]

I can take this on with #41 and #55. @arthur-aguilera and @blocke1 proposed report name "Serials Holdings for OCLC Update".

[blocke1]

It is unclear where the fixed field in MARC records in Sierra that is needed for this report will end up in FOLIO Inventory records. This report will need to be put on hold until we can get more information about the needed field in FOLIO. Or, we may need to create a new way to identify the records we need to send to OCLC.

Chris Long and Emily Semenoff will be the people to contact about this as we move forward.

Per Chris:

"It looks like for migrated records, the Sierra Cat Level code ends up in 998 $c. For records imported/created natively in FOLIO (i.e., non-migrated records), there isn’t an equivalent field in FOLIO. Cornell uses a text string to encode this type of info in an Administrative Note in Inventory, so I was thinking of doing something similar. I’m not sure where, or if, this data will end up in an exported record. We may need a new strategy to identify items needing OCLC holdings set – no idea at this point what that strategy might be."