Export Data Dump (through API)

Owned by SK
Last updated: Jun 05, 2017
9 min read

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:controlfield tag="009">15434586</marcxml:controlfield> <!-- Owning Institution's bibliographic id -->
    <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">scsbcul</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">Shared</marcxml:subfield> <!-- Collection Group Designation -->
      <marcxml:subfield code="z">CU</marcxml:subfield> <!-- Customer Code -->
    </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">Shared</marcxml:subfield> <!-- Collection Group Designation -->
      <marcxml:subfield code="z">CU</marcxml:subfield> <!-- Customer Code -->
    </marcxml:datafield>
  </marcxml:record>

MARCXML Schema Explained

  1. <001> : SCSB's Bibliographic Id - auto generated at the time of accession in SCSB's database.
  2. <852> 
    1. $b : Owning Institution code prefixed with 'scsb' (scsbcul for CUL, scsbpul for PUL and scsbnypl for NYPL)
    2. $h : Call Number - value supplied by ILS at the time of accession
    3. $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
  3. <866> : If no 866 tag existed at the time of accession, it will not be populated during data dump export.
    1. <866> $a : Textual Holdings - value supplied by ILS at the time of accession.
    2. <866> $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
  4. <876> 
    1. $0 : SCSB's Holdings Id - auto generated at the time of accession in SCSB's database.
    2. $a : SCSB's Item Id - auto generated at the time of accession in SCSB's database.
    3. $h : Use Restriction - value supplied by ILS at the time of accession. This is defined by the partners as to how their items are to be handled and if they need special care on how it is being lent to patrons. Possible values are:
      1. Blank - This implies no restrictions. To further elaborate, blank would mean the <876> tag and the $h sub tag are present but blank.
      2. In Library Use. This would mean the item cannot be taken out of the library.
      3. Supervised Use. This might mean the item can be accessed only with special equipment in a specialized room under supervision.
    4. $j : Item Status - item availability status in SCSB at the time of export.
    5. $p : Item Barcode - value supplied by ILS at the time of accession.
    6. $t : Copy number - value supplied by ILS at the time of accession.
    7. $x : Collection Group Designation -  The CGD is a designation given to an item by the partner institutions. A private item will remain accessible only to patrons of the owning institution whereas the open and shared designated items are available to be accessed by patrons of all partner institutions. The designation also changes based on certain criteria defined under the matching algorithm rules. <900> $a in SCSB Schema. Possible values are:
      1. Open
      2. Shared
      3. Private
    8. $z : Customer Code - value supplied by ILS at the time of accession. <900> $b in SCSB schema.
  5. 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
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<bibRecords>
	<bibRecord>
		<bib>
			<owningInstitutionId>PUL</owningInstitutionId>
			<owningInstitutionBibId>3824407</owningInstitutionBibId> <!-- Owning Institution Bibliographic Id -->
			<matchingInstitutionBibId source="CUL">3245</matchingInstitutionBibId> <!-- Duplicate bib identified in CUL -->
			<matchingInstitutionBibId source="PUL">8978</matchingInstitutionBibId> <!-- Duplicate bib identified in PUL -->
			<content>
				<collection>
					<record>
						<leader>01257pam a2200349 a 4500</leader>
						<controlfield tag="001">SCSB-3824407</controlfield> 
						<controlfield tag="005">20160826111904.0</controlfield>
						<controlfield tag="008">020829s2003    nyua          000 0deng  </controlfield>
						<datafield ind1=" " ind2=" " tag="010">
							<subfield code="a">  2002030677</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="020">
							<subfield code="a">074322938X</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="035">
							<subfield code="a">(OCoLC)50554424</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="035">
							<subfield code="a">(DLC) 2002030677</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="040">
							<subfield code="a">DLC</subfield>
							<subfield code="c">DLC</subfield>
							<subfield code="d">OrLoB</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="043">
							<subfield code="a">n-us---</subfield>
						</datafield>
						<datafield ind1="0" ind2="0" tag="050">
							<subfield code="a">E889</subfield>
							<subfield code="b">.L54 2003</subfield>
						</datafield>
						<datafield ind1="0" ind2="0" tag="082">
							<subfield code="a">324.973/0929</subfield>
							<subfield code="2">21</subfield>
						</datafield>
						<datafield ind1="1" ind2=" " tag="100">
							<subfield code="a">Lieberman, Joseph I.</subfield>
						</datafield>
						<datafield ind1="1" ind2="3" tag="245">
							<subfield code="a">An amazing adventure :</subfield>
							<subfield code="b">Joe and Hadassah's personal notes on the 2000 campaign /</subfield>
							<subfield code="c">Joe and Hadassah Lieberman ; with Sarah Crichton.</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="260">
							<subfield code="a">New York ;</subfield>
							<subfield code="a">London :</subfield>
							<subfield code="b">Simon &amp; Schuster,</subfield>
							<subfield code="c">c2003.</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="300">
							<subfield code="a">272 p. :</subfield>
							<subfield code="b">ill. ;</subfield>
							<subfield code="c">23 cm.</subfield>
						</datafield>
						<datafield ind1="1" ind2="0" tag="600">
							<subfield code="a">Lieberman, Joseph I.</subfield>
						</datafield>
						<datafield ind1="1" ind2="0" tag="600">
							<subfield code="a">Lieberman, Hadassah.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="650">
							<subfield code="a">Presidents</subfield>
							<subfield code="z">United States</subfield>
							<subfield code="x">Election</subfield>
							<subfield code="y">2000.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="650">
							<subfield code="a">Vice-Presidential candidates</subfield>
							<subfield code="z">United States</subfield>
							<subfield code="v">Biography.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="650">
							<subfield code="a">Legislators</subfield>
							<subfield code="z">United States</subfield>
							<subfield code="v">Biography.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="650">
							<subfield code="a">Legislators' spouses</subfield>
							<subfield code="z">United States</subfield>
							<subfield code="v">Biography.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="650">
							<subfield code="a">Political campaigns</subfield>
							<subfield code="z">United States.</subfield>
						</datafield>
						<datafield ind1=" " ind2="0" tag="651">
							<subfield code="a">United States</subfield>
							<subfield code="x">Politics and government</subfield>
							<subfield code="y">1993-2001.</subfield>
						</datafield>
						<datafield ind1="1" ind2=" " tag="700">
							<subfield code="a">Lieberman, Hadassah.</subfield>
						</datafield>
						<datafield ind1="1" ind2=" " tag="700">
							<subfield code="a">Crichton, Sarah.</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="902">
							<subfield code="a">myt</subfield>
							<subfield code="b">s</subfield>
							<subfield code="6">a</subfield>
							<subfield code="7">m</subfield>
							<subfield code="d">v</subfield>
							<subfield code="f">1</subfield>
							<subfield code="e">20030124</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="904">
							<subfield code="a">myt</subfield>
							<subfield code="b">a</subfield>
							<subfield code="h">m</subfield>
							<subfield code="c">b</subfield>
							<subfield code="e">20030124</subfield>
						</datafield>
						<datafield ind1=" " ind2=" " tag="959">
							<subfield code="a">2003-01-24 13:44:15 -0500</subfield>
						</datafield>
					</record>
				</collection>
			</content>
		</bib>
		<holdings>
			<holding>
				<owningInstitutionHoldingsId>4129325</owningInstitutionHoldingsId>
				<content>
					<collection>
						<record>
							<leader>00000nam a2200000 a 4500</leader>
							<datafield ind1="0" ind2=" " tag="852">
								<subfield code="0">4129325</subfield>
								<subfield code="b">rcppa</subfield> <!-- Location -->
								<subfield code="h">E889 .L54 2003</subfield> <!-- Call Number -->
								<subfield code="x">tr fr dixn</subfield>
								<subfield code="x">tr fr f</subfield>
							</datafield>
						</record>
					</collection>
				</content>
				<items>
					<content>
						<collection>
							<record>
								<datafield ind1=" " ind2=" " tag="876">
									<subfield code="p">32101055406860</subfield> <!-- Item Barcode -->
									<subfield code="h"/> <!-- Use Restrictions -->
									<subfield code="a">3342138</subfield> <!-- Owning Institution Item Id -->
									<subfield code="j">Available</subfield> <!-- Item status -->
									<subfield code="t">1</subfield> <!-- Copy Number -->
									<subfield code="3"/> <!-- Volume/Part/Year -->
								</datafield>
								<datafield ind1=" " ind2=" " tag="900">
									<subfield code="a">Shared</subfield> <!-- Collection Group Designation -->
									<subfield code="b">PA</subfield> <!-- Customer Code -->
								</datafield>
							</record>
						</collection>
					</content>
				</items>
			</holding>
		</holdings>
	</bibRecord>
</bibRecords>

SCSB Schema Explained

  1. bibRecords: This is the main wrapper tag that contains 1 or more bib record information.
  2. bibRecord : This is a wrapper tag that holds information about a specific Bib and its associated Holdings and Item information.
  3. bib: This tag contains meta data about the Bib and information represented in standard Marc format under the content tag.
    1. Bib Meta Data
      1. owningInstitutionId : Allowed codes are PUL for Princeton, CUL for Columbia and NYPL for New York Public Libraries.
      2. owningInstitutionBibId : Either this field or the marc 001 field value is required to indicate Bibliographic Record Id in the host system (partner's ILS).
      3. 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)
    2. content : This is a wrapper tag for the Bib record in the MarcXml format.
  4. holdings : This is a outer wrapper tag for 1 or more Holdings records for the associated Bib.
  5. 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.
  6. Holdings Meta Data
    1. owningInstitutionHoldingsId : Unique system identifier in the partners's ILS (Optional)
  7. controlField : This indicates the unique ID of the holdings record in the ILS.
  8. <852> $b : Location (Optional) - Value supplied by the ILS.
  9. <852> $h : Call Number
  10. <866> : Textual Holdings information (Optional)
  11. items : This is the outer wrapper tag for items linked to each holdings record
  12. record : This has information for individual item.
  13. <876> $a : Local item id. This is the owning institution's item id from the partner's ILS.
  14. <876> $h : Use restrictions; This is defined by the partners as to how their items are to be handled and if they need special care on how it is being lent to patrons. Possible values are:
    1. Blank - This implies no restrictions. To further elaborate, blank would mean the <876> tag and the $h sub tag are present but blank.
    2. In Library Use
    3. Supervised Use
  15. <876> $p : Item barcode. This is the barcode that the partner ILS has allotted to the item sent over to the ReCAP facility.
  16. <876> $t : Copy number (Optional)
  17. <876> $3 : Volume/Part/Year (Optional)
  18. <900> $a : Collection Group Designation (CGD). The CGD is a designation given to an item by the partner institutions. A private item will remain accessible only to patrons of the owning institution whereas the open and shared designated items are available to be accessed by patrons of all partner institutions. The designation also changes based on certain criteria defined under the matching algorithm rules. Possible values are:
    1. Open
    2. Shared
    3. Private
  19. <900> $b : Customer Code. These are codes provided by GFA LAS (Generation Fifth Applications' Library Archival System) at the ReCAP facility. It is used by LAS to identify valid delivery locations for an item.
  20. In addition, any field/subfield code that was part of the original record during accession, will also be part of the exported record.