Page History
KOHA (http://schema.koha-community.org/17_11/tables/borrowers.html) | Voyager | |||||||||
Field | Description | Note | Vastaavuus kenttä | Ehto | Vastaavuus taulu | Huomautus | ||||
borrowernumber | primary key, Koha assigned ID number for patrons/borrowers | PATRON_ID | Järjestelmien sisäiset tunnukset, ei varmaan mapata (Perus KOHAssa ei kenttää SOTUlle?) | |||||||
cardnumber | unique key, library assigned ID number for patrons/borrowers | PATRON_BARCODE | PATRON_BARCODE | Voyagerissa samalla asiakkaalla voi olla useita asiakkuuksia | ||||||
surname | patron/borrower's last name (surname) | LAST_NAME | PATRON | Myös normalisoitu muodo NORMAL_LAST_NAME | ||||||
firstname | patron/borrower's first name | FIRST_NAME | PATRON | Myös normalisoitu muodo NORMAL_FIRST_NAME | ||||||
title | patron/borrower's title, for example: Mr. or Mrs. | TITLE | PATRON | |||||||
othernames | any other names associated with the patron/borrower | MIDDLE_NAME | PATRON | Myös normalisoitu muodo NORMAL_MIDDLE_NAME | ||||||
initials | initials for your patron/borrower | |||||||||
streetnumber | the house number for your patron/borrower's primary address | |||||||||
streettype | the street type (Rd., Blvd, etc) for your patron/borrower's primary address | |||||||||
address | the first address line for your patron/borrower's primary address | ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3 | ADDRESS_TYPE="1" permanent | PATRON_ADDRESS (PATRON_ID) | ||||||
address2 | the second address line for your patron/borrower's primary address | ADDRESS_LINE4, ADDRESS_LINE5 | ADDRESS_TYPE="1" permanent | PATRON_ADDRESS (PATRON_ID) | Etenkin organisaatioasiakkailla on täytetty osoiterivit 4 ja 5 (sisältävät HAMKissa laskutukseen tarvittavia tietoja, kuten viite) | |||||
city | the city or town for your patron/borrower's primary address | CITY | ADDRESS_TYPE="1" permanent | PATRON_ADDRESS (PATRON_ID) | ||||||
state | the state or province for your patron/borrower's primary address | STATE_PROVINCE | ADDRESS_TYPE="1" permanent | PATRON_ADDRESS (PATRON_ID) | ||||||
zipcode | the zip or postal code for your patron/borrower's primary address | ZIP_POSTAL | ADDRESS_TYPE="1" permanent | PATRON_ADDRESS (PATRON_ID) | ||||||
country | the country for your patron/borrower's primary address | COUNTRY | ADDRESS_TYPE="1" permanent | |||||||
the primary email address for your patron/borrower's primary address | ADDRESS_LINE1 | ADDRESS_TYPE="3" email | ||||||||
phone | the primary phone number for your patron/borrower's primary address | PHONE_NUMBER | PHONE_TYPE="1" primary | PATRON_PHONE | ||||||
mobile | the other phone number for your patron/borrower's primary address | PHONE_NUMBER | PHONE_TYPE="2" Mobile | PATRON_PHONE | ||||||
fax | the fax number for your patron/borrower's primary address | PHONE_NUMBER | PHONE_TYPE="3" Fax | PATRON_PHONE | ||||||
emailpro | the secondary email addres for your patron/borrower's primary address | |||||||||
phonepro | the secondary phone number for your patron/borrower's primary address | ? | PHONE_NUMBER | PHONE_TYPE="4" other | PATRON_PHONE | ? Onkohan näin, tarkistettava | ||||
B_streetnumber | the house number for your patron/borrower's alternate address | |||||||||
B_streettype | the street type (Rd., Blvd, etc) for your patron/borrower's alternate address | |||||||||
B_address | the first address line for your patron/borrower's alternate address | ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3 | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_address2 | the second address line for your patron/borrower's alternate address | ADDRESS_LINE4, ADDRESS_LINE5 | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_city | the city or town for your patron/borrower's alternate address | CITY | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_state | the state for your patron/borrower's alternate address | STATE_PROVINCE | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_zipcode | the zip or postal code for your patron/borrower's alternate address | ZIP_POSTAL | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_country | the country for your patron/borrower's alternate address | COUNTRY | ADDRESS_TYPE="2", temporary | PATRON_ADDRESS (PATRON_ID) | ||||||
B_email | the patron/borrower's alternate email address | |||||||||
B_phone | the patron/borrower's alternate phone number | |||||||||
dateofbirth | the patron/borrower's date of birth (YYYY-MM-DD) | Date formats should match your system preference, and must be zero-padded, e.g. ‘01/02/2008’. | BIRTH_DATE | PATRON | ||||||
branchcode | foreign key from the branches table, includes the code of the patron/borrower's home branch | The fields ‘branchcode’, ‘categorycode’ and all fields you have defined in the BorrowerMandatoryField preference are required and must match valid entries in your database. | HOME_LOCATION | PATRON | ? Onkohan näin, tarkistettava. Koodin pitää täsmätä KOHAN asetuksiin | |||||
categorycode | foreign key from the categories table, includes the code of the patron category | The fields ‘branchcode’, ‘categorycode’ and all fields you have defined in the BorrowerMandatoryField preference are required and must match valid entries in your database. | PATRON_GROUP_ID | PATRON_BARCODE | Voyagerissa patron group on sidottu viivakoodiin, joita voi olla useita. Patron Groupit on mapattava erikseen KOHAn PatronCategory -konfiguroinnin kanssa. ON myös HOME_PATRON_GROUP_ID Voyagerissa | |||||
dateenrolled | date the patron was added to Koha (YYYY-MM-DD) | Date formats should match your system preference, and must be zero-padded, e.g. ‘01/02/2008’. | CREATE_DATE | PATRON | ||||||
dateexpiry | date the patron/borrower's card is set to expire (YYYY-MM-DD) | Date formats should match your system preference, and must be zero-padded, e.g. ‘01/02/2008’. | EXPIRE_DATE | PATRON | Voyagerissa myös PURGE_DATE | |||||
daterenewed | date the patron/borrower's card was last renewed | |||||||||
gonenoaddress | set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address | |||||||||
lost | set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card | |||||||||
debarred | until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) | |||||||||
debarredcomment | comment on the stop of the patron | |||||||||
contactname | used for children and profesionals to include surname or last name of guarantor or organization name | |||||||||
contactfirstname | used for children to include first name of guarantor | |||||||||
contacttitle | used for children to include title (Mr., Mrs., etc) of guarantor | |||||||||
guarantorid | borrowernumber used for children or professionals to link them to guarantors or organizations | |||||||||
borrowernotes | a note on the patron/borrower's account that is only visible in the staff client | NOTE | PATRON_NOTES | Voyagerissa voi olla useita huomautuksia asiakkasta kohti? | ||||||
relationship | used for children to include the relationship to their guarantor | |||||||||
sex | patron/borrower's gender | ei käytetä | Näitä ei sensitiivisyysssyistä kannatta käyttää lainkaan | |||||||
password | patron/borrower's Bcrypt encrypted password | The ‘password’ should be stored in plaintext and will be converted to a Bcrypt hash. If your passwords are already encrypted talk to your systems administrator about options | PATRON_PIN | PATRON | ||||||
flags | will include a number associated with the staff member's permissions | |||||||||
userid | patron/borrower's opac and/or staff client log in | |||||||||
opacnote | a note on the patron/borrower's account that is visible in the OPAC and staff client | |||||||||
contactnote | a note related to the patron/borrower's alternate address | |||||||||
sort1 | a field that can be used for any information unique to the library | |||||||||
sort2 | a field that can be used for any information unique to the library | |||||||||
altcontactfirstname | first name of alternate contact for the patron/borrower | |||||||||
altcontactsurname | surname or last name of the alternate contact for the patron/borrower | |||||||||
altcontactaddress1 | the first address line for the alternate contact for the patron/borrower | |||||||||
altcontactaddress2 | the second address line for the alternate contact for the patron/borrower | |||||||||
altcontactaddress3 | the city for the alternate contact for the patron/borrower | |||||||||
altcontactstate | the state for the alternate contact for the patron/borrower | |||||||||
altcontactzipcode | the zipcode for the alternate contact for the patron/borrower | |||||||||
altcontactcountry | the country for the alternate contact for the patron/borrower | |||||||||
altcontactphone | the phone number for the alternate contact for the patron/borrower | |||||||||
smsalertnumber | the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) | |||||||||
sms_provider_id | the provider of the mobile phone number defined in smsalertnumber | |||||||||
privacy | patron/borrower's privacy settings related to their reading history | |||||||||
checkprevcheckout | produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. | |||||||||
updated_on | time of last change could be useful for synchronization with external systems (among others) | |||||||||
lastseen | last time a patron has been seen (connected at the OPAC or staff interface) | |||||||||
lang | lang to use to send notices to this patron | TITLE | sw, en, ... , tyhjä on suomi | PATRON | Näin on aikoinaan sovittu jo VTLS:ssä käytössä olleen asiakkaan kielikoodin tallentamisesta. Jostain syystä tätä ei kuitenkaan ole käytetty kuin muutamassa kirjastossa (HELKA, Haaga-Helia, ...). NotesHandler osaa käyttää tuota kielenvalintaan viesteissään. NotesHandleriin voi viestit tehdä halutulle määrälle kieliä. Joka tapauksessa Kohassa kielikoodi kannattaisi ottaa käyttöön viestinnän helpottamiseksi nykyisessä monikielisessä ympäristössä. | |||||
login_attempts | number of failed login attemps | |||||||||
overdrive_auth_token | persist OverDrive auth token |
...
Ratkaistavia asioita
HETU
- Voyager-tietokannoissa on pääsääntöisesti käytetty henkilötunnusta asiakkaiden yksilöimiseen - kirjastoilla on siihen laissa säädetty oikeus
- Voyagerissakaan ei tähän ole varsinaista paikkaa, vaan HETU on tallennettu asiakastietuteen Institution ID -kenttään (PATRON.INSTITUTION_ID tai PATRON.NORMAL_INSTITUTION_ID normalisoituna)
- SSAN on amerikkalaiselle sosiaaliturvatunnukselle varustettu kenttä, eikä määrämuiotoisena sovi HETUn tallennukseen
- Institution ID on vapaamuotoinen kenttä, joten se ei tarkista mitenkään HETUn oikeellisuutta → HETUt olisi syytä ajaa tarkistimen läpi siivousten yhteydessä (oikeamuotoisuus ja oikea tarkistusmerkki)
- HETUn sijasta tietokannoissa on myös tietoisesti käytetty jonkin verran muita tunnuksia - niiden osalta pitäisi myös tehdä ratkaisut
- KOHAssa(kaan) ei ole varsinaisesti paikkaa henkilötunnukselle, mutta ratkaisu tulee olemaan erillinen HETU-siilo l. Hetula
- ratkaisu on kertaluokkaa turvallisempi kuin HETUn tallennus varsinaiseen asiakastietueeseen
primary key, Koha assigned ID number for patrons/borrowers |