https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32313
David Nind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the| |This enhancement adds release notes| |missing column descriptions | |to the items and | |biblioitems tables used in | |guided reports (these | |tables are used when | |selecting the Circulation, | |Catalog, Acquisitions, and | |Serials modules). | | | |It also | |updates some column | |descriptions used in other | |modules for consistency or | |clarification. --- Comment #3 from David Nind <[email protected]> --- Feel free to suggest alternative column names, or correct comes that I have gotten wrong. Notes on column description changes =================================== Naming approach: - Generally, use the subfield name used in the MARC framework or Koha to MARC mapping. - Otherwise use a name that: . makes sense, or . is consistent with other names, or . makes it clearer what the column contains. Columns with no descriptions - items ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ . items.itemnumber => Koha item number (autogenerated) (952$9) [1] . items.biblionumber => Biblio number (internal) (consistency with other tables) . items.bookable => Bookable . items.localuse => Total local uses (Bug 16122 - Item record needs to keep local use count) Columns with no descriptions - biblioitems ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - biblioitems.ean => EAN - biblioitems.collectiontitle => Series statement (490$a) [2] - biblioitems.collectionissn => Series ISSN (490$x) [3] - biblioitems.collectionvolume => Series volume (490$v) [4] - biblioitems.editionstatement => Edition statement (250$a) - biblioitems.editionresponsibility => Edition responsibility (250$b) [5] - biblioitems.cn_source => Source of classification or shelving scheme (942$2) [1][6] - biblioitems.cn_class => Classification part (942$h) [1] - biblioitems.cn_item => Item part (942$i) [1] - biblioitems.cn_suffix => Call number suffix (942$m) [1] - biblioitems.cn_sort => Koha normalized classification for sorting (942$6) [1][7] - biblioitems.totalissues => Koha issues (borrowed), all copies (952$0) [1][8] Column descriptions changed ~~~~~~~~~~~~~~~~~~~~~~~~~~~ These column descriptions were changed for consistency or clarification: - biblioitems.timestamp => Modification date (same title used for biblio.timestamp) - biblioitems.illus => Other physical details (maps to 300$b, have used same title used for that subfield and MARC21 definition) - biblioitems.biblioitemnumber, items.biblioitemnumber => Biblio item number (internal) (consistency) - acqorders.biblionumber, biblio.biblionumber, bibliotems.biblionumber => Biblio number (internal) (consistency with other tables) - items.cn_source => Source of classification or shelving scheme (consistency with biblioitems.cn_source) - items.itype => Koha item type (consistency with statistics and suggestions) - items.timestamp => Modification date (same title used for biblio.timestamp and biblioitems.timestamp) - suggestions.itemtype => Koha item type (consistency with items and statistics) Order of columns in source file ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Most tables are sorted by the column name in the source file. I updated items and statistics tables to sort in this order. I think these were originally in the order that the columns appear in the database table. Happy to change to database table order if this is required. Notes ~~~~~ [1] Description from Koha to MARC mappings. [2] Could reword as "Series title", but have used the 490$a description. [3] See Bug 29635 - Map biblioitems.collectionissn to 490$x by default (MARC21) (bug status = NEW). [4] Full name in 490$v is 'Series volume/sequential designation', but 'Series volume' is probably sufficient (MARC21 definition label is 'Volume/sequential designation'). [5] Full name in 250$b is 'Remainder of edition statement', but 'Edition responsibility' is probably sufficient (MARC21 definition is "Usually, a statement of personal or corporate responsibility and/or a parallel edition statement.".) [6] Description from 942$2 is "Source of classification or shelving scheme", have updated items > cn_source to match. [7] items > cn_sort uses "Koha normalized classification for sorting", so have kept the same for consistency. [8] Name used in Koha to MARC mappings is "Koha issues (borrowed), all copies". Have used the same description used for items. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
