From b9d68c9e6afd8d486ca2de0125e895d32135ccfb Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Mon, 11 Feb 2013 20:44:32 -0300 Subject: [PATCH] Followup Bug 5858 - Default frameworks missing many MARC21 tags It's a pity, but this patch re-instates deleted fields to prevent data loss. Also correct minor errors, and add field 883. --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 461 ++++++++++++++++++-- 1 file changed, 421 insertions(+), 40 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index f1acb32..3af7153 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -22,6 +22,9 @@ -- well not quite complete yet today -- but close enough for someone to have use, -- by thd for LibLime +-- +-- MARC21 UPDATE 15 (September 2012) +-- 2013-02-11 -- ************************************************************* @@ -188,11 +191,12 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('001', 'CONTROL NUMBER', 'CONTROL NUMBER', 0, 0, '', ''), ('003', 'CONTROL NUMBER IDENTIFIER', 'CONTROL NUMBER IDENTIFIER', 0, 1, '', ''), ('005', 'DATE AND TIME OF LATEST TRANSACTION', 'DATE AND TIME OF LATEST TRANSACTION', 0, 1, '', ''), - ('006', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION', 1, 0, '', ''), - ('007', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 'PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION', 1, 0, '', ''), - ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', ''), + ('006', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 'FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS', 1, 0, '', ''), + ('007', 'PHYSICAL DESCRIPTION FIXED FIELD', 'PHYSICAL DESCRIPTION FIXED FIELD', 1, 0, '', ''), + ('008', 'FIXED-LENGTH DATA ELEMENTS', 'FIXED-LENGTH DATA ELEMENTS', 0, 1, '', ''), ('009', 'PHYSICAL DESCRIPTION FIXED-FIELD FOR ARCHIVAL COLLECTION (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FIXED-FIELD FOR ARCHIVAL COLLECTION (VM) [OBSOLETE]', 1, 0, '', ''), ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', ''), + ('011', 'LINKING LIBRARY OF CONGRESS CONTROL NUMBER [OBSOLETE]', 'LINKING LIBRARY OF CONGRESS CONTROL NUMBER [OBSOLETE]', 0, 0, '', ''), ('013', 'PATENT CONTROL INFORMATION', 'PATENT CONTROL INFORMATION', 1, 0, '', ''), ('015', 'NATIONAL BIBLIOGRAPHY NUMBER', 'NATIONAL BIBLIOGRAPHY NUMBER', 1, 0, '', ''), ('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, '', ''), @@ -201,11 +205,13 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 1, 0, '', ''), ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, ''), ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, ''), + ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), ('024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL, ''), ('025', 'OVERSEAS ACQUISITION NUMBER', 'OVERSEAS ACQUISITION NUMBER', 1, 0, '', ''), ('026', 'FINGERPRINT IDENTIFIER', 'FINGERPRINT IDENTIFIER', 1, 0, '', ''), ('027', 'STANDARD TECHNICAL REPORT NUMBER', 'STANDARD TECHNICAL REPORT NUMBER', 1, 0, '', ''), ('028', 'PUBLISHER NUMBER', 'PUBLISHER NUMBER', 1, 0, NULL, ''), + ('029', 'OTHER SYSTEM CONTROL NUMBER (OCLC)', ' (OCLC)', 1, 0, '', ''), ('030', 'CODEN DESIGNATION', 'CODEN DESIGNATION', 1, 0, '', ''), ('031', 'MUSICAL INCIPITS INFORMATION', 'MUSICAL INCIPITS INFORMATION', 1, 0, '', ''), ('032', 'POSTAL REGISTRATION NUMBER', 'POSTAL REGISTRATION NUMBER', 1, 0, '', ''), @@ -215,6 +221,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('036', 'ORIGINAL STUDY NUMBER FOR COMPUTER DATA FILES', 'ORIGINAL STUDY NUMBER FOR COMPUTER DATA FILES', 0, 0, '', ''), ('037', 'SOURCE OF ACQUISITION', 'SOURCE OF ACQUISITION', 1, 0, NULL, ''), ('038', 'RECORD CONTENT LICENSOR', 'RECORD CONTENT LICENSOR', 0, 0, '', ''), + ('039', 'LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE]', 'LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE]', 0, 0, '', ''), ('040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 1, NULL, ''), ('041', 'LANGUAGE CODE', 'LANGUAGE CODE', 1, 0, '', ''), ('042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, '', ''), @@ -223,7 +230,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('045', 'TIME PERIOD OF CONTENT', 'TIME PERIOD OF CONTENT', 0, 0, '', ''), ('046', 'SPECIAL CODED DATES', 'SPECIAL CODED DATES', 1, 0, '', ''), ('047', 'FORM OF MUSICAL COMPOSITION CODE', 'FORM OF MUSICAL COMPOSITION CODE', 1, 0, '', ''), - ('048', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODE', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODE', 1, 0, '', ''), + ('048', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODES', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODES', 1, 0, '', ''), ('049', 'LOCAL HOLDINGS (OCLC)', 'LOCAL HOLDINGS (OCLC)', 0, 0, '', ''), ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, ''), ('051', 'LIBRARY OF CONGRESS COPY, ISSUE, OFFPRINT STATEMENT', 'LIBRARY OF CONGRESS COPY, ISSUE, OFFPRINT STATEMENT', 1, 0, NULL, ''), @@ -240,8 +247,9 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('082', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 'DEWEY DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL, ''), ('083','ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER','ADDITIONAL DEWEY DECIMAL CLASSIFICATION NUMBER',1,0,'',''), ('084', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL, ''), - ('085','SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS','SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS','1','0','',''), + ('085', 'SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS','SYNTHESIZED CLASSIFICATION NUMBER COMPONENTS', 1, 0, NULL, ''), ('086', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 'GOVERNMENT DOCUMENT CLASSIFICATION NUMBER', 1, 0, NULL, ''), + ('087', 'REPORT NUMBER [OBSOLETE, CAN/MARC]', 'REPORT NUMBER [OBSOLETE, CAN/MARC]', 1, 0, NULL, ''), ('088', 'REPORT NUMBER', 'REPORT NUMBER', 1, 0, NULL, ''), ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC)', 1, 0, '', ''), ('091', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 0, 0, '', ''), @@ -254,8 +262,12 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('111', 'MAIN ENTRY--MEETING NAME', 'MAIN ENTRY--MEETING NAME', 0, 0, NULL, ''), ('130', 'MAIN ENTRY--UNIFORM TITLE', 'MAIN ENTRY--UNIFORM TITLE', 0, 0, NULL, ''), ('210', 'ABBREVIATED TITLE', 'ABBREVIATED TITLE', 1, 0, NULL, ''), + ('211', 'ACRONYM OR SHORTENED TITLE [OBSOLETE]', 'ACRONYM OR SHORTENED TITLE [OBSOLETE]', 1, 0, NULL, ''), + ('212', 'VARIANT ACCESS TITLE [OBSOLETE]', 'VARIANT ACCESS TITLE [OBSOLETE]', 1, 0, NULL, ''), + ('214', 'AUGMENTED TITLE [OBSOLETE]', 'AUGMENTED TITLE [OBSOLETE]', 1, 0, NULL, ''), ('222', 'KEY TITLE', 'KEY TITLE', 1, 0, NULL, ''), ('240', 'UNIFORM TITLE', 'UNIFORM TITLE', 0, 0, 'Unititle', ''), + ('241', 'ROMANIZED TITLE (BK AM CF MP MU VM) [OBSOLETE]', 'ROMANIZED TITLE (BK AM CF MP MU VM) [OBSOLETE]', 0, 0, '', ''), ('242', 'TRANSLATION OF TITLE BY CATALOGING AGENCY', 'TRANSLATION OF TITLE BY CATALOGING AGENCY', 1, 0, NULL, ''), ('243', 'COLLECTIVE UNIFORM TITLE', 'COLLECTIVE UNIFORM TITLE', 0, 0, '', ''), ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', ''), @@ -265,45 +277,62 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), ('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), ('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), - ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 0, 0, NULL, ''), + ('257', 'COUNTRY OF PRODUCING ENTITY', 'COUNTRY OF PRODUCING ENTITY', 1, 0, NULL, ''), ('258', 'PHILATELIC ISSUE DATE', 'PHILATELIC ISSUE DATE', 1, 0, NULL, ''), ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, ''), + ('261', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, NULL, ''), + ('262', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL, USA]', 0, 0, NULL, ''), ('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''), ('264','PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE','PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE','1','0','',''), + ('265', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 0, 0, NULL, ''), ('270', 'ADDRESS', 'ADDRESS', 1, 0, NULL, ''), ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, ''), + ('301', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 0, 0, NULL, ''), + ('302', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 0, 0, NULL, ''), + ('303', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 0, 0, NULL, ''), + ('304', 'LINEAR FOOTAGE (AM) [OBSOLETE, USMARC]', 'LINEAR FOOTAGE (AM) [OBSOLETE, USMARC]', 0, 0, NULL, ''), + ('305', 'PHYSICAL DESCRIPTION FOR SOUND RECORDINGS (Pre-AACR 2) (MU) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR SOUND RECORDINGS (Pre-AACR 2) (MU) [OBSOLETE]', 0, 0, NULL, ''), ('306', 'PLAYING TIME', 'PLAYING TIME', 0, 0, NULL, ''), ('307', 'HOURS, ETC.', 'HOURS, ETC.', 1, 0, NULL, ''), + ('308', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 1, 0, NULL, ''), ('310', 'CURRENT PUBLICATION FREQUENCY', 'CURRENT PUBLICATION FREQUENCY', 0, 0, NULL, ''), + ('315', 'FREQUENCY (CF MP) [OBSOLETE]', 'FREQUENCY (CF MP) [OBSOLETE]', 0, 0, NULL, ''), ('321', 'FORMER PUBLICATION FREQUENCY', 'FORMER PUBLICATION FREQUENCY', 1, 0, NULL, ''), - ('336','CONTENT TYPE','CONTENT TYPE','1','0','',''), - ('337','MEDIA TYPE','MEDIA TYPE','1','0','',''), - ('338','CARRIER TYPE','CARRIER TYPE','1','0','',''), + ('336', 'CONTENT TYPE','CONTENT TYPE', 1, 0, NULL, ''), + ('337', 'MEDIA TYPE','MEDIA TYPE', 1, 0, NULL, ''), + ('338', 'CARRIER TYPE','CARRIER TYPE', 1, 0, NULL, ''), ('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL, ''), ('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL, ''), ('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL, ''), - ('344','SOUND CHARACTERISTICS','SOUND CHARACTERISTICS','1','0','',''), - ('345','PROJECTION CHARACTERISTICS OF MOVING IMAGE','PROJECTION CHARACTERISTICS OF MOVING IMAGE','1','0','',''), - ('346','VIDEO CHARACTERISTICS','VIDEO CHARACTERISTICS','1','0','',''), - ('347','DIGITAL FILE CHARACTERISTICS','DIGITAL FILE CHARACTERISTICS','1','0','',''), + ('344', 'SOUND CHARACTERISTICS','SOUND CHARACTERISTICS', 1, 0, NULL, ''), + ('345', 'PROJECTION CHARACTERISTICS OF MOVING IMAGE','PROJECTION CHARACTERISTICS OF MOVING IMAGE', 1, 0, NULL, ''), + ('346', 'VIDEO CHARACTERISTICS','VIDEO CHARACTERISTICS', 1, 0, NULL, ''), + ('347', 'DIGITAL FILE CHARACTERISTICS','DIGITAL FILE CHARACTERISTICS', 1, 0, NULL, ''), + ('350', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (NR) (BK AM CF MU VM SE) [OBSOLETE]', 1, 0, NULL, ''), ('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL, ''), ('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL, ''), ('355', 'SECURITY CLASSIFICATION CONTROL', 'SECURITY CLASSIFICATION CONTROL', 1, 0, NULL, ''), ('357', 'ORIGINATOR DISSEMINATION CONTROL', 'ORIGINATOR DISSEMINATION CONTROL', 0, 0, NULL, ''), + ('359', 'RENTAL PRICE (VM) [OBSOLETE]', 'RENTAL PRICE (VM) [OBSOLETE]', 0, 0, NULL, ''), ('362', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 1, 0, NULL, ''), - ('363','NORMALIZED DATE AND SEQUENTIAL DESIGNATION','NORMALIZED DATE AND SEQUENTIAL DESIGNATION','1','0','',''), + ('363', 'NORMALIZED DATE AND SEQUENTIAL DESIGNATION','NORMALIZED DATE AND SEQUENTIAL DESIGNATION', 1, 0, NULL, ''), ('365', 'TRADE PRICE', 'TRADE PRICE', 1, 0, NULL, ''), ('366', 'TRADE AVAILABILITY INFORMATION', 'TRADE AVAILABILITY INFORMATION', 1, 0, NULL, ''), - ('377','ASSOCIATED LANGUAGE','ASSOCIATED LANGUAGE','1','0','',''), - ('380','FORM OF WORK','FORM OF WORK','1','0','',''), - ('381','OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION','OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION','1','0','',''), - ('382','MEDIUM OF PERFORMANCE','MEDIUM OF PERFORMANCE','1','0','',''), - ('383','NUMERIC DESIGNATION OF MUSICAL WORK','NUMERIC DESIGNATION OF MUSICAL WORK','1','0','',''), - ('384','KEY','KEY','0','0','',''), + ('377', 'ASSOCIATED LANGUAGE','ASSOCIATED LANGUAGE', 1 , 0 , NULL, ''), + ('380', 'FORM OF WORK','FORM OF WORK', 1, 0, NULL, ''), + ('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION','OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 1, 0, NULL, ''), + ('382', 'MEDIUM OF PERFORMANCE','MEDIUM OF PERFORMANCE', 1, 0, NULL, ''), + ('383', 'NUMERIC DESIGNATION OF MUSICAL WORK','NUMERIC DESIGNATION OF MUSICAL WORK', 1, 0, NULL, ''), + ('384', 'KEY','KEY', 0, 0, NULL, ''), + ('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), + ('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), + ('411', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), + ('440', 'SERIES STATEMENT/ADDED ENTRY--TITLE [OBSOLETE]', 'SERIES STATEMENT/ADDED ENTRY--TITLE [OBSOLETE]', 1, 0, NULL, ''), ('490', 'SERIES STATEMENT', 'SERIES STATEMENT', 1, 0, '', ''), ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, ''), ('501', 'WITH NOTE', 'WITH NOTE', 1, 0, NULL, ''), ('502', 'DISSERTATION NOTE', 'DISSERTATION NOTE', 1, 0, NULL, ''), + ('503', 'BIBLIOGRAPHIC HISTORY NOTE (BK CF MU) [OBSOLETE]', 'BIBLIOGRAPHIC HISTORY NOTE (BK CF MU) [OBSOLETE]', 1, 0, NULL, ''), ('504', 'BIBLIOGRAPHY, ETC. NOTE', 'BIBLIOGRAPHY, ETC. NOTE', 1, 0, NULL, ''), ('505', 'FORMATTED CONTENTS NOTE', 'FORMATTED CONTENTS NOTE', 1, 0, NULL, ''), ('506', 'RESTRICTIONS ON ACCESS NOTE', 'RESTRICTIONS ON ACCESS NOTE', 1, 0, NULL, ''), @@ -312,26 +341,32 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('509', 'INFORMAL NOTES (RLIN)', 'INFORMAL NOTES (RLIN)', 0, 0, NULL, ''), ('510', 'CITATION/REFERENCES NOTE', 'CITATION/REFERENCES NOTE', 1, 0, NULL, ''), ('511', 'PARTICIPANT OR PERFORMER NOTE', 'PARTICIPANT OR PERFORMER NOTE', 1, 0, NULL, ''), + ('512', 'EARLIER OR LATER VOLUMES SEPARATELY CATALOGED NOTE (SE) [OBSOLETE]', 'EARLIER OR LATER VOLUMES SEPARATELY CATALOGED NOTE (SE) [OBSOLETE]', 1, 0, NULL, ''), ('513', 'TYPE OF REPORT AND PERIOD COVERED NOTE', 'TYPE OF REPORT AND PERIOD COVERED NOTE', 1, 0, NULL, ''), ('514', 'DATA QUALITY NOTE', 'DATA QUALITY NOTE', 0, 0, NULL, ''), ('515', 'NUMBERING PECULIARITIES NOTE', 'NUMBERING PECULIARITIES NOTE', 1, 0, NULL, ''), ('516', 'TYPE OF COMPUTER FILE OR DATA NOTE', 'TYPE OF COMPUTER FILE OR DATA NOTE', 1, 0, NULL, ''), + ('517', 'CATEGORIES OF FILMS NOTE (ARCHIVAL) (VM) [OBSOLETE]', 'CATEGORIES OF FILMS NOTE (ARCHIVAL) (VM) [OBSOLETE]', 0, 0, NULL, ''), ('518', 'DATE/TIME AND PLACE OF AN EVENT NOTE', 'DATE/TIME AND PLACE OF AN EVENT NOTE', 1, 0, NULL, ''), ('520', 'SUMMARY, ETC.', 'SUMMARY, ETC.', 1, 0, NULL, ''), ('521', 'TARGET AUDIENCE NOTE', 'TARGET AUDIENCE NOTE', 1, 0, NULL, ''), ('522', 'GEOGRAPHIC COVERAGE NOTE', 'GEOGRAPHIC COVERAGE NOTE', 1, 0, NULL, ''), + ('523', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 0, 0, NULL, ''), ('524', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 1, 0, NULL, ''), ('525', 'SUPPLEMENT NOTE', 'SUPPLEMENT NOTE', 0, 0, NULL, ''), ('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 0, 0, NULL, ''), + ('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL, ''), ('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL, ''), ('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''), ('534', 'ORIGINAL VERSION NOTE', 'ORIGINAL VERSION NOTE', 1, 0, NULL, ''), ('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL, ''), ('536', 'FUNDING INFORMATION NOTE', 'FUNDING INFORMATION NOTE', 1, 0, NULL, ''), + ('537', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 0, 0, NULL, ''), ('538', 'SYSTEM DETAILS NOTE', 'SYSTEM DETAILS NOTE', 1, 0, NULL, ''), ('540', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL, ''), ('541', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 1, 0, NULL, ''), ('542','INFORMATION RELATING TO COPYRIGHT STATUS ','INFORMATION RELATING TO COPYRIGHT STATUS ','1','0','',''), + ('543', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 1, 0, NULL, ''), ('544', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 1, 0, NULL, ''), ('545', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL, ''), ('546', 'LANGUAGE NOTE', 'LANGUAGE NOTE', 1, 0, NULL, ''), @@ -345,13 +380,15 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('563', 'BINDING INFORMATION', 'BINDING INFORMATION', 1, 0, NULL, ''), ('565', 'CASE FILE CHARACTERISTICS NOTE', 'CASE FILE CHARACTERISTICS NOTE', 1, 0, NULL, ''), ('567', 'METHODOLOGY NOTE', 'METHODOLOGY NOTE', 1, 0, NULL, ''), + ('570', 'EDITOR NOTE (SE) [OBSOLETE]', 'EDITOR NOTE (SE) [OBSOLETE]', 1, 0, NULL, ''), ('580', 'LINKING ENTRY COMPLEXITY NOTE', 'LINKING ENTRY COMPLEXITY NOTE', 1, 0, NULL, ''), ('581', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 1, 0, NULL, ''), + ('582', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 1, 0, NULL, ''), ('583', 'ACTION NOTE', 'ACTION NOTE', 1, 0, NULL, ''), ('584', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 1, 0, NULL, ''), ('585', 'EXHIBITIONS NOTE', 'EXHIBITIONS NOTE', 1, 0, NULL, ''), ('586', 'AWARDS NOTE', 'AWARDS NOTE', 1, 0, NULL, ''), - ('588','SOURCE DESCRIPTION NOTE','SOURCE DESCRIPTION NOTE','1','0','',''), + ('588', 'SOURCE OF DESCRIPTION NOTE','SOURCE DESCRIPTION NOTE', 1, 0, NULL, ''), ('590', 'LOCAL NOTE (RLIN)', 'LOCAL NOTE (RLIN)', 1, 0, NULL, ''), ('600', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 1, 0, NULL, ''), ('610', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 1, 0, NULL, ''), @@ -360,6 +397,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('648', 'SUBJECT ADDED ENTRY--CHRONOLOGICAL TERM', 'SUBJECT ADDED ENTRY--CHRONOLOGICAL TERM', 1, 0, NULL, ''), ('650', 'SUBJECT ADDED ENTRY--TOPICAL TERM', 'SUBJECT ADDED ENTRY--TOPICAL TERM', 1, 0, NULL, ''), ('651', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 1, 0, NULL, ''), + ('652', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 'SUBJECT ADDED ENTRY--REVERSE GEOGRAPHIC (BK MP SE) [OBSOLETE]', 1, 0, NULL, ''), ('653', 'INDEX TERM--UNCONTROLLED', 'INDEX TERM--UNCONTROLLED', 1, 0, NULL, ''), ('654', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERM', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERM', 1, 0, NULL, ''), ('655', 'INDEX TERM--GENRE/FORM', 'INDEX TERM--GENRE/FORM', 1, 0, NULL, ''), @@ -374,15 +412,18 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('698', 'LOCAL SUBJECT ADDED ENTRY--MEETING NAME (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--MEETING NAME (RLIN)', 1, 0, '', ''), ('699', 'LOCAL SUBJECT ADDED ENTRY--UNIFORM TITLE (RLIN)', 'LOCAL SUBJECT ADDED ENTRY--UNIFORM TITLE (RLIN)', 1, 0, '', ''), ('700', 'ADDED ENTRY--PERSONAL NAME', 'ADDED ENTRY--PERSONAL NAME', 1, 0, NULL, ''), + ('705', 'ADDED ENTRY--PERSONAL NAME (PERFORMER) (MU) [OBSOLETE]', 'ADDED ENTRY--PERSONAL NAME (PERFORMER) (MU) [OBSOLETE]', 1, 0, NULL, ''), ('710', 'ADDED ENTRY--CORPORATE NAME', 'ADDED ENTRY--CORPORATE NAME', 1, 0, NULL, ''), ('711', 'ADDED ENTRY--MEETING NAME', 'ADDED ENTRY--MEETING NAME', 1, 0, NULL, ''), + ('715', 'ADDED ENTRY--CORPORATE NAME (PERFORMER) (MU) [OBSOLETE]', 'ADDED ENTRY--CORPORATE NAME (PERFORMER) (MU) [OBSOLETE]', 1, 0, NULL, ''), ('720', 'ADDED ENTRY--UNCONTROLLED NAME', 'ADDED ENTRY--UNCONTROLLED NAME', 1, 0, NULL, ''), ('730', 'ADDED ENTRY--UNIFORM TITLE', 'ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL, ''), ('740', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 1, 0, NULL, ''), - ('751','ADDED ENTRY -- GEOGRAFIC NAME','ADDED ENTRY -- GEOGRAFIC NAME','1','0','',''), + ('751', 'ADDED ENTRY--GEOGRAPHIC NAME','ADDED ENTRY--GEOGRAPHIC NAME', 1, 0, NULL, ''), ('752', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL, ''), ('753', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 1, 0, NULL, ''), ('754', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 1, 0, NULL, ''), + ('755', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 1, 0, NULL, ''), ('760', 'MAIN SERIES ENTRY', 'MAIN SERIES ENTRY', 1, 0, NULL, ''), ('762', 'SUBSERIES ENTRY', 'SUBSERIES ENTRY', 1, 0, NULL, ''), ('765', 'ORIGINAL LANGUAGE ENTRY', 'ORIGINAL LANGUAGE ENTRY', 1, 0, NULL, ''), @@ -398,6 +439,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('785', 'SUCCEEDING ENTRY', 'SUCCEEDING ENTRY', 1, 0, NULL, ''), ('786', 'DATA SOURCE ENTRY', 'DATA SOURCE ENTRY', 1, 0, NULL, ''), ('787', 'OTHER RELATIONSHIP ENTRY', 'OTHER RELATIONSHIP ENTRY', 1, 0, NULL, ''), + ('789', 'COMPONENT ITEM ENTRY (RLIN)', 'COMPONENT ITEM ENTRY (RLIN)', 1, 0, '', ''), ('796', 'LOCAL ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''), ('797', 'LOCAL ADDED ENTRY--CORPORATE NAME (RLIN)', 'LOCAL ADDED ENTRY--CORPORATE NAME (RLIN)', 1, 0, '', ''), ('798', 'LOCAL ADDED ENTRY--MEETING NAME (RLIN)', 'LOCAL ADDED ENTRY--MEETING NAME (RLIN)', 1, 0, '', ''), @@ -406,28 +448,36 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('810', 'SERIES ADDED ENTRY--CORPORATE NAME', 'SERIES ADDED ENTRY--CORPORATE NAME', 1, 0, NULL, ''), ('811', 'SERIES ADDED ENTRY--MEETING NAME', 'SERIES ADDED ENTRY--MEETING NAME', 1, 0, NULL, ''), ('830', 'SERIES ADDED ENTRY--UNIFORM TITLE', 'SERIES ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL, ''), + ('840', 'SERIES ADDED ENTRY--TITLE [OBSOLETE]', 'SERIES ADDED ENTRY--TITLE [OBSOLETE]', 1, 0, NULL, ''), ('841', 'HOLDINGS CODED DATA VALUES', 'HOLDINGS CODED DATA VALUES', 0, 0, NULL, ''), ('842', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 0, 0, NULL, ''), ('843', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''), ('844', 'NAME OF UNIT', 'NAME OF UNIT', 0, 0, NULL, ''), ('845', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL, ''), ('850', 'HOLDING INSTITUTION', 'HOLDING INSTITUTION', 1, 0, NULL, ''), + ('851', 'LOCATION [OBSOLETE]', 'LOCATION [OBSOLETE]', 1, 0, NULL, ''), ('852', 'LOCATION', 'LOCATION', 1, 0, NULL, ''), ('853', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, ''), ('854', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 1, 0, NULL, ''), ('855', 'CAPTIONS AND PATTERN--INDEXES', 'CAPTIONS AND PATTERN--INDEXES', 1, 0, NULL, ''), ('856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL, ''), + ('859', 'LOCAL CONTROL INFORMATION (RLIN)', 'LOCAL CONTROL INFORMATION (RLIN)', 1, 0, '', ''), ('863', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, ''), ('864', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 1, 0, NULL, ''), ('865', 'ENUMERATION AND CHRONOLOGY--INDEXES', 'ENUMERATION AND CHRONOLOGY--INDEXES', 1, 0, NULL, ''), ('866', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, ''), ('867', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 1, 0, NULL, ''), ('868', 'TEXTUAL HOLDINGS--INDEXES', 'TEXTUAL HOLDINGS--INDEXES', 1, 0, NULL, ''), + ('870', 'VARIANT PERSONAL NAME (SE) [OBSOLETE]', 'VARIANT PERSONAL NAME (SE) [OBSOLETE]', 1, 0, NULL, ''), + ('871', 'VARIANT CORPORATE NAME (SE)[OBSOLETE]', 'VARIANT CORPORATE NAME (SE)[OBSOLETE]', 1, 0, NULL, ''), + ('872', 'VARIANT CONFERENCE OR MEETING NAME (SE) [OBSOLETE]', 'VARIANT CONFERENCE OR MEETING NAME (SE) [OBSOLETE]', 1, 0, NULL, ''), + ('873', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 1, 0, NULL, ''), ('876', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL, ''), ('877', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 1, 0, NULL, ''), ('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL, ''), ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL, ''), - ('882','REPLACEMENT RECORD INFORMATION','REPLACEMENT RECORD INFORMATION','0','0','',''), + ('882', 'REPLACEMENT RECORD INFORMATION','REPLACEMENT RECORD INFORMATION', 0, 0, NULL, ''), + ('883', 'MACHINE-GENERATED METADATA PROVENANCE','MACHINE-GENERATED METADATA PROVENANCE', 1, 0, NULL, ''), ('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL, ''), ('887', 'NON-MARC INFORMATION FIELD', 'NON-MARC INFORMATION FIELD', 1, 0, NULL, ''), ('896', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 'LOCAL SERIES ADDED ENTRY--PERSONAL NAME (RLIN)', 1, 0, '', ''), @@ -486,6 +536,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('010', 'a', 'LC control number', 'LC control number', 0, 0, 'biblioitems.lccn', 0, '', '', '', 0, 0, '', '', '', NULL), ('010', 'b', 'NUCMC control number', 'NUCMC control number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), + ('011', 'a', 'LC control number', 'LC control number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('013', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', NULL, 0, -6, '', '', '', NULL), ('013', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('013', 'a', 'Number', 'Number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -528,6 +579,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('022','m','Canceled ISSN-L','Canceled ISSN-L','1','0','','0','','','','0','0','','','',NULL), ('022', 'y', 'Incorrect ISSN', 'Incorrect ISSN', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), ('022', 'z', 'Canceled ISSN', 'Canceled ISSN', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), + ('023', 'a', 'Standard film number', 'Standard film number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('024', '2', 'Source of number or code', 'Source of number or code', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), ('024', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('024', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -554,6 +606,11 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('028', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('028', 'a', 'Publisher number', 'Publisher number', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), ('028', 'b', 'Source', 'Source', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), + ('028', 'q', 'Qualifying information', 'Qualifying information', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), + ('029', 'a', 'OCLC library identifier', 'OCLC library identifier', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('029', 'b', 'System control number', 'System control number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('029', 'c', 'OAI set name', 'OAI set name', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('029', 't', 'Content type identifier', 'Content type identifier', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('030', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('030', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('030', 'a', 'CODEN', 'CODEN', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -582,7 +639,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('032', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('032', 'a', 'Postal registration number', 'Postal registration number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('032', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('033','0','Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), + ('033','0','Record control number','Record control number','1','0','','0','','','','0','-6', '', '', '', NULL), ('033','2','Source of term','Source of term','1','0','','0','','','','0','-6', '', '', '', NULL), ('033', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('033', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -634,6 +691,11 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('038', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('038', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('038', 'a', 'Record content licensor', 'Record content licensor', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('039', 'a', 'Bibliographic description - level of rules used', 'Bibliographic description - level of rules used', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('039', 'b', 'Access points excluding subject access - level of effort used to assign access', 'Access points excluding subject access - level of effort used to assign access', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('039', 'c', 'Subject headings - level of effort used to assign', 'Subject headings - level of effort used to assign', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('039', 'd', 'Classification - level of effort used to assign', 'Classification - level of effort used to assign', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('039', 'e', 'Fixed fields - number of positions coded', 'Fixed fields - number of positions coded', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('040', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('040', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), @@ -704,7 +766,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('049', 'p', 'Secondary bibliographic subdivision', 'Secondary bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('049', 'q', 'Third bibliographic subdivision', 'Third bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('049', 'r', 'Fourth bibliographic subdivision', 'Fourth bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('049', 's', 'Fifth bibliographic subdivision', 'Fifth bibliographic subdivision', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('049', 's', 'Fifth bibliographic subdivision', 'Fifth bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('049', 't', 'Sixth bibliographic subdivision', 'Sixth bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('049', 'u', 'Seventh bibliographic subdivision', 'Seventh bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('049', 'v', 'Primary bibliographic subdivision', 'Primary bibliographic subdivision', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), @@ -801,6 +863,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('086', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('086', 'a', 'Classification number', 'Classification number', 0, 0, NULL, 0, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('086', 'z', 'Canceled/invalid classification number', 'Canceled/invalid classification number', 1, 0, NULL, 0, NULL, NULL, '', NULL, -1, '', '', '', NULL), + ('087', 'a', 'Report number [OBSOLETE, CAN/MARC]', 'Report number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), + ('087', 'z', 'Canceled/invalid report number [OBSOLETE, CAN/MARC]', 'Canceled/invalid report number [OBSOLETE, CAN/MARC]', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('088', '6', 'Linkage', 'Linkage', 0, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('088', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('088', 'a', 'Report number', 'Report number', 0, 0, NULL, 0, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -834,7 +898,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('099', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), ('099', 'e', 'Feature heading', 'Feature heading', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('099', 'f', 'Filing suffix', 'Filing suffix', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('100','0','Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), + ('100', '0', 'Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), @@ -854,7 +918,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL), ('100', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), ('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL), - ('110','0','Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), + ('110', '0', 'Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), ('110', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL), ('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), @@ -872,7 +936,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('110', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', 't', 'Title of a work', 'Title of a work', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), ('110', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL), - ('111','0','Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), + ('111', '0', 'Authority record control number','Authority record control number','1','0','','0','','','','0','-6', '', '', '', NULL), ('111', '4', 'Relator code', 'Relator code', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -891,7 +955,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('111', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('111', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), - ('130','0','Authority record control number ','Authority record control number ','1','0','','0','','','','0','-6', '', '', '', NULL), + ('130', '0', 'Authority record control number ','Authority record control number ','1','0','','0','','','','0','-6', '', '', '', NULL), ('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL), @@ -914,11 +978,17 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('210', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('210', 'a', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('210', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), + ('211', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('211', 'a', 'Acronym or shortened title', 'Acronym or shortened title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('212', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('212', 'a', 'Variant access title', 'Variant access title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('214', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('214', 'a', 'Augmented title', 'Augmented title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('222', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('222', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('222', 'a', 'Key title', 'Key title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL), - ('240','0','Authority record control number','Authority record control number','1','0','','2','','','','0','-1', '', '', '', NULL), + ('240', '0', 'Authority record control number','Authority record control number','1','0','','2','','','','0','-1', '', '', '', NULL), ('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL), @@ -935,6 +1005,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('240', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL), ('240', 'r', 'Key for music', 'Key for music', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), ('240', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', 0, -1, '', '', '', NULL), + ('241', 'a', 'Romanized title', 'Romanized title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('241', 'h', 'Medium', 'Medium', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('242', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('242', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('242', 'a', 'Title', 'Title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1020,7 +1092,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('258', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('258', 'a', 'Issuing jurisdiction', 'Issuing jurisdiction', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('258', 'b', 'Denomination', 'Denomination', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), - ('260','3','Materials specified ','Materials specified ','0','0','','2','','','','0','-6', '', '', '', NULL), + ('260','3','Materials specified','Materials specified','0','0','','2','','','','0','-6', '', '', '', NULL), ('260', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'a', 'Place of publication, distribution, etc', 'Place of publication, distribution, etc', 1, 0, 'biblioitems.place', 2, '', '', '', NULL, 0, '', '', '', NULL), @@ -1029,6 +1101,21 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('260', 'e', 'Place of manufacture', 'Place of manufacture', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'f', 'Manufacturer', 'Manufacturer', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('260', 'g', 'Date of manufacture', 'Date of manufacture', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'a', 'Producing company', 'Producing company', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'b', 'Releasing company (primary distributor)', 'Releasing company (primary distributor)', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'c', 'Date of production, release, etc.', 'Date of production, release, etc.', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'd', 'Date of production, release, etc.', 'Date of production, release, etc.', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'e', 'Contractual producer', 'Contractual producer', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('261', 'f', 'Place of production, release, etc.', 'Place of production, release, etc.', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', 'a', 'Place of production, release, etc.', 'Place of production, release, etc.', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', 'b', 'Publisher or trade name', 'Publisher or trade name', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', 'c', 'Date of production, release, etc.', 'Date of production, release, etc.', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', 'k', 'Serial identification', 'Serial identification', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('262', 'l', 'Matrix and/or take number', 'Matrix and/or take number', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('263', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('263', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('263', 'a', 'Projected publication date', 'Projected publication date', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), @@ -1038,6 +1125,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('264','a','Place of production, publication, distribution, manufacture','Place of production, publication, distribution, manufacture','1','0','','2','','','','0','-6', '', '', '', NULL), ('264','b','Name of producer, publisher, distributor, manufacturer','Name of producer, publisher, distributor, manufacturer','1','0','','2','','','','0','-6', '', '', '', NULL), ('264','c','Date of production, publication, distribution, manufacture, or copyright notice','Date of production, publication, distribution, manufacture, or copyright notice','1','0','','2','','','','0','-6', '', '', '', NULL), + ('265', '6', 'Linkage [OBSOLETE]', 'Linkage [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), + ('265', 'a', 'Source for acquisition/subscription address [OBSOLETE]', 'Source for acquisition/subscription address [OBSOLETE]', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1068,6 +1157,24 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('300', 'e', 'Accompanying material', 'Accompanying material', 0, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), ('300', 'f', 'Type of unit', 'Type of unit', 1, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), ('300', 'g', 'Size of unit', 'Size of unit', 1, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), + ('301', 'a', 'Extent of item', 'Extent of item', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('301', 'b', 'Sound characteristics', 'Sound characteristics', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('301', 'c', 'Color characteristics', 'Color characteristics', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('301', 'd', 'Dimensions', 'Dimensions', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('301', 'e', 'Sound characteristics', 'Sound characteristics', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('301', 'f', 'Speed', 'Speed', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('302', 'a', 'Page count', 'Page count', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('303', 'a', 'Unit count', 'Unit count', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('304', 'a', 'Linear footage', 'Linear footage', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('305', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'a', 'Extent', 'Extent', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'b', 'Other physical details', 'Other physical details', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'c', 'Dimensions', 'Dimensions', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('305', 'd', 'Microgroove or standard', 'Microgroove or standard', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'e', 'Stereophonic, monaural', 'Stereophonic, monaural', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'f', 'Number of tracks', 'Number of tracks', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), + ('305', 'm', 'Serial identification', 'Serial identification', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('305', 'n', 'Matrix and/or take number', 'Matrix and/or take number', 0, 0, '', 3, '', '', NULL, NULL, -6, '', '', '', NULL), ('306', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('306', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('306', 'a', 'Playing time', 'Playing time', 1, 0, '', 3, '', '', '', NULL, 0, '', '', '', NULL), @@ -1075,10 +1182,21 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('307', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('307', 'a', 'Hours', 'Hours', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('307', 'b', 'Additional information', 'Additional information', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'a', 'Number of reels', 'Number of reels', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'b', 'Footage', 'Footage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'c', 'Sound characteristics', 'Sound characteristics', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'd', 'Color characteristics', 'Color characteristics', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'e', 'Width', 'Width', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('308', 'f', 'Presentation format', 'Presentation format', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('310', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('310', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('310', 'a', 'Current publication frequency', 'Current publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('310', 'b', 'Date of current publication frequency', 'Date of current publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('315', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('315', 'a', 'Frequency', 'Frequency', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), + ('315', 'b', 'Dates of frequency', 'Dates of frequency', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), ('321', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1194,6 +1312,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('347','d','Resolution','Resolution','1','0','','3','','','','0','-6', '', '', '', NULL), ('347','e','Regional encoding','Regional encoding','1','0','','3','','','','0','-6', '', '', '', NULL), ('347','f','Transmission speed','Transmission speed','1','0','','3','','','','0','-6', '', '', '', NULL), + ('350', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('350', 'a', 'Price', 'Price', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('350', 'b', 'Form of issue', 'Form of issue', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('351', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('351', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('351', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1228,6 +1349,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('357', 'b', 'Originating agency', 'Originating agency', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('357', 'c', 'Authorized recipients of material', 'Authorized recipients of material', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('357', 'g', 'Other restrictions', 'Other restrictions', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('359', 'a', 'Rental price', 'Rental price', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('362', '6', 'Linkage', 'Linkage', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('362', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('362', 'a', 'Dates of publication and/or sequential designation', 'Dates of publication and/or sequential designation', 0, 0, 'biblioitems.volumedesc', 3, NULL, NULL, '', NULL, -1, '', '', '', NULL), @@ -1318,7 +1440,74 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('384','6','Linkage','Linkage','0','0','','3','','','','0','-1', '', '', '', NULL), ('384','8','Field link and sequence number','Field link and sequence number','1','0','','3','','','','0','-1', '', '', '', NULL), ('384','a','Key','Key','0','0','','3','','','','0','-1', '', '', '', NULL), - ('490','3','Materials specified ','Materials specified ','0','0','','3','','','','0','-1','','','', NULL), + ('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('400', 'a', 'Personal name', 'Personal name', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'b', 'Numeration', 'Numeration', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'e', 'Relator term', 'Relator term', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 't', 'Title of a work', 'Title of a work', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('400', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('400', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL), + ('410', 'a', 'Corporate name or jurisdiction name as entry element', 'Corporate name or jurisdiction name as entry element', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'b', 'Subordinate unit', 'Subordinate unit', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'c', 'Location of meeting', 'Location of meeting', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'e', 'Relator term', 'Relator term', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 't', 'Title of a work', 'Title of a work', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('410', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('411', '4', 'Relator code', 'Relator code', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', '6', 'Linkage', 'Linkage', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('411', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'c', 'Location of meeting', 'Location of meeting', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('411', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), + ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL), + ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, '', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL), + ('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL), + ('490','3','Materials specified','Materials specified','0','0','','3','','','','0','-1','','','', NULL), ('490', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL), ('490', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', NULL, NULL, -6, '', '', '', NULL), ('490', 'a', 'Series statement', 'Series statement', 1, 0, '', 4, '', '', '', NULL, -1, '', '', '', NULL), @@ -1342,6 +1531,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('502','d','Year degree granted','Year degree granted','0','0','','5','','','','0','-6', '', '', '', NULL), ('502','g','Miscellaneous information','Miscellaneous information','1','0','','5','','','','0','-6', '', '', '', NULL), ('502','o','Dissertation identifier','Dissertation identifier','1','0','','5','','','','0','-6', '', '', '', NULL), + ('503', '8', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('503', 'a', 'Bibliographic history note', 'Bibliographic history note', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('504', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('504', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('504', 'a', 'Bibliography, etc', 'Bibliography, etc', 0, 0, '', 5, NULL, NULL, '', NULL, 0, '', '', '', NULL), @@ -1384,6 +1575,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('511', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('511', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('511', 'a', 'Participant or performer note', 'Participant or performer note', 0, 0, '', 5, '', '', '', NULL, 0, '', '', '', NULL), + ('512', '6', 'Linkage', 'Linkage', 0, 0, '', -1, '', '', '', NULL, -6, '', '', '', NULL), + ('512', 'a', 'Earlier or later volumes separately cataloged note', 'Earlier or later volumes separately cataloged note', 0, 0, '', -1, '', '', '', NULL, -6, '', '', '', NULL), ('513', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('513', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('513', 'a', 'Type of report', 'Type of report', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1410,6 +1603,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('516', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('516', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('516', 'a', 'Type of computer file or data note', 'Type of computer file or data note', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('517', 'a', 'Different formats', 'Different formats', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('517', 'b', 'Content descriptors', 'Content descriptors', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('517', 'c', 'Additional animation techniques', 'Additional animation techniques', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('518','0','Record control number','Record control number','1','0','','5','','','','0','-6', '', '', '', NULL), ('518','2','Source of term','Source of term','1','0','','5','','','','0','-6', '', '', '', NULL), ('518', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1417,7 +1613,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('518', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('518', 'a', 'Date/time and place of an event note', 'Date/time and place of an event note', 0, 0, '', 5, '', '', '', NULL, 0, '', '', '', NULL), ('518','d','Date of event','Date of event','1','0','','5','','','','0','0', '', '', '', NULL), - ('518','o','Other event information','Other event information','1','0','','5','','','','0','0', '', '', '', NULL), + ('518','o','Other event information','Other event information','0','0','','5','','','','0','0', '', '', '', NULL), ('518','p','Place of event','Place of event','1','0','','5','','','','0','0', '', '', '', NULL), ('520','2','Source','Source','0','0','','5','','','','0','0', '', '', '', NULL), ('520', '3', 'Materials specified', 'Materials specified', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1435,6 +1631,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('522', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('522', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('522', 'a', 'Geographic coverage note', 'Geographic coverage note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), + ('523', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('523', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('523', 'a', 'Time period of content note', 'Time period of content note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('524', '2', 'Source of schema used', 'Source of schema used', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('524', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('524', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1453,6 +1652,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('526', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('526', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 5, '', '', '', NULL, 6, '', '', '', NULL), ('526', 'z', 'Public note', 'Public note', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), + ('527', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('527', 'a', 'Censorship note', 'Censorship note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('530', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('530', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('530', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1474,7 +1675,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('533', 'f', 'Series statement of reproduction', 'Series statement of reproduction', 1, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('533', 'm', 'Dates and/or sequential designation of issues reproduced', 'Dates and/or sequential designation of issues reproduced', 1, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), ('533', 'n', 'Note about reproduction', 'Note about reproduction', 1, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), - ('534','3','Materials specified ','Materials specified ','0','0','','5','','','','0','-1', '', '', '', NULL), + ('534','3','Materials specified','Materials specified','0','0','','5','','','','0','-1', '', '', '', NULL), ('534', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('534', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('534', 'a', 'Main entry of original', 'Main entry of original', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1509,6 +1710,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('536', 'f', 'Project number', 'Project number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('536', 'g', 'Task number', 'Task number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('536', 'h', 'Work unit number', 'Work unit number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('537', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('537', 'a', 'Source of data note', 'Source of data note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('538', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('538','5','Institution to which field applies','Institution to which field applies','1','0','','5','','','','0','-6', '', '', '', NULL), ('538', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1540,12 +1743,12 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, '', '', '', NULL), ('542','3','Materials specified','Materials specified','0','0','','5','','','','0','1', '', '', '', NULL), ('542','6','Linkage','Linkage','0','0','','5','','','','0','1', '', '', '', NULL), - ('542','8','Field link and sequence number ','Field link and sequence number ','0','0','','5','','','','0','1', '', '', '', NULL), - ('542','a','Personal creator ','Personal creator ','0','0','','5','','','','0','1', '', '', '', NULL), + ('542','8','Field link and sequence number','Field link and sequence number','0','0','','5','','','','0','1', '', '', '', NULL), + ('542','a','Personal creator','Personal creator','0','0','','5','','','','0','1', '', '', '', NULL), ('542','b','Personal creator death date',' Personal creator death date','0','0','','5','','','','0','1', '', '', '', NULL), ('542','c','Corporate creator','Corporate creator','0','0','','5','','','','0','1', '', '', '', NULL), - ('542','d','Copyright holder ','Copyright holder ','1','0','','5','','','','0','1', '', '', '', NULL), - ('542','e','Copyright holder contact information ','Copyright holder contact information ','1','0','','5','','','','0','1', '', '', '', NULL), + ('542','d','Copyright holder','Copyright holder','1','0','','5','','','','0','1', '', '', '', NULL), + ('542','e','Copyright holder contact information','Copyright holder contact information','1','0','','5','','','','0','1', '', '', '', NULL), ('542','f','Copyright statement','Copyright statement','1','0','','5','','','','0','1', '', '', '', NULL), ('542','g','Copyright date','Copyright date','0','0','','5','','','','0','1', '', '', '', NULL), ('542','h','Copyright renewal date','Copyright renewal date','1','0','','5','','','','0','1', '', '', '', NULL), @@ -1556,11 +1759,13 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('542','m','Publication status','Publication status','0','0','','5','','','','0','1', '', '', '', NULL), ('542','n','Note','Note','1','0','','5','','','','0','1', '', '', '', NULL), ('542','o','Research date','Research date','0','0','','5','','','','0','1', '', '', '', NULL), - ('542','p','Country of publication or creation ','Country of publication or creation ','1','0','','5','','','','0','1', '', '', '', NULL), + ('542','p','Country of publication or creation','Country of publication or creation','1','0','','5','','','','0','1', '', '', '', NULL), ('542','q','Supplying agency','Supplying agency','0','0','','5','','','','0','1', '', '', '', NULL), ('542','r','Jurisdiction of copyright assessment','Jurisdiction of copyright assessment','0','0','','5','','','','0','1', '', '', '', NULL), ('542','s','Source of information','Source of information','0','0','','5','','','','0','1', '', '', '', NULL), ('542','u','Uniform Resource Identifier','Uniform Resource Identifier','1','0','','5','','','','0','1', '', '', '', NULL), + ('543', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('543', 'a', 'Solicitation information note', 'Solicitation information note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('544', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('544', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), ('544', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1650,6 +1855,9 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('567', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('567', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('567', 'a', 'Methodology note', 'Methodology note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('570', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('570', 'a', 'Editor note', 'Editor note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('570', 'z', 'Source of note information', 'Source of note information', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('580', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('580', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('580', 'a', 'Linking entry complexity note', 'Linking entry complexity note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -1658,6 +1866,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('581', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('581', 'a', 'Publications about described materials note', 'Publications about described materials note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('581', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('582', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('582', 'a', 'Related computer files note', 'Related computer files note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), @@ -1857,6 +2067,10 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('651', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('651', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), ('651', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, 0, '', '', '', NULL), + ('652', 'a', 'Geographic name of place element', 'Geographic name of place element', 0, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('652', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('652', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), + ('652', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 6, '', '', '', NULL, -6, '', '', '', NULL), ('653', '6', 'Linkage', 'Linkage', 0, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('653', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 6, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('653', 'a', 'Uncontrolled term', 'Uncontrolled term', 1, 0, NULL, 6, NULL, NULL, '', NULL, 0, '', '', '', NULL), @@ -2098,6 +2312,23 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('700', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'e', 'Relator term', 'Relator term', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'h', 'Medium', 'Medium', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 'r', 'Key for music', 'Key for music', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 's', 'Version', 'Version', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('705', 't', 'Title of a work', 'Title of a work', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710','0','Authority record control number','Authority record control number','1','0','','7','','','','0','0', '', '', '', NULL), ('710', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('710', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, 0, '', '', '', NULL), @@ -2150,6 +2381,21 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('711', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('711', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', '%', '% (RLIN)', '% (RLIN)', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('715', 'a', 'Corporate name or jurisdiction name', 'Corporate name or jurisdiction name', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'b', 'Subordinate unit', 'Subordinate unit', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'e', 'Relator term', 'Relator term', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'h', 'Medium', 'Medium', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'r', 'Key for music', 'Key for music', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 's', 'Version', 'Version', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('715', 'u', 'Nonprinting information', 'Nonprinting information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('720', '4', 'Relator code', 'Relator code', 1, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL), ('720', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('720', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2217,6 +2463,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('754', 'd', 'Common or alternative name', 'Common or alternative name', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('754', 'x', 'Non-public note', 'Non-public note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('754', 'z', 'Public note', 'Public note', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('755', '2', 'Source of taxonomic identification', 'Source of taxonomic identification', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('755', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('755', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('755', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('755', 'a', 'Access term', 'Access term', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('755', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('755', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('755', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('760','4','Relationship code','Relationship code','1','0','','7','','','','0','-6', '', '', '', NULL), ('760', '6', 'Linkage', 'Linkage', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('760', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), @@ -2558,6 +2812,41 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('787', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'y', 'CODEN designation', 'CODEN designation', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), ('787', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('789', '%', '%', '%', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), + ('789', '2', '2', '2', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '3', '3', '3', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '4', '4', '4', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '5', '5', '5', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '6', '6', '6', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '7', '7', '7', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '8', '8', '8', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', '9', '9', '9', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'a', 'a', 'a', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'b', 'b', 'b', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'c', 'c', 'c', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'd', 'd', 'd', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'e', 'e', 'e', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'f', 'f', 'f', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'g', 'g', 'g', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'h', 'h', 'h', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'i', 'i', 'i', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'j', 'j', 'j', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'k', 'k', 'k', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'l', 'l', 'l', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'm', 'm', 'm', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'n', 'n', 'n', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'o', 'o', 'o', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'p', 'p', 'p', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'q', 'q', 'q', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'r', 'r', 'r', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 's', 's', 's', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 't', 't', 't', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'u', 'u', 'u', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'v', 'v', 'v', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'w', 'w', 'w', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'x', 'x', 'x', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'y', 'y', 'y', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), + ('789', 'z', 'z', 'z', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('796', '%', '% (RLIN)', '% (RLIN)', 0, 0, '', 7, '', '', '', 0, -6, '', '', '', NULL), ('796', '3', 'Materials specified', 'Materials specified', 0, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), ('796', '4', 'Relator code', 'Relator code', 1, 0, '', 7, '', '', '', NULL, -6, '', '', '', NULL), @@ -2796,6 +3085,15 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('845','u','Uniform Resource Identifier','Uniform Resource Identifier','1','0','','8','','','','0','5','','','', NULL), ('850', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), ('850', 'a', 'Holding institution', 'Holding institution', 1, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', '6', 'Linkage', 'Linkage', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'a', 'Name (custodian or owner)', 'Name (custodian or owner)', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'b', 'Institutional division', 'Institutional division', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'c', 'Street address', 'Street address', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'd', 'Country', 'Country', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'e', 'Location of units', 'Location of units', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'f', 'Item number', 'Item number', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), + ('851', 'g', 'Repository location code', 'Repository location code', 0, 0, NULL, 8, NULL, NULL, '', NULL, 5, '', '', '', NULL), ('852', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('852', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), @@ -2928,6 +3226,14 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('856', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 1, '', '', '', NULL), ('856', 'y', 'Link text', 'Link text', 1, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL), ('856', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL), + ('859', 'b', 'Operator\'s initials, OID (RLIN)', 'Operator\'s initials, OID (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'c', 'Cataloger\'s initials, CIN (RLIN)', 'Cataloger\'s initials, CIN (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'd', 'TDC (RLIN)', 'TDC (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'l', 'LIB (RLIN)', 'LIB (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'p', 'PRI (RLIN)', 'PRI (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'r', 'REG (RLIN)', 'REG (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'v', 'VER (RLIN)', 'VER (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('859', 'x', 'LDEL (RLIN)', 'LDEL (RLIN)', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), ('863','6','Linkage ','Linkage ','0','0','','8','','','','0','5', '', '', '', NULL), ('863','8','Field link and sequence number','Field link and sequence number','0','0','','8','','','','0','5', '', '', '', NULL), ('863','a','First level of enumeration','First level of enumeration','0','0','','8','','','','0','5', '', '', '', NULL), @@ -3019,6 +3325,72 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('868', 'a', 'Textual holdings', 'Textual holdings', 0, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), ('868', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), ('868', 'z', 'Public note', 'Public note', 1, 0, '', 8, '', '', '', 0, 5, '', '', '', NULL), + ('870', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'j', 'Tag and sequence number', 'Tag and sequence number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('870', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', '4', 'Relator code', 'Relator code', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'a', 'Corporate name or jurisdiction name as entry element', 'Corporate name or jurisdiction name as entry element', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'b', 'Subordinate unit', 'Subordinate unit', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'c', 'Location of meeting', 'Location of meeting', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'd', 'Date of meeting or treaty signing', 'Date of meeting or treaty signing', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'e', 'Relator term', 'Relator term', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'j', 'Tag and sequence number', 'Tag and sequence number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('871', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('872', '4', 'Relator code', 'Relator code', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', '6', 'Linkage', 'Linkage', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'c', 'Location of meeting', 'Location of meeting', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'd', 'Date of meeting', 'Date of meeting', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'e', 'Subordinate unit', 'Subordinate unit', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'j', 'Tag and sequence number', 'Tag and sequence number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('872', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'n', 'Number of part/section/meeting', 'Number of part/section/meeting', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'q', 'Name of meeting following jurisdiction name entry element', 'Name of meeting following jurisdiction name entry element', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('872', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 8, NULL, NULL, '', NULL, -6, '', '', '', NULL), + ('873', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'a', 'Uniform title', 'Uniform title', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'h', 'Medium', 'Medium', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'j', 'Tag and sequence number', 'Tag and sequence number', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'm', 'Medium of performance for music', 'Medium of performance for music', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 'r', 'Key for music', 'Key for music', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 's', 'Version', 'Version', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), + ('873', 't', 'Title of a work', 'Title of a work', 0, 0, '', 8, '', '', '', NULL, -6, '', '', '', NULL), ('876', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('876', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), ('876', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL), @@ -3108,6 +3480,15 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('882','a','Replacement title','Replacement title','1','0','','8','','','','0','5', '', '', '', NULL), ('882','i','Explanatory text','Explanatory text','1','0','','8','','','','0','5', '', '', '', NULL), ('882','w','Replacement bibliographic record control number','Replacement bibliographic record control number','1','0','','8','','','','0','5', '', '', '', NULL), + ('883','0','Authority record control number or standard number','Authority record control number or standard number','1','0','','8','','','','0','5', '', '', '', NULL), + ('883','8','Field link and sequence number','Field link and sequence number','1','0','','8','','','','0','5', '', '', '', NULL), + ('883','a','Generation process','Generation process','0','0','','8','','','','0','5', '', '', '', NULL), + ('883','c','Confidence value','Confidence value','0','0','','8','','','','0','5', '', '', '', NULL), + ('883','d','Generation date','Generation date','0','0','','8','','','','0','5', '', '', '', NULL), + ('883','q','Generation agency','Generation agency','0','0','','8','','','','0','5', '', '', '', NULL), + ('883','u','Uniform Resource Identifier','Uniform Resource Identifier','0','0','','8','','','','0','5', '', '', '', NULL), + ('883','w','Bibliographic record control number','Bibliographic record control number','1','0','','8','','','','0','5', '', '', '', NULL), + ('883','x','Validity end date','Validity end date','0','0','','8','','','','0','5', '', '', '', NULL), ('886','0','Foreign MARC subfield (R)','Foreign MARC subfield (R)','1','0','','8','','','','0','-6', '', '', '', NULL), ('886','1','Foreign MARC subfield (R)','Foreign MARC subfield (R)','1','0','','8','','','','0','-6', '', '', '', NULL), ('886','2','Source of data','Source of data','0','0','','8','','','','0','-6', '', '', '', NULL), @@ -3971,4 +4352,4 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` UPDATE `marc_subfield_structure` SET maxlength=24 WHERE tagfield='000'; -UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008'; \ No newline at end of file +UPDATE `marc_subfield_structure` SET maxlength=40 WHERE tagfield='008'; -- 1.7.9.5