Item Record Property Fields Definitions (Data Fields, Holds, Fines & Bookings) (Create Lists)
Some fields in Create Lists store record properties from your system's database. You can search on these fields just as you do with standard fixed-length and variable-length fields. In some cases, the fields duplicate data found in the standard fields.  The property fields for item records appear in the Data Fields, Holds, Fines, and Bookings tabs. Here is information on the Create Lists Sierra Fixed Field Item Definitions.
Table of Contents
Data Fields Table (Course Reserves & Floating Collections)
Field Name | Description |
---|---|
Save Item Itype | The original item type before the item was placed on Course Reserves. This value is restored to the item type field when the item is no longer on Course Reserves. |
Save Item location | The original item Location before the item was placed on Course Reserves. This value is restored to the item Location field when the item is no longer on Course Reserves. |
Save Item Checkout Total | The original item checkout total before the item was placed on Course Reserves. This value is restored to the item checkout total field when the item is no longer on Course Reserves. |
Old Location | The location that originally owned the item; used by Floating Collections products. |
Holds Tab
Field Name | Description |
---|---|
Hold Patron | The patron requesting the hold. |
Hold Record | The record on which the hold was placed. |
Hold Placed | The date the hold was placed. |
Hold Frozen | Specifies whether the hold is frozen (suspended). |
Hold Delay | The "not wanted before" date as a number of days after the date the hold was placed. The maximum value is "180". If a "not wanted before" date was not specified, the value is '0'. |
Hold Location | The location code for bib or volume-level holds. Blank for item holds. |
Hold Expires | The Not needed after date. |
Hold Status | The hold status. Code          Definition |
Hold Ir | Specifies whether the hold is an INN-Reach hold. |
Hold Pickup Location | The pickup location code. |
Hold ILL | Specifies whether the hold is an ILL hold (Marmot does not current have this module enabled) |
Hold Note | A free-text note field. |
Hold Ir Pickup Location | The INN-Reach pickup location code. |
Hold Ir Print Name | The INN-Reach print name. |
Hold Ir Delivery Stop Name | The INN-Reach delivery stop name. |
Hold Ir Converted Request | Specifies whether the hold is a converted INN-Reach request. Item and patron belong to the same Local Server. Converted to standard circulation transaction at Remote Site Check-Out. |
Hold On Holdshelf Date | Specifies when an item was placed on the holdshelf. |
Hold Pick Up By Date | Â Specifies the date after which an item can be cleared from the holdshelf. (The date is the last day on which the patron can pick up the item. The item appears on a Clear Holdshelf report printed the day after this date.)Â |
Fines Tab (Create Lists can search only for information about outstanding fines)
Field Name | Description |
---|---|
Fine Patron | The patron to whom the fine applies. |
Fine Assessed | The date the fine was assessed. Note that if the fine is a reinstated fine, this field reflects the date the fine was reinstated and not the original date the fine was assessed. |
Fine Invoice Num | The fine's invoice number. For fine adjustment entries (charge type = 4), this column contains the invoice number of the original fine. |
Fine Item Charge | If the fine type is:Â Â Â Â This field contains:Â Â |
Fine Processing Fee | If the fine type is:Â Â Â Â Â This field contains:Â |
Fine Billing Fee | If the fine type is:Â Â Â This field contains:Â |
Fine Charge Code | Code              Definition |
Fine Charge Location | If the fine type is:Â Â Â This field contains:Â |
Fine Paid Date | The date the fine was paid or, if the action was an adjustment, the current date. |
Fine Terminal Num | The statistics group from which the fine was paid or adjusted. |
Fine Paid Amount | If partial payment is accepted as full payment, the amount of the partial payment appears here. |
Fine Initials | The Sierra username used to authorize the fine payment or adjustment. |
Fine Created Code | Code    Definition |
Fine Print Bill | Specifies whether the finespaid file adds fine-payment entries to the bills2print file. |
Fine Description | If the fine type is:Â Â Â Â This field contains:Â |
Fine Item | The item for which the fine is assessed. |
Fine Checkout Date | The checkout date of the item for which a fine was assessed. |
Fine Due | The due date of the item for which a fine was assessed. |
Fine Returned Date | The date the item (for which a fine was assessed) was returned. |
Fine Loanrule | The code number of the loan rule under which the item was checked out. |
Fine Title | Title of the item associated with the charge. |
Fine Original Patron | The original patron record to which the fine was assessed. |
Fine Original Transfer Date | Date of the original transfer. |
Fine Previous Invoice | The previous invoice number. If no previous invoice number is present, the field displays "0". |
Bookings Tab
Field Name | Description |
---|---|
Booking Item | The item booked. |
Booking Patron | The patron who placed the booking. |
Booking Created | The date the booking was placed. |
Booking Start | The date the booking starts. |
Booking End | The date the booking ends. |
Booking Type | A code identifying the method used to place the booking. |
Booking Prep | The date and time at which the booked item becomes unavailable. |
Booking Location | The location code associated with the booking. |
Booking Note | A free-text note field. |
Booking Event | The event name associated with the booking. |
Related Documentation
-
Prepare Overdues Report (Sierra) (Marmot Knowledge Base)
-
Re-run Existing Query or Edit Existing Query for Create Lists (Sierra) (Marmot Knowledge Base)
-
Saved Searches (Create Lists) (Marmot Knowledge Base)
-
System Generated Review Files (Create Lists) (Marmot Knowledge Base)
-
Fines Paid Function (Sierra) (Marmot Knowledge Base)
-
Notices (Sierra) (Marmot Knowledge Base)
-
In Transit Too Long Report and Create Lists Import Barcodes (Sierra) (Marmot Knowledge Base)
-
User Generated Macros (Sierra) (Marmot Knowledge Base)
-
Saved Searches, Saved Sorts, Saved Lists and Saved Exports (Create Lists) (Marmot Knowledge Base)
-
Guidelines (Create Lists) (Marmot Knowledge Base)
-
-
Sorting a Review File and Saving a Sort (Create Lists) (Marmot Knowledge Base)
-
Check Out (Circulation Desk) Item on the Fly (Sierra) (Marmot Knowledge Base)
-
Removing Duplicate Records in a Review File (Create Lists) (Marmot Knowledge Base)
-
Create a list using ISBNs (Marmot Knowledge Base)