The SCSB middle-ware allows to export records as a MARCXML or in a proprietary SCSBXML format. The schema of the formats generated by SCSB are defined below.
MARCXML Schema sample
MARCXML by SCSB
<marcxml:record> <marcxml:leader>01716cam a2200337 a 4500</marcxml:leader> <marcxml:controlfield tag="001">SCSB-186501</marcxml:controlfield> <!-- SCSB's bibliographic id --> <marcxml:controlfield tag="003">NNC</marcxml:controlfield> <marcxml:controlfield tag="005">20100215175257.0</marcxml:controlfield> <marcxml:controlfield tag="008">910731s1991 waua b 101 0 eng d</marcxml:controlfield> <marcxml:datafield tag="010" ind1=" " ind2=" "> <marcxml:subfield code="a"> 90065684 </marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="020" ind1=" " ind2=" "> <marcxml:subfield code="a">0819404195</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="035" ind1=" " ind2=" "> <marcxml:subfield code="a">(OCoLC)502402565</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="035" ind1=" " ind2=" "> <marcxml:subfield code="a">(OCoLC)ocn502402565</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="035" ind1=" " ind2=" "> <marcxml:subfield code="a">(CStRLIN)NYCG91-B70355</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="035" ind1=" " ind2=" "> <marcxml:subfield code="9">AFM6178CU</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="035" ind1=" " ind2=" "> <marcxml:subfield code="a">(NNC)1001026</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="040" ind1=" " ind2=" "> <marcxml:subfield code="a">CU-S</marcxml:subfield> <marcxml:subfield code="c">CU-S</marcxml:subfield> <marcxml:subfield code="d">CU</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="090" ind1=" " ind2=" "> <marcxml:subfield code="a">TR593</marcxml:subfield> <marcxml:subfield code="b">.I6 1990g</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="111" ind1="2" ind2=" "> <marcxml:subfield code="a">International Congress on High Speed Photography and Photonics</marcxml:subfield> <marcxml:subfield code="n">(19th :</marcxml:subfield> <marcxml:subfield code="d">1990 :</marcxml:subfield> <marcxml:subfield code="c">Cambridge, England)</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="245" ind1="1" ind2="0"> <marcxml:subfield code="a">19th International Congress on High-Speed Photography and Photonics :</marcxml:subfield> <marcxml:subfield code="b">proceedings, 16-21 September 1990, Cambridge, England /</marcxml:subfield> <marcxml:subfield code="c">Brian Garfield, John Rendell, editors ; organized by BAHSP (British Association for High-Speed Photography), Special Committee UK 1990 Executive Committee ; sponsored by Hadland Photonics Ltd. ... [et al] ; special support from Department of Trade and Industry, Royal Photographic Society, [and] SPIE--the International Society for Optical Engineering.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="260" ind1=" " ind2=" "> <marcxml:subfield code="a">Bellingham, Wash., USA :</marcxml:subfield> <marcxml:subfield code="b">SPIE--the International Society for Optical Engineering,</marcxml:subfield> <marcxml:subfield code="c">c1991.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="300" ind1=" " ind2=" "> <marcxml:subfield code="a">2 v. (xxx, 1271 p.) :</marcxml:subfield> <marcxml:subfield code="b">ill. ;</marcxml:subfield> <marcxml:subfield code="c">28 cm.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="490" ind1="1" ind2=" "> <marcxml:subfield code="a">SPIE ;</marcxml:subfield> <marcxml:subfield code="v">v. 1358</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="504" ind1=" " ind2=" "> <marcxml:subfield code="a">Includes bibliographical references and index.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="650" ind1=" " ind2="0"> <marcxml:subfield code="a">Photography, High-speed</marcxml:subfield> <marcxml:subfield code="v">Congresses.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="650" ind1=" " ind2="0"> <marcxml:subfield code="a">Photonics</marcxml:subfield> <marcxml:subfield code="v">Congresses.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="700" ind1="1" ind2=" "> <marcxml:subfield code="a">Garfield, Brian.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="700" ind1="1" ind2=" "> <marcxml:subfield code="a">Rendell, John</marcxml:subfield> <marcxml:subfield code="q">(John T.)</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="710" ind1="2" ind2=" "> <marcxml:subfield code="a">British Association for High Speed Photography.</marcxml:subfield> <marcxml:subfield code="b">Special Committee UK 1990 Executive Committee.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="710" ind1="2" ind2=" "> <marcxml:subfield code="a">Hadland Photonics.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="830" ind1=" " ind2="0"> <marcxml:subfield code="a">Proceedings of SPIE--the International Society for Optical Engineering ;</marcxml:subfield> <marcxml:subfield code="v">v. 1358.</marcxml:subfield> </marcxml:datafield> <marcxml:datafield tag="852" ind1="0" ind2="1"> <marcxml:subfield code="b">scsb-cul</marcxml:subfield> <!-- Owning institution --> <marcxml:subfield code="h">TR593 .I6 1990g</marcxml:subfield> <!-- Call number --> <marcxml:subfield code="0">188410</marcxml:subfield> <!-- SCSB's Holdings Id --> </marcxml:datafield> <marcxml:datafield tag="866" ind1="0" ind2="0"> <!-- 866 is populated only if the record had the tag during accession --> <marcxml:subfield code="a">2v. 1991</marcxml:subfield> <!-- Textual Holdings --> <marcxml:subfield code="0">188410</marcxml:subfield> <!-- SCSB's Holdings Id --> </marcxml:datafield> <marcxml:datafield tag="876" ind1=" " ind2=" "> <marcxml:subfield code="0">188410</marcxml:subfield> <!-- SCSB's Holdings Id --> <marcxml:subfield code="a">240158</marcxml:subfield> <!-- SCSB's Item Id --> <marcxml:subfield code="h"/> <!-- Use restriction --> <marcxml:subfield code="j">Available</marcxml:subfield> <!-- Item status --> <marcxml:subfield code="p">CU07416571</marcxml:subfield> <!-- Item barcode --> <marcxml:subfield code="t">1</marcxml:subfield> <!-- Copy number --> <marcxml:subfield code="x">CU</marcxml:subfield> <!-- Customer Code --> <marcxml:subfield code="z">Shared</marcxml:subfield> <!-- Collection Group Designation --> </marcxml:datafield> <marcxml:datafield tag="876" ind1=" " ind2=" "> <marcxml:subfield code="0">188410</marcxml:subfield> <!-- SCSB's Holdings Id --> <marcxml:subfield code="a">240157</marcxml:subfield> <!-- SCSB's Item Id --> <marcxml:subfield code="h"/> <!-- Use restriction --> <marcxml:subfield code="j">Available</marcxml:subfield> <!-- Item status --> <marcxml:subfield code="p">CU13998889</marcxml:subfield> <!-- Item barcode --> <marcxml:subfield code="t">1</marcxml:subfield> <!-- Copy number --> <marcxml:subfield code="x">CU</marcxml:subfield> <!-- Customer Code --> <marcxml:subfield code="z">Shared</marcxml:subfield> <!-- Collection Group Designation --> </marcxml:datafield> </marcxml:record>
MARCXML Schema Explained
- <001> : SCSB's Bibliographic Id - auto generated at the time of accession in SCSB's database.
- <852>
- $b : Owning Institution code prefixed with 'scsb-' (scsb-cul for CUL, scsb-pul for PUL and scsb-nypl for NYPL)
- $h : Call Number - value supplied by ILS at the time of accession
- $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
- <866> : If no 866 tag existed at the time of accession, it will not be populated during data dump export.
- <866> $a : Textual Holdings - value supplied by ILS at the time of accession.
- <866> $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
- <876>
- $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
- $a : SCSB's Item Id - auto generated at the time of accession in SCSB's database.
- $h : Use Restriction - value supplied by ILS at the time of accession.
- $j : Item Status - item availability status in SCSB at the time of export.
- $p : Item Barcode - value supplied by ILS at the time of accession.
- $t : Copy number - value supplied by ILS at the time of accession.
- $x : Customer Code - value supplied by ILS at the time of accession. <900> $b in SCSB schema.
- $z : Collection Group Designation - value supplied by ILS at the time of accession and further processed through the matching process. <900> $a in SCSB schema.
- In addition, any field/subfield code that was part of the original record during accession, will also be part of the exported record.
SCSB Schema sample
SCSB Schema
<bibRecords> <bibRecord> <bib> <owningInstitutionId>PUL</owningInstitutionId> <matchingInstitutionBibId source="CUL">12345</matchingInstitutionBibId> <!-- Duplicate bib identified in CUL --> <matchingInstitutionBibId source="CUL">23456</matchingInstitutionBibId> <!-- Another duplicate bib identified in CUL --> <matchingInstitutionBibId source="NYPL">34567</matchingInstitutionBibId> <!-- Duplicate bib identified in NYPL --> <content> <collection xmlns="http://www.loc.gov/MARC21/slim"> <record> <leader>01233cas a2200373I 4500</leader> <controlfield tag="001">1</controlfield> <controlfield tag="005">20130405104912.0</controlfield> <controlfield tag="008">860123c19069999ii wr p f0 a0eng d</controlfield> <datafield tag="245" ind1="0" ind2="0"> <subfield code="a">Indian trade journal.</subfield> </datafield> </record> </collection> </content> </bib> <holdings> <holding> <owningInstitutionHoldingsId>1</owningInstitutionHoldingsId> <conthtcent> <collection xmlns="http://www.loc.gov/MARC21/slim"> <record> <datafield tag="852" ind1="0" ind2="0"> <subfield code="b">rcppa</subfield> <!-- Location --> <subfield code="h">TR593 .I6 1990g</subfield> <!-- Call Number --> </datafield> <datafield tag="866" ind1="0" ind2="0"> <subfield code="a">2v. 1991</subfield> <!-- Textual Holdings --> </datafield> </record> </collection> </content> <items> <content> <collection xmlns="http://www.loc.gov/MARC21/slim"> <record> <datafield tag="876" ind1="0" ind2="0"> <subfield code="a">240158</subfield> <!-- Local Item Id --> <subfield code="h"></subfield> <!-- Use Restrictions --> <subfield code="j">Available</subfield> <!-- Item status --> <subfield code="p">CU07416571</subfield> <!-- Item Barcode --> <subfield code="t">1</subfield> <!-- Copy Number --> <subfield code="3">2v.</subfield> <!-- Volume/Part/Year --> </datafield> <datafield tag="900" ind1="0" ind2="0"> <subfield code="a">Shared</subfield> <!-- Open/Shared/Private --> <subfield code="b">CU</subfield> <!-- Customer Code --> </datafield> </record> <record> <datafield tag="876" ind1="0" ind2="0"> <subfield code="a">240157</subfield> <!-- Local Item Id --> <subfield code="h"></subfield> <!-- Use Restrictions --> <subfield code="j">Available</subfield> <!-- Item status --> <subfield code="p">CU13998889</subfield> <!-- Item Barcode --> <subfield code="t">1</subfield> <!-- Copy Number --> <subfield code="3">1v.</subfield> <!-- Volume/Part/Year --> </datafield> <datafield tag="900" ind1="0" ind2="0"> <subfield code="a">Shared</subfield> <!-- Open/Shared/Private --> <subfield code="b">CU</subfield> <!-- Customer Code --> </datafield> </record> </collection> </content> </items> </holding> </holdings> </bibRecord> </bibRecords>
SCSB Schema Explained
- bibRecords: This is the main wrapper tag that contains 1 or more bib record information.
- bibRecord : This is a wrapper tag that holds information about a specific Bib and its associated Holdings and Item information.
- bib: This tag contains meta data about the Bib and information represented in standard Marc format under the content tag.
- Bib Meta Data
- owningInstitutionId : Allowed codes are PUL for Princeton, CUL for Columbia and NYPL for New York Public Libraries.
- owningInstitutionBibId : Either this field or the marc 001 field value is required to indicate Bibliographic Record Id in the host system.
- matchingInstitutionBibId : This will indicate bibliographic Ids that are a match among the partners' record. The attribute 'source' indicates the institution partner to which the matched record belongs. (more on JIRA-344)
- content : This is a wrapper tag for the Bib record in the MarcXml format.
- Bib Meta Data
- holdings : This is a outer wrapper tag for 1 or more Holdings records for the associated Bib.
- holding : This is the wrapper tag that contains holdings meta data information, along with actual holding details and information on 1 or more associated items.
- Holdings Meta Data
- owningInstitutionHoldingsId : Unique system identifier in the partners's ILS (Optional)
- controlField : This indicates the unique ID of the holdings record in the ILS.
- <852> $b : Location (Optional) - Value supplied by the ILS.
- <852> $h : Call Number
- <866> : Textual Holdings information (Optional)
- items : This is the outer wrapper tag for items linked to each holdings record
- record : This has information for individual item.
- <876> $a : Local item id
- <876> $h : Use restrictions; Possible values are:
- Blank - This implies no restrictions.
- In Library Use
- Supervised Use
- <876> $p : Item barcode
- <876> $t : Copy number (Optional)
- <876> $3 : Volume/Part/Year (Optional)
- <900> $a : Collection Group Designation; Possible values are:
- Open
- Shared
- Private
- <900> $b : Customer code - Values are the two letter GFA Customer Code.