deletedborrowers

primary key, Koha assigned ID number for patrons/borrowers

unique key, library assigned ID number for patrons/borrowers

patron/borrower’s last name (surname)

patron/borrower’s first name

patron/borrower’s middle name

patron/borrower’s title, for example: Mr. or Mrs.

any other names associated with the patron/borrower

initials for your patron/borrower

patron/borrower pronouns

the house number for your patron/borrower’s primary address

the street type (Rd., Blvd, etc) for your patron/borrower’s primary address

the first address line for your patron/borrower’s primary address

the second address line for your patron/borrower’s primary address

the city or town for your patron/borrower’s primary address

the state or province for your patron/borrower’s primary address

the zip or postal code for your patron/borrower’s primary address

the country for your patron/borrower’s primary address

the primary email address for your patron/borrower’s primary address

the primary phone number for your patron/borrower’s primary address

the other phone number for your patron/borrower’s primary address

the fax number for your patron/borrower’s primary address

the secondary email addres for your patron/borrower’s primary address

the secondary phone number for your patron/borrower’s primary address

the house number for your patron/borrower’s alternate address

the street type (Rd., Blvd, etc) for your patron/borrower’s alternate address

the first address line for your patron/borrower’s alternate address

the second address line for your patron/borrower’s alternate address

the city or town for your patron/borrower’s alternate address

the state for your patron/borrower’s alternate address

the zip or postal code for your patron/borrower’s alternate address

the country for your patron/borrower’s alternate address

the patron/borrower’s alternate email address

the patron/borrower’s alternate phone number

the patron/borrower’s date of birth (YYYY-MM-DD)

foreign key from the branches table, includes the code of the patron/borrower’s home branch

foreign key from the categories table, includes the code of the patron category

date the patron was added to Koha (YYYY-MM-DD)

date the patron/borrower’s card is set to expire (YYYY-MM-DD)

date the patron/borrower’s password is set to expire (YYYY-MM-DD)

date the patron/borrower’s card was last renewed

set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address

set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card

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)

comment on the stop of patron

used for children and profesionals to include surname or last name of guarantor or organization name

used for children to include first name of guarantor

used for children to include title (Mr., Mrs., etc) of guarantor

a note on the patron/borrower’s account that is only visible in the staff interface

used for children to include the relationship to their guarantor

patron/borrower’s gender

patron/borrower’s encrypted password

Secret for 2FA

Authentication method

will include a number associated with the staff member’s permissions

patron/borrower’s opac and/or staff interface log in

a note on the patron/borrower’s account that is visible in the OPAC and staff interface

a note related to the patron/borrower’s alternate address

a field that can be used for any information unique to the library

a field that can be used for any information unique to the library

first name of alternate contact for the patron/borrower

surname or last name of the alternate contact for the patron/borrower

the first address line for the alternate contact for the patron/borrower

the second address line for the alternate contact for the patron/borrower

the city for the alternate contact for the patron/borrower

the state for the alternate contact for the patron/borrower

the zipcode for the alternate contact for the patron/borrower

the country for the alternate contact for the patron/borrower

the phone number for the alternate contact for the patron/borrower

the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)

the provider of the mobile phone number defined in smsalertnumber

patron/borrower’s privacy settings related to their checkout history KEY borrowernumber (borrowernumber),

controls if relatives can see this patron’s fines

controls if relatives can see this patron’s checkouts

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’.

time of last change could be useful for synchronization with external systems (among others)

last time a patron has been seen (connected at the OPAC or staff interface)

lang to use to send notices to this patron

number of failed login attemps

persist OverDrive auth token

flag for data anonymization

flag for allowing auto-renewal

useful for reporting purposes