Classification and Call number handling in Data Import

Classification and Call number handling in Data Import

Statement of problem

  • In 2022, the Inventory and Data Import users discovered that MARC call number fields (such as 050, 060, etc.) with repeated fields or subfields are not handled properly when Instances, Holdings, and Items are created or updated. 

  • The default MARC Bib-to-Inventory Instance mapping rules handle repeated classification fields fine, since classification is a repeatable field in the Inventory Instance. However, the current rules do not handle repeated subfields within a particular classification field properly. This is often the case with classification for bibliographies or juvenile materials.

  • The existing field mappings for call numbers in holdings and item records do not work properly if the mapped call number field is repeated in the MARC Bibliographic record. Since the call number field is not repeatable in the Inventory holdings or item record, the result is a call number that is a combination of the multiple MARC fields.

  • See below for tables of the affected classification fields and subfields and requirements. 

    • Correcting the handling in Instances requires changes to the default MARC Bib-to-Inventory Instance map

    • Correcting the handling in Holdings and Items requires changes to the handling of mapped data in the call number fields of the Holdings and Item field mapping profiles

Related Jiras

https://folio-org.atlassian.net/browse/MODSOURMAN-882 (fixed in Orchid)

https://folio-org.atlassian.net/browse/MODSOURMAN-900 (fixed in Poppy)

MARC Classification fields and Instances

Red = Change that was made in Poppy

Description

MARC Field and relevant subfields

Pre-Poppy handling

when field is repeated

Required handling 

when field is repeated

Pre-Poppy handling

when subfield in one field is repeated

Required handling

when subfield in one field is repeated

Notes

Description

MARC Field and relevant subfields

Pre-Poppy handling

when field is repeated

Required handling 

when field is repeated

Pre-Poppy handling

when subfield in one field is repeated

Required handling

when subfield in one field is repeated

Notes

LC

050 $a (R)  $b (NR)

Separate classification fields

Separate classification fields

One classification field

Separate classification fields, with 1st $a and its $b if present in first Instance field, and 2nd $a in second Instance field

 

NLM

060 $a (R)  $b (NR)

Separate classification fields

Separate classification fields

One classification field

Separate classification fields, with 1st $a and its $b if present in first Instance field, and 2nd $a (and its $b, if it has one) in second Instance field

 

UDC

080 $a (NR) $b (NR)

Separate classification fields

Separate classification fields

n/a

n/a

Since $a is not repeatable within a field, no change is needed

Dewey

082 $a (R)  $b (NR)

Separate classification fields. If there is a slash in $a, remove it and close up the space

Separate classification fields. If there is a slash in $a, remove it and close up the space

One classification field

Separate classification fields, with 1st $a and its $b if present in first Instance field, and 2nd $a (and its $b, if it has one) in second Instance field

 

Gov Doc

086 $a (NR) $z (R)

Separate classification fields. If $a and $z both present in the same 086 field, split them into separate Instance fields

Separate classification fields. If $a and $z are both present in the same 086 field, split them into separate Instance fields

Separate classification fields

Separate classification fields. If $a and multiple $z's are both present in the same 086 field, split them all into separate Instance fields

No change is needed

Local LC

090 $a (R) $b (R)

Separate classification fields

Separate classification fields

One classification field

Separate classification fields, with 1st $a and its $b if present in first Instance field, and 2nd $a (and its $b, if it has one) in second Instance field

 

Instance Examples

Based on the required handling above

Description

MARC data

MARC example

Instance Classification field(s) 

Description

MARC data

MARC example

Instance Classification field(s) 

LC

2 050s

050 14 $aB3199.A33 $bP7613 2000a
050 14 $aB3199.A33 $bP7613 2000b

B3199.A33 P7613 2000a
B3199.A33 P7613 2000b

LC

1 050 with 2 $a

050 04 $aZ5853.M38 $bG37 1993 $aTA418.9.C6

Z5853.M38 G37 1993
TA418.9.C6

NLM

2 060s

060 10 $aW1 $bME9616J v.69 1997
060 10 $aQH 442.4 $bC386 1997

W1 ME9616J v.69 1997
QH 442.4 C386 1997

NLM

1 060 with 2 $a

060 \0 $aW1 NE372F v.12 $aQU 95 S839

W1 NE372F v.12
QU 95 S839

UDC

2 080s

080 \\$a001.81 $bB67
080 \\$a001.82 $bBAR

001.81 B67
001.82 BAR

Dewey

2 082s

082 04 $a300.723 $bHEA
082 04 $a338.7/6292/092 $bHEA $221

300.723 HEA
338.76292092 HEA

Dewey

1 082 with 2 $a

082 04 $a300.723 $bHEA $a338.7/6292/092

300.723 HEA
338.76292092

Gov Doc

2 086s

086 0\ $aD 210.6:M 56
086 0\ $aY 3.AT 7:6 M 56/

D 210.6:M 56
Y 3.AT 7:6 M 56/

Gov Doc

1 086 with 2 $z

086 0\ $aA 1.1: $zA 1.1/3:984 $zA 1.1/4:985

A 1.1:
A 1.1/3:984
A 1.1/4:985

Local LC

2 090s

090 14 $aB3199.A33 $bP7613 2000a
090 14 $aB3199.A33 $bP7613 2000b

B3199.A33 P7613 2000a
B3199.A33 P7613 2000b

Local LC

1 090 with 2 $a

090 14 $aZ5853.M38 $bG37 1993 $aTA418.9.C6

Z5853.M38 G37 1993
TA418.9.C6

MARC Classification and Holdings/Items

Red = Change that was made in Orchid

Description

MARC Field and relevant subfields

Field mapping

Pre-Orchid handling when field is repeated

Orchid handling 
when field is repeated

Pre-Orchid handling
when subfield in one field is repeated

Orchid handling
when subfield in one field is repeated

Notes

Description

MARC Field and relevant subfields

Field mapping

Pre-Orchid handling when field is repeated

Orchid handling 
when field is repeated

Pre-Orchid handling
when subfield in one field is repeated

Orchid handling
when subfield in one field is repeated

Notes

LC

050 $a (R)  $b (NR)

050$a " " 050$b

Some of the data from the second field is included

Use data from the first 050 only; ignore any subsequent 050 field

All data from the field is included

Use data from the first $a and $b only; ignore any subsequent

 

NLM

060 $a (R)  $b (NR)

060$a " " 060$b

Data from both fields  included

Use data from the first 060 only; ignore any subsequent 060 field

All data from the field is included

Use data from the first $a and $b only; ignore any subsequent

 

UDC

080 $a (NR) $b (NR)

080$a " " 080$b

Data from both fields  included

Use data from the first 080 only; ignore any subsequent 080 field

n/a

n/a

Since neither subfield is repeatable within a field, no change is needed

Dewey

082 $a (R)  $b (NR)

082$a " " 082$b

Data from both fields included and mixed together

Use data from the first 082 only; ignore any subsequent 082 field

All data from the field is included

Use data from the first $a and $b only; ignore any subsequent

 

Gov Doc

086 $a (NR) $z (R)

086$a

Data from both fields  included

Use data from the first 086 only; ignore any subsequent 086 field

As long as only $a is mapped, all is fine

No change needed

 

Local LC

090 $a (R) $b (R)

090$a " " 090$b

Some of the data from the second field is included

Use data from the first 050 only; ignore any subsequent 050 field

All data from the field is included

Use data from the first $a and $b only; ignore any subsequent

 

Holdings and Item Examples

Based on the required handling above

Description

MARC data

Sample MARC

Field mapping

Holdings/Item Call Number

Description

MARC data

Sample MARC

Field mapping

Holdings/Item Call Number

LC

2 050s

050 14 $aB3199.A33 $bP7613 2000a
050 14 $aB3199.A33 $bP7613 2000b

050$a " " 050$b

B3199.A33 P7613 2000a

LC

1 050 with 2 $a

050 04 $aZ5853.M38 $bG37 1993 $aTA418.9.C6

050$a " " 050$b

Z5853.M38 G37 1993

NLM

2 060s

060 10 $aW1 $bME9616J v.69 1997
060 10 $aQH 442.4 $bC386 1997

060$a " " 060$b

W1 ME9616J v.69 1997

NLM

1 060 with 2 $a

060 \0 $aW1 NE372F v.12 $aQU 95 S839

060$a " " 060$b

W1 NE372F v.12

UDC

2 080s

080 \\$a001.81 $bB67
080 \\$a001.82 $bBAR

080$a " " 080$b

001.81 B67

Dewey

2 082s

082 04 $a300.723 $bHEA
082 04 $a338.7/6292/092 $bHEA $221

082$a " " 082$b

300.723 HEA

Dewey

1 082 with 2 $a

082 04 $a300.723 $bHEA $a338.7/6292/092

082$a " " 082$b

300.723 HEA

Gov Doc

2 086s

086 0\ $aD 210.6:M 56
086 0\ $aY 3.AT 7:6 M 56/

086$a

D 210.6:M 56

Gov Doc

1 086 with 2 $z

086 0\ $aA 1.1: $zA 1.1/3:984 $zA 1.1/4:985

086$a

A 1.1

Local LC

2 090s

090 14 $aB3199.A33 $bP7613 2000a
090 14 $aB3199.A33 $bP7613 2000b

090$a " " 090$b

B3199.A33 P7613 2000a

Local LC

1 090 with 2 $a

090 14 $aZ5853.M38 $bG37 1993 $aTA418.9.C6

090$a " " 090$b

Z5853.M38 G37 1993