Using Patron Name Fields in Searches

In Sierra, Patron Name field data are not stored in the database as a single string. Instead, the various components of a patron name are partitioned into separate database elements. You must know how the system stores Patron Name field data in order to construct a search.

How Sierra Stores Patron Name Fields

The components of a Patron Name field are stored separately in the database, partitioned into the following database elements:

Field Name ID Description
Name Prefix 80105 A word or abbreviation that appears before the patron's first name. For example, "Mr."
First Name 80101 The patron's first name.
Middle Name 80103 The patron's middle name.
Last Name 80102 The patron's last name.
Name Suffix 80104 A word or abbreviation that appears after the patron's last name. For example, "Jr."
Full Name 80109 The Sierra system populates this field with the patron's name in the form <prefix> <last name>, <first name> <middle name> <suffix>.

When a patron name field is inserted into a record, the system parses the data according to rules based on your local customs and stores the name components in the appropriate database elements. The system can be configured to parse the entered name in either of two formats:

Standard Format

The standard format for keying a patron name is:

<last name>, <first name> <middle name>

The Last Name and First Name elements are separated by a comma and optional SPACE and the First Name and Middle Name are separated by another SPACE. For example:

Edison, Thomas Alva

The three elements of this name are stored in the database as:

First Name Thomas
Middle Name Alva
Last Name Edison

When loading patron records from an external source, the system parses patron names as follows:

Non-MARC records

<last name>, <first name> <middle name>

MARC records

|a<last name>,|c<prefix>|b<first name> <middle name>

Compound Format

Compound format is used in countries in which it is the custom to have more than one surname. For example, in Spanish-speaking countries, a person's full name consists of a given name, optional middle name, and the last names of both parents. For example, Teresa García López Ramírez.

When the system is configured for compound format and you are keying a patron's name, it parses the input as follows:

<last name>, <first name>

The Last Name and First Name elements are separated by a comma and optional SPACE. Everything following the comma is stored in the patron First Name database element. No data is stored in the Middle Name element in this case. For example:

Ramírez, Teresa García López

The two elements of this name are stored in the database as:

First Name Teresa García López
Last Name Ramírez

When loading patron records from an external source, the system parses patron names as follows:

Non-MARC records

<last name>, <first name>

MARC records

|a<last name>,|c<prefix>|b<first name>