NAME

Koha::Schema::Result::Category

TABLE: `categories`

ACCESSORS

categorycode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

unique primary key used to idenfity the patron category

description

  data_type: 'longtext'
  is_nullable: 1

description of the patron category

enrolmentperiod

  data_type: 'smallint'
  is_nullable: 1

number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)

enrolmentperioddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the patron is enrolled until (will be NULL if enrolmentperiod is set)

password_expiry_days

  data_type: 'smallint'
  is_nullable: 1

number of days after which the patron must reset their password

upperagelimit

  data_type: 'smallint'
  is_nullable: 1

age limit for the patron

dateofbirthrequired

  data_type: 'tinyint'
  is_nullable: 1

the minimum age required for the patron category

enrolmentfee

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

enrollment fee for the patron

overduenoticerequired

  data_type: 'tinyint'
  is_nullable: 1

are overdue notices sent to this patron category (1 for yes, 0 for no)

reservefee

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

cost to place holds

hidelostitems

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

are lost items shown to this category (1 for yes, 0 for no)

category_type

  data_type: 'varchar'
  default_value: 'A'
  is_nullable: 0
  size: 1

type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)

BlockExpiredPatronOpacActions

  accessor: 'block_expired_patron_opac_actions'
  data_type: 'varchar'
  default_value: 'follow_syspref_BlockExpiredPatronOpacActions'
  is_nullable: 0
  size: 128

specific actions expired patrons of this category are blocked from performing or if the BlockExpiredPatronOpacActions system preference is to be followed

default_privacy

  data_type: 'enum'
  default_value: 'default'
  extra: {list => ["default","never","forever"]}
  is_nullable: 0

Default privacy setting for this patron category

checkprevcheckout

  data_type: 'varchar'
  default_value: 'inherit'
  is_nullable: 0
  size: 7

produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.

can_place_ill_in_opac

  data_type: 'tinyint'
  default_value: 1
  is_nullable: 0

can this patron category place interlibrary loan requests

can_be_guarantee

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

if patrons of this category can be guarantees

reset_password

  data_type: 'tinyint'
  is_nullable: 1

if patrons of this category can do the password reset flow,

change_password

  data_type: 'tinyint'
  is_nullable: 1

if patrons of this category can change their passwords in the OAPC

min_password_length

  data_type: 'smallint'
  is_nullable: 1

set minimum password length for patrons in this category

require_strong_password

  data_type: 'tinyint'
  is_nullable: 1

set required password strength for patrons in this category

force_password_reset_when_set_by_staff

  data_type: 'tinyint'
  is_nullable: 1

if patrons of this category are required to reset password after being created by a staff member

exclude_from_local_holds_priority

  data_type: 'tinyint'
  is_nullable: 1

Exclude patrons of this category from local holds priority

noissuescharge

  data_type: 'integer'
  is_nullable: 1

define maximum amount outstanding before checkouts are blocked

noissueschargeguarantees

  data_type: 'integer'
  is_nullable: 1

define maximum amount that the guarantees of a patron in this category can have outstanding before checkouts are blocked

noissueschargeguarantorswithguarantees

  data_type: 'integer'
  is_nullable: 1

define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked

PRIMARY KEY

"categorycode"