Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
KOHA
  (http://schema.koha-community.org/17_11/tables/borrowers.html)
Voyager
FieldDescriptionNoteVastaavuus
  kenttä
EhtoVastaavuus tauluHuomautus 
borrowernumberprimary key, Koha assigned ID number for patrons/borrowers PATRON_ID  

Järjestelmien sisäiset tunnukset, ei varmaan mapata

(Perus KOHAssa ei kenttää SOTUlle?)

 
cardnumberunique key, library assigned ID
  number for patrons/borrowers
  PATRON_BARCODE  PATRON_BARCODE Voyagerissa samalla asiakkaalla voi olla useita asiakkuuksia 
surnamepatron/borrower's last name
  (surname)
 LAST_NAME PATRONMyös normalisoitu muodo NORMAL_LAST_NAME 
firstnamepatron/borrower's first name FIRST_NAME PATRONMyös normalisoitu muodo NORMAL_FIRST_NAME 
titlepatron/borrower's title, for
  example: Mr. or Mrs.
 TITLE PATRON  
othernamesany other names associated with
  the patron/borrower
 MIDDLE_NAME PATRONMyös normalisoitu muodo NORMAL_MIDDLE_NAME 
initialsinitials for your
  patron/borrower
      
streetnumberthe house number for your
  patron/borrower's primary address
      
streettypethe street type (Rd., Blvd, etc)
  for your patron/borrower's primary address
      
addressthe first address line for your
  patron/borrower's primary address
 ADDRESS_LINE1, ADDRESS_LINE2,
  ADDRESS_LINE3 
ADDRESS_TYPE="1"
  permanent
PATRON_ADDRESS (PATRON_ID)  
address2the second address line for your
  patron/borrower's primary address
 ADDRESS_LINE4, ADDRESS_LINE5ADDRESS_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)
 
citythe city or town for your
  patron/borrower's primary address
 CITYADDRESS_TYPE="1"
  permanent
PATRON_ADDRESS (PATRON_ID)  
statethe state or province for your
  patron/borrower's primary address
 STATE_PROVINCEADDRESS_TYPE="1"
  permanent
PATRON_ADDRESS (PATRON_ID)  
zipcodethe zip or postal code for your
  patron/borrower's primary address
 ZIP_POSTALADDRESS_TYPE="1"
  permanent
PATRON_ADDRESS (PATRON_ID)  
countrythe country for your
  patron/borrower's primary address
 COUNTRYADDRESS_TYPE="1"
  permanent
   
emailthe primary email address for
  your patron/borrower's primary address
 ADDRESS_LINE1ADDRESS_TYPE="3" email   
phonethe primary phone number for
  your patron/borrower's primary address
 PHONE_NUMBERPHONE_TYPE="1" primaryPATRON_PHONE  
mobilethe other phone number for your
  patron/borrower's primary address
 PHONE_NUMBERPHONE_TYPE="2" MobilePATRON_PHONE  
faxthe fax number for your
  patron/borrower's primary address
 PHONE_NUMBERPHONE_TYPE="3" FaxPATRON_PHONE  
emailprothe secondary email addres for
  your patron/borrower's primary address
      
phoneprothe secondary phone number for
  your patron/borrower's primary address
?PHONE_NUMBERPHONE_TYPE="4" otherPATRON_PHONE? Onkohan näin, tarkistettava 
B_streetnumberthe house number for your
  patron/borrower's alternate address
      
B_streettypethe street type (Rd., Blvd, etc)
  for your patron/borrower's alternate address
      
B_addressthe 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_address2the second address line for your
  patron/borrower's alternate address
 ADDRESS_LINE4, ADDRESS_LINE5ADDRESS_TYPE="2",
  temporary
PATRON_ADDRESS (PATRON_ID)  
B_citythe city or town for your
  patron/borrower's alternate address
 CITYADDRESS_TYPE="2",
  temporary
PATRON_ADDRESS (PATRON_ID)  
B_statethe state for your
  patron/borrower's alternate address
 STATE_PROVINCEADDRESS_TYPE="2",
  temporary
PATRON_ADDRESS (PATRON_ID)  
B_zipcodethe zip or postal code for your
  patron/borrower's alternate address
 ZIP_POSTALADDRESS_TYPE="2",
  temporary
PATRON_ADDRESS (PATRON_ID)  
B_countrythe country for your
  patron/borrower's alternate address
 COUNTRYADDRESS_TYPE="2",
  temporary
PATRON_ADDRESS (PATRON_ID)  
B_emailthe patron/borrower's alternate
  email address
      
B_phonethe patron/borrower's alternate
  phone number
      
dateofbirththe 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  
branchcodeforeign 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
 
categorycodeforeign 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_BARCODEVoyagerissa 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
 
dateenrolleddate 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  
dateexpirydate 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 PATRONVoyagerissa myös PURGE_DATE 
datereneweddate the patron/borrower's card
  was last renewed
      
gonenoaddressset to 1 for yes and 0 for no,
  flag to note that library marked this patron/borrower as having an
  unconfirmed address
      
lostset to 1 for yes and 0 for no,
  flag to note that library marked this patron/borrower as having lost their
  card
      
debarreduntil 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)
      
debarredcommentcomment on the stop of the
  patron
      
contactnameused for children and
  profesionals to include surname or last name of guarantor or organization
  name
      
contactfirstnameused for children to include
  first name of guarantor
      
contacttitleused for children to include
  title (Mr., Mrs., etc) of guarantor
      
guarantoridborrowernumber used for children
  or professionals to link them to guarantors or organizations
      
borrowernotesa note on the patron/borrower's
  account that is only visible in the staff client
 NOTE PATRON_NOTESVoyagerissa voi olla useita huomautuksia asiakkasta kohti? 
relationshipused for children to include the
  relationship to their guarantor
      
sexpatron/borrower's gender ei käytetä  Näitä ei sensitiivisyysssyistä kannatta käyttää lainkaan 
passwordpatron/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  
flagswill include a number associated
  with the staff member's permissions
      
useridpatron/borrower's opac and/or
  staff client log in
      
opacnotea note on the patron/borrower's
  account that is visible in the OPAC and staff client
      
contactnotea note related to the
  patron/borrower's alternate address
      
sort1a field that can be used for any
  information unique to the library
      
sort2a field that can be used for any
  information unique to the library
      
altcontactfirstnamefirst name of alternate contact
  for the patron/borrower
      
altcontactsurnamesurname or last name of the
  alternate contact for the patron/borrower
      
altcontactaddress1the first address line for the
  alternate contact for the patron/borrower
      
altcontactaddress2the second address line for the
  alternate contact for the patron/borrower
      
altcontactaddress3the city for the alternate
  contact for the patron/borrower
      
altcontactstatethe state for the alternate
  contact for the patron/borrower
      
altcontactzipcodethe zipcode for the alternate
  contact for the patron/borrower
      
altcontactcountrythe country for the alternate
  contact for the patron/borrower
      
altcontactphonethe phone number for the
  alternate contact for the patron/borrower
      
smsalertnumberthe mobile phone number where
  the patron/borrower would like to receive notices (if SMS turned on)
      
sms_provider_idthe provider of the mobile phone
  number defined in smsalertnumber
      
privacypatron/borrower's privacy
  settings related to their reading history
      
checkprevcheckoutproduce 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_ontime
  of last change could be useful for synchronization with external systems
  (among others)
      
lastseenlast
  time a patron has been seen (connected at the OPAC or staff interface)
      
langlang
  to use to send notices to this patron
     TITLEsw, en, ... , tyhjä on suomiPATRONNä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_attemptsnumber
  of failed login attemps
      
overdrive_auth_tokenpersist
  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