There are entries missing for the biblioitems table. Bug 32292 takes care of missing entries in biblio and items. How to test: * Add a new guided report * Select module catalog * Verify that statistics is missing some descriptions, only showing the database value
There are a couple of columns I'm not sure about for this. Columns with no descriptions ============================ biblioitems.ean biblioitems.collectiontitle biblioitems.collectionissn biblioitems.collectionvolume biblioitems.editionstatement biblioitems.editionresponsibility biblioitems.cn_source biblioitems.cn_class biblioitems.cn_item biblioitems.cn_suffix biblioitems.cn_sort biblioitems.totalissues Column descriptions I have identified ===================================== I've identified these ones, and a reasonably comfortable with them - notes are in brackets and footnotes (these won't be included as part of the column description). biblioitems.ean => EAN biblioitems.collectiontitle => Series statement [1] biblioitems.collectionissn => Series ISSN [2] biblioitems.editionstatement => Edition statement (250$a) [3] biblioitems.cn_source => Source of classification/shelving scheme (942$2) [3][4] biblioitems.cn_class => Classification part (942$h) [3] biblioitems.cn_item => Item part (942$i) [3] biblioitems.cn_suffix => Call number suffix (942$m) [3] biblioitems.cn_sort => Koha normalized classification for sorting (942$6) [3] [5] biblioitems.totalissues => Total checkouts (942$0) [3] [6] [1] Could reword as "Series title" [2] See Bug 29635 - Map biblioitems.collectionissn to 490$x by default (MARC21) [3] Description from Koha to MARC mappings [4] Description from 942$2 is "Source of classification or shelving scheme", have used the same as the items table. [5] The items table uses "Koha normalized classification for sorting", so have kept the same for consistency. [6] Name used in Koha to MARC mappings is "Koha issues (borrowed), all copies". Have used the same description used for items. Columns I am not sure about =========================== I'd welcome some information on these items. I couldn't figure out where these came from - which just reflects my limited MARC and Koha reporting knowledge! biblioitems.collection* ~~~~~~~~~~~~~~~~~~~~~~ I've mapped collectiontitle and collectionissn as above, however I noted using a git grep search that for UNIMARC: - 225$a Series title: is mapped to field biblioitems.collectiontitle - 225$v Volume Designation: is mapped to biblioitems.collectionvolume - 225$x ISSN of Series: is mapped to biblioitems.collectionissn In UNIMARC, 225 is for "Series". biblioitems.collectionvolume ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Possibly "Series volume number"? The title for 490$v (MARC21), if that is the related field, is "Volume/sequential designation". However, biblioitems already has "Volume number" for biblioitems.volume, that is mapped in the Koha to MARC mappings to 440$v and 490$v. When using UNIMARC, 225$v is mapped to the biblioitems.collectionvolume field and called "Volume Designation". biblioitems.editionresponsibility ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Possibly "Edition responsibility"? In UNIMARC, 225$f Statement of Responsibility is mapped to Koha field biblioitems.editionresponsibility. (From installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.yml) Note that 250 in MARC21 has $b - Remainder of edition statement: Usually, a statement of personal or corporate responsibility and/or a parallel edition statement. https://www.loc.gov/marc/bibliographic/bd250.html Koha/Bibliotem.pm has this (line 48): editionresponsibility => undef, # obsolete, not mapped