*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
NOTE: We need to select the correct value in the column labeled 'field', because the 'content' column contains values for all the data elements of the selected field. Each field contains its own row of data in the marc table, where all the field rows for the same record can be identified by the same instance_id.
It is important to note that the ‘content’ field in the table begins with a 0, which is not included in the character count. So the 7th space indicates the 06 character, and the 8th space is for the 07 character. The code above specifies that we are starting at the 7th space in the contents column, and we are selecting two spaces: the 7th and the 8th.
In the screenshot of the marc table below, the 7th and 8th characters are highlighted in the ‘content’ field. The ‘a’ in the 7th space shows that the resource is language material (from the 06 character) and the ‘m’ in the 8th space shows that the resource is a monograph/item (from the 07 character).
Table 1.
Example code to extract information from the 06 and 07 data from the marc table in Metadb:
...
WHERE field ='000';
The results table below (Table 2) show that rows 1 and 2 are monographs (07=m) which are non-musical sound recordings (06=i). (In library terms, a monograph refers to any non-serial publication including but not limited to books, reports, and audio-visual materials.) The remaining rows can be classified in a smilar manner using the 06 and 07 charcters of tyhe the 000 leader field.
Table 2.
Other Control Fields - 00X (001, 003, 005, 006, 007, 008)
...
There are seven possible material configurations: Books (BK), Computer Files (CF), Maps (MP), Music (MU), Continuing Resources (CR), Visual Materials (VM), and Mixed Materials (MX). Once the material type has been determind determined by the system from the leader field, we can obtain information relevant to that specific material type from the 008 field.
...
A record is determined to be a book if it meets the following criteria in the 000 leader field: (character 6 = a or t) AND (char 7 = a, c, d, or m). If this takes place, then in the 008 field, a record is created using the BK definition. In no place does it say ‘BK’. That’s not a possible code. See this documentation for details. Once the cataloger enters the requisite configuration in the leader 000 field, when they go to the 008 field, they will receive options only for possible book details (see screen shot below from the Cataloger's Reference Shelf documentation).
Example code: the screenshot below contains
SELECT instance_id, field, substring(sm."content", 36, 2) AS "language"
FROM folio_source_record.marc__t AS sm
WHERE field = '008' AND instance_id = 'a1dda667-0d5e-40a6-913c-08b1e26eba85'
;
The results screenshot below (Table 3) contains a row of data from the marc table where the 000 leader field shows that the material is a book (see Table 2, row 5) . In the 008 field, if the material is a book, the characters 35 and 36 describe the language of the book (spaces 36 and 37). Looking at the this row which contains data for the 008 field in spaces 36 and 37, we see that the book is in 'EN' (English).
Table 3.
Fixed field 006 – Additional Material Characteristics
This field is used for information about special aspects of the item being cataloged that cannot be coded in field 008. In the screen shot below, the first two spaces identify form of material. Referring to the documentation, ‘m’ indicates Computer file/Electronic resource. This is the same as for field 008. Everything in 006 appears in the same order as 008, as this is sort of an ‘annex’ field for 008 information.
Table 4 below shows a row of data of the 006 field where the 000 field indiocates it is a computer file. The ‘o’ in the 6th space indicates ‘online’, and the ‘d’ in the 9th space indicates that the computer file type is a document. This is based on the 006 field documentation for ‘computer files’.
Table 4.
