Refine and standardize handling of 035 OCLC numbers in MARC records (including potential duplicates)

UXPROD-4081 - Getting issue details... STATUS

DRAFT

Problem(s):

When OCLC 035s are created from incoming 001/003 data via Inventory Single Record Import or regular Data Import, the record often ends up with multiple OCLC 035s that have the same number, but varying prefixes. In addition, sometimes OCLC 035s contain leading zeroes and sometimes they don't. All of this makes it difficult to match on OCLC numbers and to have consistent presentation of OCLC numbers in Instances

Use Cases & Requirements:

Requirement	Status	Use cases
During Import, OCLC 035s are normalized to following format: (OColC)NUMBER, with no leading zeros or ocn/ocm prefixes (e.g. (OCoLC)64758)	DRAFT
Ensure that the 001 HRID is NOT being put into an 035 when a record is re-imported
Ensure that duplicate 035s are not generated when exact match is found in FOLIO
Implement Cleanup Script to normalize existing OCLC 035 values to match standard format (no leading zeros or ocn/ocm prefixes)

What Backend stories are needed?

TBD

What UI stories are needed?

TBD

SME Questions:

Question	Status	Conclusion	Comments

Developer Questions:

Question	Status	Conclusion	Comments
While we're under the hood working on 035, can we review 003 settings (CIRCLE BACK WITH MORE DETAIL LATER)
Will this have a negative impact on OCLC searching work previously completed in this story? UIIN-1208 - Getting issue details... STATUS