1 -- ***********************************************************************
2 -- KOHA UNIMARC STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK
3 -- DEVELOPMENT NOTES AND SUPPLEMENTARY SQL
5 -- Pretest Version 0.0.1
9 -- with much more work remaining
10 -- (PLEASE SEE WARNING BELOW)
13 -- originally compiled
18 -- UNIMARC manual : bibliographic format 1994 / IFLA Universal
19 -- Bibliographic Control and International MARC Core Programme (UBCIM). -
20 -- "The following list represents the state of the format as at 1 March
21 -- 2000. It includes the changes published in Update 3." -
22 -- http://www.ifla.org/VI/3/p1996-1/sec-uni.htm .
24 -- ***********************************************************************
27 -- *********************************************************************
28 -- These development notes and supplementary SQL statements have been
29 -- moved from the main file for easier readability of the main file and
30 -- to avoid possible bugs with lack of time to test for the use of
31 -- letters in field names such as used by RLIN to avoid conflict with
32 -- numbered field names already in use.
34 -- Retaining this file is important for future MARC frameworks
36 -- *********************************************************************
39 -- ****************************************************************************
43 -- Modestly corrected and augmented. Missing many elements. The work of the
44 -- original compiler had been done before significant improvements to Koha
45 -- MARC frameworks implementation had been introduced in 2006 for displaying,
46 -- editing, and preserving record data.
48 -- The documentation cited by the original compiler is known to be out of date
49 -- and incomplete. Furthermore, the original compiler did not include all
50 -- fields and subfields from the documentation he consulted.
52 -- Completely unsafe for production use without significant correction and
53 -- augmentation. These problems could be fixed but a few days work would be
54 -- required to fix them completely. -- thd.
55 -- ****************************************************************************
58 SET FOREIGN_KEY_CHECKS = 0;
61 -- ******************************************************
62 -- KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
63 -- ******************************************************
66 -- Original Record ID Field/Subfields
69 -- INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
70 -- ('090', 'Biblio Number (Koha)', 'Biblio Number (Koha)', 0, 0, '', '');
72 -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
73 -- ('090', '9', 'Biblio Number (Koha)', 'Biblio Number (Koha)', 0, 0, 'biblio.biblionumber', 0, '', '', '', 0, -5, '', '', '', NULL),
74 -- ('090', 'a', 'BiblioItem Number (Koha)', 'BiblioItem Number (Koha)', 0, 0, 'biblioitems.biblioitemnumber', 0, '', '', '', 0, -5, '', '', '', NULL);
77 -- Current Record ID Field/Subfields
79 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
80 ('999', 'System Control Numbers (Koha)', 'System Control Numbers (Koha)', 0, 0, '', '');
82 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
83 ('999', '9', 'Koha biblio number (autogenerated)', 'Koha biblio number', 0, 0, 'biblio.biblionumber', -1, '', '', '', 0, -5, '', '', '', NULL),
84 ('999', 'a', 'Koha biblioitem number (autogenerated)', 'Koha biblioitem number', 0, 0, 'biblioitems.biblioitemnumber', -1, '', '', '', 0, -5, '', '', '', NULL);
87 -- ******************************************************
90 -- Original primary biblioitems Field/Subfields
93 -- INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
94 -- ('990', 'Biblio Type (Koha)', 'Biblio Type (Koha)', 0, 1, '', '');
96 -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
97 -- ('990', 'a', 'Biblio Type (Koha)', 'Biblio Type', 0, 0, 'biblioitems.itemtype', 0, 'itemtypes', '', NULL, 0, 0, '', '', '', NULL);
101 -- Plugins which need to be written for primary biblioitems Field/Subfields.
104 -- ('990', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'biblioitems.cn_source', 9, '', '', 'unimarc_en_classcodes.pl', NULL, 0, '', '', '', NULL),
105 -- ('990', 'h', 'Classification part', 'Classification part', 0, 0, 'biblioitems.cn_class', 9, '', '', 'unimarc_callnumber.pl', NULL, 0, '', '', '', NULL),
109 -- Current primary biblioitems Field/Subfields
112 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
113 ('990', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', '');
115 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
116 ('990', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, -5, '', '', '', NULL),
117 ('990', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'biblioitems.cn_source', 9, '', '', '', NULL, 0, '', '', '', NULL),
118 ('990', '6', 'Koha normalized classification for sorting', 'Koha normalized classification for sorting', 0, 0, 'biblioitems.cn_sort', -1, '', '', '', 0, 7, '', '', '', NULL),
119 ('990', 'a', 'Koha item type [OBSOLETE]', 'Koha item type [OBSOLETE]', 0, 0, '', 9, '', '', '', NULL, -5, '', '', '', NULL),
120 ('990', 'c', 'Koha item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 0, '', '', '', NULL),
121 ('990', 'e', 'Edition', 'Edition', 0, 0, 'biblioitems.cn_edition', 9, 'CN_EDITION', '', '', NULL, 0, '', '', '', NULL),
122 ('990', 'h', 'Classification part', 'Classification part', 0, 0, 'biblioitems.cn_class', 9, '', '', '', NULL, 0, '', '', '', NULL),
123 ('990', 'i', 'Item part', 'Item part', 1, 0, 'biblioitems.cn_item', 9, '', '', '', NULL, 9, '', '', '', NULL),
124 ('990', 'k', 'Call number prefix', 'Call number prefix', 0, 0, 'biblioitems.cn_prefix', 9, '', '', '', NULL, 0, '', '', '', NULL),
125 ('990', 'm', 'Call number suffix', 'Call number suffix', 0, 0, 'biblioitems.cn_suffix', 9, '', '', '', 0, 0, '', '', '', NULL);
129 -- ******************************************************
132 -- Recommandation 995 is designed for interlibrary loan. It is not designed
133 -- for holdings even if libraries have used it for holdings.
135 -- Original items Field/Subfields
138 -- Recommandation 995 sur la fourniture de données locales dans les
139 -- échanges de notices bibliographiques en UNIMARC accompagnant le prêt
140 -- ou le dépôt d'exemplaires / ABF (Association des bibliothécaires
141 -- français) ; FULBI (Fédération des utilisateurs de logiciels de
142 -- bibliothèque) ; ADBDP (Association des directeurs de bibliothèques
143 -- départementales de prêt) ; ADBGV (Association des directeurs de
144 -- bibliothèques municipales et intercommunales des grandes villes de
145 -- France) ADDNB (Association pour le développement des documents
146 -- numériques en bibliothèque.
149 -- INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
150 -- ('995', 'Holdings', 'Holdings', 0, 0, '', ''),
152 -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
153 -- ('995', '9', 'Itemnumber (Koha Itemnumber))', '', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, '', '', '', NULL),
154 -- ('995', 'a', 'Origin of Item (Free Text)', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL),
155 -- ('995', 'b', 'Owner Library', '', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
156 -- ('995', 'c', 'Holding Branch', '', 0, 1, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
157 -- ('995', 'd', 'Code of Lending or Depository Institution', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
158 -- ('995', 'e', 'Localization of Item', '', 0, 1, '', 10, '', '', '', 0, 0, '', '', '', NULL),
159 -- ('995', 'f', 'Inventory Number', '', 0, 0, '', 10, '', '', '', 0, 0, '', '', '', NULL),
160 -- ('995', 'g', 'Barcode Prefix', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
161 -- ('995', 'h', 'Barcode Incrementation', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
162 -- ('995', 'i', 'Barcode Suffix', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
163 -- ('995', 'j', 'Barcode', 'Barcode', 0, 0, 'items.barcode', 10, '', '', '', 0, 0, '', '', '', NULL),
164 -- ('995', 'k', 'Call Number', 'Call Number', 0, 1, 'items.itemcallnumber', 10, '', '', '', 0, 0, '', '', '', NULL),
165 -- ('995', 'l', 'Numbering (Vol., Issue, etc.)', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL),
166 -- ('995', 'm', 'Date of Loan or Deposit', '', 0, 0, 'items.datelastseen', 10, '', '', '', 0, 0, '', '', '', NULL),
167 -- ('995', 'n', 'Expiration Loan Date', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
168 -- ('995', 'o', 'For Loan (0), Not for Loan (1)', '', 0, 1, 'items.notforloan', 10, '', '', '', 0, 0, '', '', '', NULL),
169 -- ('995', 'q', 'Intended Audience', '', 0, 0, '', -1, '', '', '', 0, 0, '', '', '', NULL),
170 -- ('995', 'r', 'Document Type and Material Type', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL),
171 -- ('995', 's', 'Acquisition Mode', '', 0, 1, '', -1, '', '', '', 0, 0, '', '', '', NULL),
172 -- ('995', 'u', 'Notes', '', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', '', '', NULL);
176 -- Recommended items Field/Subfields
178 -- INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
179 -- ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
181 -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
182 -- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),
183 -- ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
184 -- ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', 'unimarc_en_classcodes.pl', NULL, 0, '', '', '', NULL),
185 -- ('995', '3', 'Classification part', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL),
186 -- ('995', '4', 'Item part', 'Item part', 1, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL),
187 -- ('995', '5', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),
188 -- ('995', '6', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 10, '', '', 'marc21_locationqualifier.pl', NULL, 0, '', '', '', NULL),
189 -- ('995', '7', 'Copy number', 'Copy number', 0, 0, 'items.copynumber', 10, '', '', '', NULL, 0, '', '', '', NULL),
190 -- ('995', '8', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL),
191 -- ('995', '9', 'Internal item number (Koha itemnumber, autogenerated)', 'Internal itemnumber (Koha itemnumber)', 0, 0, 'items.itemnumber', -1, '', '', '', 0, -5, '', '', '', NULL),
192 -- ('995', 'a', 'Origin of the item (home branch) (free text)', 'Origin of item (home branch) (free text)', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
193 -- ('995', 'b', 'Origin of item (home branch) (coded)', 'Origin of item (home branch (coded)', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
194 -- ('995', 'c', 'Lending or holding organisation (holding branch) (free text)', 'Lending or holding organisation (holding branch) (free text)', 0, 1, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
195 -- ('995', 'd', 'Lending or holding organisation (holding branch) code', 'Lending or holding organisation (holding branch) code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
196 -- ('995', 'e', 'Genre detail', 'Genre', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
197 -- ('995', 'f', 'Barcode', 'Barcode', 0, 0, 'items.barcode', 10, '', '', 'barcode.pl', 0, 0, '', '', '', NULL),
198 -- ('995', 'g', 'Barcode prefix', 'Barcode prefix', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
199 -- ('995', 'h', 'Barcode incrementation', 'Barcode incrementation', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
200 -- ('995', 'i', 'Barcode suffix', 'Barcode suffix', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
201 -- ('995', 'j', 'Section', 'Section', 0, 0, '', 10, '', '', '', 0, 0, '', '', '', NULL),
202 -- ('995', 'k', 'Call number (full call number)', 'Call number (full call number)', 0, 0, 'items.itemcallnumber', 10, '', '', 'unimarc_itemcallnumber.pl', 0, 0, '', '', '', NULL),
203 -- ('995', 'l', 'Numbering (volume or other part)', 'Numbering (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', 0, 0, '', '', '', NULL),
204 -- ('995', 'm', 'Date of loan or deposit', 'Date of loan or deposit', 0, 0, 'items.datelastborrowed', 10, '', '', '', 0, -5, '', '', '', NULL),
205 -- ('995', 'n', 'Expiration of loan date', 'Expiration of loan date', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
206 -- ('995', 'o', 'Circulation type (not for loan)', 'Circulation type (not for loan)', 1, 0, 'items.notforloan', 10, '', '', '', 0, 0, '', '', '', NULL),
207 -- ('995', 'p', 'Serial', 'Serial', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
208 -- ('995', 'q', 'Intended audience (age level)', 'Intended audience (age level)', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
209 -- ('995', 'r', 'Type of item and material', 'Type of item and material', 0, 0, '', 10, '', '', '', 0, 0, '', '', '', NULL),
210 -- ('995', 's', 'Acquisition mode', 'Acquisition mode', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
211 -- ('995', 't', 'Genre', 'Genre', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
212 -- ('995', 'u', 'Copy note', 'Copy note', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', '', '', NULL),
213 -- ('995', 'v', 'Periodical number', 'Periodical number', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
214 -- ('995', 'w', 'Recipient organisation code', 'Recipient organisation code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
215 -- ('995', 'x', 'Recipient organisation, free text', 'Recipient organisation, free text', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
216 -- ('995', 'y', 'Recipient parent organisation code', 'Recipient parent organisation code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
217 -- ('995', 'z', 'Recipient parent organisation, free text', 'Recipient parent organisation, free text', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL);
221 -- Plugins which need to be written for items Field/Subfields
224 -- ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', 'unimarc_en_classcodes.pl', NULL, 0, '', '', '', NULL),
225 -- ('995', 'k', 'Call number (full call number)', 'Call number (full call number)', 0, 0, 'items.itemcallnumber', 10, '', '', 'unimarc_itemcallnumber.pl', 0, 0, '', '', '', NULL),
229 -- Current items Field/Subfields
231 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
232 ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
234 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
235 ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),
236 ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
237 ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL),
238 ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),
239 ('995', '4', 'Koha normalized classification for sorting', 'Koha normalized classification for sorting', 0, 0, 'items.cn_sort', -1, '', '', '', 0, 7, '', '', '', NULL),
240 ('995', '5', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 10, '', '', 'marc21_locationqualifier.pl', NULL, 0, '', '', '', NULL),
241 ('995', '6', 'Copy number', 'Copy number', 0, 0, 'items.copynumber', 10, '', '', '', NULL, 0, '', '', '', NULL),
242 ('995', '7', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL),
243 ('995', '8', 'Koha collection', 'Koha collection', 0, 0, 'items.ccode', 10, 'CCODE', '', '', 0, 0, '', '', '', NULL),
244 ('995', '9', 'Internal item number (Koha itemnumber, autogenerated)', 'Internal itemnumber (Koha itemnumber)', 0, 0, 'items.itemnumber', -1, '', '', '', 0, -5, '', '', '', NULL),
245 ('995', 'a', 'Origin of the item (home branch) (free text)', 'Origin of item (home branch) (free text)', 0, 1, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
246 ('995', 'b', 'Origin of item (home branch) (coded)', 'Origin of item (home branch (coded)', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
247 ('995', 'c', 'Lending or holding organisation (holding branch) (free text)', 'Lending or holding organisation (holding branch) (free text)', 0, 1, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
248 ('995', 'd', 'Lending or holding organisation (holding branch) code', 'Lending or holding organisation (holding branch) code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
249 ('995', 'e', 'Genre detail', 'Genre', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
250 ('995', 'f', 'Barcode', 'Barcode', 0, 0, 'items.barcode', 10, '', '', 'barcode.pl', 0, 0, '', '', '', NULL),
251 ('995', 'g', 'Barcode prefix', 'Barcode prefix', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
252 ('995', 'h', 'Barcode incrementation', 'Barcode incrementation', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
253 ('995', 'i', 'Barcode suffix', 'Barcode suffix', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
254 ('995', 'j', 'Section', 'Section', 0, 0, '', 10, '', '', '', 0, 0, '', '', '', NULL),
255 ('995', 'k', 'Call number (full call number)', 'Call number (full call number)', 0, 0, 'items.itemcallnumber', 10, '', '', '', 0, 0, '', '', '', NULL),
256 ('995', 'l', 'Numbering (volume or other part)', 'Numbering (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', 0, 0, '', '', '', NULL),
257 ('995', 'm', 'Date of loan or deposit', 'Date of loan or deposit', 0, 0, 'items.datelastborrowed', 10, '', '', '', 0, -5, '', '', '', NULL),
258 ('995', 'n', 'Expiration of loan date', 'Expiration of loan date', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
259 ('995', 'o', 'Circulation type (not for loan)', 'Circulation type (not for loan)', 1, 0, 'items.notforloan', 10, '', '', '', 0, 0, '', '', '', NULL),
260 ('995', 'p', 'Serial', 'Serial', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
261 ('995', 'q', 'Intended audience (age level)', 'Intended audience (age level)', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
262 ('995', 'r', 'Type of item and material', 'Type of item and material', 0, 0, '', 10, '', '', '', 0, 0, '', '', '', NULL),
263 ('995', 's', 'Acquisition mode', 'Acquisition mode', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
264 ('995', 't', 'Genre', 'Genre', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
265 ('995', 'u', 'Copy note', 'Copy note', 0, 0, 'items.itemnotes', 10, '', '', '', 0, 0, '', '', '', NULL),
266 ('995', 'v', 'Periodical number', 'Periodical number', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
267 ('995', 'w', 'Recipient organisation code', 'Recipient organisation code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
268 ('995', 'x', 'Recipient organisation, free text', 'Recipient organisation, free text', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
269 ('995', 'y', 'Recipient parent organisation code', 'Recipient parent organisation code', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL),
270 ('995', 'z', 'Recipient parent organisation, free text', 'Recipient parent organisation, free text', 0, 0, '', 10, '', '', '', 0, -1, '', '', '', NULL);