CIRCULATION REPORTS
Chapter 6. REPORT WRITER
Field Definitions
The available search and output fields, as well as the fields available for modification, depend on the type of query (User, Items, Bibliographic¸ Combination, Acquisitions Orders). The following table provides definitions for search and output fields, by query type, and identifies the data entry method for each field (text box, date entry calendar, menu).
| Field Name | Definition (Entry Type) |
|---|---|
| Address1 | The value specified in the Address 1 field of the User Record. (Text box) |
| Address2 | The value specified in the Address 2 field of the User Record. (Text box) |
| Alt Address1 | The value specified in the Alternate Address 1 field of the User Record. (Text box) |
| Alt Address2 | The value specified in the Alternate Address 2 field of the User Record. (Text box) |
| Alt City State Zip | The value specified in the Alternate Address 3 field of the User Record. (Text box) |
| Blocked Indicator | The
one-character abbreviation for the value specified in the Blocked
field of the User Record; Y = Yes, N = No. (Text box)
When entering a value as a search parameter, use the one-character abbreviation for the desired status. DO NOT enter the full name of the status. |
| Block Reason | The value contained in the Block Reason field of the User Record. (Text box) |
| Borrower Category | The value contained in the Patron Category field of the User Record. (Menu) |
| Borrower ID | The value specified in the Username or Barcode field of the User Record. (Text box) |
| Borrower Type | One- or
two-character code for the selected User Type(s) in the User
Record, as follows: (Text box)
A = PAC Staff C = CAT Staff CS = Customer SuperUser I = ILL Staff LS = Library SuperUser P = Patron RA = Reports Staff S = Staff User SA = User Administrator ST = Statistics VA = Circulation Admin VC = Circulation Staff VQ = Acquisitions Staff VS = Serials Staff When entering a value for a single User Type, enter the code followed by a comma (e.g., VC,). When entering a value of two or more User Types as a search parameter, select Like as the "matching" type for the parameter, and enclose each User Type with the "%" wildcard (e.g., %S% %VC%). |
| Cell Phone | The value specified in the Mobile Phone field of the User Record. (Text box) |
| City | The value specified in the City field of the User Record. (Text box) |
| Comment | The value specified in the Comment field of the User Record. (Text box) |
| Country | The value specified in the Country field of the User Record. (Text box) |
| Date Added | The date
(MM/DD/YYYY) on which the User Record was initially added to the database.
(Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Updated | The date
(MM/DD/YYYY) on which the User Record was last edited. (Date entry
calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Date Of Birth | The value specified in the Date of Birth field of the User Record. (Date entry calendar) |
| Date Registered | The date
(MM/DD/YYYY) on which the User Record was initially added to the database.
(Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Email Address | The value specified in the E-Mail field of the User Record. (Text box) |
| Expire Date | The value
specified in the Expiration Date field (MM/DD/YYYY) of the User Record.
(Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the user's borrowing/access privileges will expire. |
| Fax Phone | The value contained in the FAX field of the User Record. (Text box) |
| First Name | The value specified in the First Name field of the User Record. (Text box) |
| Patron Group | The value contained in the Patron Group field of the User Record. (Menu) |
| Has Image | The one-character abbreviation for the value indicating whether or not content is entered in the Patron Image Name field of the User Record; Y = Yes, N = No. (Text box) |
| Home Branch | The value contained in the Home Location field of the User Record. (Menu) |
| Home Phone | The value specified in the Home Phone field of the User Record. (Text box) |
| LastChargeOutDate | The date
(MM/DD/YYYY) on which a checkout transaction was most recently logged for
the user. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the checkout transaction occurred. |
| LastFineDepositDate | The date
(MM/DD/YYYY) on which a deposit of funds was most recently logged for the
user. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the deposit occurred. |
| LastHoldDate | The date
(MM/DD/YYYY) on which a Checkout Reserve transaction was most recently
logged for the user. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the Checkout Reserve transaction occurred. |
| Last Name | The value specified in the Last Name field of the User Record. (Text box) |
| LastPaidDate | The date
(MM/DD/YYYY) on which a payment for fines assessed was most recently
logged for the user. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the payment occurred. |
| LastRenewalDate | The date
(MM/DD/YYYY) on which a renewal transaction was most recently logged for
the user. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the renewal transaction occurred. |
| Last Usage Date | The date
(MM/DD/YYYY) on which the user most recently logged into the system. (Date
entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| [Library Defined Field 1] | The value
contained in the Library Defined Field 1 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 1, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 2] | The value
contained in the Library Defined Field 2 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 2, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 3] | The value
contained in the Library Defined Field 3 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 3, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 4] | The value
contained in the Library Defined Field 4 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 4, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 5] | The value
contained in the Library Defined Field 5 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 5, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 6] | The value
contained in the Library Defined Field 6 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 6, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 7] | The value
contained in the Library Defined Field 7 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 7, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 8] | The value
contained in the Library Defined Field 8 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 8, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 9] | The value
contained in the Library Defined Field 9 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 9, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 10] | The value
contained in the Library Defined Field 10 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 10, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 11] | The value
contained in the Library Defined Field 11 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 11, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 12] | The value
contained in the Library Defined Field 12 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 12, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 13] | The value
contained in the Library Defined Field 13 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 13, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 14] | The value
contained in the Library Defined Field 14 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 14, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 15] | The value
contained in the Library Defined Field 15 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 15, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 16] | The value
contained in the Library Defined Field 16 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 16, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 17] | The value
contained in the Library Defined Field 17 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 17, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 18] | The value
contained in the Library Defined Field 18 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 18, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 19] | The value
contained in the Library Defined Field 19 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 19, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 20] | The value
contained in the Library Defined Field 20 of the User Record. (Text
box)
When a local label has been specified for Library Defined Field 20, the "Search" and "Output" field menus will show the local label for the field. |
| Message | The value contained in the Message field of the User Record. (Text box) |
| Middle Initial | The value specified in the Initial field of the User Record. (Text box) |
| Notes | The value specified in the Notes field of the User Record. (Text box) |
| Notification Preference | The value specified in the Notification Preferences field of the User Record. (Menu) |
| Number Of Claims Return | The total number of items registered as "claimed returned" against the user’s account. (Text box) |
| Number Of Items Out | The total number of items currently checked out to the user. (Text box) |
| Number Of Lost | The total number of items registered as "lost" against the user’s account. (Text box) |
| Number Of Overdues | The total number of items currently checked out to the user for which the due date has expired. (Text box) |
| Phone2 | The value specified in the Phone 2 field of the User Record. (Text box) |
| Reserve Notification Preference | The value specified in the Reserve Notification Preferences field of the User Record. (Menu) |
| Sponsor | The value contained in the Sponsor field of the User Record. (Text box) |
| State | The
two-character abbreviation for the value specified in the State
field of the User Record. (Text box)
When entering a value as a search parameter, use the two-character abbreviation for the desired state. DO NOT enter the full name of the state. |
| Total Number Of Circs | The total number of checkout transactions made to the user over the life of the account. (Text box) |
| Work Phone | The value contained in the Work Phone field in the User Record. (Text box) |
| Zip | The value specified in the Zip field of the User Record. (Text box) |
| Field Name | Definition (Entry Type) |
|---|---|
| AGCN | The Auto-Graphics Control Number for the title (Text box) |
| Author | The author of the title (usually derived from MARC Tag 100). (Text box) |
| Date Bib Record Added | The date
(MM/DD/YYYY) on which the bibliographic record was initially added to the
database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Of Publication | The date of the title's publication (usually derived from MARC Tag 260$a). (Text box) |
| ISBN | The first International Standard Book Number for the title (usually derived from MARC Tag 020). (Text box) |
| ISSN | The first International Standard Serial Number for the title (usually derived from MARC Tag 022). (Text box) |
| Control Number (001) | The system Control Number for the title (taken from MARC Tag 001). (Text box) |
| Title | The title of the item (usually derived from MARC Tag 245$a). (Text box) |
| Field Name | Definition (Entry Type) |
|---|---|
| Alternate Item ID | The value contained in the Alternate ID field of the Item Record. (Text box) |
| Barcode | The value contained in the Barcode field of the Item record. (Text box) |
| Call Number | The value contained in the Item Call Number field of the Item Record. |
| Call Number Prefix | The value contained in the Prefix field of the Item Record. (Text box) |
| Call Number Suffix | The value contained in the Suffix field of the Item Record. (Text box) |
| Comments | The value contained in the Comment field of the Item Record. (Text box) |
| Current Branch Loc Coll | The value contained in the Current Location field of the Item Record. (Menu) |
| Current Library Branch Loc | The value contained in the Current Location field of the Item Record, truncated to "branch" level only (Menu) |
| Current Library Loc | The value contained in the Current Location field of the Item Record, truncated to "library" level only (Menu) |
| Date Item Added | The date
(MM/DD/YYYY) on which the Item Record was initially added to the database.
(Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Item Modified | The date
(MM/DD/YYYY) on which the Item Record was last edited. (Date entry
calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Date Inventoried | The date
(MM/DD/YYYY) on which the item was most recently inventoried. (Date entry
calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the item was inventoried. |
| Item Exception Type | The value contained in the Status field of the Item Record. (Menu) |
| Item Notes | The value contained in the Circ Note field of the Item Record. (Text box) |
| Last Activity Date | The date
(MM/DD/YYYY) on which the most recent Cataloging or Circulation activity
for the Item Record or the associated item occurred. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the activity occurred. |
| Last Checkout Date | The date
(MM/DD/YYYY) on which a checkout transaction was most recently logged for
the item. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the checkout transaction occurred. |
| Material Type | The value contained in the Material Type field of the Item Record. (Menu) |
| Number Of Circ All Items Last Year | The number of times all items associated with a specified title were checked out during the previous fiscal year. (Text box) |
| Number Of Circ All Items This Year | The number of times all items associated with a specified title have been checked out during the current fiscal year. (Text box) |
| Number Of Circ This Item Last Year | The number of times a specified item was checked out during the previous fiscal year. (Text box) |
| Number Of Circ This Item This Year | The number of times a specified item has been checked out during the current fiscal year. (Text box) |
| Number Of In House All Items Last Year | The number of times all items associated with a specified title were shelved during the previous fiscal year. (Text box) |
| Number Of In House All Items This Year | The number of times all items associated with a specified title have been shelved during the current fiscal year. (Text box) |
| Number Of In House This Item Last Year | The number of times a specified item was shelved during the previous fiscal year. (Text box) |
| Number Of In House This Item This Year | The number of times a specified item has been shelved during the current fiscal year. (Text box) |
| Permanent Branch Loc Coll | The value contained in the Permanent Location field of the Item Record. (Menu) |
| Permanent Library Branch Loc | The value contained in the Permanent Location field of the Item Record, truncated to "branch" level only (Menu) |
| Permanent Library Loc | The value contained in the Permanent Location field of the Item Record, truncated to "library" level only (Menu) |
| Price | The value contained in the Cost field of the Item Record. (Text box) |
| Serials Day | The value contained in the Chronology – Day field of the Item Record. (Text box) |
| Serials Issue | The value contained in the Enumeration – Issue field of the Item Record. (Text box) |
| Serials Month | The value contained in the Chronology – Month field of the Item Record. (Text box) |
| Serials Number | The value contained in the Enumeration – Other field of the Item Record. (Text box) |
| Serials Part | The value contained in the Enumeration – Part field of the Item Record. (Text box) |
| Serials Season | The value contained in the Chronology – Season field of the Item Record. (Text box) |
| Serials Supp | The value contained in the Enumeration – Supplement field of the Item Record. (Text box) |
| Serials Volume | The value contained in the Enumeration – Volume field of the Item Record. (Text box) |
| Serials Year | The value contained in the Chronology – Year field of the Item Record. (Text box) |
| Status | The value contained in the Status field of the Item Record. (Menu) |
| Status Item Date |
The date (MM/DD/YYYY) on which the Item Record was last edited. (Date
entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Status Updateable System | The value contained in the Status field of the Item Record for statuses that can be updated by the system. (Menu) |
| Status Updateable User | The value contained in the Status field of the Item Record for statuses that can be updated by the user. (Menu) |
| Field Name | Definition (Entry Type) |
|---|---|
| AGCN | The Auto-Graphics Control Number for the title (Text box) |
| Author | The author of the title (usually derived from MARC Tag 100). (Text box) |
| Date Bib Record Added |
The date (MM/DD/YYYY) on which the bibliographic record was initially
added to the database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Bib Record Modified |
The date (MM/DD/YYYY) on which the bibliographic record was most recently
edited/modified. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Of Publication | The data of the title's publication (usually derived from MARC Tag 260$a). (Text box) |
| ISBN | The first International Standard Book Number for the title (usually derived from MARC Tag 020). (Text box) |
| ISSN | The first International Standard Serial Number for the title (usually derived from MARC Tag 022). (Text box) |
| Control Number (001) | The system Control Number for the title (taken from MARC Tag 001). (Text box) |
| Title | The title of the item (usually derived from MARC Tag 245$a). (Text box) |
| Field Name | Definition (Entry Type) |
|---|---|
| AGCN | The Auto-Graphics Control Number for the title (Text box) |
| Author | The author of the title (usually derived from MARC Tag 100). (Text box) |
| Date Bib Record Added |
The date (MM/DD/YYYY) on which the bibliographic record was initially
added to the database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Of Publication | The date of the title's publication (usually derived from MARC Tag 260$a). (Text box) |
| ISBN | The first International Standard Book Number for the title (usually derived from MARC Tag 020). (Text box) |
| ISSN | The first International Standard Serial Number for the title (usually derived from MARC Tag 022). (Text box) |
| Control Number (001) | The system Control Number for the title (taken from MARC Tag 001). (Text box) |
| Title | The title of the item (usually derived from MARC Tag 245$a). (Text box) |
| Field Name | Definition (Entry Type) |
| Address1 | The value specified in the Address 1 field of the User Record. (Text box) |
| Address2 | The value specified in the Address 2 field of the User Record. (Text box) |
| Alt Address1 | The value specified in the Alternate Address 1 field of the User Record. (Text box) |
| Alt Address2 | The value specified in the Alternate Address 2 field of the User Record. (Text box) |
| Alt City State Zip | The value specified in the Alternate Address 3 field of the User Record. (Text box) |
| Blocked Indicator |
The one-character abbreviation
for the value specified in the Blocked field of the User Record;
Y = Yes, N = No. (Text box) When entering a value as a search parameter, use the one-character abbreviation for the desired status. DO NOT enter the full name of the status. |
| Block Reason | The value contained in the Block Reason field of the User Record. (Text box) |
| Borrower Category | The value contained in the Patron Category field of the User Record. (Menu) |
| Borrower ID | The value specified in the Username or Barcode field of the User Record. (Text box) |
| Borrower Type |
One- or two-character code for the selected User Type(s) in the
User Record, as follows: (Text box)
A = PAC Staff
C = CAT Staff When entering a value for a single User Type, enter the code followed by a comma (e.g., VC,). When entering a value of two or more User Types as a search parameter, select Like as the "matching" type for the parameter, and enclose each User Type with the "%" wildcard (e.g., %S% %VC%). |
| Cell Phone | The value specified in the Mobile Phone field of the User Record. (Text box) |
| City | The value specified in the City field of the User Record. (Text box) |
| Comment | The value specified in the Comment field of the User Record. (Text box) |
| Country | The value specified in the Country field of the User Record. (Text box) |
| Date Added | The date (MM/DD/YYYY) on which the User
Record was initially added to the database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Updated | The date (MM/DD/YYYY) on which the User
Record was last edited. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Date Of Birth | The value specified in the Date of Birth field of the User Record. (Date entry calendar) |
| Date Registered | The date (MM/DD/YYYY) on which the User
Record was initially added to the database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Email Address | The value specified in the E-Mail field of the User Record. (Text box) |
| Expire Date | The value specified in the Expiration Date
field (MM/DD/YYYY) of the User Record. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the user's borrowing/access privileges will expire. |
|
Fax Phone |
The value contained in the FAX field of the User Record. (Text box) |
| First Name | The value specified in the First Name field of the User Record. (Text box) |
| Patron Group | The value contained in the Patron Group field of the User Record. (Menu) |
| Has Image | The one-character abbreviation for the value indicating whether or not content is entered in the Patron Image Name field of the User Record; Y = Yes, N = No. (Text box) |
| Home Branch | The value contained in the Home Location field of the User Record. (Menu) |
| Home Phone | The value specified in the Home Phone field of the User Record. (Text box) |
Last Charge Out Date |
The date (MM/DD/YYYY) on which a checkout transaction was most recently logged for the user. (Date entry calendar) When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the checkout transaction occurred. |
|
Last Fine Deposit Date |
The date (MM/DD/YYYY) on which a deposit of funds was most recently logged for the user. (Date entry calendar) When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the deposit occurred. |
|
Last Hold Date |
The date (MM/DD/YYYY) on which a Checkout Reserve transaction was most recently logged for the user. (Date entry calendar) When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the Checkout Reserve transaction occurred. |
| Last Name | The value specified in the Last Name field of the User Record. (Text box) |
|
Last Paid Date |
The date (MM/DD/YYYY) on which a payment for fines assessed was most recently logged for the user. (Date entry calendar) When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the payment occurred. |
|
Last Renewal Date |
The date (MM/DD/YYYY) on which a renewal transaction was most recently logged for the user. (Date entry calendar) When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the renewal transaction occurred. |
| Last Usage Date | The date (MM/DD/YYYY) on which the user most
recently logged into the system. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| [Library Defined Field 1] | The value contained in the Library Defined
Field 1 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 1, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 2] | The value contained in the Library Defined
Field 2 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 2, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 3] | The value contained in the Library Defined
Field 3 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 3, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 4] | The value contained in the Library Defined
Field 4 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 4, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 5] | The value contained in the Library Defined
Field 5 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 5, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 6] | The value contained in the Library Defined
Field 6 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 6, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 7] | The value contained in the Library Defined
Field 7 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 7, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 8] | The value contained in the Library Defined
Field 8 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 8, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 9] | The value contained in the Library Defined
Field 9 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 9, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 10] | The value contained in the Library Defined
Field 10 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 10, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 11] | The value contained in the Library Defined
Field 11 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 11, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 12] | The value contained in the Library Defined
Field 12 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 12, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 13] | The value contained in the Library Defined
Field 13 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 13, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 14] | The value contained in the Library Defined
Field 14 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 14, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 15] | The value contained in the Library Defined
Field 15 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 15, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 16] | The value contained in the Library Defined
Field 16 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 16, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 17] | The value contained in the Library Defined
Field 17 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 17, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 18] | The value contained in the Library Defined
Field 18 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 18, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 19] | The value contained in the Library Defined
Field 19 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 19, the "Search" and "Output" field menus will show the local label for the field. |
| [Library Defined Field 20] | The value contained in the Library Defined
Field 20 of the User Record. (Text box)
When a local label has been specified for Library Defined Field 20, the "Search" and "Output" field menus will show the local label for the field. |
| Message | The value contained in the Message field of the User Record. (Text box) |
| Middle Initial | The value specified in the Initial field of the User Record. (Text box) |
| Notes | The value specified in the Notes field of the User Record. (Text box) |
| Number Of Claims Return | The total number of items registered as "claimed returned" against the user’s account. (Text box) |
| Number Of Items Out | The total number of items currently checked out to the user. (Text box) |
| Number Of Lost | The total number of items registered as "lost" against the user’s account. (Text box) |
| Number Of Overdues | The total number of items currently checked out to the user for which the due date has expired. (Text box) |
| Phone1 | The value specified in the Phone 1 field of the User Record. (Text box) |
| Phone2 | The value specified in the Phone 2 field of the User Record. (Text box) |
| Sponsor | The value contained in the Sponsor field of the User Record. (Text box) |
| State | The two-character abbreviation for the value
specified in the State field of the User Record. (Text box)
When entering a value as a search parameter, use the two-character abbreviation for the desired state. DO NOT enter the full name of the state. |
| Total Number Of Circs | The total number of checkout transactions made to the user over the life of the account. (Text box) |
| Work Phone | The value contained in the Work Phone field in the User Record. (Text box) |
| Zip | The value specified in the Zip field of the User Record. (Text box) |
| Field Name | Definition (Entry Type) |
|---|---|
| Alternate Item ID | The value contained in the Alternate ID field of the Item Record. (Text box) |
| Barcode | The value contained in the Barcode field of the Item record. (Text box) |
| Call Number | The value contained in the Item Call Number field of the Item Record. |
| Call Number Prefix | The value contained in the Prefix field of the Item Record. (Text box) |
| Call Number Suffix | The value contained in the Suffix field of the Item Record. (Text box) |
| Comments | The value contained in the Comment field of the Item Record. (Text box) |
| Current Branch Loc Coll | The value contained in the Current Location field of the Item Record. (Menu) |
| Current Library Branch Loc | The value contained in the Current Location field of the Item Record, truncated to "branch" level only (Menu) |
| Current Library Loc | The value contained in the Current Location field of the Item Record, truncated to "library" level only (Menu) |
| Date Item Added |
The date (MM/DD/YYYY) on which the Item
Record was initially added to the database. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was added to the database. |
| Date Item Modified |
The date (MM/DD/YYYY) on which the Item
Record was last edited. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Date Inventoried |
The date (MM/DD/YYYY) on which the item was
most recently inventoried. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the item was inventoried. |
| Item Exception Type | The value contained in the Status field of the Item Record. (Menu) |
| Item Notes | The value contained in the Circ Note field of the Item Record. (Text box) |
| Last Activity Date |
The date (MM/DD/YYYY) on which the most
recent Cataloging or Circulation activity for the Item Record or the
associated item occurred. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the activity occurred. |
| Last Checkout Date |
The date (MM/DD/YYYY) on which a checkout
transaction was most recently logged for the item. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the checkout transaction occurred. |
| Material Type | The value contained in the Material Type field of the Item Record. (Menu) |
| Number Of Circ All Items Last Year | The number of times all items associated with a specified title was checked out during the previous fiscal year. (Text box) |
| Number Of Circ All Items This Year | The number of times all items associated with a specified title have been checked out during the current fiscal year. (Text box) |
| Number Of Circ This Item Last Year | The number of times a specified item was checked out during the previous fiscal year. (Text box) |
| Number Of Circ This Item This Year | The number of times a specified item has been checked out during the current fiscal year. (Text box) |
| Number Of In House All Items Last Year | The number of times all items associated with a specified title was shelved during the previous fiscal year. (Text box) |
| Number Of In House All Items This Year | The number of times all items associated with a specified title have been shelved during the current fiscal year. (Text box) |
| Number Of In House This Item Last Year | The number of times a specified item was shelved during the previous fiscal year. (Text box) |
| Number Of In House This Item This Year | The number of times a specified item has been shelved during the current fiscal year. (Text box) |
| Permanent Branch Loc Coll | The value contained in the Permanent Location field of the Item Record. (Menu) |
| Permanent Library Branch Loc | The value contained in the Permanent Location field of the Item Record, truncated to "branch" level only (Menu) |
| Permanent Library Loc | The value contained in the Permanent Location field of the Item Record, truncated to "library" level only (Menu) |
| Price | The value contained in the Cost field of the Item Record. (Text box) |
| Serials Day | The value contained in the Chronology – Day field of the Item Record. (Text box) |
| Serials Issue | The value contained in the Enumeration – Issue field of the Item Record. (Text box) |
| Serials Month | The value contained in the Chronology – Month field of the Item Record. (Text box) |
| Serials Number | The value contained in the Enumeration – Other field of the Item Record. (Text box) |
| Serials Part | The value contained in the Enumeration – Part field of the Item Record. (Text box) |
| Serials Season | The value contained in the Chronology – Season field of the Item Record. (Text box) |
| Serials Supp | The value contained in the Enumeration – Supplement field of the Item Record. (Text box) |
| Serials Volume | The value contained in the Enumeration – Volume field of the Item Record. (Text box) |
| Serials Year | The value contained in the Chronology – Year field of the Item Record. (Text box) |
| Status | The value contained in the Status field of the Item Record. (Menu) |
| Status Item Date |
The date (MM/DD/YYYY) on which
the Item Record was last edited. (Date entry calendar)
When selected as an output field, includes the time of day (HH:MM:SS AM/PM) at which the record was edited. |
| Status Updateable System | The value contained in the Status field of the Item Record for statuses that can be updated by the system. (Menu) |
| Status Updateable User | The value contained in the Status field of the Item Record for statuses that can be updated by the user. (Menu) |
| Field Name | Definition (Entry Type) |
|---|---|
| Author | The value contained in the Author field of the order. (Text box) |
| Branch Distribution List | The value contained in the Select Distribution List field of the order. (Menu) |
| Default Fund | The value contained in the Default Fund field of the order. (Menu) |
| Create Bib | The one-character abbreviation indicating whether or not a bibliographic record was created for the ordered item; Y = Yes, N = No. (Text box) |
| Create Item | The one-character abbreviation indicating whether or not an item record was created for the ordered item; Y = Yes, N = No. (Text box) |
| Fiscal Year | The value contained in the Fiscal Year field of the order. (Menu) |
| Material Type | The value contained in the Material Type field of the order. (Menu) |
| Order Number | The value contained in the Order Number field of the order. (Text box) |
| Transmit Mechanism | The value contained in the Order Transmission Method field of the order. (Menu) |
| Order Type | The value contained in the Type of Order field of the order. (Menu) |
| Price | The value contained in the Price field of the order. (Text box) |
| Quantity | The value contained in the Item Detail – Quantity field of the order for a given location for which items are ordered. (Text box) |
| Requestor | The value contained in the Item Detail – Requestor field of the order for a given location for which items are ordered. (Text box) |
| Title | The value contained in the Title field of the order. (Text box) |
| Total Quantity | The sum of the values contained in the Item Detail – Quantity fields of the order for all locations for which items are ordered. (Text box) |
| Unit Destination Branch | The value contained in the Item Detail – Branch field of the order for a given location for which items are ordered. (Menu) |
| Unit Destination Location Collection | The value contained in the Item Detail – Location field of the order for a given location for which items are ordered. (Menu) |
| Unit Fiscal Year | The value contained in the Item Detail – Fiscal Year field of the order for a given location for which items are ordered. (Menu) |
| Unit Fund | The value contained in the Item Detail – Fund field of the order for a given location for which items are ordered. (Menu) |
| Vendor | The value contained in the Vendor field of the order. (Menu) |