Search Results for: patron record

Create a List of Online Registration Patron Records

 Searching for new online registrations in Create List:

  1. In an empty Review File, set store record type as “Patron p”.
  2. Leave the “Range” index setting in place.
  3. Use the following search strategy:
    • Line 1:  Type=Patron, Field=Created,  Condition=Between, Value A = the start of your date Range, and Value B= the end of your date range
    • Line 2: Type= Patron,  Field = Stat Class, Condition= The stat class value assigned in your template*
      *The number assigned uses a 0 in place of the asterisk in the terminal number
  4.  Click Search.

Reviewing Online Registration Patron Records

Remote/Patron Self-Registration Policy
[Resource Sharing Standards]

Staff shall review records that have been created online within 30 days for accuracy and duplicate records. The record will be considered temporary until verified by staff.  Records that have not been verified to meet previously stated registration policy or merged with an existing record within 30 days will be expired.

A verified record must include the library code and initials of who verified it and the date of verification.  The records must be reviewed within 30 days of the created date.

Remote/Patron Self-Registration Review Procedures

New Record Alerts: There are 2 ways to be alerted that new registrations have been completed.

  1. An email notification is sent by Sierra and forwarded by Mid-Hudson staff to a designated staff member of the library.  The notices are sent only on weekdays.  The notice includes only the name, and barcode (pnumber) of the registrant.  A separate notice is sent for each completed registration.  
  2. Create lists can be used to retrieve records to be reviewed in batches.

 Searching for new online registrations in Create List:

  1. In an empty Review File, set store record type as “Patron p”.
  2. Leave the “Range” index setting in place.
  3. Use the following search strategy:
    • Line 1:  Type=Patron, Field=Created,  Condition=Between, Value A = the start of your date Range, and Value B= the end of your date range
    • Line 2: Type= Patron,  Field = Stat Class, Condition= The stat class value assigned in your template*
      *The number assigned uses a 0 in place of the asterisk in the terminal number
  4.  Click Search.

Record Review and Necessary Edits

Libraries with online registration will review all patron records created through their form within 30 days to determine that someone is eligible. Staff completely and accurately fills in all required fields and checks Sierra to determine if a record already exists. Staff verifies home library and notifies home library when appropriate. Follow local procedure to issue a 14 – digit barcode.~RS Standards

  1. Is this your record?
    If this patron resides within another libraries service area, edit the home ptype and home library to reflect your best estimate of where the patron resides and send that library an email with identifying information or a screen capture.  They will be responsible for this record’s review or pass the record to another library.
  2. Check for duplicates
    1. Check to see if a record for this patron already exists using the name, birth date and other information in the new registration.  A second sierra session is helpful in this process.
    2. If a duplicate record exists.  Determine which of the records is the more complete and valid version.  This will become the Destination record in the merger process.   If the records are comparable, the activity on the record can be used to determine the Destination Record.  Recent activity will be indicated in the CIRCACTIVE field.   The record that is less complete or not recently used will become the Source record in the merge process.Merge Record Instructions.

      At this point you will be working with a new Patron.

  3. Insert and Create the APATID:  The Online form cannot produce an APATID (a patron ID) the review process includes creating the APATID.
    1. Click Insert field and scroll to find the APATID Field.
    2. Create the APATID as follows:
      The APATID is created from the first 4 letters of the Patron’s Last Name (if last name does not have 4 letters insert an “*” for each missing letter), followed by the first letter of their first name and then the single digit of their birth month followed by the two digits to indicate the day of the month. For October use the Letter O, for November use the letter N and For December use the letter D. The APATID IS TYPED IN UPPER CASE. This field is necessary to check for duplicate records.

      Example: Smith, John, born 7/04/1976 APATID = SMITJ704
      NOTE: To search by APATID, type the letter “u” before the APATID in the search box type “uSMITJ704” , and press enter.

  4. Review Record Content
    • Records should include all required fields according to Resource Sharing standards.  The form required fields and template defaults should have produced a complete record, but staff should verify.  
    • Check for corrections in formatting, Alphabetizing and spelling.
  5. Update the Created by field
    • You will add your libraries 3 letter code and your initials
    • Check with your director for your local policy on how this statement is formed.
  6. Complete the local procedures
    • Check with your library administration to review local procedures in place for updating message and note fields.

Patron Record – All Fields Explained

To view a complete Patron’s Record: View>Patron – Refer to the table below for descriptions of fields.

To Edit a Patron’s Record:

Enter the “Check Out (Circulation Desk)” Function in Sierra and scan/key in the patron’s library barcode or enter the patrons name (n Last name, First name) into the “Key or scan patron barcode” bar.

Click on the “Edit” icon

Click the “Save” icon to save changes or “Close” icon to erase changes made before last Save.

All Fields Explained:

Card Expires: Expiration date of library card.

GENDER: Gender of patron.

BRTHDECADE: Decade range of birth year.

TOWN CODE: Town Code for town in which the patron lives.

P TYPE: Patron Type – Select the library that is chartered to serve that patron.

TOT CHKOUT: Number of items the patron checked out (includes GEAC Stats).

TOT RENWAL: Total number of items the patron has renewed.

CUR CHKOUT: Number of items the patron currently has checked out.

BIRTH DATE: Birth date of the patron (same as P TYPE).

HOME LIBR: Select the library that is chartered to serve patron. This is the default pickup location for patron holds.

PMESSAGE: Patron message, includes On The Fly, Check Address, Check Phone #, & other predetermined messages .

MBLOCK: Manual Block – Can be Check Returned, Mail Returned, & other predetermined messages.

CL RTRND: The number claimed returned.

MONEY OWED: Amount patron currently owes in fines and bills.

BLK UNIT: Not used.

CUR ITEMA: Not used.

CUR ITEMB: Not used.

OD PENALTY: Not used.

ILL REQUES: Not used.

CUR ITEMC: Not used.

CUR ITEM D: Not used.

ZIP: Zip Code.

CIRCACTIVE: Last circulation transaction (check in, check out, hold placed or fine paid).

Notice Preference: Patron’s preferred method for notices. If set to “none” system defaults to email, then telephone, then print. Telephone is used for Teleforms libraries only.

PATRON NAME: Name of the patron – Last Name Comma First Name.

ADDRESS: Home address of the patron (not PO Box).

TELEPHONE: Patron’s preferred phone number.

INTERNET: Approved for internet use? Yes or No.

APATID: A Patron ID/User ID: a combination of the first 4 letters of the patron’s last name, first letter of the first name, month, and day of birth.

MESSAGE: Message appears as a pop-up when you enter the patron’s record.

ENTERED BY: Location and name of library personnel who created the record.

P BARCODE: Library barcode number of the patron.

PIN: Personal Identification Number. The number the patron uses to sign into SAM and their account in the OPAC.

Patron Record – All Fields Explained

To view a complete Patron’s Record: View > Patron – Refer to the table below for descriptions of fields. To Edit a Patron’s Record:

  • Enter the “Check Out (Circulation Desk)” Function in Sierra and scan/key in the patron’s library barcode or enter the patrons name (n Last name, First name) into the “Key or scan patron barcode” bar.
  • Click on the “Edit” icon
  • Click the “Save” icon to save changes or “Close” icon to erase changes made before last Save.

All Fields Explained:

BLK UNIT, CUR ITEMA, CUR ITEMB, OD PENALTY, ILL REQUES, CUR ITEMC, and CUR ITEM D not used.

Circulation & Patron Records

Patron Record

Patron records

Each library is responsible for any loss incurred when it does not follow Resource Sharing policies.

 Patron Registration Policy

  1. System Residents: A library card for use in all Mid-Hudson Library System member libraries is issued free of charge to anyone meeting the following criteria:
    1. A resident* of any city, town, or municipality within the Mid-Hudson Library System Service area**, and
    2. Does not already have a Patron Record in the Sierra patron
  2. Non-Resident Patrons: Anyone not eligible for a card as a System Resident may be issued a non-resident card by any MHLS library based on local policies, including fees and borrowing The decision to honor non-resident cards is at the discretion of the circulating library.

The issuing library shall require proof of name and address when creating or verifying a patron record.

*Resident as defined by Commissioner’s Regulations 90.3 (5) Resident borrower means an individual who resides within the boundaries of the chartered service area of a public or association or Indian library as defined in section 253 of the Education law and who is a library cardholder at that library.

**link to service area map (DLD)

The following fields must be accurately completed in all patron records:

Fixed Length Fields: Ptypetown codehome libraryzipexpiration datebirth date Variable Length Fields: barcodenamemailing address, (street address if different from mailing), phone or emailAPATIDentered by

Procedure:

Before issuing a card, first make sure that the patron does not have an existing record. The surest way of determining this is by checking for a duplicate APATID. In the Sierra checkout function, enter “u” then the APATID into the search field and press enter.

If you determine that a record already exists, verify that the record is up-to-date, complete and accurate.

If you determine that the patron does not have a record, create a new patron record.

In the Sierra checkout function, click on the New icon. Accurately fill in all the required fields.

Required fields appear in bold below.

EXP DATE: Check your library’s policy. At most libraries choose a date 3 years from today’s date.

GENDER: m for Male or f for Female or n for Not-specified

BIRTHDECADE: The decade in which the patron was born.

BIRTH DATE: Actual birth date. DD-MM-YYYY

TOWN CODE: The municipality where the patron resides.

HOME LIBR (This is a 3 letter code-Do not use the 4 item location codes!): The library in whose area of service the patron resides is the home library. For non-residents the issuing library is the home library. When issuing library cards to residents of unserved areas of the Mid-Hudson Library System, home library is the issuing library.

P TYPE: The Patron’s Ptype should match the home library. When issuing a non-resident card the P-type is 3 non-resident. Note: For non-resident, the issuing library shall designate themselves as the home library when creating patron records for individuals who do not reside within the Mid-Hudson Library System’s service area. The issuing library will include a Message field in the patron record that includes the date and a statement of the amount paid for the non-resident membership and the library location collected.
Example: Issued 12/12/2017, Non-resident membership fee of $25 collected at KHK.

ZIP: Find the zip code in the list that reflects the patron’s residence.

NOTICE PREFERENCE: To establish the desired way of ILS contact for patron.

Note: notice preference is used for ILS notification.  Unless specified, default order is Email, then Phone, then Print.  See the notification flow chart for more details.

NAME: Last Name, First Name Middle Initial.
Example: Smith, Jane E. Do not use other titles like Dr. Junior etc. If you wish, they can be put in the notes field.

MAILING ADDRESS (a address): When typing addresses please use the proper postal abbreviations.
Example: 103 Market ST, Poughkeepsie NY 12601

STREET ADDRESS (h address): Required if different from the mailing address.

TELEPHONE: Use the area code and type as shown: 555-555-5555

EMAIL: A single and properly constructed email address, including an “@” and a “.” STAT CLASS: This statistical field is unused and can be defined separately by each library.

APATID: First 4 letters of the Patron’s Last Name (if last name does not have 4 letters insert an “*” for each missing letter), followed by the first letter of their first name and then the single digit of their birth month followed by the two digits to indicate the day of the month. For October use the Letter O, for November use the letter N and For December use the letter D. The APATID IS TYPED IN UPPER CASE. This field is necessary to check for duplicate records.

Example: Smith, John, born 7/04/1976 APATID = SMITJ704
NOTE: To search by APATID, type the letter “u” before the APATID in the search box type “uSMITJ704” , and press enter.

BARCODE: Type or scan the patron card barcode number. Do not add spaces.

MESSAGE (Required only for Non Resident): a message that pops up each time the record is accessed.  Used to alert staff of immediate circumstances.  When entering a non-resident card the Message field should be edited to include the date the card was issued, any membership fee that was collected, and the library 3 letter location code.

Example: Issued 12/12/2017, Non-resident membership fee of $25 collected at KHK.

ENTERED BY: Three letter library code followed by a hyphen and staff initials and the date. This field is also added and completed, when verifying a record that has been created using Online Patron Registration.

Example: adr-ls 01/22/2019

NOTE: Use this field to put in any information that you may wish to maintain in the patron record.  This field does not pop-up when entering the record.

PIN: When it is entered it is displayed in an encrypted format that cannot be read. A PIN (Personal Identification Number) should be between 4 and eight characters long, contain both letters and numbers if possible, and not have any repeating patterns of characters. To reset a PIN delete characters in the field.

INTERNET: Used for local internet policy. Can be used to instruct public computing management software or parental permission has been signed for youth cards.

E-CONTACT:  Permission for the library to contact the patron via email in addition to ILS notices.    Enter   either “y,” “yes” or “n,” “no.”

GUARDIAN: an optional field that can be used to indicate a guardian in the case of a minor. Should be entered in the same format as the name (Last name, First name) Example: Smith, John

E-CONTACT: If the patron did NOT check the box on the library card application opting out of email contact, then enter Y in this field. If the patron DID check the box opting out of email contact, then enter N in this field. This field indicates whether a patron has agreed to be contacted for library promotions.

*-Note for non resident “The issuing library shall designate themselves as the home library when creating patron records for individuals who do not reside within the Mid-Hudson Library System’s service area. The issuing library will include a Message field in the patron record that includes the date and a statement of the amount paid for the non resident membership and the library location collected. Example: Issued 12/12/2017, Non Resident member ship fee of $25 collected at KHK

Remote/Patron Self-Registration Policy

Staff shall review records that have been created online within 30 days for accuracy and duplicate records. The record will be considered temporary until verified by staff. Records that have not been verified to meet previously stated registration policy, or merged with an existing records within 30 days will be expired.

A verified record must include the library code and initials of who verified it and the date of verification.

Procedure

Review: Libraries with online registration will review all patron records created through their form within 30 days to determine that someone is eligible. Staff completely and accurately fills in all required fields and checks Sierra to determine if a record already exists. Staff verifies home library and notifies home library when appropriate. Follow local procedure to issue a 14 – digit barcode.

Merge Patron – Online Patron registration Record

Before you begin the actual merge process, you will want to really review the records to determine which will be the Source record (the record that you will copy from) and which will be the Destination record (the record you will copy to). The Destination record will be the one record remaining.

The following considerations should be taken to determine the best Destination. The considerations are listed in the order of importance, with 1 being the most important.

  1. Are there active transactions on the record? If items are checked out, holds, fines, or linked patrons, the record is currently “in use” and is likely the best Destination record.
  2. Is the Circ active date recent? This is an indicator that the card is being used in transactions, authentication, or has been logged into by the patron. This field is updated when the card is used by the patron.
  3. Is the record data more inclusive? If neither record has active transactions or a recent circ active date, then the completeness of the record can determine the Destination record.

Select “Merge Duplicate Patron Records” from the Functions drop down menu.

Sierra will open the Merge window, where you will identify the patrons you wish to merge.

In the first field, enter the patron record number that you want to serve as the source record (old or lesser record).

In the second field, enter the patron record number that you want to serve as the destination record (the record that will be kept).

After you enter a patron record in each field, Sierra enables the Merge Patrons button. To merge the patron records that you entered, select the “Merge Patrons” button. Sierra merges the patron records unless any of the following conditions is true:

    • Conditions that Prevent the Merging of Patron Records — Problems & Descriptions
      • Busy records – Item records that are linked to the source record cannot be busy.
      • Holdshelf – Source record cannot have a hold with an “on the holdshelf” status.
      • Identical records – You cannot merge a single record.
      • Length – Modified destination record cannot exceed 100K in size.
      • Too many links – The number of item links in the modified destination record cannot exceed 1900.

If any of the above conditions is true, Sierra displays a brief description of the problem. After you view the message, Sierra returns you to the previous screen.

If the patron records that you entered can be merged, Sierra displays both records. For example:

If you do not want to merge these records, select the Close icon. Sierra returns you to the previous screen.

If you want to merge these records, select “Merge Patrons”. Sierra combines information from both records into the destination record and then deletes the source record. Sierra Circulation adds a NOTE field that contains the source record number and the date to the destination record.

You may need to clean up the patron record a little to remove fields that are redundant or no longer accurate.

If the circ active date of the source record is populated.  You should ensure that an Overdrive account that may exist on the Source record is merged in that interface too.

Log into your Overdrive Market account and go to “Support”

In the merge patron function put the  8 digit Source record number in the “Original User” field, and the 8 digit Destination record number in the “New User ID”.

Ordering Barcodes and Patron Cards

You never want to find yourself without a good stash of barcodes for your items or barcoded patron cards.  These are custom orders that must be ordered in advance using particular prefix and formats to work in our Integrated Library System.  Your new barcodes will need to use your current prefix, and duplicate any existing records or unused supply you may yet use.  

What do you need to know before you order?

    1. What type of barcode do we use?
      Codabar14 digit barcode, where the last digit is a check digit in a modulus 10 (Mod-10) complementary check digit format (more detail on this format).  When you are looking at the barcodes on a sheet, they may not look consecutive to you until you ignore that last number.
    2. What is a check digit?
      A check digit is the last digit in our codabar barcode.  It is the correct answer to an equation that is done on the previous 13 digits in the code.   It’s purpose is to check the validity of the barcode as it is scanned.  An incorrect answer would result in an error message, alerting you to rescan.
    3. What your next number should be?
      You wont want to repeat any number you have already used.  Create a list of all of your current records.  Sort the list by the barcode number.  Look at the first and last barcode number in your list.  The largest of the two numbers is the highest number that has been issued.  You will need to also check your current stock to find a higher number.  What is the next highest group that you would order.
      For example if your highest barcode is 22390000027896, you might consider moving to the next decimal place and order 2239000010000#, where the last digit is the check digit.  In this example we just added started the next range by replacing the last 0 with a 1.  

Document the order for the next time you need to order.

 Barcode Validity Checking: An Example
A typical barcode consists of 14 digits in the following pattern:
Example barcode
In this example, the barcode uses a modulus 10 (Mod-10) complementary check digit. The check digit derives from the barcode as follows:
Mod-10 Algorithms Differ Among Vendors

The method for calculating a Mod-10 check digit can differ from vendor to vendor. Check with your barcode vendor to determine if their algorithm matches the algorithm used here.

  1. Starting with the second digit from the left, add every other digit. Using the example barcode above (without the check digit):
    Add every other digit
  2. Multiply each of the remaining digits by 2. If any product has two digits, add the digits to produce a single-digit number. Sum the results:
    Add numbers together
  3. Add the results from steps 1 and 2. In the example:
    16 + 30 = 46
  4. Subtract the units digit obtained in step 3 from the number 10. The result is the check digit. In the example:
    10 – 6 = 4
4 is the check digit for the example barcode.

Can’t place holds on ordered records – RESOLVED

Problem: Patrons cannot place holds on titles that are yet to be released, like they can in Encore.

Reported: 11/19/21

Resolution: Mid-Hudson has adjusted the settings of each material type in Vega to be requestable even when no items are yet attached to bib records. The issue should be fixed. Please let us know if you are still having problems with this.

Continue reading

Create List: Import Records

Importing Records from a File

You can create a new review file by importing a list of barcodes, record numbers, or indexed field values. Before creating your list, see Format of Input Files for information on how to format your files.

To import from a file:

  1. Select Create Lists from the Function list.
  2. On the Review Files tab, select an empty review file by clicking its row, or select a file to overwrite. To find empty review files, select Empty from the drop-down menu of review file types.
  3. Click Import Records.
  4. If prompted to overwrite the existing file, do one of the following:
    • Click Yes to open the Import Records dialog box and overwrite the file.
    • Click No to return to the list of review files.
  1. Enter a name for the review file. The maximum length is 150 characters.
  2. Select how you want to import records into the review file by doing one of the following:
    • To import a list of barcodes, select the Barcode radio button.
    • To import a list of record numbers, select the Record Number radio button.
    • To import a list of index entries, select the Index radio button, and select an index from the drop-down menu.
  3. From the Store Record Type list, select a record type to store. The list shows only the valid record types for the import method or index you selected in the step above.
  4. Click Choose File. The Select File dialog box opens.
  5. Select the text file containing the data you want to import, and click Load. Create Lists processes the file and displays the results in the bottom half of the Import Records dialog box.
Error Messages During Loading

If the file you selected contains entries that cannot be loaded, Create Lists displays an error message. See Error Messages During Loading for more information.

  1. Click Import to create the review file, or click Cancel to close the dialog box without creating a review file.

Format of Input Files

Input files must be formatted with one value per line. The system searches for exact matches only; partial matching is not supported (for example, entering “12345” in a file will not find a barcode with the value of “123456”).

In addition to the rules above, each input method has additional formatting requirements listed below.

Barcodes
When importing a list of item or patron barcodes, keep the following in mind:
  • You can import barcodes using either a .txt or .csv file.
  • Include the barcode number only; do not include the field group tag.
Record Numbers
When importing a list of record numbers, keep the following in mind:
  • You can import record numbers using a .txt file only; .csv files are not supported.
  • Valid record numbers must begin with the record type tag, such as “b” for bibliographic records.
  • Create Lists recognizes record numbers with a character length equal to the smallest record number in the system up to the largest record number in the system.
  • The system ignores delimiters and other extraneous text.
  • The check digit is not required, but can be included. If your library has mixed-length record numbers, Innovative recommends excluding the check digit, as a 6-digit record number might be confused with a 7-digit record number. In this case, you can import 6-digit and 7-digit numbers separately.
Indexed Fields
When importing a list of indexed field values, keep the following in mind:
  • You can import record numbers using either a .txt or .csv file for indexed fields.
  • Phrase indexes are supported; keyword indexes are not supported.

Error Messages During Loading

When you load a .csv or .txt file, Create Lists processes each entry in the file. If any entries cannot be loaded, Create Lists displays an error message stating there are one or more entries that:

  • Don’t match any record
  • Match multiple records
  • Don’t fit in the review file

For example:

To download the error file:

  1. Click Download. The system opens the Save file dialog box.

If you are using Sierra Web, the system automatically saves the file to your Download folder.

  1. Enter a name for the error file.
  2. Navigate to the location where you want to save the file.
  3. Click Save. Create Lists saves your file and returns you to the Import Records dialog box.
  4. If you have valid entries (shown in the bottom half of the Import Records dialog box), continue with the import process above.