...
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.
...
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 , during data loadand 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. |
...