Data availability via Template Toolkit per notice or slip

Data availability via Template Toolkit per notice/slip

Each notice and slip in Koha has limited access to data for inclusion. Generally, this is logical: an issue slip can include patron and item information, but cannot include data about unrelated holds. But not all cases are that straightforward.

Further, Template Toolkit uses variable labels that don't always match the Koha database schema, leading to confusion about proper terminology.

Variable labels

The following list connects Koha database table names to the values used to access that data in Template Toolkit.
article_requests:
singular:[% article_request %]
plural:[% article_requests %]

aqbasket:
singular:[% basket %]
plural:[% baskets %]

aqbooksellers:
singular:[% bookseller %]
plural:[% booksellers %]

biblio:
singular:[% biblio %]
plural:[% biblios %]

biblioitems:
singular:[% biblioitem %]
plural:[% biblioitems %]

borrowers:
singular:[% borrower %]
plural:[% borrowers %]

branches:
singular:[% branch %]
plural:[% branches %]

credits:
singular:[% credit %]
plural:[% credits %]

debits:
singular:[% debit %]
plural:[% debits %]

items:
singular:[% item %]
plural:[% items %]

additional_contents:
singular:[% additional_content %]
plural:[% additional_contents %]

opac_news:
singular:[% news %]
plural:[% news %]

aqorders:
singular:[% order %]
plural:[% orders %]

reserves:
singular:[% hold %]
plural:[% holds %]

serial:
singular:[% serial %]
plural:[% serials %]

subscription:
singular:[% subscription %]
plural:[% subscriptions %]

suggestions:
singular:[% suggestion %]
plural:[% suggestions %]

tickets:
singular:[% ticket %]
plural:[% tickets %]

ticket_updates:
singular:[% ticket_update %]
plural:[% ticket_updates %]

issues:
singular:[% checkout %]
plural:[% checkouts %]

old_issues:
singular:[% old_checkout %]
plural:[% old_checkouts %]

overdues:
singular:[% overdue %]
plural:[% overdues %]

borrower_modifications:
singular:[% patron_modification %]
plural:[% patron_modifications %]

illrequests:
singular:[% illrequest %]
plural:[% illrequests %]

preservation_train_items:
singular:[% train_item %]
plural:[% train_items %]

problem_reports:
singular:[% problemreport %]
plural:[% problemreports %]

Use a template to retrieve available variables for a given notice or slip

That list of all possible Template Toolkit variables can be adapted into a template that can be used in Koha to determine which specific variables are available in a given notice. Such a template is included below as well as in an attached file. To use this template, edit the notice or slip for which you wish to know the available variables:
  1. In Koha, go to Tools
  2. In Tools, go to Notices and Slips
  3. Search for the specific notice or slip you wish to test, click Edit
  4. Replace the contents of one or more transport type's notice/slip with the provided template
  5. Generate that notice or slip for a test patron
Inserting the provided template into the Email transport type for the HOLD notice
The resulting HOLD email in a patron's record
The notice in the screenshot above shows us that biblio data is available in this notice. If we wanted to include the title, for example, we would use "[% biblio.title %]."

Singular and Plural

Generally, a given notice will have access to either singular or plural data based on the type of notice. For example, the AUTO_RENEWALS notice includes a singular checkout object whereas the AUTO_RENEWALALS_DGST contains plural checkouts. A singular object can be accessed directly -- to get the due date of a singular checkout, use "[% checkout.date_due %]." In order to access the data points for individual objects with a plural listing, use a FOREACH loop
[% FOREACH c IN checkouts %]
[% c.date_due %]<br>
[% END %]
The code above will return the due date for each checked-out item, each on its own line. Note that the "c" in "FOREACH c IN checkouts" is an arbitrary local choice, just for this loop. The following would work identically:
[% FOREACH thing IN checkouts %]
[% thing.date_due %]<br>
[% END %]

The template:

[% USE Dumper %]
[% IF article_request || article_requests %]
article_requests:<br>
singular: article_request<br>
[% Dumper.dump_html(article_request.unblessed) %]<br>
plural: article_requests<br>
[% Dumper.dump_html(article_requests.unblessed) %]<br>
[% END %]
[% IF basket || baskets %]<br>
aqbasket:<br>
singular: basket<br>
[% Dumper.dump_html(basket.unblessed) %]<br>
plural: baskets<br>
[% Dumper.dump_html(baskets.unblessed) %]<br>
aqbooksellers:<br>
[% END %]
[% IF bookseller || booksellers %]<br>
aqbooksellers:<br>
singular: bookseller<br>
[% Dumper.dump_html(bookseller.unblessed) %]<br>
plural: booksellers<br>
[% Dumper.dump_html(booksellers.unblessed) %]<br>
<br>
[% END %]
[% IF biblio || biblios %]<br>
biblio:<br>
singular: biblio<br>
[% Dumper.dump_html(biblio.unblessed) %]<br>
plural: biblios<br>
[% Dumper.dump_html(biblios.unblessed) %]<br>
[% END %]
[% IF biblioitem || biblioitems %]<br>
biblioitems:<br>
singular: biblioitem<br>
[% Dumper.dump_html(biblioitem.unblessed) %]<br>
plural: biblioitems<br>
[% Dumper.dump_html(biblioitems.unblessed) %]<br>
<br>
[% END %]
[% IF borrower || borrowers %]<br>
borrowers:<br>
singular: borrower<br>
[% Dumper.dump_html(borrower.unblessed) %]<br>
plural: borrowers<br>
[% Dumper.dump_html(borrowers.unblessed) %]<br>
<br>
[% END %]
[% IF branch || branches %]<br>
branches:<br>
singular: branch<br>
[% Dumper.dump_html(branch.unblessed) %]<br>
plural: branches<br>
[% Dumper.dump_html(branches.unblessed) %]<br>
<br>
[% END %]
[% IF credit || credits %]<br>
credits:<br>
singular: credit<br>
[% Dumper.dump_html(credit.unblessed) %]<br>
plural: credits<br>
[% Dumper.dump_html(credits.unblessed) %]<br>
<br>
[% END %]
[% IF debit || debits %]<br>
debits:<br>
singular: debit<br>
[% Dumper.dump_html(debit.unblessed) %]<br>
plural: debits<br>
[% Dumper.dump_html(debits.unblessed) %]<br>
<br>
[% END %]
[% IF item || items %]<br>
items:<br>
singular: item<br>
[% Dumper.dump_html(item.unblessed) %]<br>
plural: items<br>
[% Dumper.dump_html(items.unblessed) %]<br>
<br>
[% END %]
[% IF additional_content || additional_contents %]<br>
additional_contents:<br>
singular: additional_content<br>
[% Dumper.dump_html(additional_content.unblessed) %]<br>
plural: additional_contents<br>
[% Dumper.dump_html(additional_contents.unblessed) %]<br>
<br>
[% END %]
[% IF news || news %]<br>
opac_news:<br>
singular: news<br>
[% Dumper.dump_html(news.unblessed) %]<br>
plural: news<br>
[% Dumper.dump_html(news.unblessed) %]<br>
<br>
[% END %]
[% IF order || orders %]<br>
aqorders:<br>
singular: order<br>
[% Dumper.dump_html(order.unblessed) %]<br>
plural: orders<br>
[% Dumper.dump_html(orders.unblessed) %]<br>
<br>
[% END %]
[% IF hold || holds %]<br>
reserves:<br>
singular: hold<br>
[% Dumper.dump_html(hold.unblessed) %]<br>
plural: holds<br>
[% Dumper.dump_html(holds.unblessed) %]<br>
<br>
[% END %]
[% IF serial || serials %]<br>
serial:<br>
singular: serial<br>
[% Dumper.dump_html(serial.unblessed) %]<br>
plural: serials<br>
[% Dumper.dump_html(serials.unblessed) %]<br>
<br>
[% END %]
[% IF subscription || subscriptions %]<br>
subscription:<br>
singular: subscription<br>
[% Dumper.dump_html(subscription.unblessed) %]<br>
plural: subscriptions<br>
[% Dumper.dump_html(subscriptions.unblessed) %]<br>
<br>

[% END %]
[% IF suggestion || suggestions %]<br>
suggestions:<br>
singular: suggestion<br>
[% Dumper.dump_html(suggestion.unblessed) %]<br>
plural: suggestions<br>
[% Dumper.dump_html(suggestions.unblessed) %]<br>
<br>
[% END %]
[% IF ticket || tickets %]<br>
tickets:<br>
singular: ticket<br>
[% Dumper.dump_html(ticket.unblessed) %]<br>
plural: tickets<br>
[% Dumper.dump_html(tickets.unblessed) %]<br>
<br>
[% END %]
[% IF ticket_update || ticket_updates %]<br>
ticket_updates:<br>
singular: ticket_update<br>
[% Dumper.dump_html(ticket_update.unblessed) %]<br>
plural: ticket_updates<br>
[% Dumper.dump_html(ticket_updates.unblessed) %]<br>
<br>
[% END %]
[% IF checkout || checkouts %]<br>
issues:<br>
singular: checkout<br>
[% Dumper.dump_html(checkout.unblessed) %]<br>
plural: checkouts<br>
[% Dumper.dump_html(checkouts.unblessed) %]<br>
<br>
[% END %]
[% IF old_checkout || old_checkouts %]<br>
old_issues:<br>
singular: old_checkout<br>
[% Dumper.dump_html(old_checkout.unblessed) %]<br>
plural: old_checkouts<br>
[% Dumper.dump_html(old_checkouts.unblessed) %]<br>
<br>
[% END %]
[% IF overdue || overdues %]<br>
overdues:<br>
singular: overdue<br>
[% Dumper.dump_html(overdue.unblessed) %]<br>
plural: overdues<br>
[% Dumper.dump_html(overdues.unblessed) %]<br>
<br>
[% END %]
[% IF patron_modification || patron_modifications %]<br>
borrower_modifications:<br>
singular: patron_modification<br>
[% Dumper.dump_html(patron_modification.unblessed) %]<br>
plural: patron_modifications<br>
[% Dumper.dump_html(patron_modifications.unblessed) %]<br>
<br>
[% END %]
[% IF illrequest || illrequests %]<br>
illrequests:<br>
singular: illrequest<br>
[% Dumper.dump_html(illrequest.unblessed) %]<br>
plural: illrequests<br>
[% Dumper.dump_html(illrequests.unblessed) %]<br>
<br>
[% END %]
[% IF train_item || train_items %]<br>
preservation_train_items:<br>
singular: train_item<br>
[% Dumper.dump_html(train_item.unblessed) %]<br>
plural: train_items<br>
[% Dumper.dump_html(train_items.unblessed) %]<br>
<br>
[% END %]
[% IF problemreport || problemreports %]<br>
problem_reports:<br>
singular: problemreport<br>
[% Dumper.dump_html(problemreport.unblessed) %]<br>
plural: problemreports<br>
[% Dumper.dump_html(problemreports.unblessed) %]<br>
[% END %]
[% IF offset || offsets %]
offsets:
singular: offset<br>
[% Dumper.dump_html(offset.unblessed) %]<br>
plural: offsets<br>
[% Dumper.dump_html(offsets.unblessed) %]<br>
[% END %]

Sample notice output

Below is the output of this template for a selection of common notices.

HOLD

biblio:
singular: biblio
$VAR1 = {
'seriestitle' => undef,
'datecreated' => '2014-05-07',
'biblionumber' => 344,
'abstract' => undef,
'unititle' => undef,
'notes' => undef,
'part_number' => undef,
'author' => 'Heylin, Clinton.',
'serial' => undef,
'frameworkcode' => 'BKS',
'medium' => undef,
'part_name' => undef,
'copyrightdate' => 2012,
'subtitle' => undef,
'title' => 'E Street shuffle :',
'timestamp' => '2020-04-21 09:38:27'
};

plural: biblios
$VAR1 = '';

biblioitems:
singular: biblioitem
$VAR1 = {
'cn_class' => undef,
'agerestriction' => undef,
'ean' => undef,
'cn_source' => 'ddc',
'pages' => '1 v. ;',
'timestamp' => '2014-05-07 13:36:26',
'size' => '20 cm.',
'biblionumber' => 344,
'issn' => undef,
'cn_sort' => '',
'number' => undef,
'publishercode' => 'Constable,',
'collectionissn' => undef,
'cn_item' => undef,
'biblioitemnumber' => 344,
'volumedate' => undef,
'illus' => undef,
'volume' => undef,
'isbn' => '9781780335797 (hbk.) : | 1780335792 (hbk.) : | 9781780338682 (pbk.)',
'editionstatement' => undef,
'place' => 'London :',
'volumedesc' => undef,
'itemtype' => 'BK',
'collectiontitle' => undef,
'publicationyear' => undef,
'cn_suffix' => undef,
'editionresponsibility' => undef,
'notes' => undef,
'totalissues' => undef,
'lccn' => undef,
'url' => undef,
'collectionvolume' => undef
};

plural: biblioitems
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'contactname' => '',
'address' => '4345 Library Rd.',
'mobile' => '',
'altcontactaddress1' => '',
'relationship' => undef,
'gonenoaddress' => 0,
'streettype' => undef,
'cardnumber' => '23529000035676',
'sort1' => '0.36460167669188',
'auth_method' => 'password',
'preferred_name' => 'Henry',
'othernames' => '',
'initials' => '',
'B_address2' => '',
'phone' => '(212) 555-1212',
'email' => 'a@a.a',
'date_renewed' => undef,
'flags' => undef,
'secret' => undef,
'dateofbirth' => '1958-05-30',
'debarred' => undef,
'address2' => '',
'zipcode' => '44224',
'sex' => 'F',
'firstname' => 'Henry',
'overdrive_auth_token' => undef,
'fax' => '',
'altcontactfirstname' => '',
'city' => 'Springfield, MA',
'B_zipcode' => '',
'B_state' => '',
'B_phone' => '',
'altcontactaddress2' => '',
'middle_name' => '',
'B_city' => '',
'altcontactstate' => '',
'B_streettype' => undef,
'categorycode' => 'PT',
'protected' => 0,
'privacy_guarantor_checkouts' => 0,
'contactnote' => '',
'lastseen' => undef,
'B_country' => '',
'password_expiration_date' => undef,
'smsalertnumber' => undef,
'borrowernotes' => '',
'B_streetnumber' => '',
'contactfirstname' => undef,
'primary_contact_method' => '',
'altcontactsurname' => '',
'altcontactphone' => '',
'branchcode' => 'MPL',
'lang' => 'default',
'sort2' => '0.33887459834933',
'surname' => 'Acevedo',
'B_address' => '',
'userid' => '23529000035676',
'checkprevcheckout' => 'inherit',
'privacy' => 1,
'privacy_guarantor_fines' => 0,
'streetnumber' => '',
'anonymized' => 0,
'contacttitle' => undef,
'title' => '',
'password' => '42b29d0771f3b7ef',
'pronouns' => '',
'altcontactaddress3' => '',
'B_email' => '',
'login_attempts' => 0,
'altcontactcountry' => '',
'altcontactzipcode' => '',
'sms_provider_id' => undef,
'dateenrolled' => '1990-09-23',
'autorenew_checkouts' => 1,
'opacnote' => '',
'state' => '',
'debarredcomment' => undef,
'borrowernumber' => 19,
'dateexpiry' => '2099-12-31',
'phonepro' => '',
'updated_on' => '2025-04-24 19:12:31',
'emailpro' => '',
'country' => '',
'lost' => 0
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchurl' => undef,
'branchnotes' => undef,
'issuing' => undef,
'opacusercss' => undef,
'geolocation' => undef,
'branchzip' => undef,
'branchcode' => 'CPL',
'branchreplyto' => undef,
'branchreturnpath' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchillemail' => undef,
'public' => 1,
'branchcountry' => undef,
'branchip' => undef,
'branchfax' => undef,
'branchemail' => undef,
'branchaddress3' => undef,
'branchstate' => undef,
'branchcity' => undef,
'branchphone' => undef,
'branchaddress2' => undef,
'branchname' => 'Centerville',
'pickup_location' => 1,
'marcorgcode' => undef,
'opacuserjs' => undef
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = {
'damaged_on' => undef,
'holdingbranch' => 'CPL',
'more_subfields_xml' => undef,
'datelastborrowed' => '2025-04-24',
'homebranch' => 'CPL',
'datelastseen' => '2025-04-25 13:45:50',
'permanent_location' => 'GEN',
'biblionumber' => 344,
'materials' => undef,
'new_status' => undef,
'price' => undef,
'timestamp' => '2025-04-25 13:45:50',
'itype' => 'BK',
'cn_source' => 'ddc',
'issues' => 5,
'reserves' => undef,
'coded_location_qualifier' => undef,
'location' => 'GEN',
'onloan' => undef,
'damaged' => 0,
'stack' => undef,
'stocknumber' => undef,
'itemnotes' => undef,
'replacementpricedate' => '2014-09-04',
'withdrawn' => 0,
'itemcallnumber' => undef,
'replacementprice' => undef,
'biblioitemnumber' => 344,
'notforloan' => 0,
'cn_sort' => '',
'exclude_from_local_holds_priority' => undef,
'copynumber' => undef,
'uri' => undef,
'restricted' => undef,
'withdrawn_on' => undef,
'barcode' => '111',
'itemnotes_nonpublic' => undef,
'itemlost_on' => undef,
'bookable' => undef,
'booksellerid' => undef,
'ccode' => 'REF',
'itemnumber' => 755,
'renewals' => 8,
'enumchron' => undef,
'deleted_on' => undef,
'localuse' => undef,
'itemlost' => 0,
'dateaccessioned' => '2014-09-04'
};

plural: items
$VAR1 = '';

reserves:
singular: hold
$VAR1 = {
'non_priority' => 0,
'lowestPriority' => 0,
'timestamp' => '2025-04-25 13:45:54',
'item_group_id' => undef,
'notificationdate' => undef,
'item_level_hold' => 0,
'waitingdate' => '2025-04-25',
'biblionumber' => 344,
'cancellation_reason' => undef,
'found' => 'W',
'cancellationdate' => undef,
'branchcode' => 'CPL',
'reminderdate' => undef,
'deleted_biblionumber' => undef,
'reserve_id' => 3,
'reservenotes' => '',
'suspend' => 0,
'itemtype' => undef,
'patron_expiration_date' => undef,
'expirationdate' => '2025-05-02',
'desk_id' => undef,
'itemnumber' => 755,
'reservedate' => '2025-04-25',
'suspend_until' => undef,
'borrowernumber' => 19,
'priority' => 0
};

plural: holds
$VAR1 = '';

HOLDDGST

biblio:
singular: biblio
$VAR1 = {
'part_name' => undef,
'copyrightdate' => 2012,
'subtitle' => undef,
'title' => 'E Street shuffle :',
'timestamp' => '2020-04-21 09:38:27',
'seriestitle' => undef,
'biblionumber' => 344,
'datecreated' => '2014-05-07',
'abstract' => undef,
'unititle' => undef,
'notes' => undef,
'author' => 'Heylin, Clinton.',
'part_number' => undef,
'serial' => undef,
'frameworkcode' => 'BKS',
'medium' => undef
};

plural: biblios
$VAR1 = '';

biblioitems:
singular: biblioitem
$VAR1 = {
'cn_source' => 'ddc',
'pages' => '1 v. ;',
'timestamp' => '2014-05-07 13:36:26',
'size' => '20 cm.',
'cn_class' => undef,
'agerestriction' => undef,
'ean' => undef,
'volumedate' => undef,
'illus' => undef,
'volume' => undef,
'biblionumber' => 344,
'cn_sort' => '',
'issn' => undef,
'number' => undef,
'publishercode' => 'Constable,',
'collectionissn' => undef,
'cn_item' => undef,
'biblioitemnumber' => 344,
'volumedesc' => undef,
'itemtype' => 'BK',
'collectiontitle' => undef,
'isbn' => '9781780335797 (hbk.) : | 1780335792 (hbk.) : | 9781780338682 (pbk.)',
'editionstatement' => undef,
'place' => 'London :',
'notes' => undef,
'lccn' => undef,
'totalissues' => undef,
'url' => undef,
'collectionvolume' => undef,
'publicationyear' => undef,
'cn_suffix' => undef,
'editionresponsibility' => undef
};

plural: biblioitems
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'privacy_guarantor_fines' => 0,
'streetnumber' => '',
'anonymized' => 0,
'title' => '',
'contacttitle' => undef,
'B_email' => '',
'password' => '42b29d0771f3b7ef',
'altcontactaddress3' => '',
'pronouns' => '',
'sms_provider_id' => undef,
'altcontactzipcode' => '',
'altcontactcountry' => '',
'login_attempts' => 0,
'opacnote' => '',
'dateenrolled' => '1990-09-23',
'autorenew_checkouts' => 1,
'debarredcomment' => undef,
'borrowernumber' => 19,
'state' => '',
'updated_on' => '2025-04-24 19:12:31',
'phonepro' => '',
'emailpro' => '',
'dateexpiry' => '2099-12-31',
'lost' => 0,
'country' => '',
'protected' => 0,
'privacy_guarantor_checkouts' => 0,
'B_country' => '',
'password_expiration_date' => undef,
'smsalertnumber' => undef,
'contactnote' => '',
'lastseen' => undef,
'contactfirstname' => undef,
'B_streetnumber' => '',
'borrowernotes' => '',
'primary_contact_method' => '',
'branchcode' => 'MPL',
'lang' => 'default',
'altcontactsurname' => '',
'altcontactphone' => '',
'sort2' => '0.33887459834933',
'surname' => 'Acevedo',
'checkprevcheckout' => 'inherit',
'privacy' => 1,
'B_address' => '',
'userid' => '23529000035676',
'dateofbirth' => '1958-05-30',
'debarred' => undef,
'sex' => 'F',
'zipcode' => '44224',
'address2' => '',
'fax' => '',
'altcontactfirstname' => '',
'firstname' => 'Henry',
'overdrive_auth_token' => undef,
'B_state' => '',
'city' => 'Springfield, MA',
'B_zipcode' => '',
'altcontactaddress2' => '',
'B_city' => '',
'middle_name' => '',
'B_phone' => '',
'categorycode' => 'PT',
'altcontactstate' => '',
'B_streettype' => undef,
'gonenoaddress' => 0,
'relationship' => undef,
'contactname' => '',
'mobile' => '',
'altcontactaddress1' => '',
'address' => '4345 Library Rd.',
'sort1' => '0.36460167669188',
'cardnumber' => '23529000035676',
'streettype' => undef,
'auth_method' => 'password',
'initials' => '',
'othernames' => '',
'preferred_name' => 'Henry',
'B_address2' => '',
'phone' => '(212) 555-1212',
'email' => 'a@a.a',
'flags' => undef,
'date_renewed' => undef,
'secret' => undef
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchname' => 'Centerville',
'branchaddress2' => undef,
'branchphone' => undef,
'branchcity' => undef,
'opacuserjs' => undef,
'pickup_location' => 1,
'marcorgcode' => undef,
'branchzip' => undef,
'geolocation' => undef,
'opacusercss' => undef,
'issuing' => undef,
'branchnotes' => undef,
'branchurl' => undef,
'branchstate' => undef,
'branchaddress3' => undef,
'branchemail' => undef,
'branchfax' => undef,
'branchcountry' => undef,
'branchip' => undef,
'public' => 1,
'branchillemail' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchreturnpath' => undef,
'branchreplyto' => undef,
'branchcode' => 'CPL'
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = {
'ccode' => 'REF',
'itemnumber' => 755,
'bookable' => undef,
'itemlost_on' => undef,
'booksellerid' => undef,
'itemlost' => 0,
'localuse' => undef,
'dateaccessioned' => '2014-09-04',
'enumchron' => undef,
'deleted_on' => undef,
'renewals' => 8,
'notforloan' => 0,
'biblioitemnumber' => 344,
'cn_sort' => '',
'replacementprice' => undef,
'itemcallnumber' => undef,
'restricted' => undef,
'withdrawn_on' => undef,
'uri' => undef,
'copynumber' => undef,
'itemnotes_nonpublic' => undef,
'barcode' => '111',
'exclude_from_local_holds_priority' => undef,
'coded_location_qualifier' => undef,
'stocknumber' => undef,
'stack' => undef,
'damaged' => 0,
'withdrawn' => 0,
'replacementpricedate' => '2014-09-04',
'itemnotes' => undef,
'onloan' => undef,
'location' => 'GEN',
'permanent_location' => 'GEN',
'homebranch' => 'CPL',
'datelastseen' => '2025-04-25 13:46:24',
'materials' => undef,
'biblionumber' => 344,
'damaged_on' => undef,
'more_subfields_xml' => undef,
'datelastborrowed' => '2025-04-24',
'holdingbranch' => 'CPL',
'reserves' => undef,
'issues' => 5,
'price' => undef,
'new_status' => undef,
'cn_source' => 'ddc',
'itype' => 'BK',
'timestamp' => '2025-04-25 13:46:24'
};

plural: items
$VAR1 = '';

reserves:
singular: hold
$VAR1 = {
'priority' => 0,
'borrowernumber' => 19,
'reservedate' => '2025-04-25',
'suspend_until' => undef,
'itemnumber' => 755,
'desk_id' => undef,
'expirationdate' => '2025-05-02',
'patron_expiration_date' => undef,
'itemtype' => undef,
'suspend' => 0,
'reservenotes' => '',
'reserve_id' => 3,
'deleted_biblionumber' => undef,
'branchcode' => 'CPL',
'reminderdate' => undef,
'cancellationdate' => undef,
'found' => 'W',
'cancellation_reason' => undef,
'biblionumber' => 344,
'waitingdate' => '2025-04-25',
'notificationdate' => undef,
'item_group_id' => undef,
'item_level_hold' => 0,
'timestamp' => '2025-04-25 13:46:26',
'lowestPriority' => 0,
'non_priority' => 0
};

plural: holds
$VAR1 = '';


HOLD_REMINDER

borrowers:
singular: borrower
$VAR1 = {
'privacy' => 1,
'lastseen' => undef,
'contactname' => '',
'B_country' => '',
'sort2' => '0.33887459834933',
'phone' => '(212) 555-1212',
'primary_contact_method' => '',
'contactfirstname' => undef,
'privacy_guarantor_fines' => 0,
'zipcode' => '44224',
'B_zipcode' => '',
'B_streetnumber' => '',
'initials' => '',
'state' => '',
'mobile' => '',
'borrowernumber' => 19,
'contacttitle' => undef,
'altcontactcountry' => '',
'branchcode' => 'MPL',
'email' => 'a@a.a',
'altcontactsurname' => '',
'title' => '',
'altcontactaddress1' => '',
'flags' => undef,
'B_state' => '',
'borrowernotes' => '',
'updated_on' => '2025-05-01 18:08:29',
'B_streettype' => undef,
'altcontactzipcode' => '',
'auth_method' => 'password',
'address' => '4345 Library Rd.',
'secret' => undef,
'sort1' => '0.36460167669188',
'dateenrolled' => '1990-09-23',
'altcontactfirstname' => '',
'password' => '42b29d0771f3b7ef',
'altcontactstate' => '',
'categorycode' => 'S',
'address2' => '',
'altcontactaddress2' => '',
'sms_provider_id' => undef,
'protected' => 0,
'pronouns' => '',
'B_address2' => '',
'gonenoaddress' => 0,
'contactnote' => '',
'streettype' => undef,
'streetnumber' => '',
'relationship' => undef,
'emailpro' => '',
'debarredcomment' => undef,
'date_renewed' => undef,
'altcontactaddress3' => '',
'firstname' => 'Henry',
'phonepro' => '',
'B_email' => '',
'lost' => 0,
'B_phone' => '',
'fax' => '',
'userid' => '23529000035676',
'city' => 'Springfield, MA',
'autorenew_checkouts' => 1,
'checkprevcheckout' => 'inherit',
'login_attempts' => 0,
'country' => '',
'password_expiration_date' => undef,
'dateofbirth' => '1958-05-30',
'debarred' => undef,
'anonymized' => 0,
'B_address' => '',
'overdrive_auth_token' => undef,
'cardnumber' => '23529000035676',
'lang' => 'default',
'sex' => 'F',
'middle_name' => '',
'B_city' => '',
'smsalertnumber' => undef,
'privacy_guarantor_checkouts' => 0,
'preferred_name' => 'Henry',
'surname' => 'Acevedo',
'dateexpiry' => '2099-12-31',
'othernames' => '',
'altcontactphone' => '',
'opacnote' => ''
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchcode' => 'UPL',
'issuing' => undef,
'branchreturnpath' => undef,
'branchphone' => undef,
'branchaddress2' => undef,
'branchfax' => undef,
'branchnotes' => undef,
'branchaddress3' => undef,
'branchemail' => undef,
'branchurl' => undef,
'public' => 1,
'branchcountry' => undef,
'branchzip' => undef,
'marcorgcode' => undef,
'branchaddress1' => 'Chestnut Hollow',
'branchreplyto' => undef,
'branchillemail' => undef,
'pickup_location' => 1,
'opacusercss' => undef,
'opacuserjs' => undef,
'branchname' => 'Union',
'branchcity' => undef,
'geolocation' => undef,
'branchip' => undef,
'branchstate' => undef
};

plural: branches
$VAR1 = '';

reserves:
singular: hold
$VAR1 = '';

plural: holds
$VAR1 = [
{
'desk_id' => undef,
'notificationdate' => undef,
'expirationdate' => '2025-05-08',
'item_group_id' => undef,
'deleted_biblionumber' => undef,
'suspend' => 0,
'suspend_until' => undef,
'cancellation_reason' => undef,
'cancellationdate' => undef,
'lowestPriority' => 0,
'priority' => 0,
'itemnumber' => 976,
'borrowernumber' => 19,
'branchcode' => 'UPL',
'itemtype' => undef,
'reminderdate' => undef,
'reservedate' => '2025-05-01',
'reserve_id' => 1,
'biblionumber' => 344,
'reservenotes' => '',
'item_level_hold' => 0,
'waitingdate' => '2025-05-01',
'found' => 'W',
'non_priority' => 0,
'timestamp' => '2025-05-01 18:10:21',
'patron_expiration_date' => undef
}
];

HOLD_CANCELLATION


Infobiblio:
singular: biblio
$VAR1 = {
'biblionumber' => 6,
'title' => 'X Power Tools',
'part_name' => undef,
'author' => 'Tyler, chris',
'unititle' => undef,
'seriestitle' => undef,
'frameworkcode' => 'BKS',
'notes' => undef,
'serial' => undef,
'copyrightdate' => undef,
'timestamp' => '2020-01-29 12:06:37',
'subtitle' => undef,
'abstract' => undef,
'medium' => undef,
'datecreated' => '2014-05-07',
'part_number' => undef
};

plural: biblios
$VAR1 = '';


biblioitems:
singular: biblioitem
$VAR1 = {
'cn_item' => undef,
'pages' => undef,
'collectionvolume' => undef,
'ean' => undef,
'publicationyear' => undef,
'collectionissn' => undef,
'collectiontitle' => undef,
'editionresponsibility' => undef,
'illus' => undef,
'totalissues' => undef,
'issn' => undef,
'cn_sort' => '',
'number' => undef,
'itemtype' => 'BK',
'cn_suffix' => undef,
'volume' => undef,
'isbn' => '9780596101954',
'agerestriction' => undef,
'volumedesc' => undef,
'timestamp' => '2020-01-29 12:06:37',
'lccn' => undef,
'volumedate' => undef,
'editionstatement' => undef,
'biblionumber' => 6,
'cn_source' => undef,
'biblioitemnumber' => 6,
'cn_class' => undef,
'place' => undef,
'size' => undef,
'publishercode' => undef,
'url' => undef,
'notes' => undef
};

plural: biblioitems
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'B_city' => undef,
'country' => undef,
'address2' => undef,
'userid' => '23529000035676',
'flags' => undef,
'phonepro' => undef,
'pronouns' => undef,
'date_renewed' => undef,
'B_address' => undef,
'B_email' => undef,
'phone' => '(212) 555-1212',
'sort1' => '0.36460167669188',
'privacy' => 1,
'auth_method' => 'password',
'altcontactphone' => undef,
'overdrive_auth_token' => undef,
'lost' => undef,
'lastseen' => undef,
'debarred' => undef,
'contacttitle' => undef,
'cardnumber' => '23529000035676',
'privacy_guarantor_checkouts' => 0,
'protected' => 0,
'sex' => 'F',
'fax' => undef,
'anonymized' => 0,
'sms_provider_id' => undef,
'address' => '4345 Library Rd.',
'B_phone' => undef,
'B_streettype' => undef,
'altcontactaddress1' => undef,
'firstname' => 'Henry',
'borrowernotes' => undef,
'borrowernumber' => 19,
'B_country' => undef,
'dateexpiry' => '2099-12-31',
'B_streetnumber' => undef,
'dateenrolled' => '1990-09-23',
'secret' => undef,
'altcontactaddress3' => undef,
'privacy_guarantor_fines' => 0,
'email' => 'lisette@bywatersolutions.com',
'primary_contact_method' => undef,
'altcontactsurname' => undef,
'surname' => 'Acevedo',
'branchcode' => 'CPL',
'sort2' => '0.33887459834933',
'title' => undef,
'emailpro' => undef,
'state' => undef,
'login_attempts' => 0,
'B_zipcode' => undef,
'dateofbirth' => '1958-05-30',
'autorenew_checkouts' => 1,
'password_expiration_date' => undef,
'mobile' => undef,
'updated_on' => '2025-05-27 19:20:44',
'debarredcomment' => undef,
'city' => 'Springfield, MA',
'contactname' => '',
'preferred_name' => 'Henry',
'middle_name' => undef,
'relationship' => undef,
'categorycode' => 'S',
'othernames' => undef,
'password' => '42b29d0771f3b7ef',
'contactnote' => undef,
'altcontactcountry' => undef,
'B_state' => undef,
'streetnumber' => undef,
'altcontactzipcode' => undef,
'smsalertnumber' => undef,
'zipcode' => '44224',
'gonenoaddress' => undef,
'altcontactfirstname' => undef,
'B_address2' => undef,
'streettype' => undef,
'altcontactstate' => undef,
'contactfirstname' => undef,
'altcontactaddress2' => undef,
'checkprevcheckout' => 'inherit',
'lang' => 'default',
'initials' => '',
'opacnote' => undef
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchillemail' => undef,
'branchname' => 'Centerville',
'public' => 1,
'branchstate' => undef,
'branchnotes' => undef,
'branchreturnpath' => undef,
'branchphone' => undef,
'issuing' => undef,
'branchreplyto' => undef,
'branchcity' => undef,
'opacusercss' => undef,
'branchaddress3' => undef,
'branchaddress2' => undef,
'branchcode' => 'CPL',
'opacuserjs' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchcountry' => undef,
'branchzip' => undef,
'marcorgcode' => undef,
'geolocation' => undef,
'branchurl' => undef,
'branchfax' => undef,
'pickup_location' => 1,
'branchemail' => undef,
'branchip' => undef
};

plural: branches
$VAR1 = '';

reserves:
singular: hold
$VAR1 = {
'waitingdate' => undef,
'lowestPriority' => 0,
'itemnumber' => undef,
'itemtype' => undef,
'non_priority' => 0,
'reminderdate' => undef,
'branchcode' => 'CPL',
'item_group_id' => undef,
'deleted_biblionumber' => undef,
'priority' => 0,
'reservedate' => '2025-05-28',
'reserve_id' => 5,
'reservenotes' => '',
'found' => undef,
'patron_expiration_date' => undef,
'suspend' => 0,
'cancellationdate' => '2025-05-28',
'biblionumber' => 6,
'expirationdate' => undef,
'cancellation_reason' => 'NOT_FOUND',
'item_level_hold' => 0,
'desk_id' => undef,
'notificationdate' => undef,
'timestamp' => '2025-05-28 16:05:45',
'suspend_until' => undef,
'borrowernumber' => 19
};

plural: holds
$VAR1 = '';

AUTO_RENEWALS

biblio:
singular: biblio
$VAR1 = {
'datecreated' => '2014-05-07',
'part_name' => undef,
'copyrightdate' => 2012,
'seriestitle' => undef,
'biblionumber' => 344,
'serial' => undef,
'notes' => undef,
'abstract' => undef,
'title' => 'E Street shuffle :',
'frameworkcode' => 'BKS',
'part_number' => undef,
'author' => 'Heylin, Clinton.',
'subtitle' => undef,
'medium' => undef,
'timestamp' => '2020-04-21 09:38:27',
'unititle' => undef
};

plural: biblios
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'userid' => '23529000035676',
'lastseen' => undef,
'altcontactsurname' => '',
'dateenrolled' => '1990-09-23',
'sort1' => '0.36460167669188',
'altcontactaddress1' => '',
'country' => '',
'phonepro' => '',
'contactname' => '',
'surname' => 'Acevedo',
'B_streetnumber' => '',
'login_attempts' => 0,
'B_address' => '',
'relationship' => undef,
'B_country' => '',
'gonenoaddress' => 0,
'firstname' => 'Henry',
'auth_method' => 'password',
'altcontactaddress2' => '',
'streetnumber' => '',
'contactfirstname' => undef,
'othernames' => '',
'dateexpiry' => '2099-12-31',
'sort2' => '0.33887459834933',
'email' => 'a@a.a',
'address' => '4345 Library Rd.',
'borrowernotes' => '',
'protected' => 0,
'overdrive_auth_token' => undef,
'checkprevcheckout' => 'inherit',
'privacy' => 1,
'privacy_guarantor_fines' => 0,
'password_expiration_date' => undef,
'cardnumber' => '23529000035676',
'fax' => '',
'sex' => 'F',
'B_state' => '',
'city' => 'Springfield, MA',
'mobile' => '',
'title' => '',
'altcontactstate' => '',
'sms_provider_id' => undef,
'preferred_name' => 'Henry',
'altcontactphone' => '',
'contacttitle' => undef,
'altcontactcountry' => '',
'opacnote' => '',
'dateofbirth' => '1958-05-30',
'primary_contact_method' => '',
'B_city' => '',
'categorycode' => 'PT',
'B_phone' => '',
'debarred' => undef,
'address2' => '',
'flags' => undef,
'lost' => 0,
'altcontactzipcode' => '',
'phone' => '(212) 555-1212',
'anonymized' => 0,
'debarredcomment' => undef,
'branchcode' => 'MPL',
'pronouns' => '',
'privacy_guarantor_checkouts' => 0,
'altcontactfirstname' => '',
'autorenew_checkouts' => 1,
'borrowernumber' => 19,
'streettype' => undef,
'secret' => undef,
'B_zipcode' => '',
'zipcode' => '44224',
'updated_on' => '2025-04-25 14:13:37',
'contactnote' => '',
'altcontactaddress3' => '',
'B_email' => '',
'B_streettype' => undef,
'smsalertnumber' => '',
'state' => '',
'lang' => 'default',
'middle_name' => '',
'password' => '42b29d0771f3b7ef',
'initials' => '',
'date_renewed' => undef,
'emailpro' => '',
'B_address2' => ''
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchfax' => undef,
'geolocation' => undef,
'branchaddress2' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchemail' => undef,
'branchreturnpath' => undef,
'branchcode' => 'CPL',
'branchstate' => undef,
'branchphone' => undef,
'branchaddress3' => undef,
'branchzip' => undef,
'branchillemail' => undef,
'branchcountry' => undef,
'branchname' => 'Centerville',
'branchurl' => undef,
'public' => 1,
'branchip' => undef,
'opacusercss' => undef,
'opacuserjs' => undef,
'branchcity' => undef,
'issuing' => undef,
'branchreplyto' => undef,
'marcorgcode' => undef,
'pickup_location' => 1,
'branchnotes' => undef
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = {
'itemnumber' => 755,
'datelastseen' => '2025-04-25 14:29:25',
'more_subfields_xml' => undef,
'holdingbranch' => 'CPL',
'copynumber' => undef,
'dateaccessioned' => '2014-09-04',
'itemcallnumber' => undef,
'replacementpricedate' => '2014-09-04',
'withdrawn_on' => undef,
'deleted_on' => undef,
'cn_sort' => '',
'biblionumber' => 344,
'cn_source' => 'ddc',
'barcode' => '111',
'ccode' => 'REF',
'itemlost_on' => undef,
'exclude_from_local_holds_priority' => undef,
'renewals' => 16,
'onloan' => '2025-05-01',
'stocknumber' => undef,
'uri' => undef,
'itemnotes' => undef,
'booksellerid' => undef,
'itemlost' => 0,
'new_status' => undef,
'itemnotes_nonpublic' => undef,
'replacementprice' => undef,
'bookable' => undef,
'notforloan' => 0,
'homebranch' => 'CPL',
'stack' => undef,
'issues' => 10,
'reserves' => undef,
'restricted' => undef,
'itype' => 'BK',
'datelastborrowed' => '2025-04-25',
'localuse' => undef,
'biblioitemnumber' => 344,
'permanent_location' => 'GEN',
'price' => undef,
'location' => 'GEN',
'timestamp' => '2025-04-25 14:29:33',
'damaged' => 0,
'enumchron' => undef,
'coded_location_qualifier' => undef,
'damaged_on' => undef,
'withdrawn' => 0,
'materials' => undef
};

plural: items
$VAR1 = '';

issues:
singular: checkout
$VAR1 = {
'date_due' => '2025-05-01 23:59:00',
'issue_id' => 10,
'checkin_library' => undef,
'notedate' => undef,
'noteseen' => undef,
'itemnumber' => 755,
'borrowernumber' => 19,
'issuedate' => '2025-04-25 14:29:25',
'renewals_count' => 1,
'lastreneweddate' => '2025-04-25 14:29:33',
'issuer_id' => undef,
'returndate' => undef,
'timestamp' => '2025-04-25 14:29:33',
'auto_renew' => 1,
'auto_renew_error' => undef,
'note' => undef,
'unseen_renewals' => 0,
'branchcode' => 'CPL',
'onsite_checkout' => 0
};

plural: checkouts
$VAR1 = '';

AUTO_RENEWALS_DGST

borrowers:
singular: borrower
$VAR1 = {
'altcontactcountry' => '',
'sex' => 'F',
'altcontactaddress3' => '',
'contactname' => '',
'privacy_guarantor_checkouts' => 0,
'initials' => '',
'overdrive_auth_token' => undef,
'city' => 'Springfield, MA',
'lost' => 0,
'lang' => 'default',
'mobile' => '',
'phone' => '(212) 555-1212',
'contacttitle' => undef,
'zipcode' => '44224',
'privacy' => 1,
'surname' => 'Acevedo',
'secret' => undef,
'userid' => '23529000035676',
'privacy_guarantor_fines' => 0,
'state' => '',
'firstname' => 'Henry',
'updated_on' => '2025-04-25 14:13:37',
'middle_name' => '',
'contactnote' => '',
'country' => '',
'password' => '42b29d0771f3b7ef',
'dateexpiry' => '2099-12-31',
'dateofbirth' => '1958-05-30',
'othernames' => '',
'pronouns' => '',
'email' => 'a@a.a',
'title' => '',
'gonenoaddress' => 0,
'B_phone' => '',
'altcontactsurname' => '',
'smsalertnumber' => '',
'altcontactaddress2' => '',
'sort1' => '0.36460167669188',
'altcontactstate' => '',
'opacnote' => '',
'altcontactfirstname' => '',
'B_state' => '',
'altcontactaddress1' => '',
'sort2' => '0.33887459834933',
'primary_contact_method' => '',
'dateenrolled' => '1990-09-23',
'date_renewed' => undef,
'protected' => 0,
'checkprevcheckout' => 'inherit',
'auth_method' => 'password',
'autorenew_checkouts' => 1,
'lastseen' => undef,
'B_email' => '',
'password_expiration_date' => undef,
'login_attempts' => 0,
'B_streettype' => undef,
'emailpro' => '',
'categorycode' => 'PT',
'B_address2' => '',
'B_streetnumber' => '',
'borrowernotes' => '',
'fax' => '',
'streettype' => undef,
'altcontactphone' => '',
'address2' => '',
'sms_provider_id' => undef,
'flags' => undef,
'debarred' => undef,
'contactfirstname' => undef,
'B_country' => '',
'cardnumber' => '23529000035676',
'B_city' => '',
'B_zipcode' => '',
'streetnumber' => '',
'address' => '4345 Library Rd.',
'borrowernumber' => 19,
'B_address' => '',
'altcontactzipcode' => '',
'branchcode' => 'MPL',
'relationship' => undef,
'preferred_name' => 'Henry',
'phonepro' => '',
'debarredcomment' => undef,
'anonymized' => 0
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'public' => 1,
'pickup_location' => 1,
'branchemail' => undef,
'marcorgcode' => undef,
'opacuserjs' => undef,
'branchip' => undef,
'branchzip' => undef,
'branchaddress1' => '372 Forest Street',
'branchreplyto' => undef,
'branchfax' => undef,
'geolocation' => undef,
'branchphone' => undef,
'branchcountry' => undef,
'opacusercss' => undef,
'branchnotes' => undef,
'branchaddress3' => undef,
'branchstate' => undef,
'issuing' => undef,
'branchurl' => undef,
'branchreturnpath' => undef,
'branchaddress2' => undef,
'branchillemail' => undef,
'branchcode' => 'MPL',
'branchname' => 'Midway',
'branchcity' => undef
};

plural: branches
$VAR1 = '';

issues:
singular: checkout
$VAR1 = '';

plural: checkouts
$VAR1 = [
{
'lastreneweddate' => '2025-04-25 14:29:13',
'returndate' => undef,
'itemnumber' => 755,
'auto_renew' => 1,
'checkin_library' => undef,
'unseen_renewals' => 0,
'note' => undef,
'date_due' => '2025-05-01 23:59:00',
'renewals_count' => 1,
'onsite_checkout' => 0,
'issuer_id' => undef,
'timestamp' => '2025-04-25 14:29:13',
'auto_renew_error' => undef,
'noteseen' => undef,
'notedate' => undef,
'issuedate' => '2025-04-25 14:29:09',
'borrowernumber' => 19,
'issue_id' => 9,
'branchcode' => 'CPL'
}
];

OVERDUE (notices generated via the overdues process, regardless of letter code)

borrowers:
singular: borrower
$VAR1 = {
'contacttitle' => undef,
'altcontactstate' => '',
'altcontactaddress2' => '',
'categorycode' => 'PT',
'debarred' => undef,
'streettype' => undef,
'primary_contact_method' => '',
'gonenoaddress' => 0,
'fax' => '',
'B_address' => '',
'email' => 'a@a.a',
'emailpro' => '',
'pronouns' => '',
'password' => '42b29d0771f3b7ef',
'anonymized' => 0,
'sms_provider_id' => undef,
'altcontactfirstname' => '',
'sort2' => '0.33887459834933',
'othernames' => '',
'phonepro' => '',
'altcontactaddress1' => '',
'title' => '',
'dateenrolled' => '1990-09-23',
'phone' => '(212) 555-1212',
'updated_on' => '2025-04-25 14:13:37',
'middle_name' => '',
'B_zipcode' => '',
'contactname' => '',
'dateofbirth' => '1958-05-30',
'surname' => 'Acevedo',
'address2' => '',
'overdrive_auth_token' => undef,
'checkprevcheckout' => 'inherit',
'altcontactphone' => '',
'address' => '4345 Library Rd.',
'zipcode' => '44224',
'sort1' => '0.36460167669188',
'cardnumber' => '23529000035676',
'userid' => '23529000035676',
'privacy_guarantor_fines' => 0,
'lastseen' => undef,
'dateexpiry' => '2099-12-31',
'protected' => 0,
'contactfirstname' => undef,
'password_expiration_date' => undef,
'B_phone' => '',
'initials' => '',
'country' => '',
'B_country' => '',
'B_email' => '',
'mobile' => '',
'smsalertnumber' => '',
'city' => 'Springfield, MA',
'privacy' => 1,
'altcontactaddress3' => '',
'flags' => undef,
'B_streetnumber' => '',
'borrowernotes' => '',
'opacnote' => '',
'login_attempts' => 0,
'relationship' => undef,
'auth_method' => 'password',
'B_state' => '',
'debarredcomment' => undef,
'lost' => 0,
'lang' => 'default',
'firstname' => 'Henry',
'privacy_guarantor_checkouts' => 0,
'sex' => 'F',
'contactnote' => '',
'date_renewed' => undef,
'B_streettype' => undef,
'B_city' => '',
'borrowernumber' => 19,
'altcontactzipcode' => '',
'streetnumber' => '',
'branchcode' => 'MPL',
'altcontactsurname' => '',
'state' => '',
'preferred_name' => 'Henry',
'secret' => undef,
'B_address2' => '',
'autorenew_checkouts' => 1,
'altcontactcountry' => ''
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'opacusercss' => undef,
'branchreplyto' => undef,
'branchcountry' => undef,
'branchzip' => undef,
'pickup_location' => 1,
'branchreturnpath' => undef,
'marcorgcode' => undef,
'branchip' => undef,
'branchfax' => undef,
'branchphone' => undef,
'branchaddress3' => undef,
'branchcity' => undef,
'branchcode' => 'CPL',
'geolocation' => undef,
'branchemail' => undef,
'branchurl' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchaddress2' => undef,
'issuing' => undef,
'opacuserjs' => undef,
'branchname' => 'Centerville',
'branchstate' => undef,
'branchnotes' => undef,
'public' => 1,
'branchillemail' => undef
};

plural: branches
$VAR1 = '';

overdues:
singular: overdue
$VAR1 = '';

plural: overdues
$VAR1 = [
{
'lastreneweddate' => undef,
'issuedate' => '2025-04-25 15:32:56',
'notedate' => undef,
'issuer_id' => undef,
'unseen_renewals' => 0,
'note' => undef,
'noteseen' => undef,
'borrowernumber' => 19,
'itemnumber' => 755,
'renewals_count' => 0,
'returndate' => undef,
'timestamp' => '2025-04-25 15:32:56',
'issue_id' => 11,
'date_due' => '2025-04-24 23:59:00',
'auto_renew' => 0,
'branchcode' => 'CPL',
'auto_renew_error' => undef,
'onsite_checkout' => 0,
'checkin_library' => undef
}
];

DUE

biblio:
singular: biblio
$VAR1 = {
'title' => 'E Street shuffle :',
'subtitle' => undef,
'frameworkcode' => 'BKS',
'notes' => undef,
'serial' => undef,
'abstract' => undef,
'copyrightdate' => 2012,
'unititle' => undef,
'seriestitle' => undef,
'author' => 'Heylin, Clinton.',
'part_name' => undef,
'part_number' => undef,
'timestamp' => '2020-04-21 09:38:27',
'datecreated' => '2014-05-07',
'biblionumber' => 344,
'medium' => undef
};

plural: biblios
$VAR1 = '';

biblioitems:
singular: biblioitem
$VAR1 = {
'url' => undef,
'pages' => '1 v. ;',
'publishercode' => 'Constable,',
'biblioitemnumber' => 344,
'cn_item' => undef,
'itemtype' => 'BK',
'biblionumber' => 344,
'collectionvolume' => undef,
'timestamp' => '2014-05-07 13:36:26',
'publicationyear' => undef,
'issn' => undef,
'editionresponsibility' => undef,
'volumedesc' => undef,
'ean' => undef,
'collectiontitle' => undef,
'cn_suffix' => undef,
'editionstatement' => undef,
'place' => 'London :',
'illus' => undef,
'cn_class' => undef,
'cn_source' => 'ddc',
'number' => undef,
'isbn' => '9781780335797 (hbk.) : | 1780335792 (hbk.) : | 9781780338682 (pbk.)',
'agerestriction' => undef,
'notes' => undef,
'totalissues' => undef,
'volume' => undef,
'volumedate' => undef,
'cn_sort' => '',
'lccn' => undef,
'collectionissn' => undef,
'size' => '20 cm.'
};

plural: biblioitems
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'middle_name' => '',
'initials' => '',
'cardnumber' => '23529000035676',
'autorenew_checkouts' => 1,
'B_streetnumber' => '',
'phonepro' => '',
'title' => '',
'lost' => 0,
'dateexpiry' => '2099-12-31',
'privacy_guarantor_checkouts' => 0,
'borrowernotes' => '',
'privacy_guarantor_fines' => 0,
'altcontactaddress1' => '',
'anonymized' => 0,
'primary_contact_method' => '',
'pronouns' => '',
'lang' => 'default',
'protected' => 0,
'altcontactaddress3' => '',
'smsalertnumber' => undef,
'mobile' => '',
'B_address2' => '',
'altcontactaddress2' => '',
'opacnote' => '',
'city' => 'Springfield, MA',
'B_address' => '',
'password' => '42b29d0771f3b7ef',
'altcontactcountry' => '',
'lastseen' => undef,
'zipcode' => '44224',
'B_city' => '',
'B_zipcode' => '',
'categorycode' => 'PT',
'password_expiration_date' => undef,
'date_renewed' => undef,
'streetnumber' => '',
'contacttitle' => undef,
'phone' => '(212) 555-1212',
'B_phone' => '',
'altcontactzipcode' => '',
'dateofbirth' => '1958-05-30',
'state' => '',
'B_state' => '',
'secret' => undef,
'B_country' => '',
'auth_method' => 'password',
'login_attempts' => 0,
'debarred' => undef,
'country' => '',
'altcontactsurname' => '',
'emailpro' => '',
'address' => '4345 Library Rd.',
'borrowernumber' => 19,
'surname' => 'Acevedo',
'B_streettype' => undef,
'dateenrolled' => '1990-09-23',
'address2' => '',
'othernames' => '',
'altcontactstate' => '',
'fax' => '',
'checkprevcheckout' => 'inherit',
'sms_provider_id' => undef,
'sort1' => '0.36460167669188',
'contactname' => '',
'privacy' => 1,
'relationship' => undef,
'altcontactphone' => '',
'preferred_name' => 'Henry',
'B_email' => '',
'debarredcomment' => undef,
'overdrive_auth_token' => undef,
'branchcode' => 'MPL',
'gonenoaddress' => 0,
'updated_on' => '2025-04-24 19:12:31',
'sex' => 'F',
'flags' => undef,
'firstname' => 'Henry',
'email' => 'a@a.a',
'userid' => '23529000035676',
'streettype' => undef,
'altcontactfirstname' => '',
'contactfirstname' => undef,
'sort2' => '0.33887459834933',
'contactnote' => ''
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchphone' => undef,
'branchemail' => undef,
'branchurl' => undef,
'branchip' => undef,
'branchillemail' => undef,
'geolocation' => undef,
'opacusercss' => undef,
'branchreplyto' => undef,
'branchreturnpath' => undef,
'public' => 1,
'branchfax' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchcountry' => undef,
'branchstate' => undef,
'branchzip' => undef,
'marcorgcode' => undef,
'branchaddress2' => undef,
'branchname' => 'Centerville',
'pickup_location' => 1,
'branchnotes' => undef,
'opacuserjs' => undef,
'branchcode' => 'CPL',
'branchaddress3' => undef,
'branchcity' => undef,
'issuing' => undef
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = {
'cn_sort' => '',
'homebranch' => 'CPL',
'datelastseen' => '2025-04-24 19:19:43',
'itemnotes' => undef,
'exclude_from_local_holds_priority' => undef,
'localuse' => undef,
'itemcallnumber' => undef,
'ccode' => 'REF',
'enumchron' => undef,
'itemnotes_nonpublic' => undef,
'stack' => undef,
'new_status' => undef,
'booksellerid' => undef,
'cn_source' => 'ddc',
'renewals' => 6,
'reserves' => undef,
'damaged_on' => undef,
'dateaccessioned' => '2014-09-04',
'holdingbranch' => 'CPL',
'bookable' => undef,
'replacementprice' => undef,
'price' => undef,
'replacementpricedate' => '2014-09-04',
'notforloan' => 0,
'itype' => 'BK',
'datelastborrowed' => '2025-04-24',
'biblionumber' => 344,
'itemnumber' => 755,
'barcode' => '111',
'issues' => 5,
'stocknumber' => undef,
'materials' => undef,
'uri' => undef,
'damaged' => 0,
'permanent_location' => 'GEN',
'restricted' => undef,
'copynumber' => undef,
'withdrawn_on' => undef,
'onloan' => '2025-04-25',
'biblioitemnumber' => 344,
'coded_location_qualifier' => undef,
'location' => 'GEN',
'withdrawn' => 0,
'deleted_on' => undef,
'more_subfields_xml' => undef,
'itemlost_on' => undef,
'timestamp' => '2025-04-25 12:01:20',
'itemlost' => 0
};

plural: items
$VAR1 = '';

issues:
singular: checkout
$VAR1 = {
'replacementpricedate' => '2014-09-04',
'seriestitle' => undef,
'price' => undef,
'replacementprice' => undef,
'bookable' => undef,
'medium' => undef,
'biblionumber' => 344,
'datelastborrowed' => '2025-04-24',
'part_name' => undef,
'itype' => 'BK',
'notforloan' => 0,
'damaged_on' => undef,
'reserves' => undef,
'branchcode' => 'CPL',
'holdingbranch' => 'CPL',
'dateaccessioned' => '2014-09-04',
'new_status' => undef,
'stack' => undef,
'enumchron' => undef,
'itemnotes_nonpublic' => undef,
'ccode' => 'REF',
'renewals' => 6,
'auto_renew_error' => undef,
'cn_source' => 'ddc',
'part_number' => undef,
'booksellerid' => undef,
'exclude_from_local_holds_priority' => undef,
'itemnotes' => undef,
'notes' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'checkin_library' => undef,
'borrowernumber' => 19,
'homebranch' => 'CPL',
'cn_sort' => '',
'itemcallnumber' => undef,
'localuse' => undef,
'itemlost_on' => undef,
'more_subfields_xml' => undef,
'deleted_on' => undef,
'withdrawn' => 0,
'location' => 'GEN',
'coded_location_qualifier' => undef,
'biblioitemnumber' => 344,
'unseen_renewals' => 0,
'author' => 'Heylin, Clinton.',
'itemlost' => 0,
'timestamp' => '2025-04-25 12:01:20',
'datecreated' => '2014-05-07',
'permanent_location' => 'GEN',
'copynumber' => undef,
'restricted' => undef,
'note' => undef,
'subtitle' => undef,
'damaged' => 0,
'notedate' => undef,
'onloan' => '2025-04-25',
'withdrawn_on' => undef,
'issues' => 5,
'unititle' => undef,
'issue_id' => 5,
'itemnumber' => 755,
'barcode' => '111',
'lastreneweddate' => '2025-04-25 12:01:20',
'uri' => undef,
'materials' => undef,
'issuer_id' => undef,
'renewals_count' => 2,
'stocknumber' => undef,
'auto_renew' => 0,
'title' => 'E Street shuffle :',
'issuedate' => '2025-04-24 19:19:43',
'onsite_checkout' => 0,
'frameworkcode' => 'BKS',
'returndate' => undef,
'abstract' => undef,
'copyrightdate' => 2012,
'serial' => undef,
'noteseen' => undef,
'date_due' => '2025-04-25 23:59:00'
};

plural: checkouts
$VAR1 = '';

DUEDGST

borrowers:
singular: borrower
$VAR1 = {
'country' => '',
'contactnote' => '',
'zipcode' => '44224',
'password_expiration_date' => undef,
'gonenoaddress' => 0,
'contactfirstname' => undef,
'lastseen' => undef,
'overdrive_auth_token' => undef,
'firstname' => 'Henry',
'altcontactstate' => '',
'secret' => undef,
'privacy_guarantor_checkouts' => 0,
'altcontactfirstname' => '',
'B_phone' => '',
'userid' => '23529000035676',
'B_state' => '',
'fax' => '',
'state' => '',
'flags' => undef,
'surname' => 'Acevedo',
'sort2' => '0.33887459834933',
'lang' => 'default',
'email' => 'a@a.a',
'address2' => '',
'B_address' => '',
'streetnumber' => '',
'B_zipcode' => '',
'phone' => '(212) 555-1212',
'relationship' => undef,
'date_renewed' => undef,
'debarred' => undef,
'B_email' => '',
'B_streettype' => undef,
'dateexpiry' => '2099-12-31',
'city' => 'Springfield, MA',
'sms_provider_id' => undef,
'altcontactaddress2' => '',
'borrowernumber' => 19,
'password' => '42b29d0771f3b7ef',
'lost' => 0,
'branchcode' => 'MPL',
'cardnumber' => '23529000035676',
'B_streetnumber' => '',
'initials' => '',
'altcontactzipcode' => '',
'altcontactsurname' => '',
'privacy_guarantor_fines' => 0,
'streettype' => undef,
'B_address2' => '',
'smsalertnumber' => undef,
'autorenew_checkouts' => 1,
'preferred_name' => 'Henry',
'othernames' => '',
'altcontactcountry' => '',
'anonymized' => 0,
'categorycode' => 'PT',
'mobile' => '',
'title' => '',
'login_attempts' => 0,
'dateofbirth' => '1958-05-30',
'updated_on' => '2025-04-24 19:12:31',
'opacnote' => '',
'address' => '4345 Library Rd.',
'pronouns' => '',
'contactname' => '',
'primary_contact_method' => '',
'altcontactaddress3' => '',
'B_country' => '',
'checkprevcheckout' => 'inherit',
'dateenrolled' => '1990-09-23',
'privacy' => 1,
'protected' => 0,
'borrowernotes' => '',
'altcontactphone' => '',
'auth_method' => 'password',
'B_city' => '',
'debarredcomment' => undef,
'emailpro' => '',
'altcontactaddress1' => '',
'middle_name' => '',
'sort1' => '0.36460167669188',
'sex' => 'F',
'phonepro' => '',
'contacttitle' => undef
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchreplyto' => undef,
'branchname' => 'Midway',
'issuing' => undef,
'branchillemail' => undef,
'geolocation' => undef,
'opacuserjs' => undef,
'opacusercss' => undef,
'branchnotes' => undef,
'marcorgcode' => undef,
'branchfax' => undef,
'branchip' => undef,
'branchaddress3' => undef,
'branchcode' => 'MPL',
'branchstate' => undef,
'pickup_location' => 1,
'branchcity' => undef,
'branchreturnpath' => undef,
'branchemail' => undef,
'branchcountry' => undef,
'branchurl' => undef,
'branchphone' => undef,
'branchaddress1' => '372 Forest Street',
'branchaddress2' => undef,
'branchzip' => undef,
'public' => 1
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = '';

plural: items
$VAR1 = [
{
'replacementpricedate' => '2014-09-04',
'itemlost_on' => undef,
'datelastborrowed' => '2025-04-24',
'replacementprice' => undef,
'damaged_on' => undef,
'uri' => undef,
'biblioitemnumber' => 344,
'biblionumber' => 344,
'renewals' => 6,
'itype' => 'BK',
'barcode' => '111',
'booksellerid' => undef,
'dateaccessioned' => '2014-09-04',
'exclude_from_local_holds_priority' => undef,
'cn_sort' => '',
'bookable' => undef,
'copynumber' => undef,
'timestamp' => '2025-04-25 12:01:20',
'onloan' => '2025-04-25',
'permanent_location' => 'GEN',
'withdrawn_on' => undef,
'holdingbranch' => 'CPL',
'itemnotes' => undef,
'new_status' => undef,
'itemlost' => 0,
'coded_location_qualifier' => undef,
'itemnotes_nonpublic' => undef,
'deleted_on' => undef,
'withdrawn' => 0,
'location' => 'GEN',
'issues' => 5,
'localuse' => undef,
'cn_source' => 'ddc',
'price' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'stocknumber' => undef,
'notforloan' => 0,
'materials' => undef,
'homebranch' => 'CPL',
'reserves' => undef,
'itemcallnumber' => undef,
'enumchron' => undef,
'damaged' => 0,
'itemnumber' => 755,
'more_subfields_xml' => undef,
'ccode' => 'REF',
'restricted' => undef,
'stack' => undef
}
];

issues:
singular: checkout
$VAR1 = '';

plural: checkouts
$VAR1 = [
{
'noteseen' => undef,
'abstract' => undef,
'branchcode' => 'CPL',
'seriestitle' => undef,
'datecreated' => '2014-05-07',
'notedate' => undef,
'checkin_library' => undef,
'borrowernumber' => 19,
'notforloan' => 0,
'materials' => undef,
'medium' => undef,
'returndate' => undef,
'localuse' => undef,
'issues' => 5,
'withdrawn' => 0,
'issue_id' => 5,
'location' => 'GEN',
'itemnotes_nonpublic' => undef,
'deleted_on' => undef,
'coded_location_qualifier' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'stocknumber' => undef,
'price' => undef,
'cn_source' => 'ddc',
'title' => 'E Street shuffle :',
'issuedate' => '2025-04-24 19:19:43',
'more_subfields_xml' => undef,
'note' => undef,
'itemnumber' => 755,
'stack' => undef,
'restricted' => undef,
'ccode' => 'REF',
'part_number' => undef,
'issuer_id' => undef,
'part_name' => undef,
'homebranch' => 'CPL',
'reserves' => undef,
'author' => 'Heylin, Clinton.',
'damaged' => 0,
'enumchron' => undef,
'itemcallnumber' => undef,
'renewals_count' => 2,
'itype' => 'BK',
'date_due' => '2025-04-25 23:59:00',
'exclude_from_local_holds_priority' => undef,
'barcode' => '111',
'booksellerid' => undef,
'onsite_checkout' => 0,
'dateaccessioned' => '2014-09-04',
'datelastborrowed' => '2025-04-24',
'replacementprice' => undef,
'replacementpricedate' => '2014-09-04',
'itemlost_on' => undef,
'serial' => undef,
'renewals' => 6,
'notes' => undef,
'uri' => undef,
'auto_renew_error' => undef,
'damaged_on' => undef,
'biblioitemnumber' => 344,
'biblionumber' => 344,
'itemlost' => 0,
'new_status' => undef,
'itemnotes' => undef,
'auto_renew' => 0,
'subtitle' => undef,
'holdingbranch' => 'CPL',
'frameworkcode' => 'BKS',
'copyrightdate' => 2012,
'lastreneweddate' => '2025-04-25 12:01:20',
'copynumber' => undef,
'bookable' => undef,
'timestamp' => '2025-04-25 12:01:20',
'cn_sort' => '',
'withdrawn_on' => undef,
'unseen_renewals' => 0,
'unititle' => undef,
'onloan' => '2025-04-25',
'permanent_location' => 'GEN'
}
];

PREDUE

biblio:
singular: biblio
$VAR1 = {
'part_number' => undef,
'datecreated' => '2014-05-07',
'timestamp' => '2020-04-21 09:38:27',
'notes' => undef,
'subtitle' => undef,
'part_name' => undef,
'biblionumber' => 344,
'copyrightdate' => 2012,
'author' => 'Heylin, Clinton.',
'medium' => undef,
'title' => 'E Street shuffle :',
'serial' => undef,
'seriestitle' => undef,
'frameworkcode' => 'BKS',
'unititle' => undef,
'abstract' => undef
};

plural: biblios
$VAR1 = '';

biblioitems:
singular: biblioitem
$VAR1 = {
'size' => '20 cm.',
'volumedesc' => undef,
'notes' => undef,
'cn_source' => 'ddc',
'publishercode' => 'Constable,',
'lccn' => undef,
'collectiontitle' => undef,
'volume' => undef,
'collectionvolume' => undef,
'totalissues' => undef,
'publicationyear' => undef,
'place' => 'London :',
'cn_sort' => '',
'ean' => undef,
'agerestriction' => undef,
'itemtype' => 'BK',
'cn_item' => undef,
'timestamp' => '2014-05-07 13:36:26',
'issn' => undef,
'editionstatement' => undef,
'biblioitemnumber' => 344,
'url' => undef,
'biblionumber' => 344,
'editionresponsibility' => undef,
'isbn' => '9781780335797 (hbk.) : | 1780335792 (hbk.) : | 9781780338682 (pbk.)',
'number' => undef,
'pages' => '1 v. ;',
'illus' => undef,
'volumedate' => undef,
'cn_suffix' => undef,
'collectionissn' => undef,
'cn_class' => undef
};

plural: biblioitems
$VAR1 = '';

borrowers:
singular: borrower
$VAR1 = {
'sort2' => '0.33887459834933',
'mobile' => '',
'smsalertnumber' => undef,
'lost' => 0,
'debarredcomment' => undef,
'B_state' => '',
'borrowernotes' => '',
'streetnumber' => '',
'email' => 'a@a.a',
'protected' => 0,
'address2' => '',
'privacy_guarantor_checkouts' => 0,
'B_country' => '',
'sort1' => '0.36460167669188',
'gonenoaddress' => 0,
'privacy' => 1,
'altcontactcountry' => '',
'B_streetnumber' => '',
'updated_on' => '2025-04-24 19:12:31',
'B_city' => '',
'secret' => undef,
'altcontactphone' => '',
'contactfirstname' => undef,
'B_address2' => '',
'title' => '',
'checkprevcheckout' => 'inherit',
'altcontactaddress3' => '',
'middle_name' => '',
'lastseen' => undef,
'fax' => '',
'auth_method' => 'password',
'borrowernumber' => 19,
'cardnumber' => '23529000035676',
'preferred_name' => 'Henry',
'state' => '',
'pronouns' => '',
'sex' => 'F',
'branchcode' => 'MPL',
'login_attempts' => 0,
'altcontactaddress1' => '',
'contactnote' => '',
'date_renewed' => undef,
'dateexpiry' => '2099-12-31',
'altcontactstate' => '',
'dateofbirth' => '1958-05-30',
'phonepro' => '',
'categorycode' => 'PT',
'flags' => undef,
'B_email' => '',
'altcontactsurname' => '',
'primary_contact_method' => '',
'altcontactzipcode' => '',
'zipcode' => '44224',
'othernames' => '',
'emailpro' => '',
'country' => '',
'streettype' => undef,
'opacnote' => '',
'surname' => 'Acevedo',
'userid' => '23529000035676',
'B_zipcode' => '',
'city' => 'Springfield, MA',
'firstname' => 'Henry',
'altcontactaddress2' => '',
'address' => '4345 Library Rd.',
'lang' => 'default',
'phone' => '(212) 555-1212',
'password_expiration_date' => undef,
'privacy_guarantor_fines' => 0,
'autorenew_checkouts' => 1,
'B_address' => '',
'altcontactfirstname' => '',
'dateenrolled' => '1990-09-23',
'contactname' => '',
'contacttitle' => undef,
'initials' => '',
'password' => '42b29d0771f3b7ef',
'B_phone' => '',
'overdrive_auth_token' => undef,
'debarred' => undef,
'relationship' => undef,
'anonymized' => 0,
'B_streettype' => undef,
'sms_provider_id' => undef
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchnotes' => undef,
'branchip' => undef,
'branchcountry' => undef,
'branchfax' => undef,
'opacuserjs' => undef,
'branchphone' => undef,
'opacusercss' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchname' => 'Centerville',
'branchillemail' => undef,
'branchzip' => undef,
'branchcity' => undef,
'branchaddress3' => undef,
'branchemail' => undef,
'marcorgcode' => undef,
'pickup_location' => 1,
'branchreturnpath' => undef,
'branchcode' => 'CPL',
'branchaddress2' => undef,
'branchurl' => undef,
'geolocation' => undef,
'branchstate' => undef,
'issuing' => undef,
'public' => 1,
'branchreplyto' => undef
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = {
'timestamp' => '2025-04-25 13:33:13',
'bookable' => undef,
'enumchron' => undef,
'uri' => undef,
'materials' => undef,
'location' => 'GEN',
'localuse' => undef,
'itemlost_on' => undef,
'copynumber' => undef,
'restricted' => undef,
'more_subfields_xml' => undef,
'stocknumber' => undef,
'notforloan' => 0,
'itemnotes_nonpublic' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'issues' => 5,
'itemnotes' => undef,
'homebranch' => 'CPL',
'cn_source' => 'ddc',
'price' => undef,
'holdingbranch' => 'CPL',
'damaged' => 0,
'renewals' => 8,
'exclude_from_local_holds_priority' => undef,
'itemcallnumber' => undef,
'ccode' => 'REF',
'replacementprice' => undef,
'biblioitemnumber' => 344,
'dateaccessioned' => '2014-09-04',
'withdrawn' => 0,
'permanent_location' => 'GEN',
'new_status' => undef,
'biblionumber' => 344,
'itemnumber' => 755,
'onloan' => '2025-04-26',
'damaged_on' => undef,
'itemlost' => 0,
'replacementpricedate' => '2014-09-04',
'deleted_on' => undef,
'stack' => undef,
'barcode' => '111',
'reserves' => undef,
'datelastborrowed' => '2025-04-24',
'itype' => 'BK',
'booksellerid' => undef,
'coded_location_qualifier' => undef,
'withdrawn_on' => undef,
'cn_sort' => ''
};

plural: items
$VAR1 = '';

issues:
singular: checkout
$VAR1 = {
'copyrightdate' => 2012,
'issuer_id' => undef,
'location' => 'GEN',
'localuse' => undef,
'itemlost_on' => undef,
'frameworkcode' => 'BKS',
'restricted' => undef,
'copynumber' => undef,
'notforloan' => 0,
'stocknumber' => undef,
'more_subfields_xml' => undef,
'date_due' => '2025-04-26 23:59:00',
'datecreated' => '2014-05-07',
'enumchron' => undef,
'timestamp' => '2025-04-25 13:33:13',
'bookable' => undef,
'subtitle' => undef,
'noteseen' => undef,
'uri' => undef,
'materials' => undef,
'part_name' => undef,
'price' => undef,
'author' => 'Heylin, Clinton.',
'holdingbranch' => 'CPL',
'seriestitle' => undef,
'auto_renew' => 0,
'unititle' => undef,
'notedate' => undef,
'renewals' => 8,
'damaged' => 0,
'itemnotes_nonpublic' => undef,
'checkin_library' => undef,
'auto_renew_error' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'issues' => 5,
'itemnotes' => undef,
'cn_source' => 'ddc',
'homebranch' => 'CPL',
'note' => undef,
'biblionumber' => 344,
'new_status' => undef,
'itemnumber' => 755,
'serial' => undef,
'title' => 'E Street shuffle :',
'medium' => undef,
'lastreneweddate' => '2025-04-25 13:33:13',
'abstract' => undef,
'borrowernumber' => 19,
'damaged_on' => undef,
'onloan' => '2025-04-26',
'returndate' => undef,
'exclude_from_local_holds_priority' => undef,
'itemcallnumber' => undef,
'branchcode' => 'CPL',
'issue_id' => 5,
'ccode' => 'REF',
'replacementprice' => undef,
'permanent_location' => 'GEN',
'dateaccessioned' => '2014-09-04',
'withdrawn' => 0,
'biblioitemnumber' => 344,
'deleted_on' => undef,
'stack' => undef,
'onsite_checkout' => 0,
'barcode' => '111',
'unseen_renewals' => 0,
'reserves' => undef,
'datelastborrowed' => '2025-04-24',
'itype' => 'BK',
'renewals_count' => 4,
'booksellerid' => undef,
'cn_sort' => '',
'withdrawn_on' => undef,
'coded_location_qualifier' => undef,
'part_number' => undef,
'itemlost' => 0,
'notes' => undef,
'issuedate' => '2025-04-24 19:19:43',
'replacementpricedate' => '2014-09-04'
};

plural: checkouts
$VAR1 = '';

PREDUEDGST

borrowers:
singular: borrower
$VAR1 = {
'altcontactzipcode' => '',
'email' => 'a@a.a',
'othernames' => '',
'privacy' => 1,
'pronouns' => '',
'lang' => 'default',
'B_country' => '',
'password_expiration_date' => undef,
'address2' => '',
'gonenoaddress' => 0,
'login_attempts' => 0,
'checkprevcheckout' => 'inherit',
'B_email' => '',
'B_city' => '',
'updated_on' => '2025-04-24 19:12:31',
'flags' => undef,
'contactfirstname' => undef,
'contactnote' => '',
'primary_contact_method' => '',
'dateexpiry' => '2099-12-31',
'overdrive_auth_token' => undef,
'sort1' => '0.36460167669188',
'borrowernotes' => '',
'contactname' => '',
'streettype' => undef,
'altcontactaddress2' => '',
'address' => '4345 Library Rd.',
'emailpro' => '',
'password' => '42b29d0771f3b7ef',
'privacy_guarantor_fines' => 0,
'protected' => 0,
'altcontactphone' => '',
'auth_method' => 'password',
'relationship' => undef,
'altcontactstate' => '',
'altcontactsurname' => '',
'streetnumber' => '',
'mobile' => '',
'anonymized' => 0,
'sort2' => '0.33887459834933',
'debarred' => undef,
'B_address2' => '',
'lastseen' => undef,
'secret' => undef,
'lost' => 0,
'altcontactcountry' => '',
'country' => '',
'middle_name' => '',
'firstname' => 'Henry',
'dateofbirth' => '1958-05-30',
'dateenrolled' => '1990-09-23',
'zipcode' => '44224',
'B_phone' => '',
'phone' => '(212) 555-1212',
'altcontactfirstname' => '',
'altcontactaddress1' => '',
'preferred_name' => 'Henry',
'privacy_guarantor_checkouts' => 0,
'state' => '',
'sms_provider_id' => undef,
'date_renewed' => undef,
'B_address' => '',
'title' => '',
'borrowernumber' => 19,
'cardnumber' => '23529000035676',
'userid' => '23529000035676',
'altcontactaddress3' => '',
'B_streettype' => undef,
'city' => 'Springfield, MA',
'fax' => '',
'branchcode' => 'MPL',
'initials' => '',
'sex' => 'F',
'categorycode' => 'PT',
'B_zipcode' => '',
'debarredcomment' => undef,
'smsalertnumber' => undef,
'autorenew_checkouts' => 1,
'B_streetnumber' => '',
'surname' => 'Acevedo',
'phonepro' => '',
'opacnote' => '',
'B_state' => '',
'contacttitle' => undef
};

plural: borrowers
$VAR1 = '';

branches:
singular: branch
$VAR1 = {
'branchname' => 'Midway',
'branchaddress3' => undef,
'public' => 1,
'geolocation' => undef,
'branchreplyto' => undef,
'branchillemail' => undef,
'opacusercss' => undef,
'branchstate' => undef,
'branchip' => undef,
'branchemail' => undef,
'branchnotes' => undef,
'marcorgcode' => undef,
'branchcity' => undef,
'branchphone' => undef,
'branchcode' => 'MPL',
'opacuserjs' => undef,
'branchreturnpath' => undef,
'branchfax' => undef,
'branchurl' => undef,
'branchzip' => undef,
'branchaddress2' => undef,
'branchcountry' => undef,
'issuing' => undef,
'pickup_location' => 1,
'branchaddress1' => '372 Forest Street'
};

plural: branches
$VAR1 = '';

items:
singular: item
$VAR1 = '';

plural: items
$VAR1 = [
{
'notforloan' => 0,
'booksellerid' => undef,
'dateaccessioned' => '2014-09-04',
'more_subfields_xml' => undef,
'withdrawn_on' => undef,
'datelastseen' => '2025-04-24 19:19:43',
'homebranch' => 'CPL',
'damaged' => 0,
'restricted' => undef,
'price' => undef,
'stocknumber' => undef,
'ccode' => 'REF',
'itemnotes' => undef,
'enumchron' => undef,
'coded_location_qualifier' => undef,
'itemcallnumber' => undef,
'renewals' => 8,
'copynumber' => undef,
'bookable' => undef,
'exclude_from_local_holds_priority' => undef,
'damaged_on' => undef,
'uri' => undef,
'biblioitemnumber' => 344,
'materials' => undef,
'withdrawn' => 0,
'cn_sort' => '',
'onloan' => '2025-04-26',
'holdingbranch' => 'CPL',
'new_status' => undef,
'issues' => 5,
'itype' => 'BK',
'timestamp' => '2025-04-25 13:33:13',
'stack' => undef,
'itemnotes_nonpublic' => undef,
'itemlost_on' => undef,
'replacementprice' => undef,
'location' => 'GEN',
'reserves' => undef,
'itemlost' => 0,
'itemnumber' => 755,
'replacementpricedate' => '2014-09-04',
'barcode' => '111',
'cn_source' => 'ddc',
'deleted_on' => undef,
'localuse' => undef,
'biblionumber' => 344,
'permanent_location' => 'GEN',
'datelastborrowed' => '2025-04-24'
}
];

issues:
singular: checkout
$VAR1 = '';

plural: checkouts
$VAR1 = [
{
'withdrawn' => 0,
'lastreneweddate' => '2025-04-25 13:33:13',
'biblioitemnumber' => 344,
'materials' => undef,
'onloan' => '2025-04-26',
'noteseen' => undef,
'cn_sort' => '',
'new_status' => undef,
'issues' => 5,
'holdingbranch' => 'CPL',
'subtitle' => undef,
'notedate' => undef,
'auto_renew_error' => undef,
'abstract' => undef,
'branchcode' => 'CPL',
'damaged_on' => undef,
'author' => 'Heylin, Clinton.',
'uri' => undef,
'title' => 'E Street shuffle :',
'renewals_count' => 4,
'borrowernumber' => 19,
'copyrightdate' => 2012,
'issuer_id' => undef,
'deleted_on' => undef,
'checkin_library' => undef,
'cn_source' => 'ddc',
'date_due' => '2025-04-26 23:59:00',
'biblionumber' => 344,
'permanent_location' => 'GEN',
'localuse' => undef,
'seriestitle' => undef,
'datelastborrowed' => '2025-04-24',
'serial' => undef,
'notes' => undef,
'stack' => undef,
'timestamp' => '2025-04-25 13:33:13',
'note' => undef,
'itype' => 'BK',
'itemnotes_nonpublic' => undef,
'itemlost_on' => undef,
'replacementprice' => undef,
'reserves' => undef,
'location' => 'GEN',
'unseen_renewals' => 0,
'replacementpricedate' => '2014-09-04',
'itemlost' => 0,
'itemnumber' => 755,
'barcode' => '111',
'auto_renew' => 0,
'more_subfields_xml' => undef,
'part_name' => undef,
'part_number' => undef,
'withdrawn_on' => undef,
'damaged' => 0,
'frameworkcode' => 'BKS',
'datelastseen' => '2025-04-24 19:19:43',
'homebranch' => 'CPL',
'notforloan' => 0,
'booksellerid' => undef,
'onsite_checkout' => 0,
'returndate' => undef,
'dateaccessioned' => '2014-09-04',
'datecreated' => '2014-05-07',
'coded_location_qualifier' => undef,
'enumchron' => undef,
'itemcallnumber' => undef,
'medium' => undef,
'copynumber' => undef,
'renewals' => 8,
'exclude_from_local_holds_priority' => undef,
'bookable' => undef,
'restricted' => undef,
'price' => undef,
'ccode' => 'REF',
'stocknumber' => undef,
'itemnotes' => undef,
'issue_id' => 5,
'unititle' => undef,
'issuedate' => '2025-04-24 19:19:43'
}
];

ISSUEQSLIP


Info
borrowers:
singular:
borrower
$VAR1 = {
'preferred_name' => undef,
'primary_contact_method' => undef,
'sms_provider_id' => undef,
'surname' => 'koha',
'B_state' => undef,
'email' => undef,
'phone' => undef,
'B_city' => undef,
'B_streetnumber' => undef,
'auth_method' => 'password',
'altcontactaddress1' => undef,
'updated_on' => '2025-08-05 17:16:23',
'categorycode' => 'S',
'contactname' => undef,
'password' => 'x,
'B_phone' => undef,
'zipcode' => undef,
'altcontactstate' => undef, 'lost' => undef, 'address2' => undef, 'cardnumber' => '42', 'B_streettype' => undef, 'B_address2' => undef, 'firstname' => undef, 'B_country' => undef, 'lang' => 'default', 'secret' => undef, 'mobile' => undef, 'privacy_guarantor_checkouts' => 0, 'gonenoaddress' => undef, 'B_zipcode' => undef, 'userid' => 'koha', 'B_address' => undef, 'contactnote' => undef, 'opacnote' => '', 'privacy' => 1, 'altcontactphone' => undef, 'sort1' => undef, 'altcontactcountry' => undef, 'lastseen' => undef, 'branchcode' => 'CPL', 'overdrive_auth_token' => undef, 'smsalertnumber' => undef, 'sex' => undef, 'contacttitle' => undef, 'login_attempts' => 0, 'altcontactaddress3' => undef, 'debarredcomment' => undef, 'B_email' => undef, 'address' => undef, 'dateexpiry' => '2033-11-05', 'title' => undef, 'date_renewed' => undef, 'protected' => 0, 'altcontactzipcode' => undef, 'city' => undef, 'anonymized' => 0, 'flags' => 1, 'othernames' => undef, 'checkprevcheckout' => 'inherit', 'dateenrolled' => '2025-08-05', 'phonepro' => undef, 'emailpro' => undef, 'pronouns' => undef, 'fax' => undef, 'altcontactfirstname' => undef, 'altcontactaddress2' => undef, 'middle_name' => undef, 'dateofbirth' => undef, 'streetnumber' => undef, 'borrowernumber' => 51, 'contactfirstname' => undef, 'altcontactsurname' => undef, 'privacy_guarantor_fines' => 0, 'state' => undef, 'country' => undef, 'streettype' => undef, 'autorenew_checkouts' => 1, 'relationship' => undef, 'initials' => undef, 'borrowernotes' => '', 'sort2' => undef, 'debarred' => undef, 'password_expiration_date' => undef }; plural: borrowers $VAR1 = ''; branches: singular: branch $VAR1 = { 'branchnotes' => undef, 'pickup_location' => 1, 'branchstate' => undef, 'branchurl' => undef, 'branchillemail' => undef, 'issuing' => undef, 'branchaddress2' => undef, 'branchphone' => undef, 'branchcode' => 'CPL', 'opacusercss' => undef, 'branchaddress1' => 'Jefferson Summit', 'branchname' => 'Centerville', 'opacuserjs' => undef, 'branchaddress3' => undef, 'branchcity' => undef, 'branchemail' => undef,
'branchzip' => undef,
'branchfax' => undef,
'marcorgcode' => undef,
'geolocation' => undef,
'public' => 1,
'branchreturnpath' => undef,
'branchip' => undef,
'branchreplyto' => undef,
'branchcountry' => undef
 };

plural:
branches
$VAR1 = '';

issues:
singular:
checkout
$VAR1 = '';

plural:
checkouts
$VAR1 = []; 

CHECKOUT

Info
biblio:
singular: biblio
$VAR1 = {
'author' => 'Tyler, chris',
'opac_suppressed' => 0,
'seriestitle' => undef,
'subtitle' => undef,
'medium' => undef,
'title' => 'X Power Tools',
'timestamp' => '2020-01-29 12:06:37',
'part_number' => undef,
'copyrightdate' => undef,
'datecreated' => '2014-05-07',
'notes' => undef,
'abstract' => undef,
'unititle' => undef,
'serial' => undef,
'biblionumber' => 6,
'frameworkcode' => 'BKS',
'part_name' => undef
};

plural: biblios
$VAR1 = '';


biblioitems:
singular: biblioitem
$VAR1 = {
'biblioitemnumber' => 6,
'editionresponsibility' => undef,
'biblionumber' => 6,
'url' => undef,
'illus' => undef,
'size' => undef,
'publishercode' => undef,
'volume' => undef,
'totalissues' => undef,
'pages' => undef,
'cn_source' => undef,
'itemtype' => 'BK',
'timestamp' => '2020-01-29 12:06:37',
'isbn' => '9780596101954',
'agerestriction' => undef,
'notes' => undef,
'lccn' => undef,
'collectionvolume' => undef,
'cn_sort' => '',
'issn' => undef,
'volumedate' => undef,
'cn_item' => undef,
'collectiontitle' => undef,
'ean' => undef,
'cn_class' => undef,
'editionstatement' => undef,
'collectionissn' => undef,
'volumedesc' => undef,
'publicationyear' => undef,
'number' => undef,
'cn_suffix' => undef,
'place' => undef
};

plural: biblioitems
$VAR1 = '';



borrowers:
singular: borrower
$VAR1 = {
'overdrive_auth_token' => undef,
'B_streetnumber' => '',
'B_country' => '',
'login_attempts' => 0,
'smsalertnumber' => undef,
'contacttitle' => undef,
'altcontactaddress2' => '',
'debarredcomment' => undef,
'B_address' => '',
'password_expiration_date' => undef,
'B_streettype' => undef,
'B_phone' => '',
'gonenoaddress' => 0,
'contactfirstname' => undef,
'anonymized' => 0,
'secret' => undef,
'contactname' => '',
'mobile' => '',
'lang' => 'default',
'emailpro' => '',
'address' => '4345 Library Rd.',
'pronouns' => '',
'title' => '',
'contactnote' => '',
'protected' => 0,
'branchcode' => 'CPL',
'sms_provider_id' => undef,
'checkprevcheckout' => 'inherit',
'B_state' => '',
'sex' => 'F',
'email' => 'lisette@bywatersolutions.com',
'privacy' => 1,
'sort2' => '0.33887459834933',
'preferred_name' => 'Henry',
'altcontactstate' => '',
'fax' => '',
'lost' => 0,
'privacy_guarantor_checkouts' => 0,
'B_zipcode' => '',
'userid' => '23529000035676',
'auth_method' => 'password',
'dateofbirth' => '1958-05-30',
'altcontactphone' => '',
'othernames' => '',
'dateexpiry' => '2099-12-31',
'phonepro' => '',
'flags' => undef,
'country' => '',
'date_renewed' => undef,
'cardnumber' => '23529000035676',
'initials' => '',
'phone' => '(212) 555-1212',
'updated_on' => '2025-10-16 15:02:46',
'sort1' => '0.36460167669188',
'altcontactaddress3' => '',
'privacy_guarantor_fines' => 0,
'altcontactaddress1' => '',
'relationship' => undef,
'altcontactsurname' => '',
'state' => '',
'altcontactcountry' => '',
'debarred' => undef,
'borrowernotes' => '',
'middle_name' => '',
'borrowernumber' => 19,
'categorycode' => 'S',
'B_email' => '',
'B_address2' => '',
'city' => 'Springfield, MA',
'firstname' => 'Henry',
'altcontactzipcode' => '',
'B_city' => '',
'zipcode' => '44224',
'autorenew_checkouts' => 1,
'password' => '42b29d0771f3b7ef',
'surname' => 'Acevedo',
'streettype' => undef,
'primary_contact_method' => '',
'opacnote' => '',
'lastseen' => undef,
'address2' => '',
'dateenrolled' => '1990-09-23',
'altcontactfirstname' => '',
'streetnumber' => ''
};

plural: borrowers
$VAR1 = '';



branches:
singular: branch
$VAR1 = {
'branchzip' => undef,
'branchphone' => undef,
'branchstate' => undef,
'geolocation' => undef,
'branchillemail' => undef,
'branchemail' => undef,
'branchreplyto' => undef,
'branchaddress3' => undef,
'issuing' => undef,
'branchfax' => undef,
'pickup_location' => 1,
'branchurl' => undef,
'branchaddress1' => 'Jefferson Summit',
'branchaddress2' => undef,
'opacuserjs' => undef,
'branchreturnpath' => undef,
'branchnotes' => undef,
'branchcountry' => undef,
'marcorgcode' => undef,
'branchcity' => undef,
'opacusercss' => undef,
'branchname' => 'Centerville',
'branchcode' => 'CPL',
'public' => 1,
'branchip' => undef
};

plural: branches
$VAR1 = '';



items:
singular: item
$VAR1 = {
'location' => 'GEN',
'dateaccessioned' => '2014-09-04',
'itemnumber' => 20,
'homebranch' => 'CPL',
'replacementprice' => undef,
'renewals' => undef,
'deleted_on' => undef,
'barcode' => '39999000000252',
'biblionumber' => 6,
'materials' => undef,
'itemnotes' => undef,
'issues' => 2,
'new_status' => undef,
'itemlost_on' => undef,
'restricted' => undef,
'withdrawn_on' => undef,
'holdingbranch' => 'CPL',
'cn_sort' => '_',
'stack' => undef,
'datelastborrowed' => '2025-10-16',
'enumchron' => undef,
'ccode' => 'REF',
'replacementpricedate' => '2014-09-04',
'damaged_on' => undef,
'damaged' => 0,
'itemlost' => 0,
'datelastseen' => '2025-10-16 15:05:10',
'bookable' => undef,
'coded_location_qualifier' => undef,
'price' => undef,
'itype' => 'BK',
'localuse' => undef,
'permanent_location' => 'GEN',
'booksellerid' => undef,
'notforloan' => 0,
'withdrawn' => 0,
'copynumber' => undef,
'biblioitemnumber' => 6,
'exclude_from_local_holds_priority' => undef,
'itemcallnumber' => undef,
'reserves' => undef,
'stocknumber' => undef,
'uri' => undef,
'onloan' => '2025-10-21',
'timestamp' => '2025-10-16 15:05:10',
'more_subfields_xml' => undef,
'itemnotes_nonpublic' => undef,
'cn_source' => undef
};

plural: items
$VAR1 = '';



issues:
singular: checkout
$VAR1 = {
'checkin_library' => undef,
'notedate' => undef,
'auto_renew_error' => undef,
'lastreneweddate' => undef,
'issue_id' => 3,
'itemnumber' => 20,
'note' => undef,
'timestamp' => '2025-10-16 15:05:10',
'unseen_renewals' => 0,
'auto_renew' => 0,
'booking_id' => undef,
'branchcode' => 'CPL',
'onsite_checkout' => 0,
'returndate' => undef,
'noteseen' => undef,
'borrowernumber' => 19,
'issuer_id' => undef,
'date_due' => '2025-10-21 23:59:00',
'issuedate' => '2025-10-16 15:05:10',
'renewals_count' => 0
};

plural: checkouts
$VAR1 = '';

A note about the advance_notices.pl cronjob

The DUE, DUEDGST, PREDUE, and PREDUEDGST notices are all generated via the advance_notices.pl cronjob. In the above examples, these notices show significantly more data under the checkout/checkouts label than other notices do. The advance_notices cron does not actually pass a checkout object to Koha. Instead, it passes a hash of data containing the an assortment of data about the checkout, item, and biblio. This does not impact the basic notation required to insert these values into a notice, but does make some advanced features unavailable. 

    • Related Articles

    • Overview: Courtesy and Overdue Notices in Koha

      This article reviews configuration and settings for Koha's courtesy and overdue notices. It is meant as an overview for libraries in implementation or for any library who is new to using these notices. Note that there are many more notices and slips ...
    • Notices in Koha

      Notices are a powerful way to communicate with patrons about their checked-out materials, holds, renewals, etc. Koha has many options for customizing the notices and customizing how they are delivered, both through settings configuration and through ...
    • Koha Glossary of Terms

      Find the basics of Koha's vocabulary here This glossary is in alphabetical order. Use control+F to quickly search this page for specific terms. Authority Record: allows your library to control and search fields in your MARC records such as subject ...
    • Tips for a successful data migration

      During your migration to Koha, diving deep into your data is one of the most crucial aspects of the process, and there are three things we'd like our onboarding partners to keep in mind: First and foremost, think about patron experience. Streamlining ...
    • Patron Point and Koha - Library Setup

      How does it work? Patron Point can send email, SMS, and/or phone messages. Similar to SIP users, an API patron/user allows third party integrations such as Patron Point to connect to Koha. The API patron will have permissions that allow it to ...