Line 0
Link Here
|
|
|
1 |
$DBversion = 'XXX'; # will be replaced by the RM |
2 |
if( CheckVersion( $DBversion ) ) { |
3 |
if( !TableExists( 'holdings' ) ) { |
4 |
$dbh->do(q{ |
5 |
CREATE TABLE `holdings` ( -- table that stores summary holdings information |
6 |
`holding_id` int(11) NOT NULL auto_increment, -- unique identifier assigned to each holdings record |
7 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio table used to link this record to the right bib record |
8 |
`frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record |
9 |
`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that owns this record (MARC21 852$a) |
10 |
`location` varchar(80) default NULL, -- authorized value for the shelving location for this record (MARC21 852$b) |
11 |
`ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 852$g) |
12 |
`callnumber` varchar(255) default NULL, -- call number (852$h+$k+$l+$m in MARC21) |
13 |
`suppress` tinyint(1) NOT NULL DEFAULT 0, -- Boolean indicating whether the record is suppressed in OPAC |
14 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched |
15 |
`datecreated` DATE NOT NULL, -- the date this record was added to Koha |
16 |
`deleted_on` DATETIME DEFAULT NULL, -- the date this record was deleted |
17 |
PRIMARY KEY (`holding_id`), |
18 |
KEY `hldnoidx` (`holding_id`), |
19 |
KEY `hldbibnoidx` (`biblionumber`), |
20 |
CONSTRAINT `holdings_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
21 |
CONSTRAINT `holdings_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |
22 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
23 |
}); |
24 |
} |
25 |
if( !TableExists( 'holdings_metadata' ) ) { |
26 |
$dbh->do(q{ |
27 |
CREATE TABLE `holdings_metadata` ( |
28 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
29 |
`holding_id` INT(11) NOT NULL, |
30 |
`format` VARCHAR(16) NOT NULL, |
31 |
`schema` VARCHAR(16) NOT NULL, |
32 |
`metadata` LONGTEXT NOT NULL, |
33 |
`deleted_on` DATETIME DEFAULT NULL, -- the date this record was deleted |
34 |
PRIMARY KEY(id), |
35 |
UNIQUE KEY `holdings_metadata_uniq_key` (`holding_id`,`format`,`schema`), |
36 |
KEY `hldnoidx` (`holding_id`), |
37 |
CONSTRAINT `holdings_metadata_fk_1` FOREIGN KEY (`holding_id`) REFERENCES `holdings` (`holding_id`) ON DELETE CASCADE ON UPDATE CASCADE |
38 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
39 |
}); |
40 |
} |
41 |
|
42 |
if( !column_exists( 'items', 'holding_id' ) ) { |
43 |
$dbh->do(q{ |
44 |
ALTER TABLE `items` ADD COLUMN `holding_id` int(11) default NULL; |
45 |
}); |
46 |
$dbh->do(q{ |
47 |
ALTER TABLE `items` ADD CONSTRAINT `items_ibfk_5` FOREIGN KEY (`holding_id`) REFERENCES `holdings` (`holding_id`) ON DELETE CASCADE ON UPDATE CASCADE; |
48 |
}); |
49 |
$dbh->do(q{ |
50 |
ALTER TABLE `items` ADD KEY `hldid_idx` (`holding_id`); |
51 |
}); |
52 |
|
53 |
$dbh->do(q{ |
54 |
ALTER TABLE `deleteditems` ADD COLUMN `holding_id` int(11) default NULL; |
55 |
}); |
56 |
} |
57 |
|
58 |
$dbh->do(q{ |
59 |
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('holdings'); |
60 |
}); |
61 |
|
62 |
$dbh->do(q{ |
63 |
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES |
64 |
('SummaryHoldings', '0', NULL, 'If ON, enables support for holdings records.', 'YesNo'); |
65 |
}); |
66 |
|
67 |
$dbh->do(q{ |
68 |
INSERT IGNORE INTO `biblio_framework` VALUES ('HLD', 'Default holdings framework'); |
69 |
}); |
70 |
|
71 |
if (C4::Context->preference("marcflavour") eq 'MARC21') { |
72 |
# items.holding_id in the default framework |
73 |
$dbh->do(q{ |
74 |
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES |
75 |
('952', 'k', 'Holdings record', 'Holdings record', 0, 0, 'items.holding_id', 10, 'holdings', '', '', NULL, -1, '', '', '', NULL); |
76 |
}); |
77 |
# items.holding_id in the ACQ framework |
78 |
$dbh->do(q{ |
79 |
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES |
80 |
('952', 'k', 'Holdings record', 'Holdings record', 0, 0, 'items.holding_id', 10, 'holdings', '', '', NULL, -1, 'ACQ', '', '', NULL); |
81 |
}); |
82 |
|
83 |
# Holdings framework |
84 |
$dbh->do(q{ |
85 |
INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES |
86 |
('000', 'LEADER', 'LEADER', 0, 1, '', 'HLD'), |
87 |
('001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 0, '', 'HLD'), |
88 |
('003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, '', 'HLD'), |
89 |
('004', 'CONTROL NUMBER FOR RELATED BIBLIOGRAPHIC RECORD', 'CONTROL NUMBER FOR RELATED BIBLIOGRAPHIC RECORD', 0, 0, '', 'HLD'), |
90 |
('005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, '', 'HLD'), |
91 |
('006', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 1, 0, '', 'HLD'), |
92 |
('007', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 1, 0, '', 'HLD'), |
93 |
('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'HLD'), |
94 |
('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'HLD'), |
95 |
('014', 'LINKAGE NUMBER', 'LINKAGE NUMBER', 1, 0, '', 'HLD'), |
96 |
('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, '', 'HLD'), |
97 |
('017', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 1, 0, '', 'HLD'), |
98 |
('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'HLD'), |
99 |
('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'HLD'), |
100 |
('024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL, 'HLD'), |
101 |
('027', 'STANDARD TECHNICAL REPORT NUMBER', 'STANDARD TECHNICAL REPORT NUMBER', 1, 0, '', 'HLD'), |
102 |
('030', 'CODEN DESIGNATION', 'CODEN DESIGNATION', 1, 0, '', 'HLD'), |
103 |
('035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL, 'HLD'), |
104 |
('040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL, 'HLD'), |
105 |
('066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL, 'HLD'), |
106 |
('337', 'MEDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, 'HLD'), |
107 |
('338', 'CARRIER TYPE', 'CARRIER TYPE', 1, 0, NULL, 'HLD'), |
108 |
('347', 'DIGITAL FILE CHARACTERISTICS', 'DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, 'HLD'), |
109 |
('506', 'RESTRICTIONS ON ACCESS NOTE', 'RESTRICTIONS ON ACCESS NOTE', 1, 0, NULL, 'HLD'), |
110 |
('538', 'SYSTEM DETAILS NOTE', 'SYSTEM DETAILS NOTE', 1, 0, NULL, 'HLD'), |
111 |
('541', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 1, 0, NULL, 'HLD'), |
112 |
('561', 'OWNERSHIP AND CUSTODIAL HISTORY', 'OWNERSHIP AND CUSTODIAL HISTORY', 1, 0, NULL, 'HLD'), |
113 |
('562', 'COPY AND VERSION IDENTIFICATION NOTE', 'COPY AND VERSION IDENTIFICATION NOTE', 1, 0, NULL, 'HLD'), |
114 |
('563', 'BINDING INFORMATION', 'BINDING INFORMATION', 1, 0, NULL, 'HLD'), |
115 |
('583', 'ACTION NOTE', 'ACTION NOTE', 1, 0, NULL, 'HLD'), |
116 |
('842', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 0, 0, NULL, 'HLD'), |
117 |
('843', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, 'HLD'), |
118 |
('844', 'NAME OF UNIT', 'NAME OF UNIT', 0, 0, NULL, 'HLD'), |
119 |
('845', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL, 'HLD'), |
120 |
('852', 'LOCATION', 'LOCATION', 1, 0, NULL, 'HLD'), |
121 |
('853', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, 'HLD'), |
122 |
('854', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 1, 0, NULL, 'HLD'), |
123 |
('855', 'CAPTIONS AND PATTERN--INDEXES', 'CAPTIONS AND PATTERN--INDEXES', 1, 0, NULL, 'HLD'), |
124 |
('856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL, 'HLD'), |
125 |
('863', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, 'HLD'), |
126 |
('864', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 1, 0, NULL, 'HLD'), |
127 |
('865', 'ENUMERATION AND CHRONOLOGY--INDEXES', 'ENUMERATION AND CHRONOLOGY--INDEXES', 1, 0, NULL, 'HLD'), |
128 |
('866', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, 'HLD'), |
129 |
('867', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 1, 0, NULL, 'HLD'), |
130 |
('868', 'TEXTUAL HOLDINGS--INDEXES', 'TEXTUAL HOLDINGS--INDEXES', 1, 0, NULL, 'HLD'), |
131 |
('876', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, 'HLD'), |
132 |
('877', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 1, 0, NULL, 'HLD'), |
133 |
('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL, 'HLD'), |
134 |
('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, 'HLD'), |
135 |
('883', 'MACHINE-GENERATED METADATA PROVENANCE', 'MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, 'HLD'), |
136 |
('884', 'DESCRIPTION CONVERSION INFORMATION', 'DESCRIPTION CONVERSION INFORMATION', 1, 0, NULL, 'HLD'), |
137 |
('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'HLD'), |
138 |
('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'HLD'); |
139 |
}); |
140 |
$dbh->do(q{ |
141 |
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES |
142 |
('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader_holdings.pl', 0, 0, 'HLD', '', '', NULL), |
143 |
('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 4, 'HLD', '', '', NULL), |
144 |
('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, 'HLD', '', '', NULL), |
145 |
('004', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
146 |
('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, 'HLD', '', '', NULL), |
147 |
('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, 0, 'HLD', '', '', NULL), |
148 |
('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'HLD', '', '', NULL), |
149 |
('008', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_field_008_holdings.pl', 0, 0, 'HLD', '', '', NULL), |
150 |
('010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
151 |
('010', 'a', 'LC control number', 'LC control number', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
152 |
('010', 'b', 'NUCMC control number', 'NUCMC control number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
153 |
('010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
154 |
('014', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
155 |
('014', 'a', 'Linkage number', 'Linkage number', 0, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
156 |
('014', 'b', 'Source of number', 'Source of number', 0, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
157 |
('014', 'z', 'Canceled/invalid linkage number', 'Canceled/invalid linkage number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
158 |
('016', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
159 |
('016', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
160 |
('016', 'a', 'Record control number', 'Record control number', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
161 |
('016', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
162 |
('017', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
163 |
('017', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
164 |
('017', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
165 |
('017', 'a', 'Copyright or legal deposit number', 'Copyright or legal deposit number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
166 |
('017', 'b', 'Assigning agency', 'Assigning agency', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
167 |
('017', 'd', 'Date', 'Date', 0, 0, '', 0, '', '', NULL, 0, -6, 'HLD', '', '', NULL), |
168 |
('017', 'i', 'Display text', 'Display text', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
169 |
('017', 'z', 'Canceled/invalid copyright or legal deposit number', 'Canceled/invalid copyright or legal deposit number', 1, 0, '', 0, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
170 |
('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
171 |
('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
172 |
('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
173 |
('020', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
174 |
('020', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
175 |
('020', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
176 |
('022', '2', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
177 |
('022', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
178 |
('022', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
179 |
('022', 'a', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
180 |
('022', 'l', 'ISSN-L', 'ISSN-L', 0, 0, '', 0, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
181 |
('022', 'm', 'Canceled ISSN-L', 'Canceled ISSN-L', 1, 0, '', 0, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
182 |
('022', 'y', 'Incorrect ISSN', 'Incorrect ISSN', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
183 |
('022', 'z', 'Canceled ISSN', 'Canceled ISSN', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
184 |
('024', '2', 'Source of number or code', 'Source of number or code', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
185 |
('024', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
186 |
('024', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
187 |
('024', 'a', 'Standard number or code', 'Standard number or code', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
188 |
('024', 'b', 'Additional codes following the standard number [OBSOLETE]', 'Additional codes following the standard number [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
189 |
('024', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
190 |
('024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
191 |
('024', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
192 |
('024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
193 |
('027', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
194 |
('027', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
195 |
('027', 'a', 'Standard technical report number', 'Standard technical report number', 0, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
196 |
('027', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
197 |
('027', 'z', 'Canceled/invalid number', 'Canceled/invalid number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
198 |
('030', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
199 |
('030', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
200 |
('030', 'a', 'CODEN', 'CODEN', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
201 |
('030', 'z', 'Canceled/invalid CODEN', 'Canceled/invalid CODEN', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
202 |
('035', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
203 |
('035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
204 |
('035', 'a', 'System control number', 'System control number', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
205 |
('035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, '', 0, '', '', '', 0, -1, 'HLD', '', '', NULL), |
206 |
('040', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
207 |
('040', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'HLD', '', '', NULL), |
208 |
('040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
209 |
('040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
210 |
('040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 1, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
211 |
('040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, '', 0, '', '', '', 0, 0, 'HLD', '', '', NULL), |
212 |
('066', 'a', 'Primary G0 character set', 'Primary G0 character set', 0, 0, '', 0, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
213 |
('066', 'b', 'Primary G1 character set', 'Primary G1 character set', 0, 0, '', 0, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
214 |
('066', 'c', 'Alternate G0 or G1 character set', 'Alternate G0 or G1 character set', 1, 0, '', 0, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
215 |
('337', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
216 |
('337', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
217 |
('337', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
218 |
('337', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
219 |
('337', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
220 |
('337', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
221 |
('337', 'a', 'Media type term', 'Media type term', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
222 |
('337', 'b', 'Media type code', 'Media type code', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
223 |
('338', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
224 |
('338', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
225 |
('338', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
226 |
('338', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
227 |
('338', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
228 |
('338', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
229 |
('338', 'a', 'Carrier type term', 'Carrier type term', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
230 |
('338', 'b', 'Carrier type code', 'Carrier type code', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
231 |
('347', 'a', 'File type', 'File type', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
232 |
('347', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
233 |
('347', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
234 |
('347', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
235 |
('347', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
236 |
('347', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
237 |
('347', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
238 |
('347', 'b', 'Encoding format', 'Encoding format', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
239 |
('347', 'c', 'File size', 'File size', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
240 |
('347', 'd', 'Resolution', 'Resolution', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
241 |
('347', 'e', 'Regional encoding', 'Regional encoding', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
242 |
('347', 'f', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 3, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
243 |
('506', '2', 'Source of term', 'Source of term', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
244 |
('506', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
245 |
('506', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
246 |
('506', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
247 |
('506', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
248 |
('506', 'a', 'Terms governing access', 'Terms governing access', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
249 |
('506', 'b', 'Jurisdiction', 'Jurisdiction', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
250 |
('506', 'c', 'Physical access provisions', 'Physical access provisions', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
251 |
('506', 'd', 'Authorized users', 'Authorized users', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
252 |
('506', 'e', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
253 |
('506', 'f', 'Standardized terminology for access restriction', 'Standardized terminology for access restriction', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
254 |
('506', 'g', 'Availability date', 'Availability date', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
255 |
('506', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
256 |
('506', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, 'HLD', '', '', NULL), |
257 |
('538', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
258 |
('538', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
259 |
('538', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
260 |
('538', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
261 |
('538', 'a', 'System details note', 'System details note', 0, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
262 |
('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
263 |
('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, 'HLD', '', '', NULL), |
264 |
('541', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
265 |
('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
266 |
('541', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
267 |
('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
268 |
('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
269 |
('541', 'b', 'Address', 'Address', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
270 |
('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
271 |
('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
272 |
('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
273 |
('541', 'f', 'Owner', 'Owner', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
274 |
('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
275 |
('541', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
276 |
('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
277 |
('561', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
278 |
('561', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
279 |
('561', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
280 |
('561', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
281 |
('561', 'a', 'History', 'History', 0, 0, '', 5, '', '', '', NULL, 6, 'HLD', '', '', NULL), |
282 |
('561', 'b', 'Time of collation [OBSOLETE]', 'Time of collation [OBSOLETE]', 0, 0, '', 5, '', '', '', NULL, 6, 'HLD', '', '', NULL), |
283 |
('561', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
284 |
('562', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
285 |
('562', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', -1, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
286 |
('562', '6', 'Linkage', 'Linkage', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
287 |
('562', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
288 |
('562', 'a', 'Identifying markings', 'Identifying markings', 1, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
289 |
('562', 'b', 'Copy identification', 'Copy identification', 1, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
290 |
('562', 'c', 'Version identification', 'Version identification', 1, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
291 |
('562', 'd', 'Presentation format', 'Presentation format', 1, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
292 |
('562', 'e', 'Number of copies', 'Number of copies', 1, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
293 |
('563', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
294 |
('563', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', -1, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
295 |
('563', '6', 'Linkage', 'Linkage', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
296 |
('563', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
297 |
('563', 'a', 'Binding note', 'Binding note', 0, 0, '', 5, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
298 |
('563', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, NULL, NULL, '', 1, -1, 'HLD', '', '', NULL), |
299 |
('583', '2', 'Source of term', 'Source of term', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
300 |
('583', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
301 |
('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
302 |
('583', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
303 |
('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
304 |
('583', 'a', 'Action', 'Action', 0, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
305 |
('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
306 |
('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
307 |
('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
308 |
('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
309 |
('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
310 |
('583', 'h', 'Jurisdiction', 'Jurisdiction', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
311 |
('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
312 |
('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
313 |
('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
314 |
('583', 'l', 'Status', 'Status', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
315 |
('583', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
316 |
('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
317 |
('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, 'HLD', '', '', NULL), |
318 |
('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 5, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
319 |
('583', 'z', 'Public note', 'Public note', 1, 0, '', 5, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
320 |
('842', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
321 |
('842', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
322 |
('842', 'a', 'Textual physical form designator', 'Textual physical form designator', 0, 0, '', 8, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
323 |
('843', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
324 |
('843', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
325 |
('843', '6', 'Linkage', 'Linkage', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
326 |
('843', '7', 'Fixed-length data elements of reproduction', 'Fixed-length data elements of reproduction', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
327 |
('843', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
328 |
('843', 'a', 'Type of reproduction', 'Type of reproduction', 0, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
329 |
('843', 'b', 'Place of reproduction', 'Place of reproduction', 1, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
330 |
('843', 'c', 'Agency responsible for reproduction', 'Agency responsible for reproduction', 1, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
331 |
('843', 'd', 'Date of reproduction', 'Date of reproduction', 0, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
332 |
('843', 'e', 'Physical description of reproduction', 'Physical description of reproduction', 0, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
333 |
('843', 'f', 'Series statement of reproduction', 'Series statement of reproduction', 1, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
334 |
('843', 'm', 'Dates of publication and/or sequential designation of issues reproduced', 'Dates of publication and/or sequential designation of issues reproduced', 1, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
335 |
('843', 'n', 'Note about reproduction', 'Note about reproduction', 1, 0, '', 8, NULL, NULL, '', NULL, -1, 'HLD', '', '', NULL), |
336 |
('844', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
337 |
('844', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
338 |
('844', 'a', 'Name of unit', 'Name of unit', 0, 0, '', 8, '', '', '', NULL, -1, 'HLD', '', '', NULL), |
339 |
('845', '2', 'Source of term', 'Source of term', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
340 |
('845', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
341 |
('845', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
342 |
('845', '6', 'Linkage', 'Linkage', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
343 |
('845', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
344 |
('845', 'a', 'Terms governing use and reproduction', 'Terms governing use and reproduction', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
345 |
('845', 'b', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
346 |
('845', 'c', 'Authorization', 'Authorization', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
347 |
('845', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
348 |
('845', 'f', 'Use and reproduction rights', 'Use and reproduction rights', 1, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
349 |
('845', 'g', 'Availability date', 'Availability date', 1, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
350 |
('845', 'q', 'Supplying agency', 'Supplying agency', 0, 0, '', 8, NULL, NULL, '', NULL, -6, 'HLD', '', '', NULL), |
351 |
('845', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, NULL, NULL, '', 1, -6, 'HLD', '', '', NULL), |
352 |
('852', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
353 |
('852', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
354 |
('852', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
355 |
('852', '8', 'Sequence number', 'Sequence number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
356 |
('852', 'a', 'Location', 'Location', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
357 |
('852', 'b', 'Sublocation or collection', 'Sublocation or collection', 1, 0, 'holdings.holdingbranch', 8, 'branches', '', '', NULL, 4, 'HLD', '', '', NULL), |
358 |
('852', 'c', 'Shelving location', 'Shelving location', 1, 0, 'holdings.location', 8, 'LOC', '', '', NULL, 4, 'HLD', '', '', NULL), |
359 |
('852', 'd', 'Former shelving location', 'Former shelving location', 1, 0, '', 8, '', '', '', NULL, 1, 'HLD', '', '', NULL), |
360 |
('852', 'e', 'Address', 'Address', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
361 |
('852', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
362 |
('852', 'g', 'Non-coded location qualifier', 'Non-coded location qualifier', 1, 0, 'holdings.ccode', 8, 'CCODE', '', '', NULL, 4, 'HLD', '', '', NULL), |
363 |
('852', 'h', 'Classification part', 'Classification part', 0, 0, 'holdings.callnumber', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
364 |
('852', 'i', 'Item part', 'Item part', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
365 |
('852', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
366 |
('852', 'k', 'Call number prefix', 'Call number prefix', 1, 0, 'holdings.callnumber', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
367 |
('852', 'l', 'Shelving form of title', 'Shelving form of title', 0, 0, 'holdings.callnumber', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
368 |
('852', 'm', 'Call number suffix', 'Call number suffix', 1, 0, 'holdings.callnumber', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
369 |
('852', 'n', 'Country code', 'Country code', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
370 |
('852', 'p', 'Piece designation', 'Piece designation', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
371 |
('852', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
372 |
('852', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
373 |
('852', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
374 |
('852', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, '', '', '', 1, 4, 'HLD', '', '', NULL), |
375 |
('852', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
376 |
('852', 'z', 'Public note', 'Public note', 1, 0, 'holdings.public_note', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
377 |
('853', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
378 |
('853', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
379 |
('853', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
380 |
('853', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
381 |
('853', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
382 |
('853', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
383 |
('853', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
384 |
('853', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
385 |
('853', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
386 |
('853', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
387 |
('853', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
388 |
('853', 'i', 'First level of chronology', 'First level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
389 |
('853', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
390 |
('853', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
391 |
('853', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
392 |
('853', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
393 |
('853', 'n', 'Pattern note', 'Pattern note', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
394 |
('853', 'p', 'Number of pieces per issuance', 'Number of pieces per issuance', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
395 |
('853', 't', 'Copy', 'Copy', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
396 |
('853', 'u', 'Bibliographic units per next higher level', 'Bibliographic units per next higher level', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
397 |
('853', 'v', 'Numbering continuity', 'Numbering continuity', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
398 |
('853', 'w', 'Frequency', 'Frequency', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
399 |
('853', 'x', 'Calendar change', 'Calendar change', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
400 |
('853', 'y', 'Regularity pattern', 'Regularity pattern', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
401 |
('853', 'z', 'Numbering scheme', 'Numbering scheme', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
402 |
('854', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
403 |
('854', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
404 |
('854', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
405 |
('854', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
406 |
('854', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
407 |
('854', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
408 |
('854', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
409 |
('854', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
410 |
('854', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
411 |
('854', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
412 |
('854', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
413 |
('854', 'i', 'First level of chronology', 'First level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
414 |
('854', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
415 |
('854', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
416 |
('854', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
417 |
('854', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
418 |
('854', 'n', 'Pattern note', 'Pattern note', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
419 |
('854', 'p', 'Number of pieces per issuance', 'Number of pieces per issuance', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
420 |
('854', 't', 'Copy', 'Copy', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
421 |
('854', 'u', 'Bibliographic units per next higher level', 'Bibliographic units per next higher level', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
422 |
('854', 'v', 'Numbering continuity', 'Numbering continuity', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
423 |
('854', 'w', 'Frequency', 'Frequency', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
424 |
('854', 'x', 'Calendar change', 'Calendar change', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
425 |
('854', 'y', 'Regularity pattern', 'Regularity pattern', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
426 |
('854', 'z', 'Numbering scheme', 'Numbering scheme', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
427 |
('855', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
428 |
('855', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
429 |
('855', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
430 |
('855', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
431 |
('855', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
432 |
('855', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
433 |
('855', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
434 |
('855', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
435 |
('855', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
436 |
('855', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
437 |
('855', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
438 |
('855', 'i', 'First level of chronology', 'First level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
439 |
('855', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
440 |
('855', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
441 |
('855', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
442 |
('855', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
443 |
('855', 'n', 'Pattern note', 'Pattern note', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
444 |
('855', 'p', 'Number of pieces per issuance', 'Number of pieces per issuance', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
445 |
('855', 't', 'Copy', 'Copy', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
446 |
('855', 'u', 'Bibliographic units per next higher level', 'Bibliographic units per next higher level', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
447 |
('855', 'v', 'Numbering continuity', 'Numbering continuity', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
448 |
('855', 'w', 'Frequency', 'Frequency', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
449 |
('855', 'x', 'Calendar change', 'Calendar change', 0, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
450 |
('855', 'y', 'Regularity pattern', 'Regularity pattern', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
451 |
('855', 'z', 'Numbering scheme', 'Numbering scheme', 1, 0, '', 8, '', '', '', NULL, 4, 'HLD', '', '', NULL), |
452 |
('856', '2', 'Access method', 'Access method', 0, 0, '', 8, '', '', '', 0, 5, 'HLD', '', '', NULL), |
453 |
('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, 5, 'HLD', '', '', NULL), |
454 |
('856', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', 0, 5, 'HLD', '', '', NULL), |
455 |
('856', '7', 'Access status', 'Access status', 0, 0, '', 8, '', '', '', 0, 5, 'HLD', '', '', NULL), |
456 |
('856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', 0, 5, 'HLD', '', '', NULL), |
457 |
('856', 'a', 'Host name', 'Host name', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
458 |
('856', 'b', 'Access number', 'Access number', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
459 |
('856', 'c', 'Compression information', 'Compression information', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
460 |
('856', 'd', 'Path', 'Path', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
461 |
('856', 'f', 'Electronic name', 'Electronic name', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
462 |
('856', 'h', 'Processor of request', 'Processor of request', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
463 |
('856', 'i', 'Instruction', 'Instruction', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
464 |
('856', 'j', 'Bits per second', 'Bits per second', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
465 |
('856', 'k', 'Password', 'Password', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
466 |
('856', 'l', 'Logon', 'Logon', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
467 |
('856', 'm', 'Contact for access assistance', 'Contact for access assistance', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
468 |
('856', 'n', 'Name of location of host', 'Name of location of host', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
469 |
('856', 'o', 'Operating system', 'Operating system', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
470 |
('856', 'p', 'Port', 'Port', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
471 |
('856', 'q', 'Electronic format type', 'Electronic format type', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
472 |
('856', 'r', 'Settings', 'Settings', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
473 |
('856', 's', 'File size', 'File size', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
474 |
('856', 't', 'Terminal emulation', 'Terminal emulation', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
475 |
('856', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, '', '', '', 1, 4, 'HLD', '', '', NULL), |
476 |
('856', 'v', 'Hours access method available', 'Hours access method available', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
477 |
('856', 'w', 'Record control number', 'Record control number', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
478 |
('856', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
479 |
('856', 'y', 'Link text', 'Link text', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
480 |
('856', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
481 |
('863', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
482 |
('863', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
483 |
('863', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, 'holdings.summary', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
484 |
('863', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, 'holdings.summary', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
485 |
('863', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
486 |
('863', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
487 |
('863', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
488 |
('863', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
489 |
('863', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
490 |
('863', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
491 |
('863', 'i', 'First level of chronology', 'First level of chronology', 0, 0, 'holdings.summary', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
492 |
('863', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
493 |
('863', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
494 |
('863', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
495 |
('863', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
496 |
('863', 'n', 'Converted Gregorian year', 'Converted Gregorian year', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
497 |
('863', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
498 |
('863', 'p', 'Piece designation', 'Piece designation', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
499 |
('863', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
500 |
('863', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
501 |
('863', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
502 |
('863', 'v', 'Issuing date', 'Issuing date', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
503 |
('863', 'w', 'Break indicator', 'Break indicator', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
504 |
('863', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
505 |
('863', 'z', 'Public note', 'Public note', 1, 0, 'holdings.summary', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
506 |
('864', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
507 |
('864', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
508 |
('864', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
509 |
('864', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
510 |
('864', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
511 |
('864', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
512 |
('864', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
513 |
('864', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
514 |
('864', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
515 |
('864', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
516 |
('864', 'i', 'First level of chronology', 'First level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
517 |
('864', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
518 |
('864', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
519 |
('864', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
520 |
('864', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
521 |
('864', 'n', 'Converted Gregorian year', 'Converted Gregorian year', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
522 |
('864', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
523 |
('864', 'p', 'Piece designation', 'Piece designation', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
524 |
('864', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
525 |
('864', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
526 |
('864', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
527 |
('864', 'v', 'Issuing date', 'Issuing date', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
528 |
('864', 'w', 'Break indicator', 'Break indicator', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
529 |
('864', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
530 |
('864', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
531 |
('865', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
532 |
('865', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
533 |
('865', 'a', 'First level of enumeration', 'First level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
534 |
('865', 'b', 'Second level of enumeration', 'Second level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
535 |
('865', 'c', 'Third level of enumeration', 'Third level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
536 |
('865', 'd', 'Fourth level of enumeration', 'Fourth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
537 |
('865', 'e', 'Fifth level of enumeration', 'Fifth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
538 |
('865', 'f', 'Sixth level of enumeration', 'Sixth level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
539 |
('865', 'g', 'Alternative numbering scheme, first level of enumeration', 'Alternative numbering scheme, first level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
540 |
('865', 'h', 'Alternative numbering scheme, second level of enumeration', 'Alternative numbering scheme, second level of enumeration', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
541 |
('865', 'i', 'First level of chronology', 'First level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
542 |
('865', 'j', 'Second level of chronology', 'Second level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
543 |
('865', 'k', 'Third level of chronology', 'Third level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
544 |
('865', 'l', 'Fourth level of chronology', 'Fourth level of chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
545 |
('865', 'm', 'Alternative numbering scheme, chronology', 'Alternative numbering scheme, chronology', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
546 |
('865', 'n', 'Converted Gregorian year', 'Converted Gregorian year', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
547 |
('865', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
548 |
('865', 'p', 'Piece designation', 'Piece designation', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
549 |
('865', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
550 |
('865', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
551 |
('865', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
552 |
('865', 'v', 'Issuing date', 'Issuing date', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
553 |
('865', 'w', 'Break indicator', 'Break indicator', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
554 |
('865', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
555 |
('865', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
556 |
('866', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
557 |
('866', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
558 |
('866', 'a', 'Textual string', 'Textual string', 0, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
559 |
('866', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
560 |
('866', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
561 |
('867', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
562 |
('867', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
563 |
('867', 'a', 'Textual string', 'Textual string', 0, 0, 'holdings.supplements', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
564 |
('867', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
565 |
('867', 'z', 'Public note', 'Public note', 1, 0, 'holdings.supplements', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
566 |
('868', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
567 |
('868', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
568 |
('868', 'a', 'Textual string', 'Textual string', 0, 0, 'holdings.indexes', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
569 |
('868', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
570 |
('868', 'z', 'Public note', 'Public note', 1, 0, 'holdings.indexes', 8, '', '', '', 0, 4, 'HLD', '', '', NULL), |
571 |
('876', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
572 |
('876', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
573 |
('876', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
574 |
('876', 'a', 'Internal item number', 'Internal item number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
575 |
('876', 'b', 'Invalid or canceled internal item number', 'Invalid or canceled internal item number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
576 |
('876', 'c', 'Cost', 'Cost', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
577 |
('876', 'd', 'Date acquired', 'Date acquired', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
578 |
('876', 'e', 'Source of acquisition', 'Source of acquisition', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
579 |
('876', 'h', 'Use restrictions', 'Use restrictions', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
580 |
('876', 'j', 'Item status', 'Item status', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
581 |
('876', 'l', 'Temporary location', 'Temporary location', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
582 |
('876', 'p', 'Piece designation', 'Piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
583 |
('876', 'r', 'Invalid or canceled piece designation', 'Invalid or canceled piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
584 |
('876', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
585 |
('876', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
586 |
('876', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
587 |
('877', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
588 |
('877', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
589 |
('877', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
590 |
('877', 'a', 'Internal item number', 'Internal item number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
591 |
('877', 'b', 'Invalid or canceled internal item number', 'Invalid or canceled internal item number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
592 |
('877', 'c', 'Cost', 'Cost', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
593 |
('877', 'd', 'Date acquired', 'Date acquired', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
594 |
('877', 'e', 'Source of acquisition', 'Source of acquisition', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
595 |
('877', 'h', 'Use restrictions', 'Use restrictions', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
596 |
('877', 'j', 'Item status', 'Item status', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
597 |
('877', 'l', 'Temporary location', 'Temporary location', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
598 |
('877', 'p', 'Piece designation', 'Piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
599 |
('877', 'r', 'Invalid or canceled piece designation', 'Invalid or canceled piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
600 |
('877', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
601 |
('877', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
602 |
('877', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
603 |
('878', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
604 |
('878', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
605 |
('878', '8', 'Sequence number', 'Sequence number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
606 |
('878', 'a', 'Internal item number', 'Internal item number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
607 |
('878', 'b', 'Invalid or canceled internal item number', 'Invalid or canceled internal item number', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
608 |
('878', 'c', 'Cost', 'Cost', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
609 |
('878', 'd', 'Date acquired', 'Date acquired', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
610 |
('878', 'e', 'Source of acquisition', 'Source of acquisition', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
611 |
('878', 'h', 'Use restrictions', 'Use restrictions', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
612 |
('878', 'j', 'Item status', 'Item status', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
613 |
('878', 'l', 'Temporary location', 'Temporary location', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
614 |
('878', 'p', 'Piece designation', 'Piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
615 |
('878', 'r', 'Invalid or canceled piece designation', 'Invalid or canceled piece designation', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
616 |
('878', 't', 'Copy number', 'Copy number', 0, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
617 |
('878', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
618 |
('878', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', NULL, 5, 'HLD', '', '', NULL), |
619 |
('880', '2', '2', '2', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
620 |
('880', '3', '3', '3', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
621 |
('880', '4', '4', '4', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
622 |
('880', '5', '5', '5', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
623 |
('880', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
624 |
('880', '7', '7', '7', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
625 |
('880', '8', '8', '8', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
626 |
('880', '9', '9', '9', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
627 |
('880', 'a', 'a', 'a', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
628 |
('880', 'b', 'b', 'b', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
629 |
('880', 'c', 'c', 'c', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
630 |
('880', 'd', 'd', 'd', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
631 |
('880', 'e', 'e', 'e', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
632 |
('880', 'f', 'f', 'f', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
633 |
('880', 'g', 'g', 'g', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
634 |
('880', 'h', 'h', 'h', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
635 |
('880', 'i', 'i', 'i', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
636 |
('880', 'j', 'j', 'j', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
637 |
('880', 'k', 'k', 'k', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
638 |
('880', 'l', 'l', 'l', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
639 |
('880', 'm', 'm', 'm', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
640 |
('880', 'n', 'n', 'n', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
641 |
('880', 'o', 'o', 'o', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
642 |
('880', 'p', 'p', 'p', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
643 |
('880', 'q', 'q', 'q', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
644 |
('880', 'r', 'r', 'r', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
645 |
('880', 's', 's', 's', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
646 |
('880', 't', 't', 't', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
647 |
('880', 'u', 'u', 'u', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
648 |
('880', 'v', 'v', 'v', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
649 |
('880', 'w', 'w', 'w', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
650 |
('880', 'x', 'x', 'x', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
651 |
('880', 'y', 'y', 'y', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
652 |
('880', 'z', 'z', 'z', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
653 |
('883', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
654 |
('883', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
655 |
('883', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
656 |
('883', 'a', 'Generation process', 'Generation process', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
657 |
('883', 'c', 'Confidence value', 'Confidence value', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
658 |
('883', 'd', 'Generation date', 'Generation date', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
659 |
('883', 'q', 'Generation agency', 'Generation agency', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
660 |
('883', 'x', 'Validity end date', 'Validity end date', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
661 |
('883', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
662 |
('883', 'w', 'Bibliographic record control number', 'Bibliographic record control number', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
663 |
('884', 'a', 'Conversion process', 'Conversion process', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
664 |
('884', 'g', 'Conversion date', 'Conversion date', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
665 |
('884', 'k', 'Identifier of source metadata', 'Identifier of source metadata', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
666 |
('884', 'q', 'Conversion agency', 'Conversion agency', 0, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
667 |
('884', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 8, '', '', '', NULL, -6, 'HLD', '', '', NULL), |
668 |
('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, 'holdings.suppress', 9, '', '', '', 0, 4, 'HLD', '', '', NULL), |
669 |
('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'HLD', '', '', NULL), |
670 |
('999', 'e', 'Koha holding_id', 'Koha holding_id', 0, 0, 'holdings.holding_id', -1, NULL, NULL, '', NULL, -5, 'HLD', '', '', NULL); |
671 |
}); |
672 |
$dbh->do("UPDATE marc_subfield_structure SET maxlength=24 WHERE frameworkcode='HLD' AND tagfield='000'"); |
673 |
$dbh->do("UPDATE marc_subfield_structure SET maxlength=40 WHERE tagfield='008'"); |
674 |
} |
675 |
|
676 |
# Always end with this (adjust the bug info) |
677 |
SetVersion( $DBversion ); |
678 |
print "Upgrade to $DBversion done (Bug 20447 - Add holdings tables)\n"; |
679 |
} |