Search Results for: patron record

Materials Booking and your patrons

Once you have identified and made your items bookable, you now need to Book ’em!  Materials booking will be introduced as a staff-assisted process for the immediate future, however in time we may make it available to patrons in the catalog.  

Booking will need to be turned on for your library and staff will need to have the authorization also.  Once in place, you will see the Materials Booking tab in the patron record, and also in the item.  Like holds, you can place a booking from the patron record or the item record.  Our materials will be booked at the item level.  

Checking out booked items is done in the same way as a regular circulating item from the patron record in circulation desk mode.  You will be asked to confirm the booking end date as the due date.  Booked item defaults go directly to billed status on the day after they are due and the price in the item is used for the billing amount.

Add a booking from a patron record

  1. Select the Materials booking tab
  2. Select add booking
  3. Search to find the item you wish to book.
  4. Choose Book item
  5. Fill in the form with an event name (ex: 3 day booking), the default booking defined in the loan rule will be applied, but you may change it.
  6. Add your library as the pickup loc (3 letter code)
  7. Add Optional note
  8. Save

Add a booking from the item

  1. Locate your bookable item
  2. Click Book Selected item(s)
  3. Scan your patron barcode or search for them by name.
  4. Enter event text (ex: 3 day booking)
  5. Enter date ranges & add any notes
  6. Select your library as the pickup location
  7. Enter optional note
  8. Save

Booking from a patron record

Locate your bookable item

Select the item(s) and choose “Book Selected Item(s)

Complete the booking form:
Event: Describes the Booking event.  You will want to define local event names to help you to manage groupings for locating and statistical purposes.
Example: Summer Reading – 7 day booking
Dates (wanted from and to): The range that the booking is needed for (it will be defined by default, once you pick a start date, but you may edit it).
Repeat Booking (Optional) if your booking will repeat it can be set up in advance
Booking Note: (Optional) This is a local note to be used internally or to provide information verbally to the patron.
Pickup Location: Your location – right now booking is limited to your stuff being picked up at your location. 

Booking from the item record.

Filling a Booking

Similar to filling holds, you will look to see what you have booked that needs to be readied for pick up.  Each day you run list of items for that day and the next (or you can edit that range).   Print the slips for the selected items.  They should be made ready for pickup and placed on the holdshelf or in your specified place.

Cancelled and expired bookings can be removed from the shelf.

Serials – Holdings Records

While the traditional text holdings statements are enough for most libraries, it is also possible to configure the Serials module to let your patrons know exactly which issues you have.

You will do this by setting up the Holdings for your subscription

To begin, open the Card for your periodical subscription –

On the  left had side of the screen, there are six tabs. Along with the Card tab is one for Holdings

With no issues currently checked in, there is nothing to display in the Holdings window.

Before checking in the first issue, update the Card so that the check box Update Holdings? is checked. With this box checked, the Update Holdings? box on the Card screen will be checked as well.

When an issue is Checked In, the Card is updated to reflect that the Issue has Arrived.

When the Issue is Checked In, as long as the Update Holdings? box is checked, 

The Holdings tab display will reflect the issues the library owns.

When additional issues are Checked In, Sierra will update the Holdings display automatically.

The Holdings display will even correctly reflect when a Volume of Issues has bee received and a new Volume begins.

Sometimes an Issue will not have arrived before you receive the following issue – you may Check In Issue 3 before Issue 2 has arrived. When this happens, there is a Gap in your library’s Holdings.

Sierra will recognize this Gap and your Holdings will reflect this Gap accordingly.

But the previously missing Issue may arrive eventually and you will check it in,

When you Check In this issue, there is no longer a Gap in your Holdings and Sierra will update the Holdings display to close the Gap.

With the Holdings updated for your subscription, your patrons will know exactly which issues your library owns –

When patrons search for a periodical,

The Holdings for your library will display,

Showing both the latest issue you have received as well as the range of all the issues housed in your library.

Patron Images

Description: If your library chooses to use the Internal Patron Images feature, you can capture patron photographs of your patrons and display them in patron records.

Impact: By choosing to enable the Show patron photo option for staff members’ Sierra logins, library staff will be able to view and/or take patron photographs to be stored in patron records. These photographs can provide another level of security for the patron’s account.

If your library chooses to use the Patron Images feature, and you have access to a camera, you can take a patron’s photograph, which will be displayed in the Patron Record. Sierra will display the patron’s photograph in the patron display window.*

The Patron Images feature will be displayed from the Circulation Desk function as well as the Inter-Library Loan function. 

*If there is no photograph associated with the Patron’s Record, Sierra will display the photograph area as blank.

Item Record – All Fields Explained

All Fields Explained:

“Not Checked Out” (font at top of record): This area tells you the status of the item (checked out, checked in, missing, etc.)

COPY #: How many copies there are.

ICODE1: Content of material.

ANNUAL RPT: Annual Report category.

I TYPE: Format and hold rule.

PRICE: Amount to be charged if lost.

OUT DATE: Date check out.

OUT LOC: Where the item was checked out.

DUE DATE: Date due back.

PATRON#:  Patron who has item.**

LPATRON: Previous patron who had item.**

LCHKIN: Date item was last checked in.

INVDA: Inventory date.

IN LOC: Terminal where the item was checked in.

# RENEWALS: Number of renewals.

 #OVDNOTICE: Number of overdue notices sent.

ODUE DATE: Date of overdue notice.

IUSE3: Internal use counter.

RECAL DATE: Not used.

TOT CHKOUT: Total checkouts for this item (includes GEAC stats).

TOT RENEW: Total renewals for this item (includes GEAC stats).

LOUTDATE: Previous out date.

LOCATION: Owning library.

LOANRULE: Loan period.

STATUS: Availability of item.

INTL USE: Internal use counter.

COPY USE: Internal use counter. IMESSAGE Internal message.

OPACMSG: Not used.

YTD CIRC: Circs this year.

LYRCIRC: Last years circ.

AGENCY: Not used.

CALL #: Call # of item at specific location.

AT KEY: Not used.

BARCODE: Barcode of individual item.

INT NOTE: Internal note.

GEAC L CIR:C Data used in migration only.

OLD SCAT: Migrated from GEAC.

**Double click on this will bring up patron information

List Patrons

  1. Find and highlight an empty review file and click Search Records.
  2. Name the Review File
  3. Range will remain as it is and nothing will be entered in the start and stop fields.  This means that your search will be done over the entire patron record set in Sierra, from the first record p10000008 through whatever the last patron created, which is the number populated in the stop field.
    Note: This is different than when you search for items, because with items you can be certain of the barcode prefix, and change from the entire range of records to search by index of barcode, where you would include the first 5 digits of your barcode in the “start” and “stop”.
  4. Your search will be:

Type=Patron

Field=PTYPE

Condition = equal to

Value = YOUR Ptype – which will display as the code number in the completed search

Below is an example for the Kingston Library, whose PTYPE is 40.

Item Record – All Fields Explained

Descriptions of fields listed in the table below the image.

All Fields Explained:

**Double click on this will bring up patron information.

AGENCY, AT KEY, OPACMSG, and RECAL DATE Not used.

Patrons added

From Create Lists create a query of patrons added to your library within the last three months.

Find an empty Review File and click on the search Records button. The Query box will open. Set the Record Type to Patron, since those are the types of records you are requesting.

Leave Range set as it is (to search the broadest set of records possible) and start to build your query.

Limit to your patrons by limiting to patrons whose P Type is your library. With your library set, click on Append Line to add another criteria to your query –

The way to restrict to recently added patron is to limit by patron records created within a certain date range.

Type: Patron

Field: Created

Condition: Between

Value A: Start date

Value B: Current date

You could also set the Condition to Greater than and set Value A to a previous date. This will provide a list of patrons added to your library between that date and when you are running the report.

This is as much query as you will need to gather the information you want. Give the query a Name and click on Search to submit your query.

The report will run and retrieve the records that meet your search criteria. This will give you a total number of new patrons added, to work with those records you will want to Export the records to a spreadsheet.

Generate a list of Patrons whose accounts Are Delinquent

From Create Lists create a query of patrons whose library cards are delinquent, based on a set dollar amount as a threshold.

Find an empty Review File and click on the search Records button. The Query box will open. Set the Record Type to Patron, since those are the types of records you are requesting.

Leave Range set as it is (to search the broadest set of records possible) and start to build your query.

Limit your search to patrons whose home library is your library. With your library set, click on Append Line to add another criteria to your query –

In the second line of your query, input the following criterea:

Type: Patron

Field: Money Owed

Condition: greater than or equal to

Value A: $25

You may want to limit by additional criterea, such as Billed Status or for patrons who were billed more than 30 days ago.

To limit by items that were billed more than 30 days ago:

Type: Item

Field: ODUE DATE

Condition: Less than or equal to

Value A: Today’s date minus 30 days

This query is all you will need to gather the information you want. Give the query a Name and click on Search to submit your query.

The report will run and retrieve the records that meet your search criteria. This will give you a total number of new patrons who owe $25 or more and whose items have been billed. To work with those records you will want to Export the records to a spreadsheet.

Generate a count of Patrons with a circ active date within the last month

From Create Lists, you can create a report of patrons who have used the library within the last month. You will want to run this report as close to the beginning of the month as possible to retrieve an accurate count.

Find an empty Review File and click on the search Records button. The Query box will open. Set the Record Type to Patron, since those are the types of records you are requesting.

Leave Range set as it is (to search the broadest set of records possible) and start to build your query.

For the first line in your query, establish the patrons to those whose P Type represents your library, meaning your patrons.

You will only need one other line in your query, to determine that the patrons have used their library card within the last month. To do this use the CIRCACTIVE field

For Condition, use greater than, enter the date of the first day for the previous month. Leave Value B blank.

Search Records.

When the search finishes running, the number in the Current Records field will represent the number of patrons with a circ active date within the last month.