Item Record Fixed Length Field Definitions (Sierra)

58

Copy #:

Indicates which copy of the title corresponds to the item record. They are commonly used in item records attached to bibliographic records with multiple items.

59

ICODE1

Your library chooses the number listed in this field. 

60

ICODE2

The “n” is used as an item suppression code. Here is more information about the ICODE2 fields.

61

ITYPE

The type of item. Used to define groups of items that may circulate differently.

62

PRICE

Contains the price of the item.

63

OUT DATE

This is the date and time the item was checked out. Sierra updates the OUT DATE when the item is checked out and again when the item is checked in.  The information from this field gets moved to the LOUTDATE when the item gets checked in. 

64

OUT LOC

This is the stat group associated with a Sierra login where the item was last checked out or is currently checked out. Here is more information about the MLN1 OUT LOC.

65

DUE DATE

This is when the item is due.

66

PATRON#

The record number of the patron who has the item checked out (displayed without the last digit, the check digit). '0' if the item is not checked out.

67

LPATRON

The record number of the last patron to check out the item (displayed without the last digit, the check digit).  

68

LCHKIN (Last Checkin)

This shows the date and time of the last time an item was checked in. 

69

INVDA (Inventory Date)

The date the item was inventoried and found on the shelf.  Here is more information about MLN1 Inventory.

70

IN LOC

This is the stat group associated with a Sierra login where the item was last checked in. This field is updated when a check in unlinks the item record from the patron record.  If the item’s status is set to IN TRANSIT, a check in at the destination location does not update the IN LOC field.  

Here is more information about the MLN1 IN LOC.

71

# RENEWALS

# RENEWALS: This is the number of times the item has been renewed by the patron who currently has the item checked out.

72

# OVERDUE

The level of the last overdue letter sent to the patron who has the item checked out.

73

ODUE DATE (Overdue Date)

The date of the last overdue notification sent to the patron. 

74

IUSE3

Library chosen field for tracking internal use of items. See Sierra - Count Use Functions for more information.

75

RECAL DATE

The date the item was recalled (blank if the item has not been recalled). When an item is recalled, the system allows a new, earlier due date for the current loan and would generate a recall notice to be sent to the patron. 

76

TOT CHKOUT

This keeps a running total of all the checkouts for an item regardless of the library location where the item was checked out. Renewals are not counted in the TOT CHKOUT field.

77

TOT RENEW

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

78

LOUTDATE (Last Out Date)

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

79

LOCATION

The branch location code for the item. Codes must be predefined in the Branch (location) codes table.

87

LOANRULE

The loan rule number under which the item is currently checked out. '0' if the item is not checked out.

88

STATUS

The status of the item. Here is more information about Item Statuses.

93

INTL USE

Library chosen field for tracking internal use of items. See Sierra - Count Use Functions for more information.

94

COPY USE

Library chosen field for tracking internal use of photocopied items. See Sierra - Count Use Functions for more information.

97

IMESSAGE

A code entered in this field causes the system to display the code's definition (i.e., the message) during checkout or checkin of the item. If the code is a space or hyphen, no message will display. 

108

OPACMSG

Codes and definitions are added by Marmot for this field (with the exception of the code for 'r' rental).

The definitions are displayed as messages in the OPAC. If OPACMSG is r (rental), the system will bill the patron for the item based on the length of time the item has been checked out (i.e., rented).

Do not use for non-rental items. The definition of 'r' cannot be changed. Changing the definition does not change the software's action. 

109

YTDCIRC (Year-to-date circ)

This will show all the checkouts for this calendar year. 

On January 1st (Public Libraries) or July 1st (Academic Libraries), there is a year-end roll-over of circulation statistics. 

The LYRCIRC is zeroed out and those numbers are moved to the YTDCIRC. 

110

LYRCIRC (Last year circ)

This is a tally of the checkout circulation of an item from the previous calendar year.  

127

AGENCY

The AGENCY to which the item belongs.

306

Sticky Status

MLN2 Libraries only

The item's sticky status. If the Sticky Status feature is enabled, when an item is checked in, the system checks for the presence of a Sticky Status field in the item record. If one exists, the system changes the item's status to the code indicated in the Sticky Status field. For more information, see Using the Sticky Status Feature.

81

RECORD#

Record number associated with the item.

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.