Format Logic
This document describes the logic that Pika uses to determine various formats for display.
Table of Contents
- 1 Basic Information and Process
- 2 All relevant formats based on MARC data
- 2.1 4K Ultra Blu-Ray
- 2.2 Adult Literacy Book
- 2.3 Archival Materials
- 2.4 Audio, Audio Cassette, Audio CD (all the formats with these labels)
- 2.4.1 Audio CD
- 2.4.2 Audio CD with Blu-Ray
- 2.4.3 Audio CD with CDROM
- 2.4.4 Audio CD with DVD
- 2.4.5 Audio Cassette
- 2.4.6 Audio
- 2.5 Blu-ray
- 2.6 Blu-Ray/4K Ultra HD Blu-Ray Combo Pack
- 2.7 Board Book
- 2.8 Book
- 2.9 Books with Accompanying Materials
- 2.9.1 Book with Audio CD
- 2.9.2 Book with CD-ROM
- 2.9.3 Book with DVD
- 2.9.4 Book with DVD-ROM
- 2.10 Book Club Kit
- 2.11 Braille
- 2.12 Cassette
- 2.13 CD
- 2.13.1 Compact Disc (CD)
- 2.14 CD-ROM
- 2.15 DVD (All Formats with the DVD Label)
- 2.15.1 DVD
- 2.15.2 Video Disc (DVD)
- 2.16 DVD/Blu-Ray Combo Pack
- 2.17 Electronic
- 2.18 Game Systems
- 2.19 Go Reader
- 2.20 Globe
- 2.21 Graphic Novel
- 2.22 Illustrated Edition
- 2.23 Journal
- 2.24 Kit
- 2.25 Large Print
- 2.26 Manuscript
- 2.27 Map (All the formats with the Map label)
- 2.27.1 Atlas (Map)
- 2.27.2 Map
- 2.28 Microfilm
- 2.29 Mixed Materials
- 2.30 MP3 Audio CD
- 2.31 Music CD
- 2.32 Music CD with DVD
- 2.33 Music Recording
- 2.34 Musical Score
- 2.35 Newspaper
- 2.36 Painting
- 2.37 Phonograph
- 2.38 Photo (All the formats with the Photo label)
- 2.38.1 Chart (Photo)
- 2.38.2 Collage (Photo)
- 2.38.3 Drawing (Photo)
- 2.38.4 Flash Card (Photo)
- 2.38.5 Photo
- 2.38.6 Photonegative (Photo)
- 2.38.7 Print (Photo)
- 2.39 Physical Object
- 2.40 Playaway
- 2.41 Playaway Launchpad
- 2.42 Playaway View
- 2.43 Read-Along Book (All formats labeled as Read-Along Book)
- 2.43.1 VOX Book (Read-Along Book)
- 2.43.2 WonderBooks (Read-Along Book)
- 2.44 Seed Packet
- 2.45 Sensor Image
- 2.46 Serial
- 2.47 Slide (All the formats with the Slide label)
- 2.47.1 Slide
- 2.47.2 Transparency (Slide)
- 2.48 Software (All the formats with the Software label)
- 2.48.1 Chip Cartridge (Software)
- 2.48.2 Disk Cartridge (Software)
- 2.48.3 Floppy Disk (Software)
- 2.48.4 Software
- 2.48.5 Tape Cartridge (Software)
- 2.49 Tape Recording (position 3 - K, L, M, N, O, P, R)
- 2.50 Thesis
- 2.51 Vertical File
- 2.52 VHS or Video (All formats with the VHS or Video label)
- 2.52.1 Filmstrip (Video)
- 2.52.2 Motion Picture (Video)
- 2.52.3 Video
- 2.52.4 Video Cartridge (Video)
- 2.52.5 Video Cassette (VHS)
- 2.52.6 Video Reel (Video)
- 2.53 WonderBook (Labeled as PlayStation 3)
- 2.54 Yoto Cards
- 2.54.1 Yoto Story Cards
- 2.54.2 Yoto Music Card
- 3 Normalized formats based on MARC data
- 3.1 Blu-ray
- 3.2 CD
- 3.3 Compact Disc
- 3.4 DVD
- 3.5 DVD
- 3.6 DVD
- 3.7 Game Formats
- 3.8 Graphic Novel
- 3.9 Kit
- 3.10 Large Print
- 3.11 Large Print
- 3.12 Manuscript
- 3.13 Map
- 3.14 MP3 Audio Disc
- 3.15 Music Cassette
- 3.16 Music CD
- 3.17 Music Score
- 3.18 Playaway
- 3.19 Sound Cassette
- 3.20 Sound Cassette
- 3.21 Sound Disc
- 3.22 Sound Disc
- 3.23 Sound Disc
- 3.24 Sound Disc
- 3.25 Video Cassette
- 3.26 Video Disc
- 4 Format > Readable Labels Translations
- 5 eContent IType Translation Map
- 6 Format Category
- 7 How to expand the MARC Leader, MARC 007 & MARC 008 fields in Sierra
- 8 Checking your work using Pika
- 9 Related Documentation
Basic Information and Process
When building format facet logic, Pika references a combination of information from the MARC record. We reference location codes, i-types, and material types. Formats can be determined by material type, location type, collection code, i-Types, etc. At Marmot we cannot use these alone, because they are either not discreet enough, or they conflict.
The process for format determination always starts by examining the MARC Leader to determine whether or not the leader position 6 is J for an initial determination of MusicRecording. After this determination, Pika will reference mapping based on other fields in the MARC, as described below. Typically, information in the leader field is used for format determination as a last option. When using the MARC leader, characters are counted using MARC record position counting that is similar to program position counting. Similarly, the 007 is the second to last option for format determination and is only applied if format determination cannot be referenced from any other MARC fields.
All relevant formats based on MARC data
4K Ultra Blu-Ray
MARC 250 Edition Statement, subfield a
MARC 300 Physical Description, any subfield except e
MARC 347 Digital File Characteristics, subfield b
MARC 538 Note Field, subfield a
MARC 250 Edition Statement
Pika references the 250 Edition Statement. Pika references the subfield a. If the subfield a has the following phrase :
4k ultra hd blu-ray
4k ultra hd bluray
4k ultrahd blu-ray
4k ultrahd bluray
4k uh blu-ray
4 k uh bluray
4k ultra high-definition blu-ray
4k ultra high-definition bluray
4k ultra high definition blu-ray
4k ultra high definition bluray
4k ultra hd
it will be determined as 4K Ultra Blu-Ray.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Pika references any subfield aside from subfield e. If a subfield exists (except for e) and has the following phrase :
4k ultra hd blu-ray
4k ultra hd bluray
4k ultrahd blu-ray
4k ultrahd bluray
4k uh blu-ray
4 k uh bluray
4k ultra high-definition blu-ray
4k ultra high-definition bluray
4k ultra high definition blu-ray
4k ultra high definition bluray
4k ultra hd
it will be determined as 4K Ultra Blu-Ray.
MARC 347 Digital File Characteristics
Pika references the 347 Digital File Characteristics. Pika references the subfield b. If the subfield b has the following phrase :
4k ultra hd blu-ray
4k ultra hd bluray
4k ultrahd blu-ray
4k ultrahd bluray
4k uh blu-ray
4 k uh bluray
4k ultra high-definition blu-ray
4k ultra high-definition bluray
4k ultra high definition blu-ray
4k ultra high definition bluray
4k ultra hd
it will be determined as 4K Ultra Blu-Ray.
MARC 538 Note Field
Pika references the 538 Notes field. Pika references the subfield a. If the subfield a has the following phrase :
4k ultra hd blu-ray
4k ultra hd bluray
4k ultrahd blu-ray
4k ultrahd bluray
4k uh blu-ray
4 k uh bluray
4k ultra high-definition blu-ray
4k ultra high-definition bluray
4k ultra high definition blu-ray
4k ultra high definition bluray
4k ultra hd
it will be determined as 4K Ultra Blu-Ray.
Adult Literacy Book
MARC 650, any subfield.
MARC 655, any subfield.
MARC 650 Topical Subject Term
Pika references the 650 Topical Subject term. Pika references any subfield. If any subfield has the phrase “Readers for new literates” it will be determined as Adult Literacy Book.
MARC 655 Genre/Form Term
Pika references the 655 Genre/Form term. Pika references any subfield. If any subfield has the phrase “Readers for new literates” it will be determined as Adult Literacy Book.
Archival Materials
MARC 590 Local Note, subfield a
MARC 590 Local Note
Pika references the 590 Local Note. Pika references the subfield a. If the subfield a has the phrase “archival materials” it will be determined as Archival Materials.
Audio, Audio Cassette, Audio CD (all the formats with these labels)
Audio CD
MARC 007
Position 0 - letter s (sound recording)
Position 1 - letter d (sound disc)
Position 3 - letter z (other)
MARC 300 Physical Description, any subfield except e
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 d (sound disc). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), the 007-character position 1 (Spec Mat) has the letter d (sound disc), and 007-character position 3 (speed) has the letter z (other), it will be determined as an Audio CD.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Pika references the any subfield expect subfield e - Accompanying material. If a subfield exists (except for e) and it has the following phrase:
audio disc
sound disc
it will be determined as a Audio CD.
Audio CD with Blu-Ray
MARC 007
position 0 - letter s (sound recording)
position 1 - letter d (sound disc)
position 3 - letter z (other)
MARC 300 Physical Description, any subfield except e
MARC 347 Digital File Characteristics, subfield a
MARC 538, subfield a
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 d (sound disc). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), the 007-character position 1 (Spec Mat) has the letter d (sound disc), and 007-character position 3 (speed) has the letter z (other), it will be determined as a Sound Disc.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Looking at all the different subfields. Pika references the anything, but subfield e - Accompanying material. If a subfield exists (except for e) and If it is ‘Bluray’ or ‘Blu-ray’, it will be determined as an Audio CD with Blu-Ray.
MARC 347 Digital File Characteristics
Pika references 347 Digital File Characteristics. Pika references the subfield a. If subfield a has the phrase bluray or blu-ray, it will be determined as a Blu-ray.
MARC 538 Note Field
Pika references the 538 Notes field. We are going to look at subfield a. If subfield a has the phrase Blu-ray or Bluray, it will be determined as an Audio CD with Blu-Ray.
Audio CD with CDROM
MARC 007
position 0 - letter s (sound recording)
position 1 - letter d (sound disc)
position 3 - letter z (other)
MARC 300 Physical Description, any subfield except e
MARC 538, subfield a
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 d (sound disc). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), the 007-character position 1 (Spec Mat) has the letter d (sound disc), and 007-character position 3 (speed) has the letter z (other), it will be determined as a Sound Disc.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Looking at all the different subfields. Pika references the anything, but subfield e - Accompanying material. If a subfield exists (except for e) and If it is ‘CDROM’ or ‘DVDROM’, it will be determined as an Audio CD with CDROM.
MARC 538 Note Field
Pika references the 538 Notes field. We are going to look at subfield a. If subfield a has CDROM or DVDROM, it will be determined as an Audio CD with CDROM.
Audio CD with DVD
MARC 007
position 0 - letter s (sound recording)
position 1 - letter d (sound disc)
position 3 - letter z (other)
MARC 300 Physical Description, any subfield except e
MARC 347 Digital File Characteristics, subfield b
MARC 538, subfield a
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 d (sound disc). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), the 007-character position 1 (Spec Mat) has the letter d (sound disc), and 007-character position 3 (speed) has the letter z (other), it will be determined as a Sound Disc.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Looking at all the different subfields. Pika references the anything but subfield e - Accompanying material. If a subfield exists (except for e) and if it is ‘DVD’, it will be determined as an Audio CD with DVD.
MARC 347 Digital File Characteristics
Pika references 347 Digital File Characteristics. Pika references the subfield b. If subfield b is a DVD, it will be determined as an Audio CD with DVD.
MARC 538 Note Field
Pika references the 538 Notes field. We are going to look at subfield a. If subfield a has DVD, it will be determined as an Audio CD with DVD.
Audio Cassette
MARC 007
Position 0 - letter s (sound recording)
Position 1 - letter s (Sound cassette)
MARC 300 Physical Description, any subfield except e
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 s (sound cassette). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), and the 007-character position 1 (Spec Mat) has the letter s (sound cassette), it will be determined as a Audio Cassette.
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Looking at all the different subfields. Pika references every subfield except subfield e. If a subfield exists (except for e) and is has the phrase “sound cassette” it will be determined as a Audio Cassette.
Audio
MARC leader
Position 6 - letter i (nonmusical sound recording)
MARC 007
Position 0 - letter s (sound recording)
Position 1 - letter z (other)
MARC 245 (title statement)
subfield k
subfield p
MARC Leader – Position 6 (Type of Record)
Pika references the MARC Leader Position 6 (REC TYPE). If there is the letter i (nonmusical sound recording), it will be determined as Audio.
MARC 245 Title Statement
Pika references the 245 Title Statement. Pika references the subfield k. If the subfield k is a sound recording, it will be determined as Audio.
MARC 245 Title Statement
Pika references the 245 Title Statement. Pika references the subfield p. If the subfield p is a sound recording, it will be determined as Audio.
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 s (sound recording) and 007 z (other). If the 007-character position 0 (Mat Catg) has the letter s (sound recording), and the 007-character position 1 (Spec Mat) has the letter z (other), it will be determined as Audio.
Blu-ray
MARC 300 Physical Description, any subfield except e
MARC 347 Digital File Characteristics, subfield b
MARC 538, subfield a
MARC 300 Physical Description Field
Pika references the 300 Physical Description field. Pika references all subfields except for subfield e. If a subfield exists (except for e) and has the phrase bluray or blu-ray, it will be determined as a Blu-ray.
MARC 347 Digital File Characteristics
Pika references 347 Digital File Characteristics. Pika references the subfield b. If subfield b has the phrase bluray or blu-ray, it will be determined as a Blu-ray.
MARC 538 Notes Field
Pika references the 538 Notes field. Pika references the the subfield a. If subfield a has the phrase bluray or blu-ray, it will be determined as a Blu-ray.
Blu-Ray/4K Ultra HD Blu-Ray Combo Pack
MARC 250 Edition Statement, subfield a
MARC 300 Physical Description, subfield a
MARC 250 Edition Statement
Pika references the 250 Edition Statement. Pika references the subfield a. If the subfield a has the following phrase :
4k ultra hd + blu-ray
4k ultra hd blu-ray + blu-ray
blu-ray + 4k ultra hd
4k ultra hd/blu-ray combo
it will be determined as a Blu-Ray/4K Ultra HD Blu-Ray Combo Pack.
MARC 300 Physical Description
Pika references the 300 Physical Description. Pika refernces the subfield a. If the subfield a has the phrase “1 blu-ray disc + 1 4K Ultra HD” it will be determined as a Blu-Ray/4K Ultra HD Blu-Ray Combo Pack.
Board Book
MARC 250 Edition Statement, subfield a
MARC 500 General Note, subfield a
MARC 650 Subject, subfield a
MARC 655 Index term Genre/Form, subfield a
MARC 250 Edition Field
Pika references the 250 Edition Statement. Pika references the subfield a. Pika references subfield a. If the subfield a has the phrase “board book” it will be determined as a Board Book.
MARC 500 General Note
Pika references the 500 General Note field. Pika references subfield a. If the subfield a has the phrase “board book” it will be determined as a Board Book.
MARC 650 Subject Field
Pika references the subject information from the MARC 650 field. Pika references the the subfield a. If the subfield a has the phrase “board books” it will be determined as a Board Book.
MARC 655 Index Term-Genre/Form
Pika references the 655 Index Term-Genre/Form. Pika references the the subfield a. If the subfield a has the phrase “board books” it will be determined as a Board Book.
Book
MARC Leader position 7 (bibliographic level) - letter m
MARC 007
Position 0 - letter t (text)
Position 1 - letter a (regular print)
MARC 300 Physical Description, any subfield except e
MARC Leader – Position 7 (Bibliographic Level)
Pika references the MARC Leader Position 7. If there is the letter M – Monograph/Item, and we have not found a format yet, the format is Book.
MARC 007- Physical Description Fixed Field-General Information
Pika references the 007 t (text) and 007 a (regular print). If the 007-character position 0 (Mat Catg) has the letter t (text), and the 007-character position 1 (Spec Mat) has the letter a (regular print), it will be determined as a Book.
MARC 300 Physical Description
Pika references the 300 Physical Description field. Looking at all the different subfields. Pika references anything, but subfield e - Accompanying material. Pika references a page count. If there is a page count, we will assume that it is some type of book.
Books with Accompanying Materials
MARC 300 Physical Description, any subfield except e
MARC 300 Physical Description, subfield e
For all books with accompanying materials, the first check will be to determine if the primary material is a book. After the first check, Pika will use other MARC data to determine the format of the accompanying material.
Some books with accompanying materials use existing logic to determine the accompanying materials format, with an additional fall backs, as noted below.
Book with Audio CD
Reference format determination for Book
MARC 300 Physical description, subfield e
Reference format determination for Sound Disc (Audio CD)
MARC 300 Physical description, subfield e
Process
If the record is determined as a Book, we will reference the MARC 300 Physical description subfield e. If the phrase Audio Disc is found, it will be determined as a Book with Audio CD.
If the record is determined as a Sound Disc (Audio CD), we will reference MARC 300 Physical description subfield e. If the phrase Book is found, it will be determined as a Book with Audio CD.
Book with CD-ROM
Reference format determination for CD ROM
MARC Leader position 6 (type of record) - letter a (language material)
Process