a checked box indicates that bibLoad.pl has been coded for the relevant data and tested to make sure that it works - red text indicates that bibLoad.pl has not yet been coded

  • leader

    • if 07 = i then modeOfIssuance = integrating resource
    • if 07 = m

      • and 19 = # then modeOfIssuance = single unit

      • and 19 = a, b, or c then modeOfIssuance = multipart monograph !!! there aren't any !!!

    • if 07 = s then modeOfIssuance = serial

  • 001 – instances.identifiers 

    • solrID

  • 008 – pos. 35-37 = instance.languages (see also 041)

  • 010 – instances.identifiers

  • 020 – instances.identifiers

  • 022 – instances.identifiers

  • 035 – instances.identifiers

    • OCLC

    • Sirsi catalog key

  • 041 – instance.languages (see also 008)

  • 100 – instances.contributors.name

    • contributorNameType = Personal name
    • contributorType = 100$e

  • 110 – instances.contributors.name
    • contributorNameType = Corporate name
    • contributorType = 110$e
  • 111 – instances.contributors.name
    • contributorNameType = Meeting name
    • contributorType = 111$j
  • 130 – instances.alternativeTitles
    • alternativeTitleType = Uniform title
  • 210 – instances.alternativeTitles
    • if 2nd indicator = # then alternativeTitleType = Abbreviated key title
    • if 2nd indicator = 0 then alternativeTitleType = Abbreviated key title
  • 222 – instances.alternativeTitles
    • alternativeTitleType = Key title
  • 240 – instances.alternativeTitles
    • alternativeTitleType = Uniform title
  • 242 – instances.alternativeTitles
    • alternativeTitleType = Translation of title
  • 243 – instances.alternativeTitles
    • alternativeTitleType = Collective uniform title
  • 245 – instances.title
    • instances.indexTitle (title normalized for browsing and searching; based on the title with articles removed per 2nd indicator)
  • 246 – instances.alternativeTitles
    • if 2nd indicator = # then alternativeTitleType = No type specified
    • if 2nd indicator = 0 then alternativeTitleType = Portion of title
    • if 2nd indicator = 1 then alternativeTitleType = Parallel title
    • if 2nd indicator = 2 then alternativeTitleType = Distinctive title
    • if 2nd indicator = 3 then alternativeTitleType = Other title
    • if 2nd indicator = 4 then alternativeTitleType = Cover title
    • if 2nd indicator = 5 then alternativeTitleType = Added title page title
    • if 2nd indicator = 6 then alternativeTitleType = Caption title
    • if 2nd indicator = 7 then alternativeTitleType = Running title
    • if 2nd indicator = 8 then alternativeTitleType = Spine title
  • 247 – instances.alternativeTitles
    • alternativeTitleType = Former title
  • 250 – instances.editions
  • 260 – instances.publication...
  • 264 – instances.publication...
  • 300 – instances.physicalDescriptions
  • 336 – instances.instanceTypeId (aka Resource type)
  • 338 – instances.instanceFormatIds
  • 490 – instances.series
  • 5xx – instances.notes
  • 6xx – instances.subjects
  • 700 – instances.contributors
    • contributorType = 700$e
  • 710 – instances.contributors
    • contributorType = 710$e
  • 711 – instances.contributors
    • contributorType = 711$j
  • 720 – instances.contributors
    • contributorType = 720$e
  • 730 – instances.alternativeTitles
    • alternativeTitleType = Uniform title
  • 740 – instances.alternativeTitles
    • alternativeTitleType = Uncontrolled related/analytical title
  • 800 – instances.series
  • 810 – instances.series
  • 811 – instances.series
  • 830 – instances.series
  • 856 – instances.electronicAccess
    • 2nd indicator – relationshipId
    • 856$3 – materialsSpecification
    • 856$u – uri
    • 856$y – linkText
    • 856$z – publicNote
  • 999
    • $a – if callNumber !~ /^XX/ → holdingsRecord.callNumber
    • $i – if barcode !~ /-/ then → items.barcode
    • $k (current location)
      • if $k is CATALOG, CATALOGING temporaryLocation = Tech Services; items.status = In process
      • if $k is DAMAGED temporaryLocation = Repair
      • if $k is DISCARD don't create item - if there are no other items then instance.status = discarded
      • if $k is DISPLAY temporaryLocation = Main Library Exhibits 
      • if $k is LOST, LOST-ASSUM then items.status = Declared lost
      • if $k is MISSING then items.status = Missing
      • if $k is REPAIR temporaryLocation = Repair
      • if $k is WITHDRAWN don't create item - if there are no other items then instance.status = Discarded
    • $l (home location)
      • University Library (UL)

        • Circulating Collection (CC) → loanType = can circulate
          • Level A (CC1) !!! not relevant to the old ILS !!!
          • FOLIO, OVERSIZE → Level A Folio (CC2)
          • if $l = STACKS & $a =~ /^[4-7]/  → Level B (CC3)
          • if $l = STACKS & $a =~ /^H[E-X]/ or $a =~ /^[JKLMNPQRSTUVZ]/ → Level C (CC4)
          • if $l = STACKS & $a =~ /^[CDEFG]/ or $a =~ /^H[0-9]/ or $a =~ /^H[A-D]/ → Level D (CC6)
          • if $l = STACKS & $a =~ /^1/ or $a =~ /^2[3-9]/ or $a =~ /^3/ or $a =~ /^8/ or $w = ASIS & $t = THESIS-C → Level E (CC7)
          • if $l = STACKS & $a =~ /^2[0-2]/ or $a =~ /^9/ or $a =~ /^[A-B]/ → Level F (CC8)
          • MEDIALIB → Media Library (CC9); 
        • Government Documents (GD)
          • UN-CIRC → Level A UN Docs (GD1); instances.natureOfContentTerm = GovDocs
          • UN-NONCIRC → Level A UN Docs (GD1); loanType = reading roominstances.natureOfContentTerm = GovDocs
          • US-CIRC, USGOVDOCS → Level A US Docs (GD2)instances.natureOfContentTerm = GovDocs
          • US-NONCIRC → Level A US Docs (GD2)loanType = reading roominstances.natureOfContentTerm = GovDocs
          • NJDOCS → Level A NJ Docs (GD3)instances.natureOfContentTerm = GovDocs
          • Level A GovDoc Microforms (GD4)instances.natureOfContentTerm = GovDocs
        • Journals (J) → loanType = reading room
          • ATRIUM → Level C Atrium (J1)
          • Level A Journals (J2)
          • Level A Journal Microforms (J3) 
        • Library Offices (LO)
          • ILLOFF → Inter-Library Loan (LO1)
          • REFOFF → Reference (LO2); instances.natureOfContentTerm = Reference
          • PRESERV, REPAIR → Repair (LO3)
          • ACQ, CATALOG, CATALOGING → Tech Services (LO4)
          • THEO → Theo Librarian (LO5)
          • Main Library Exhibits (LO6) !!! this is only ever a temporary location !!!
          • OFFSITE, STORAGE → Reserves Storage (LO7); loanType = course reserves
        • Reference Collection (RC) → loanType = reference
          • ATLAS → Level C Atlases (RC1)instances.natureOfContentTerm = Reference
          • REFERENCE → Level C Reference (RC2); instances.natureOfContentTerm = Reference
          • REFCOUNTER → Level C Ref Desk (RC3); instances.natureOfContentTerm = Reference
          • MICROFORM → Level A Ref Microforms (RC4); instances.natureOfContentTerm = Reference
          • SCILIB → Science Library (RC5)
      • United Methodist Archives and History Center (UMAHC) → loanType = reading room

        • Methodist Library (ML)

          • METHLIB → Compact Shelving (ML1)
          • METHMFORM → Microforms (ML2)
          • METHREADNG → Wilson Reading Room (ML3)
        • Special Collections (SC)

          • 19CENT → 19th Century (SC1)

          • BIBLE → Bible (SC2)

          • BLACK → Black (SC3)
          • BYNNER → Bynner (SC4)
          • BYRON → Byron (SC5)
          • CATHER → Cather (SC6)
          • CHESLER → Chesler (SC7)
          • DORNAN → Dornan (SC8) !!! there's nothing here yet !!!
          • ELLIS → Ellis (SC9)
          • FRAG-PER → Fragile Periodicals (SC10)
          • HABERLY → Haberly (SC12)
          • HYMNBOOK → Hymn Book (SC13)
          • KOHLER → Kohler (SC14)
          • KORNITZER → Kornitzer (SC15)
          • KUMIN → Kumin (SC16)
          • LANDAU → Landau (SC17)
          • MCCLINTOCK → McClintock (SC18)
          • MICHALSON → Michalson (SC19)
          • PHONODISC → Phonodiscs (SC20)
          • POPCULTURE → Popular Culture (SC21)
          • PRAYERBOOK → Prayer Book (SC22)
          • RAREBOOKS → Rare Books (SC23)
          • SIMENON → Simenon (SC24)
          • THOMAS → Thomas (SC25)
          • WESTAR → Westar (SC26)
          • WGST → Gender and Sexuality (SC11)
          • ZUCK → Zuck (SC27)
        • University Archives (UA)
          • ARCHIVES → Archives (UA1)
          • FAC-ALUM → Faculty-Alumni (UA2)
          • HERBERG → Herberg (UA3)
          • Level G (UA4) !!! not relevant to the old ILS !!!
          • THESIS → Theses and Dissertations (UA5)instances.natureOfContentTerm = Theses & Dissertations
    • $t (item type)
      • AUDIOTAPE → audio cassette
      • AV → film reel
      • AV-EQUIP → av equipment

      • BOOK → book
      • CD-AUD-NC → CD
      • CD-AUDIO → CD
      • CD-ROM-C → CD-ROM
      • CD-ROM-NC → CD-ROM
      • DVD-C → DVD; instance.natureOfContentTerm = Video
      • DVD-ML → DVD; instance.natureOfContentTerm = Video
      • DVD-NC → DVD; instance.natureOfContentTerm = Video
      • E-BOOK → do not create item
      • E-DATABASE → do not create item
      • E-JRNL → do not create item
      • E-REF → do not create item
      • ELECRSOURC → do not create item
      • GOVDOC-C → bookinstances.natureOfContentTerm = GovDocs
      • GOVDOC-NC → bookloanType = reading roominstances.natureOfContentTerm = GovDocs
      • LOCKERKEY → room/locker key
      • MANUSCRIPT → manuscript
      • METH-REF → book
      • METHLIBBK → book
      • MICROFICHE → microfiche
      • MICROFILM → microfilm
      • NJDOCS → bookinstances.natureOfContentTerm = GovDocs
      • PAMPHLET → pamphlet
      • PERIODICAL → periodical
      • PHONO-NC → phono disc
      • POSTER → poster
      • RAREBOOK → book
      • REF-BOOK → book
      • ROOMKEY → room/locker key
      • SC-BIGBK-H → folio-h
      • SC-BIGBK-V → folio-v
      • SC-BOOK → book
      • SC-MSS → manuscript
      • SC-SERIAL → periodical
      • SPECIAL → book
      • SUPERFICHE → superfiche
      • THESIS-C book; instances.natureOfContentTerm = Theses & Dissertations
      • THESIS-NC → book; instances.natureOfContentTerm = Theses & Dissertations
      • ULTRAFICHE → ultrafiche
      • USGOVDOCS → bookinstances.natureOfContentTerm = GovDocs
      • VIDEO-C → video cassetteinstances.natureOfContentTerm = Video
      • VIDEO-ML → video cassetteinstances.natureOfContentTerm = Video
      • VIDEO-NC → video cassetteinstances.natureOfContentTerm = Video
      • VIDEO-STR → do not create item; instance.natureOfContentTerm = Video
    • $w – holdingsRecord.callNumberTypeId


Some data is not in the MARC record:

  • Analytic Position
  • Cataloged date (catalogedDate) date format = yyyy-mm-dd
  • Item categories
  • Item notes
    • Circ
    • Public
    • Staff
  • Shadowed item in the ILS ~ discoverySuppress = true in FOLIO
    • because of the juggling required to associate locations with call numbers rather than items it is necessary to shadow items in FOLIO who's call numbers are shadowed in the ILS
  • Shadowed title in the ILS ~ discoverySuppress = true in FOLIO


Holdings statements are in the MARC Holdings Records... 

  • 852$c → holdingsRecord.location
  • 863$a-d → items.enumeration
  • 863$i-l → items.chronology
  • 863$x → items.notes; itemNoteType = Staff; staffOnly = true !!! there aren't any !!!
  • 863$z → items.notes; itemNoteType = Public; staffOnly = false
  • 866$a → holdingsRecord.holdingsStatements.statement
  • 866$x;z → holdingsRecord.holdingsStatements.note
  • 867$a → holdingsRecord.holdingsStatementsForSupplements.statement
  • 867$x;z → holdingsRecord.holdingsStatementsForSupplements.note
  • 868$a → holdingsRecord.holdingsStatementsForIndexes.statement
  • 868$xz → holdingsRecord.holdingsStatementsForIndexes.note


  • No labels