Skip to main content
OCLC Support

Record merge field transfer and merge matrix

Find information about fields that will and will not automatically transfer to the retained record during the merge process and the process to use when deciding which record should be the retained record.

Overview

This document provides information about fields that will and will not automatically transfer to the retained bibliographic record during the merge process.  It also covers the process to use when deciding which record should be the retained record.

Merge Transfer Fields

This section provides a table of which fields will transfer and the conditions under which they will transfer.

040 symbols in subfield $c and subfield $d of the merged records (except OCL and OCLCQ) are kept in the subfield $d of the retained record ONLY when data transfers from the merged record(s).

If the 019 and/or 029 are the only fields that transfer to the retained record, the symbols in the 040 field subfield $c and subfield $d will NOT transfer to the 040 $d of the retain record.

Category 1: Always transferred.

019

029

Category 2: Usually transferred when present in the record being merged and not present in the record being retained.

( * ) – See specific section below for more information

006

007

010

015

016

020

022

024

027

028

030

031

033

037

041

043

045

047

048

050*

052

055

060*

070

072

074

080

082*

083

084

085

086

088

090*

092*

096*

258

300

305

306

336

337

338

340

344

345

346

347

377

380

381

382

383

384

4xx*

504

505

506

520

526

533*

538

542

546

586

6xx*

751*

753

758

776

788*

8xx*

856*

891

936*

938

               

Category 3: Usually transferred when present in the record being merged and not present in the CONSER record being retained.

( * ) – See specific section below for more information

015

016

022

024

027

028

030

6xx*

856*

891

936*

 Note: Rules for transfer are quite complex and are documented in program design documents. Many fields (for example, field 024) have specialized tests for uniqueness. If the fields are determined to be 'unique', they will be transferred to the retained record.

Section 1: Call number fields (050/090, 060/096, 082/092); MEsh 6xx

050/090

  • If there are no LC call numbers present in the retained record, the system will only transfer the first call number it comes to in the merge sequence.

060/096/6xx

  • The National Library of Medicine (NLM) fields assigned by NLM (tags 060, 069, and 6xx second indicator '2') are always retained and replace medical fields in the retained record regardless of the source.

Example:
An LC record is the retained record and contains medical fields, the medical fields from the NLM merged record replaces the medical fields in the LC record.

082/092

  • If the 082/092 is already present in the retained record, then no others will transfer.
  • If there is no 082/092 present in the retained record, then all unique occurrences of DDC numbers (082) assigned by LC(040 $c DLC or 082 second indicator '0') are transferred from the merged record(s) to the retained record.
  • If there are no LC assigned DDC numbers in the retained or any of the merged records, all unique DDC numbers (082 or 092) are transferred to the retained record. Any 092 field that is already present in the retained record, or that is transferred from any of the merged records, is converted to an 082 field. If the 092 field has first indicator value of '0' or '1', that value is used and the second indicator is set to '4'. Otherwise, the indicators are set to '04'.

082/092 Notes

  • To be considered the same, the numeric portion (ignore alpha prefixes and suffixes; if an alpha suffix is followed by numerals, ignore them too) must be the same left to right to the length of the shorter of the two numbers. Example: 735.29 and 735.295 would be considered the same.
  • If the field only contains alpha and no numeric, then all unique occurrences are kept of the sequences of 'Fic', 'E', and 'B' and are put in an 082 14. All other 082/092 fields containing only alpha characters are not transferred.

Section 2: Series (4xx/8xx)

  • Traced series are always retained over untraced series. See scenarios below for more information:

Scenarios:

Case Retained Record Delete record Merge Decision
A No series No series No series
B No series Untraced series Retain untraced series
C No series Traced series Retain traced series
D Untraced series No series Retain untraced series
E Untraced series Untraced series No series merge; retain untraced series in retained record
F Untraced series Traced series Retain traced series; delete series from retained record
G Traced series No series Retain traced series
H Traced series Untraced series Retain traced series
I Traced series Traced series No series merge; retain traced series from retained record

Section 3: Fields 533 & 583

  • All 533 and 583 fields that have unique subfield $5 entries will transfer to the retained record.
  • Fields 533 and 583 will not transfer if the field does not have a unique subfield $5 entry.

Section 4: Subject headings (600-651 & 653-662)

  • Subject headings are transferred based on the second indicator value. Headings with different values are transferred from the merged record to the retained record.

Example:
The retained record has:
650 _0 Conflicts of interests $z United States.
600 10 Baker, Robert Gene.

The duplicate record has:
610 10 United States. $b Department of Justice.

The corporate subject heading will NOT transfer from the duplicate record to the retained record since the second indicator values are the same.

 Note: Subject headings with second indicator value '7' that have unique subfield $2 entries will transfer to the retained record.

Section 5: Field 751

  • Field 751 will transfer if the field is not present in the retained record
  • All 751 fields that have unique subfield $2 entries will transfer to the retained record

Section 6: Field 788

  • Field 788 will transfer if the 788 subfield $e differs from the 040 subfield $b in the retained record
  • All 788 fields that have unique subfield $e entries will transfer to the retained record, with the following exception: 
    • In cases where the inputting institutions of the retained and deleted records match (040 $c), if the deleted record has an updated field 788 with $e that matches the language of the cataloging code in field 040 $b of the retained record, field 788 from the deleted record may replace field 788 on the retained record, thereby allowing an upgrade of the institution's own 788 field
  • Fields without subfield $e will not transfer

Section 7: Field 856

  • All unique URLs should transfer to the retained record
  • CONSER exception:  
    • Field 856 will transfer all unique ‘digitalarchive’ URLs even if the retained record is CONSER
    • Field 856 will not transfer in all other cases when the retained record is CONSER

Section 8: Field 936

  • Field 936 should ONLY be present in Serials format records, however, may be encountered on other format records
  • The 936 field will NOT transfer if the record number in the 936 field IS the record number of the delete record or if the record number is in the 019 field of the retained record

Merge decision matrix – does not include CONSER records

Use the table below to determine which record should be retained.  A definition for each of the action categories is provided below the table.

  New Zealand National Bibliography

(042 = nznb or toknb)
National Library Records

(040/c = DLC, GWDNB, NLC, NLM, and ELvl = blank or 1; or 040/c = any symbol and 042 = lac or pcc)
LC/LAC CIP Records

(040/c = DLC or NLC and ELvl = 8)
Member

(anything not in the previous outlined categories)
New Zealand National Bibliography

(042 = nznb or toknb)
*Ask OCLC Retain New Zealand National Bibliography Retain New Zealand National Bibliography Retain New Zealand National Bibliography
National Library Records

(040/c = DLC, GWDNB, NLC, NLM, and ELvl = blank or 1; or 040/c = any symbol and 042 = lac or pcc)
Retain New Zealand National Bibliography non-LC PCC vs. non-LC PCC keep most complete

*Ask OCLC in all other cases
Retain National Library record Retain National Library record
LC/LAC CIP Records

(040/c = DLC or NLC and ELvl = 8)
Retain New Zealand National Bibliography Retain National Library record *Ask OCLC Retain LC/LAC encoding level 8
Member

(anything not in the previous outlined categories)
Retain New Zealand National Bibliography Retain National Library record Retain LC/LAC encoding level 8 **Retain most complete

Merge decision matrix – Continuing Resource records – CONSER

Use the table below to determine which record should be retained when merging Continuing Resources.  A definition for each of the action categories is provided below the table.

  CONSER New Zealand National Bibliography

(042 = nznb or toknb)
National Library Records

(Non-CONSER  040/c = DLC, GWDNB, NLC, NLM, and ELvl = blank or 1; or 040/c = any symbol and 042 = non-CONSER code)
LC/LAC CIP Records

(Non-CONSER: 040/c = DLC or NLC and ELvl = 8)
Member

(anything not in the previous outlined categories)
CONSER ***Retain based on CEG Retain CONSER Retain CONSER Retain CONSER Retain CONSER
New Zealand National Bibliography

(042 = nznb or toknb)
Retain CONSER *Ask OCLC Retain New Zealand National Bibliography Retain New Zealand National Bibliography Retain New Zealand National Bibliography
National Library Records

(Non-CONSER  040/c = DLC, GWDNB, NLC, NLM, and ELvl = blank or 1; or 040/c = any symbol and 042 = non-CONSER code)
Retain CONSER Retain New Zealand National Bibliography non-LC PCC vs. non-LC PCC keep most complete

*Ask OCLC in all other cases
Retain National Library record Retain National Library record
LC/LAC CIP Records

(Non-CONSER: 040/c = DLC or NLC and ELvl = 8)
Retain CONSER Retain New Zealand National Bibliography Retain National Library record *Ask OCLC Retain LC/LAC encoding level 8
Member

(anything not in the previous outlined categories)
Retain CONSER Retain New Zealand National Bibliography Retain National Library record Retain LC/LAC encoding level 8 **Retain most complete

Definitions

*Ask OCLC: BibChange@OCLC.org

**Retain most complete: Based on content, NOT the number of fields.  Also take into consideration the number of holdings on each record.  If the records being compared are for the most part equal in completeness and holdings, retain the record with the lowest OCLC control number.

***Retain based on CEG: Follow guidelines in the CONSER Editing Guidelines (CEG), Sections C7 and C8. For information on CONSER authentication codes, see CEG Field 042.

Additional information

Encoding Level J: Treat as member.  OK to merge, retaining the most complete record.  Transfer 010 to $z in the retained record.

UKM CIP encoding level 8: See also section UKM CIP (Cataloging-in-Publication) Guidelines in the document Field by Field Comparison for Merging Duplicate Records in WorldCat for special instructions for UKM CIP records

Revision history

Date Last edited by Description of changes
09 Sept 2019 Shanna  
06 April 2023 Shanna Added field 788 to table of fields that will transfer

Added Section 6 to explain transfer of 788 field
01 Feb 2024 Shanna Added field 758 to table of fields that will transfer