Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Element Name

Description

Data Source

Library_Address_Line1_C

The first line of the library’s address.

The Address element in the Branch Addresses table (click on the image to expand).

The first line of the Address element in the Branch Addresses tableImage Modified

Library_Address_Line2_C

The second line of the library’s address.

The Address element in the Branch Addresses table (click on the image to expand).

The second line of the Address element in the Branch Addresses tableImage Modified

Library_Address_Line3_C

The third line of the library’s address.

The Address element in the Branch Addresses table (click on the image to expand).

The third line of the Address element in the Branch Addresses tableImage Modified

Library_Address_Line4_C

The fourth line of the library’s address.

The Address element in the Branch Addresses table (click on the image to expand).

The fourth line of the Address element in the Branch Addresses tableImage Modified

Message_C

Text from the Text of Circulation Notices table.

The Text of Circulation Notices table.

Patron_Mobile_Number_C

The patron’s mobile phone number.

The MOBILE PH variable-length field in the patron record.

The Mobile Phone Number fieldImage Modified

Patron_Notice_Pref_C

The notification preference indicated by the patron.

The NOTICE PREF fixed-length field in the patron record.

The Notice Preference fieldImage Modified

Print_Sequence_C

The ordinal number of this notice in the list of notices printed.

The Sierra system.

Text_Number_C

The number of the Text of Circulation Notices table entry used in the Message_C data library element.

The Text of Circulation Notices table.

Total_Patron_Fines_C

The total amount of all the patron’s current charges.

The Sierra system.

...

Data Element

Description

Data Source

Bill_Charge_Type

The type of charge.

The fine on the patron’s record.

The title of the type of charge for the Fine in SierraImage Modified

Bill_Desc

The title, record number, and relevant overdue information for the overdue item.

The fine on the patron’s record.

Bill_Invoice

The invoice number for this charge.

The Detailed Fine Display on the patron’s record.

The Detailed Fine Display in SierraImage Modified

Bill_Total_Amount

The total amount of the patron’s current bill.

The Sierra system.

The total of the patron's bills in SierraImage Modified

Item_Agency

The agency that owns the item.

The AGENCY fixed-length field in the item record.

The Agency fieldImage Modified

Item_Author

The title’s author.

The AUTHOR variable-length field in the bibliographic record.

The Author fieldImage Modified

Item_Barcode

The item’s barcode.

The BARCODE variable-length field in the item record.

The Barcode fieldImage Modified

Item_Bib_Record_Id

The title’s record number.

The record number fixed-length field in the bibliographic record.

The bibliographic record numberImage Modified

Item_Call_Number

The item’s call number.

The CALL # variable-length field in the item record.

The Call Number fieldImage Modified

Item_Checked_Out_Date

The date and time the item was checked out.

The OUT DATE fixed-length field in the item record.

The Out Date fieldImage Modified

Item_Checked_Out_Location

The statistics group associated with the login at which the item was checked out.

The OUT LOC fixed-length field in the item record.

The Out LOC fieldImage Modified

Item_Code1

An item code.

The ICODE1 fixed-length field in the item record.

The ICODE1 fieldImage Modified

Item_Code2

An item code.

The ICODE2 fixed-length field in the item record.

The ICODE2 fieldImage Modified

Item_Due_Date

The item’s due date.

The DUE DATE fixed-length field in the item record.

The Due Date fieldImage Modified

Item_Edition

The edition information.

The MARC 250 field in the bibliographic record.

The MARC 250 fieldImage Modified

Item_ID

The ordinal number of this item in the list of items in this notice.

The Sierra system.

Item_In_Location

The statistics group associated with the login at which the item was last checked in.

The IN LOC fixed-length field in the item record.

The IN LOC fieldImage Modified

Item_Last_Checkin

The date the item was last checked in.

The LCHKIN fixed-length field in the item record.

The LCHKIN fieldImage Modified

Item_Location

The branch location code for the item.

The LOCATION fixed-length field in the item record.

The LOCATION fieldImage Modified

Item_Material_Type

The title’s material type.

The MAT TYPE fixed-length field in the item record.

The MAT TYPE fieldImage Modified

Item_Message

A code corresponding to a library-defined item message.

The IMESSAGE fixed-length field in the item record.

The IMESSAGE fieldImage Modified

Item_Note

The first note (the note most recently added) in the item record.

The INT NOTE variable-length field in the item record.

The INT NOTE fieldImage Modified

Item_Publish_Date

The date the title was published.

The MARC 260 field in the bibliographic record.

Item_Publisher

Information about the publisher.

The MARC 260 field in the bibliographic record.

The MARC 260 fieldImage Modified

Item_Record_Id

The item record number.

The record number fixed-length field in the item record.

The item record number Image Modified

Item_Title

The item’s title.

The TITLE variable-length field in the bibliographic record.

The Title fieldImage Modified

Item_Total_Checkout

The total number of times this item has been checked out.

The TOT CHCKOUT fixed-length field in the item record.

The TOT CHKOUT fieldImage Modified

Item_Type

The type of item.

The I TYPE fixed-length field in the item record.

The ITYPE fieldImage Modified

Item_Volume

The item’s volume number.

The VOLUME variable-length field in the item record.

The VOLUME fieldImage Modified

Message_Patron

A message to print above the patron’s name and address.

The Text of Circulation Notices table.

Patron_Address_Line1

The first line of the patron’s address.

The ADDRESS variable-length field in the patron record.

The first line of the Address field in the patron recordImage Modified

Patron_Address_Line2

The second line of the patron’s address.

The ADDRESS variable-length field in the patron record.

The second line of the Address field in the patron recordImage Modified

Patron_Agency

The agency to which the patron belongs.

The PAT AGENCY fixed-length field in the patron record.

The PAT Agency fieldImage Modified

Patron_Barcode

The patron’s barcode.

The P BARCODE variable-length field in the patron record.

The P BARCODE fieldImage Modified

Patron_Checked_Out_Number

The total number of items the patron currently has checked out.

The CUR CHKOUT fixed-length field in the patron record.

The CUR CHKOUT fieldImage Modified

Patron_Code1

A fixed-length field in the patron record that your library can define.

The Item Fixed Length Field Definitions (Sierra) PCODE1 fixed-length field in the patron record.

The PCODE1 fieldImage Modified

Patron_Code2

A fixed-length field in the patron record.

The PCODE2 fixed-length field in the patron record.

The PCODE2 fieldImage Modified

Patron_Code3

A fixed-length field in the patron record.

The PCODE3 fixed-length field in the patron record.

The PCODE3 fieldImage Modified

Patron Code4

A fixed-length field in the patron record.

The PCODE4 fixed-length field in the patron record.

The PCODE4 fieldImage Modified

Patron_Home_Library

The patron’s home library.

The HOME LIBR fixed-length field in the patron record.

Patron_Message

A message in the patron record.

The MESSAGE varaible-length field in the patron record.

Patron_Name

The patron’s name, printed as last name, first name.

The PATRN NAME variable length field in the patron record.

The PATRON NAME fieldImage Modified

Patron_Phone_Number

The patron’s primary primary telephone number.

The TELEPHONE variable-length field in the patron record.

The TELEPHONE fieldImage Modified

Patron_Phone2_Number

An alternate telephone number for the patron.

The TELEPHONE2 variable-length field in the patron record.

The TELEPHONE2 fieldImage Modified

Patron_Record_ID

The patron’s record number.

The record number fixed-length field in the patron record.

The patron record numberImage Modified

Patron_Type

The P TYPE code associated with the patron.

The P TYPE fixed-length field in the patron record.

The P TYPE fieldImage Modified

Examples

Info

The null values indicate data that will populate when the overdue notice is printed.

...

Print Template Editor (Jaspersoft) View

Sierra View

The raw data view of the Overdue Notice in the Jaspersoft SoftwareImage Modified

The view of the Overdue Notice once loaded into SierraImage Modified

Marmot Default

Print Template Editor (Jaspersoft) View

Sierra View

The raw data view of the Overdue Notice in the Jaspersoft softwareImage Modified

The view of the Overdue Notice once loaded into Sierra.Image Modified

Custom

Print Template Editor (Jaspersoft) View

Sierra View

The raw data view of the Overdue Notice in the Jaspersoft softwareImage Modified

The Overdue Notice view once loaded into SierraImage Modified

Top of page

...