Components of the Library Data Clean Up Project

Major Blocker/no work around
Must be completed before or during OCLC DataSync and Postwork period

Probable deadlines prior to May 27, 2022

Huge Hurdle/work around painful
Can wait until after OCLC DataSync, but before FOLIO implementation

Probable deadlines prior to June 30, 2022 (adjusted since FOLIO timeline shifted)

Errors in data that will be difficult or impossible to remediate in FOLIO on migration or immediately after migration. 
Example: Item material type is BK instead of SER.
Example: Batch change IPS for withdrawing items, missing items, etc.
Example: Fragile data like the LKR , like multiple bibs for 1 title.
Example: Addressing invalid (legacy) location codes when the code exists in Aleph records but not in Aleph tables (PENAP, ECCO, etc.)

Data Enhancement/work around not sustainable

Probable deadline time-frame to be determined

P1-E 040 by language clean-up project

Most of these (15,246) had record matches in OCLC, Aleph records should be overlaid.  Field protections/merge routine is being developed (as of 2/15/2022)

Remaining unresolved titles will be cataloged in RDD or RLTS

There are full-level bibs in system which were created for language of cataloging other eng (040$b) which should be reviewed and replaced (may require significant manual review/cataloging). 
 
Matt's help is needed to create/execute separate extract of these records

Related work: Presence of 040 $b (not eng) needs to be updated in cataloging documentation and processes.

Delete Gov Doc records for print records without items.

Other "extra" records exist, suppress as needed.  (i.e.: malformed holding codes)

P1 -D Aleph 935 - reunite related titles (935)

As of June 30, decision made to not migrate remaining 935 data

Lok Saba debates is an example
Delete extraneous 935s, then cause titles to be reunited

Have data-set

Can't delete records in FOLIO
Most have STA=circ-created
Some have "Temporary On-the-Fly" in 245 or 500

Matt's help is needed to to ID the rest

review needed in RDD due to data inconsistencies

Have data-set, needs manual refinement

P1-H Items with sublibrary CHEM or VESIC (AskTech #5167)

Follow up on all BES holdings (including Herbaria), these may come back to the libraries, but decision was delayed in 2020.

*Decision on remaining collection is needed before transfer and final data cleanup possible, but planning suggests this will be done by January 2023, so cleanup aspect is done for now.

Ghost holdings in bound-withs.  Are these old reserves?  How do we ID and remove them? 

wsl=VESIC (17 records)
wsl=CHEM (0 records)

Leeda has data and notes to share

P1-I Lost materials

Several sets of holdings need to be set to  Lost.  This includes IPS=LM, holding codes for "Off-Site Stacks," etc.  When the only holding we had is Lost, holdings need to be removed from OCLC

LM meant "missing from LC Reclass", but put in use by DUL Circ and Law for other reasons, now LM means the same across DUL and professional school libraries.

DUL 'LM's need to be changed to "LO" when material is not currently circulating.
Postwork: Document new workflow in TSPD, link to ADS page for additional info on their part of the workflow

cross check item material type (microformat) and "general" stacks in DOC sublibrary. (~34,300 Suppressed on 10/12)

consider maps with same inconsistency

move to 866 statements

Make sure that this is a retired practice

In-Process

as of Oct.1, 2021

P1-N Update bibliographic records for Gale electronic resources

Records provided by Gale; not available from 360.  Original records loads described print, not electronic resources.  New file has been supplied.  We need to check to see if OCLC holdings are set. Attempt to match on 901 NCCO number.

Approximately 300,000 records were suppressed as of Oct. 11, 2021

Make sure to think about RL records where Gale URLs may be added in error.

see planning request from Ros
both IPS LC and GW mean "In-Process LC reclass project" 
 -- Flip IPS LC to "blank" when 05099 exists
 -- Flip IPS GW to "blank" when 05099 exists
-- Manual intervention to apply LC classification when no 05099

Many lines in the log files. Need to be broken out into workable projects

Dennis has created PostGres DB to enable error log review and planning.

These data are not valid according to the ANSI/NISO Z39.71standard and should be updated both to confirm holding accuracy and to comply with this standard.

Reduce the number of locations to create in FOLIO to facilitate migration
Make sure to update/review the LSC Accession list

example: Remove Quarto locations:

P2-N IPS cleanup discovered by /wiki/spaces/LIB/pages/34898762 working group meetings (AskTech #6782, #6783, #6785, #6787) as of 7/23/2021.

Several IPS codes were identified for deprecation and need to be removed from the Aleph tables after data has been cleaned up

P3-B Item Status 04 (AskTech #4772)

some overlap with P2-I

P3-D Bib 940 tags

P3-G 035 number begins with T

Action plan written, cleanup needed

P4-B Clean up copy numbers ( c.1 ) in "Item Description"

Send requirements to Jeff F. so that this can be done during migration

Copy numbers are also held in copy number field; confirm how spine label printing might work in FOLIO. The Description field does not have a natural home in the migration, so may be put in notes or left behind in migration.

RL wants to retain information in the Item description field, including copy numbers.

Simply delete these fields (but not all 590s).  Consider that this set will be smaller post-OCLC reclamation sync.

RLTS has no concerns on this.

P4-D Delete LEILA test record set

Deprecated after analysis revealed not actual data set

(982 plus 910=LEILA)

will not impact data sync due to lack of OCLC number