Add a column to the Biblio table for Remainder Of Title / Subtitle

In USMARC there is the subfield 245$b which is Remainder Of Title. In Koha 2.2 this field was linked to the database table and column bibliosubtitle.subtitle. This table does not exist in Koha 3. Being able to see this subfield in search results would be very helpful on some biblio records.

In order to get this subfield on the search results template it must be linked to a database column. In testing it seems that the column does not need to be filled for the proper value to reach the template. This means existing database rows do not need to be updated.

• Should a command line script be included to update existing rows with the value from this subfield in the MARC record

1. The command line script is included. The question remains whether the updatedatabase.pl block should call the command line script.

• The column will be called remainderoftitle because subtitle is already used in the staff template
• UNIMARC subfield 200$e will be linked too.

• Modify templates in the staff and OPAC interfaces to show this

1. Staff Search Results: koha-tmpl/intranet-tmpl/…/modules/catalogue/results.tmpl
2. Staff Biblio Details: koha-tmpl/intranet-tmpl/…/modules/catalogue/detail.tmpl
3. OPAC Search Results : koha-tmpl/opac-tmpl/…/modules/opac-results.tmpl
4. OPAC Biblio Details : koha-tmpl/opac-tmpl/…/modules/opac-detail.tmpl

• Update Default MARC framework to link database column to MARC subfield

1. Modify default framework definition: in installer/data/ mysql and Pg / en and fr-FR /marcflavour/ marc21 and unimarc /mandatory/ marc21_framework_DEFAULT.sql or unimarc_framework_DEFAULT.sql
   1. mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
   2. mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql
   3. mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql
   4. mysql/fr-FR/marcflavour/unimarc/Obligatoire/unimarc_framework_DEFAULT.sql
   5. Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
2. Add to updatedatabase.pl: sql to update marc_subfield_structure to set kohafield to biblio.subtitle

• Update Database

1. Modify kohastructure.sql: installer/data/ mysql and Pg /kohastructure.sql
2. Add to updatedatabase.pl: sql to add the column to the biblio table

• Patch Submitted