...
The 9XX fields are earmarked for institution specific data in MARC and this is widely leveraged by legacy LMS to carry Item and Holding information apart from the 841-88X fields earmarked for holdings and item data. Care should be employed to extract such information for load into corresponding holding and item tables.
...
Certain LMS allow institutions to have alphanumeric Control Field 001. However, OLE supports only a 11 digit integer as the Bib Id. There are also instances when a single bib record held multiple Control Field 003 values owing to lax validation requirements of legacy LMS.
It One option is therefore advisable to write a small program to extract information from these 9XX fields to construct the CSV formatted file to load the data into the holding and item tables. This program would parse the MARCXML converted from the MARC file and extract crucial item and holding data. The program can also be used to manipulate Bib data - replace Control Field 001, remove duplicate Control Field 003, move the alpha numeric Control Field 001 to a 9XX field, etc.
An alternate way of A second option for loading MARC records is through Webservice APIs. More detailed information along with sample request XMLs can be found here.
Bound-Withs
Institutions are likely to deal with bound-withs during data load. A bound-with is when two or more independent monographs are placed under one cover by the publisher or post publication by the library and treated as a single entity for all circulation purposes.
To load bound-withs, Bibliographic records are created for each independent monograph in the Bound-with collection. One Bib is designated as the parent and the holding record is created. Finally, all the other Bib data are linked to the newly created holding.
The linking information goes into the ole_ds_bib_holdings_t table. The table contains the following columns:
| Column | Data Type | Comment |
|---|---|---|
| BIB_HOLDINGS_T | Integer (11) | This is the Primary Key and will have to be unique. |
| HOLDINGS_ID | Integer (11) | This is the Primary Key from the ole_ds_holdings_t table representing the Holding data. |
| BIB_ID | Integer (11) | This is the Primary Key from the ole_ds_bib_t table representing the Bib data. |