KOHA (http://schema.koha-community.org/17_11/tables/borrowers.html) | Voyager | ||||||
Field | Description | Note | Vastaavuus kenttä | Ehto | Vastaavuus taulu | Huomautus | |
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 | ||||||
login_attempts | number of failed login attemps | ||||||
overdrive_auth_token | persist OverDrive auth token |