Patron Record Fixed Length Field Definitions (Sierra)

The following information describes the fixed-length fields found in patron records.


Table of Contents

Patron Fixed Length Fields

Numbers are associated with the Fixed Fields when choosing a Field for Create Lists

MLN1 Libraries Patron Fixed-Length Fields

The Patron Fixed-Length Fields for the MLN1 libraries in Sierra using the Create Lists Function

Field Number

Field Short Label

Description

Field Number

Field Short Label

Description

43

EXP Date

The expiration date of the patron's borrowing privileges.

44

PCODE1

Your library chooses this field. Commonly used as statistical category fields.

45

PCODE2

Your library chooses this field. Commonly used as statistical category fields.

46

PCODE3

Your library chooses this field. Commonly used as statistical category fields.

47

P TYPE

The type of patron. Used to define groups of patrons that may have different borrowing privileges.

48

TOT CHKOUT

A count of the total number of items the patron has checked out.

49

TOT RENEW

This is the total number of times an item has been renewed.

50

CUR CHKOUT

This is the last check out date for an item. This is updated during check in.

51

BIRTH DATE

Optional field containing the birth date of the patron. Listed as month-day-year (mm-dd-yy or mm-dd-yyyy).

53

HOME LIBR

The code for the patron's home library.

54

PMESSAGE

A code corresponding to a library-defined patron message. A value in this field causes the system to display the corresponding message text when the patron attempts to check out, renew, or hold an item.

Do not remove the "NO MESSAGE" value from the table of valid codes and definitions; you cannot remove messages if you delete the "NO MESSAGE" value.

55

HLODUES (Highest Overdues)

The highest level of overdue notice (1 = first overdue, 2 = second overdue, etc.) among all overdue notices recently sent to the patron. The Highest Level Odue element specifies the maximum number of notices a patron can receive before the patron is blocked.  This field is for system use and is not a real-time indicator of a patron's overdue levels. The number increases when a patron receives an overdue notice, but it does not decrease when overdue items are returned. Instead, when a patron attempts to perform a transaction (such as checking out an item or placing a hold), the system checks the value of this field against the # OVERDUE field in each item checked out to the patron. If the value in the HLODUES field does not match the highest value in the # OVERDUE field, the system resets the HLODUES field.

56

MBLOCK

Manual patron block. A value in this field prevents the patron from checking out items. The values of this field represent various common reasons a patron might be blocked.  Do not remove the "NO BLOCK" code; you cannot unblock patrons if you delete the "NO BLOCK" code.

95

CL RTRND (Claims Returned)

Count of the number of items the patron has "claimed returned."

96

MONEY OWED

The amount of money the patron owes in fines and charges.

102

CUR ITEMA (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories. 

103

CUR ITEMB (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.  

124

CUR ITEMC (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.  

125

CUR ITEMD (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.

126

PCODE4

Your library chooses this field. Commonly used as statistical category fields.

158

PAT AGENCY

The AGENCY (MLN1) to which the patron belongs.

163

CIRCACTIVE

The most recent date when one of the following circulation activities was performed for or by the patron: 

  • checking out an item

  • checking in an item

  • renewing an item

  • placing a hold

  • placing a booking

  • photocopying materials

  • verifying in the WebPAC, if the UPDATECIRC Web option is set to "true"

  • viewing patron information with Patron API

  • viewing patron information via the My Account Web Service

  • updating the patron record via the Patron Update Web Service

  • paying fines via the Fines Payment Web Service

  • checking items out and in with the SIP2 Circulation Interface

Note: the OverDrive API views the patron information with the Patron API for verification and does update the patron’s circactive date.

263

LANG PREF

Preferred language for notices.

Lang Pref (Language Preference)

At multilingual sites, the Preferred Patron Language feature enables you to assign a preferred language in the LANG PREF field of the patron record. You can then generate certain types of circulation notices in a patron's preferred language. 

This works in conjunction with the Notice Preference.  If your Spanish-speaking patrons would prefer to have their email notices in Spanish instead of English, you will need to work with Marmot’s User Services Manager to set up these notices.  Libraries must be able to translate their notice information from English to Spanish.

268

Notice Preference

The notification preference for each patron (Email, Print, Phone).

270

Total Registrations

Used for the program registration. Marmot no longer has this product.

271

Total Programs Attended

Used for the program registration. Marmot no longer has this product.

297

Waitlists on Record

Used for the program registration.  Marmot no longer has this product.

81

RECORD #

The record number associated with the patron.

83

CREATED

Date the record was created.

84

UPDATED

Date of the last update to the record. The system updates this field any time the record is edited or involved in a transaction.

85

REVISIONS

Number of revisions to the record.

Top of page

MLN2 Libraries Patron Fixed-Length Fields

The Patron Fixed-Length Fields for the MLN2 libraries in Sierra using the Create Lists Function

Field Number

Field Short Label

Description

Field Number

Field Short Label

Description

43

EXP Date

The expiration date of the patron's borrowing privileges.

44

RESIDENCY

The residency code is for statistical purposes and it should match the mailing address the patron provided to the library staff.

45

PCODE2

Your library chooses this field. Commonly used as statistical category fields.

46

BIRTHYEAR

You would choose the birthyear for your patron from a prepopulated list.

47

P TYPE

The type of patron. Used to define groups of patrons that may have different borrowing privileges.

48

TOT CHKOUT

A count of the total number of items the patron has checked out.

49

TOT RENWAL

This is the total number of times an item has been renewed.

50

CUR CHKOUT

This is the last check out date for an item. This is updated during check in.

51

BIRTH DATE

Optional field containing the birth date of the patron. Listed as month-day-year (mm-dd-yy or mm-dd-yyyy).

53

HOME LIBR

The code for the patron's home library.

54

PMESSAGE

A code corresponding to a library-defined patron message. A value in this field causes the system to display the corresponding message text when the patron attempts to check out, renew, or hold an item.

Do not remove the "NO MESSAGE" value from the table of valid codes and definitions; you cannot remove messages if you delete the "NO MESSAGE" value.

55

HLODUES (Highest Overdues)

The highest level of overdue notice (1 = first overdue, 2 = second overdue, etc.) among all overdue notices recently sent to the patron. The Highest Level Odue element specifies the maximum number of notices a patron can receive before the patron is blocked.  This field is for system use and is not a real-time indicator of a patron's overdue levels. The number increases when a patron receives an overdue notice, but it does not decrease when overdue items are returned. Instead, when a patron attempts to perform a transaction (such as checking out an item or placing a hold), the system checks the value of this field against the # OVERDUE field in each item checked out to the patron. If the value in the HLODUES field does not match the highest value in the # OVERDUE field, the system resets the HLODUES field.

56

MBLOCK

Manual patron block. A value in this field prevents the patron from checking out items. The values of this field represent various common reasons a patron might be blocked.  Do not remove the "NO BLOCK" code; you cannot unblock patrons if you delete the "NO BLOCK" code.

95

CL RTRND (Claims Returned)

Count of the number of items the patron has "claimed returned."

96

MONEY OWED

The amount of money the patron owes in fines and charges.

102

CUR ITEMA (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories. 

103

CUR ITEMB (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.  

124

CUR ITEMC (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.  

125

CUR ITEMD (Current Item)

Total number of items the patron currently has checked out from library-defined categories A, B, C, and D. Libraries can restrict the number of items a patron is allowed to check out from one of four library-defined categories.

126

PCODE4

Your library chooses this field. Commonly used as statistical category fields.

158

PAT AGENCY

The AGENCY (MLN1) to which the patron belongs.

163

CIRCACTIVE

The most recent date when one of the following circulation activities was performed for or by the patron: 

  • checking out an item

  • checking in an item

  • renewing an item

  • placing a hold

  • placing a booking

  • photocopying materials

  • verifying in the WebPAC, if the UPDATECIRC Web option is set to "true"

  • viewing patron information with Patron API

  • viewing patron information via the My Account Web Service

  • updating the patron record via the Patron Update Web Service

  • paying fines via the Fines Payment Web Service

  • checking items out and in with the SIP2 Circulation Interface

Note: the OverDrive API views the patron information with the Patron API for verification and does update the patron’s circactive date.

263

LANG PREF

Preferred language for notices.

Lang Pref (Language Preference)

At multilingual sites, the Preferred Patron Language feature enables you to assign a preferred language in the LANG PREF field of the patron record. You can then generate certain types of circulation notices in a patron's preferred language. 

This works in conjunction with the Notice Preference.  If your Spanish-speaking patrons would prefer to have their email notices in Spanish instead of English, you will need to work with Marmot’s User Services Manager to set up these notices.  Libraries must be able to translate their notice information from English to Spanish.

268

Notice Preference

The notification preference for each patron (Email, Print, Phone).

81

RECORD #

The record number associated with the patron.

83

CREATED

Date the record was created.

84

UPDATED

Date of the last update to the record. The system updates this field any time the record is edited or involved in a transaction.

85

REVISIONS

Number of revisions to the record.

Related Documentation

Top of page

Â