From a75c6cd311ec776bd6446acaba69d5962f6b1ceb Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Tue, 20 Mar 2012 15:39:46 +0100 Subject: [PATCH] Bug 5482: Update colums.def file Updates the borrowers and items table descriptions using the descriptions from the interface and the MARC21 default framework. Biblio and biblioitems still need some work. Signed-off-by: Owen Leonard Signed-off-by: Jared Camins-Esakov --- koha-tmpl/intranet-tmpl/prog/en/columns.def | 220 ++++++++++---------- 1 file changed, 115 insertions(+), 105 deletions(-) diff --git a/koha-tmpl/intranet-tmpl/prog/en/columns.def b/koha-tmpl/intranet-tmpl/prog/en/columns.def index 3c6794946f..14c9b78382 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/columns.def +++ b/koha-tmpl/intranet-tmpl/prog/en/columns.def @@ -1,124 +1,134 @@ -borrowers.borrowernumber Borrower Number -borrowers.cardnumber Card Number +borrowers.borrowernumber Borrower number +borrowers.title Salutation borrowers.surname Surname -borrowers.firstname Firstname -borrowers.title Title -borrowers.othernames Other Names -borrowers.initials Initials -borrowers.streetaddress Street Address -borrowers.suburb Suburb -borrowers.city City -borrowers.phone Phone -borrowers.emailaddress Email -borrowers.faxnumber Fax -borrowers.textmessaging Opac Message -borrowers.altstreetaddress Alternative Street Address -borrowers.altsuburb Alternative Suburb -borrowers.altcity Alternative City -borrowers.altphone Alternative Phone -borrowers.dateofbirth Date of Birth -borrowers.branchcode Branch Code -borrowers.categorycode Borrowers Category -borrowers.dateenrolled Date Enrolled -borrowers.gonenoaddress Address Missing -borrowers.lost Lost Card -borrowers.debarred Restricted -borrowers.studentnumber Student Id number -borrowers.school School -borrowers.contactname Contact Name -borrowers.borrowernotes Circulation Notes -borrowers.guarantor Guarantor(parent) -borrowers.area Area -borrowers.ethnicity Ethnicity -borrowers.ethnotes Ethnicity Notes +borrowers.firstname First name +borrowers.dateofbirth Date of birth +borrowers.initials Initials +borrowers.othernames Other name borrowers.sex Gender -borrowers.expiry Expiry Date -borrowers.altnotes Alternative Contact Notes -borrowers.altrelationship Relationship of Alternative Contact -borrowers.streetcity Streetcity?? -borrowers.phoneday Work Phone -borrowers.preferredcont Preferred method of Contact -borrowers.physstreet Physical Street Address -borrowers.password Password -borrowers.flags Warnings -borrowers.userid Login ID -borrowers.homezipcode Zip/Post Code -borrowers.zipcode Zip/Post Code 2? -borrowers.sort1 Sorting Column -borrowers.sort2 Sorting Column 2 -borrowers.cellph Cellphone number -borrowers.borlog -borrowers.checkhist -items.itemnumber Item Number (koha internal) -items.biblionumber Biblio Number (koha internal) -items.multivolumepart Item one part of a Multi volume set -items.biblioitemnumber Biblioitem Number (koha internal) +borrowers.relationship Relationship +borrowers.guarantorid Guarantor borrower number +borrowers.streetnumber Street number +borrowers.streettype Street type +borrowers.address +borrowers.address2 +borrowers.city City +borrowers.state State +borrowers.zipcode Zip/postal code +borrowers.country Country +borrowers.phone Primary phone +borrowres.phonepro Secondary phone +borrowers.mobile Other phone +borrowers.email Primary email +borrowers.emailpro Secondary email +borrowers.fax Fax +borrowers.B_streetnumber Alternate address: Street number +borrowers.B_stretttype Alternatate address: Street type +borrowres.B_address Alternate address: Address +borrowers.B_address2 Alternate address: Address 2 +borrowers.B_city Alternate address: City +borrowers.B_state Alternate address: State +borrowers.B_zipcode Alternate address: Zip/postal code +borrowers.B_country Alternate address: Country +borrowers.B_phone Alternate address: Phone +borrowers.B_email Alternate address: Email +borrowers.contactnote Altenate address: contact note +borrowers.altcontactfirstname Alternate contact: Surname +borrowres.altcontactsurname Alternate contact: First name +borrowers.altcontactaddress1 Alternate contact: Address +borrowers.altcontactaddress2 Alternate contact: Adress 2 +borrowers.altcontactaddress3 Alternate contact: City +borrowers.altcontactstate Alternate contact: State +borrowers.altcontactzipcode Alternate contact: Zip/postal code +borrowers.altcontactcountry Alternate contact: Country +borrowers.altcontactphone Alternate contact: Phone +borrowers.cardnumber Card number +borrowers.branchcode Library +borrowers.categorycode Category +borrowers.sort1 Sort 1 +borrowers.sort2 Sort 2 +borrowers.dateenrolled Registration date +borrowers.dateexpiry Expiry date +borrowers.opacnote OPAC note +borrowers.borrowernotes Circulation note +borrowres.username Username +borrowers.password Password +borrowers.gonenoaddress Gone no address +borrowers.lost Lost card +borrowers.debarred Restricted until +borrowers.debarredcomment Coment +items.itemnumber Item number (internal) +items.biblionumber Biblio number (internal) +items.biblioitemnumber Biblioitem number (internal) items.barcode Barcode -items.dateaccessioned Accession Date -items.booksellerid Supplier ID -items.homebranch Home Branch +items.dateaccessioned Date acquired +items.booksellerid Source of acquisition +items.homebranch Permanent library items.price Price -items.replacementprice Replacement Price -items.replacementpricedate Date Replacement Price was set -items.datelastborrowed Date Item last issued -items.datelastseen Date Item was last seen by Koha -items.multivolume Volume Number (if part of a multivolume work) -items.stack Is the item in the stack? -items.onloan On loan -items.notforloan Item Not for loan -items.itemlost Item Lost -items.wthdrawn Item Cancelled -items.itemcallnumber Item Call Number -items.issues Issues Count -items.renewals Renewals Count -items.reserves Reserves Count -items.restricted Item Restricted -items.binding Item needs binding -items.itemnotes Item Notes -items.holdingbranch Holding Branch -items.paidfor Has Item been lost and then paid for +items.replacementprice Replacement price +items.replacementpricedate Price effective from +items.datelastborrowed Date last checked out +items.datelastseen Date last seen +items.stack Shelving control number +items.onloan Due date +items.cn_source Source of classificaton / shelving scheme +items.cn_sort Koha normalized classification for sorting +items.notforloan Not for loan +items.itemlost Lost status +items.wthdrawn Withdrawn status +items.itemcallnumber Call number +items.issues Total checkouts +items.renewals Total renewals +items.reserves Total holds +items.restricted Use restrictions +items.itemnotes Public note +items.holdingbranch Current library +items.paidfor items.timestamp Timestamp -items.location Location -items.ccode Koha Collection -items.itype Item-level Item Type -items.spystatus -items.spydescr -items.itemlog -items.spycopydata -statistics.datetime Statistics Date and Time -statistics.branch Branch Code -statistics.proccode Type of Procedure +items.location Shelving location +items.ccode Collection code +items.itype Koha itemtype +items.stocknumber Inventory number +items.damaged Damaged status +items.materials Materials specified +items.uri Uniform Resource Identifier +items.more_subfields_xml Additional subfields (XML) +items.enumchron Serial enumeraton/chronology +items.copynumber Copy number +statistics.datetime Statistics date and time +statistics.branch Library +statistics.proccode Type of procedure statistics.value Value statistics.type Type statistics.other -statistics.usercode User Code -statistics.itemnumber Item Number -statistics.itemtype Item Type -statistics.borrowernumber Borrower Number -biblio.frameworkcode Framework Code +statistics.usercode User code +statistics.itemnumber Item number +statistics.itemtype Itemtype +statistics.borrowernumber Borrower number +biblio.frameworkcode Framework code biblio.author Author -biblio.datecreated Creation Date -biblio.timestamp Modification Date -biblioitems.biblioitemnumber Biblioitem Number -biblioitems.biblionumber Biblio Number -biblioitems.volume Volume Number -biblioitems.number Number +biblio.datecreated Creation date +biblio.timestamp Modification date +biblioitems.biblioitemnumber Biblioitem number +biblioitems.biblionumber Biblio number +biblioitems.volume Volume number +biblioitems.number number biblioitems.classification Classification -biblioitems.itemtype Biblio-level Item Type +biblioitems.itemtype Biblio-level item type biblioitems.isbn ISBN biblioitems.issn ISSN -biblioitems.dewey Dewey/Classification -biblioitems.subclass Sub Classification -biblioitems.publicationyear Publication Date +biblioitems.dewey Dewey/classification +biblioitems.subclass Sub classification +biblioitems.publicationyear Publication date biblioitems.publishercode Publisher -biblioitems.volumedate Volume Date -biblioitems.volumeddesc Volume Information +biblioitems.volumedate Volume date +biblioitems.volumeddesc Volume information biblioitems.timestamp Timestamp biblioitems.illus Illustrator -biblioitems.pages Number of Pages +biblioitems.pages Number of pages biblioitems.notes Notes biblioitems.size Size -biblioitems.place Place of Publication +biblioitems.place Place of publication biblioitems.lccn LCCN -biblioitems.marc MARC Blob +biblioitems.marcxml MARC blob biblioitems.url URL -- 2.39.5