Bug 32313 - Complete database column descriptions for cataloguing module in guided reports
Summary: Complete database column descriptions for cataloguing module in guided reports
Status: ASSIGNED
Alias: None
Product: Koha
Classification: Unclassified
Component: I18N/L10N (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor (vote)
Assignee: David Nind
QA Contact: Testopia
URL:
Keywords: Academy
Depends on: 29695 32292
Blocks:
  Show dependency treegraph
 
Reported: 2022-11-21 22:27 UTC by Katrin Fischer
Modified: 2022-12-06 03:25 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2022-11-21 22:27:46 UTC
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
Comment 1 David Nind 2022-12-05 01:26:07 UTC
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