Report objects Q-Z
View all report objects Q-Z available to build custom report queries and to retrieve data for custom and standard reports.
| R S T U V W Y R |
Received Date
| Description | The date and time a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Received Day
| Description | The enumerated day (1-31) of the month a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Received Day Name
| Description | The day of the week (e.g., Wednesday) a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Received Month
| Description | The enumerated month of the year (1-12) a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Received Month Name
| Description | The month name (e.g., November) a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Received User Full Name
| Description | The user's full name that received an item. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Received Year
| Description | The year a copy of an ordered item was received by the institution. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Record View Count
| Description | Count of the record views after search. Data comes from the external provider COUNTER DB1 reports. |
| Type | Measure |
| Universe | E-Resources COUNTER 4 |
| Appears in | COUNTER 4 Merged Database Usage Detail | COUNTER 4 Merged Database Usage Summary | COUNTER 4 Merged Vendor Usage Detail |
Regular Search Count
| Description | The number of times an item is searched using the regular search method, which excludes searches attributed to automated search processes and federated searches. |
| Type | Measure |
| Universe | E-Resources COUNTER 4 |
| Appears in | COUNTER 4 Merged Database Usage Detail | COUNTER 4 Merged Database Usage Summary | COUNTER 4 Merged Vendor Usage Detail |
Remaining Fund %
| Description | =If([Budgeted Amount]=0 Or [Fund Balance] =0) Then 0 Else [Remaining Fund %] |
| Type | Measure |
| Universe | Acquisitions |
| Appears in | Fund Balance |
Remaining Fund Balance
| Description | =[Budgeted Amount]-[Fund Encumbered Amount]-[Fund Expended Amount] |
| Type | Measure |
| Universe | Acquisitions |
| Appears in | Fund Balance |
Removed Group Titles
| Description | The number of titles that an institution no longer has their OCLC symbol attached to, for a given timeframe. |
| Type | Measure |
| Universe | Group Activity |
| Appears in | Count of New and Removed Group Titles |
Removed Titles
| Description | The number of titles that an institution no longer has their OCLC symbol attached to, for a given time frame. |
| Type | Measure |
| Universe | Cataloging |
| Appears in |
Reports
| Description | List of standard reports that are derived from the source data, e.g., the Open Holds Report is derived from the Circulation Hold Request. |
| Type | Dimensions |
| Universe | Data Refresh Activity |
| Appears in | Acquisitions Data Last Refreshed | Cataloging Data Last Refreshed | Circulation Data Last Refreshed | E-Resources Data Last Refreshed | Group Data Last Refreshed |
Request Closed Date/Time
| Description | The system date and time when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Closed Date Day
| Description | The enumerated day (1-31) of the month when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Closed Date Day Name
| Description | The day of the week (e.g., Wednesday) when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Closed Date Month
| Description | The enumerated month of the year (e.g., 11) when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Closed Date Month Name
| Description | The month name (e.g., November) when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Closed Date Year
| Description | The year when the request moved from active to closed. Requests are closed as a result of being supplied, cancelled, exhausted, or expired. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copy/Loan Indicator
| Description | Identifies if the lender fulfilled the request as a copy or loan. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date/Time
| Description | The date and time when a borrowing institution pledged payment for a copy that has been shipped by a lending institution.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date Day
| Description | The enumerated day (1-31) of the month when a borrowing institution pledged payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date Day Name
| Description | The day of the week (e.g., Wednesday) when a borrowing institution pledged payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date Month
| Description | The enumerated month of the year (e.g., 11) when a borrowing institution pledged payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date Month Name
| Description | The month name (e.g., November) when a borrowing institution pledged payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Committed Date Year
| Description | The year when a borrowing institution pledged payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Compliance Type
| Description | Indicates which guidelines or law that borrowing staff have used to determine copyright compliance, e.g., US_CCG, US_CCL, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Fee Amount
| Description | Monetary amount that the borrowing institution pledges as payment for a copy that has been shipped by a lending institution. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Fee Currency
| Description | Currency of the amount that the borrowing institution pledges as payment for a copy that has been shipped by a lending institution, e.g., UNITED_STATES_DOLLAR. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Copyright Permission Type
| Description | The copyright clearance selection made by the borrowing institution, e.g., FAIR_USE, WILL_PAY, OTHER_CCG, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Count
| Description | The total number of requests created in or submitted to OCLC's ILL network. |
| Type | Measure |
| Universe | Interlibrary Loan |
| Appears in |
Request Created Date/Time
| Description | The date and time when the patron or borrowing institution created the request.
Note: ILL requests created on or after 19 March 2023 will display the time based on your local time zone. ILL requests created before 19 March 2023 will display the midnight hour (00:00:00) UTC of the day the request was created. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Created Date Day
| Description | The enumerated day (1-31) of the month when the patron or borrowing institution created the request. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Created Date Day Name
| Description | The day of the week (e.g., Wednesday) when the patron or borrowing institution created the request. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Created Date Month
| Description | The enumerated month of the year (e.g., 11) when the patron or borrowing institution created the request. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Created Date Month Name
| Description | The month name (e.g., November) when the patron or borrowing institution created the request. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Created Date Year
| Description | The year when the patron or borrowing institution created the request. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Disposition
| Description | The ILL system-supplied, secondary status of the request, e.g., SCANNING, SHIPPED_MISSING, OVERDUE, SUPPLIED, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date/Time
| Description | The system date and time when a request exhausted the lender string before the borrower's need-before date.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date Day
| Description | The enumerated day (1-31) of the month when a request exhausted the lender string before the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date Day Name
| Description | The day of the week (e.g., Wednesday) when a request exhausted the lender string before the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date Month
| Description | The enumerated month of the year (e.g., 11) when a request exhausted the lender string before the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date Month Name
| Description | The month name (e.g., November) when a request exhausted the lender string before the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Exhausted Date Year
| Description | The year when a request exhausted the lender string before the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Expired Date/Time
| Description | The system date and time when an active ILL request met or exceeded the borrower's need-before date.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Expired Date Day
| Description | The enumerated day (1-31) of the month when an active ILL request met or exceeded the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Expired Date Day Name
| Description | The day of the week (e.g., Wednesday) when an active ILL request met or exceeded the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Expired Date Month
| Description | The enumerated month of the year (e.g., 11) when an active ILL request met or exceeded the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Expired Date Month Name
| Description | The month name (e.g., November) when an active ILL request met or exceeded the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Expired Date Year
| Description | The year when an active ILL request met or exceeded the borrower's need-before date. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Fulfillment Type
| Description | Method by which the patron's request was fulfilled, e.g., OCLC-ILL, DOCUMENT_DELIVERY, OPEN_ACCESS, PURCHASE, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Article Author
| Description | Individual or corporate entity responsible for the production of an article in a serial, book chapter, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Article Issue
| Description | The number assigned by the publisher to a separately published part of a serial publication, to distinguish it from other parts issued at different times. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Article Issue Date
| Description | The specific date or season when a particular issue of a serial was published, e.g., July 2010, Summer 2010, 2010-07-01, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Article Pages
| Description | A number assigned in sequence to a page in a manuscript, book, pamphlet, periodical, etc., to facilitate reference. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Article Title
| Description | The descriptive name used to identify an article in a serial, book chapter, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Article Volume
| Description | The number or other identifier assigned to all the issues of a periodical published during a given publication period. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Author
| Description | Individual or corporate entity responsible for the production of a work. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Bib Level
| Description | Derived from MARC leader position 07, the bibliographic level of the record, e.g., Monograph/Item, Serial, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Dewey Call Number
| Description | Classification of books and other publications utilizing the Dewey Decimal system. It uses the numbers 000 to 999 to cover the general fields of knowledge and subdivides each field by the use of decimals and letters. Named after its inventor, Melvil Dewey. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Dewey Division Number
| Description | The second level of subdivision in the DDC, represented by the first two digits in the notation, e.g., 62 in 620 Engineering and allied operations. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Dewey Main Class Number
| Description | One of the ten major subdivisions of the DDC, represented by the first digit in the notation, e.g., 600. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Dissertation Note
| Description | Note related to a dissertation or thesis. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item DOI
| Description | Digital Object Identifier that persistently identifies and facilitates access to a piece of intellectual property on a digital network, irrespective of its current location. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Edition
| Description | A specific version of a work (e.g., the seventeenth edition of Webster's Dictionary). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Edition Preference
| Description | The borrowing institution's preferred edition of the item, e.g., ANY, THIS, or RECENT. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Imprint
| Description | The publishing company and the date and place of publication of the requested item, e.g., Singapore : World Scientific, ©2013. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item ISBN
| Description | International Standard Book Number - is a unique numeric commercial book identifier. The old format is 10 digits, the new format is 13 digits. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item ISSN
| Description | An International Standard Serial Number (ISSN) is a unique eight-digit number used to identify a periodical publication at a specific media type. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Language
| Description | The primary language in which a work is published. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item LC Call Number
| Description | Value that defines the classification of an item on the shelf in the library according to the Library of Congress scheme. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item LC Main Class Category
| Description | Library of Congress classification letter code, which is the highest level in the LC classification scheme, e.g., P. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item LC Subclass Category
| Description | Library of Congress subclass classification code - the second level in the LC classification scheme, e.g., PS. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Material Format
| Description | A category of an item that defines the physical or digital nature of the item (e.g., book, CD, eBook, etc.). (Also known as material type) |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail | Document Delivery Request Status |
Request Item NLM Call Number
| Description | Value that defines the classification of an item on the shelf in the library according to the NLM (National Library of Medicine) scheme. It uses the letters Q to W to cover the general fields of knowledge and subdivides each field by the use of decimals and letters. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item OCLC Number
| Description | The OCLC Control Number is a unique, sequentially assigned number associated with a record in WorldCat. The number is included in a WorldCat record when the record is created. The OCLC Control Number enables successful implementation and use of many OCLC products and services, including WorldCat Discovery and WorldCat Navigator. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item PMID
| Description | The unique identifier assigned to a bibliographic record in the National Library of Medicine's PubMed database. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Universe | Interlibrary Loan |
Request Item Publication Date
| Description | Date resource was published. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Series Note
| Description | Note related to a collection of related titles or items. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Title
| Description | The descriptive name used to identify an intellectual work such as a book, film or other composition. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Item Uniform Title
| Description | Controlled, distinctive title that represents a work issued under more than one title. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Item Verification
| Description | Details pertaining to the source of the citation or request, physical description of the requested item, etc. For example: WorldCat (49942201) Physical Description: 211 pages ; 22 cm. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Patron Department
| Description | The patron department supplied by the borrowing library or patron. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail | Document Delivery Request Statistics |
Request Patron Max Cost
| Description | Maximum monetary amount that the patron was willing to pay for the borrowed item. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Universe | Interlibrary Loan |
Request Patron Max Cost Currency
| Description | Currency of the maximum amount that the patron was willing to pay for the item, e.g., UNITED_STATES_DOLLAR. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Patron Pickup Location
| Description | The library branch or location at which an item that fulfills an ILL request should be help for pickup by the patron. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Patron Status
| Description | The patron status supplied by the borrowing library or patron in the request, e.g., Undergraduate, Adult, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail | Document Delivery Request Statistics |
Request Produced Date/Time
| Description | The system date and time (in US Easter Time) when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Date Day
| Description | The enumerated day (1-31) of the month when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Date Day Name
| Description | The day of the week (e.g., Wednesday) when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Date Month
| Description | The enumerated month of the year (e.g., 11) when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Date Month Name
| Description | The month name (e.g., November) when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Date Year
| Description | The year when the borrowing institution or system process (e.g., automation) submitted the ILL request to potential lenders. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Produced Type
| Description | Indicates if the request was created by library staff (STAFF), created by the patron and submitted directly to lenders without staff intervention (UNMEDIATED), or created by the patron and submitted to lenders after some staff intervention (STAFF MEDIATED). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Filled Count
| Description | The number of purchase requests (Request Fulfillment Type of either PURCHASE or ACQUISITIONS) completed in the ILL system. |
| Type | Measure |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date/Time
| Description | The date and time when the purchase order was submitted.
Note: ILL requests created/updated on or after 19 March 2023 will display the time based on your local time zone. ILL requests created/updated before 19 March 2023 will display the time in UTC (Universal Time Coordinated). |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date Day
| Description | The enumerated day (1-31) of the month when the purchase order was submitted. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date Day Name
| Description | The day of the week (e.g., Wednesday) when the purchase order was submitted. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date Month
| Description | The enumerated month of the year (e.g., 11) when the purchase order was submitted. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date Month Name
| Description | The month name (e.g., November) when the purchase order was submitted. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Date Year
| Description | The year when the purchase order was submitted. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Number
| Description | The vendor order number recorded in the ILL system for a purchased item. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Price
| Description | The monetary amount recorded in the ILL system for a purchased item. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Purchase Order Vendor Name
| Description | The name of the vendor from which the borrowing institution has purchased an item in the ILL system. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request Source System
| Description | The system where the request was created, e.g. WSILL (WorldShare ILL), ILLIAD, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in | Document Delivery Request Detail |
Request Status
| Description | The ILL system-supplied status of the request, e.g., RECEIVED, CLOSED, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Request URL Type
| Description | Indicates the type of fulfillment link provided for copy requests, e.g., ARTICLE_EXCHANGE, OPEN_ACCESS, KNOWLEDGE_BASE, etc. |
| Type | Dimension |
| Universe | Interlibrary Loan |
| Appears in |
Requestor Name
| Description | Patron that has requested an order item. If null, then no patron has requested this order item. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in | Open Encumbrances | Payment Activity by Material Format | Payment Activity by Requestor | Title Copy Detail Report |
Resource Metadata Type
| Description | The type or source of the resource metadata, including WorldCat, the WorldCat knowledge base (for eProducts), or User Entered. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Result Click Count
| Description | The count of user-initiated requests for a resource, typically for a journal, book, multimedia, article, or collection. |
| Type | Measure |
| Universe | E-Resources COUNTER 4 |
| Appears in | COUNTER 4 Merged Database Usage Detail | COUNTER 4 Merged Database Usage Summary | COUNTER 4 Merged Vendor Usage Detail |
Schedule Created Date/Time
| Description | The date and time when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Created Day
| Description | The enumerated day (1-31) of the month when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Created Day Name
| Description | The day of the week (e.g., Wednesday) when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Created Month
| Description | The enumerated month of the year (e.g., 11) when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Created Month Name
| Description | The month name (e.g., November) when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Created Year
| Description | The year when the schedule was created. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Date/Time
| Description | The date and time when the schedule will expire. This date may also be set when a schedule is cancelled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Day
| Description | The enumerated day (1-31) of the month when the schedule will expire. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Day Name
| Description | The day of the week (e.g., Wednesday) when the schedule will expire. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Month
| Description | The enumerated month of the year (e.g., 11) when the schedule will expire. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Month Name
| Description | The month name (e.g., November) when the schedule will expire. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Expiration Year
| Description | The year when the schedule will expire. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Date/Time
| Description | The date and time when the item is needed. Displayed as 'Time for Pickup' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Day
| Description | The enumerated day (1-31) of the month when the item is needed. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Day Name
| Description | The day of the week (e.g., Wednesday) when the item is needed. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Month
| Description | The enumerated month of the year (e.g., 11) when the item is needed. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Month Name
| Description | The month name (e.g., November) when the item is needed. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule From Year
| Description | The year when the item is needed. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Institution Name
| Description | Organization (e.g., library, museum, or consortium) where the schedule was fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Institution Symbol
| Description | The three or five-character code assigned by OCLC to identify a member institution. This is often referred to as the OCLC symbol. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Last Modified Date/Time
| Description | The date and time when the schedule was last modified. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Note
| Description | A staff note that relates to a schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pickup Branch Location
| Description | The service location at a library branch at which an item that fulfills a schedule request should be hold for pickup by the patron. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pickup Branch Name
| Description | The library branch at which an item that fulfills a schedule request should be held for pickup by the patron. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Date/Time
| Description | The end of the embargo period for the item. During the embargo, the item is not available for circulation. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Day
| Description | The enumerated day (1-31) of the month when the embargo period ends. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Day Name
| Description | The day of the week (e.g., Wednesday) when the embargo period ends. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Month
| Description | The enumerated month of the year (e.g., 11) when the embargo period ends. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Month Name
| Description | The month name (e.g., November) when the embargo period ends. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Post-Embargo Year
| Description | The year when the embargo period ends. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Date/Time
| Description | The start of the embargo period. During the embargo, the item is not available for circulation. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Day
| Description | The enumerated day (1-31) of the month when the embargo period starts. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Day Name
| Description | The day of the week (e.g., Wednesday) when the embargo period starts. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Month
| Description | The enumerated month of the year (e.g., 11) when the embargo period starts. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Month Name
| Description | The month name (e.g., November) when the embargo period starts. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Pre-Embargo Year
| Description | The year when the embargo period starts. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule Staff Full Name
| Description | The full name (given name and surname) of the staff member who scheduled the item. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Date/Time
| Description | The date and time that the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Day
| Description | The enumerated day (1-31) of the month when the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Day Name
| Description | The day of the week (e.g., Wednesday) when the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Month
| Description | The enumerated month of the year (e.g., 11) when the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Month Name
| Description | The month name (e.g., November) when the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Schedule To Year
| Description | The year when the item must be returned at the end of the scheduled period. Displays as 'Due Date' in the Circulation application. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Date/Time
| Description | The date and time when the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Day
| Description | The enumerated day (1-31) of the month when the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Day Name
| Description | The day of the week (e.g., Wednesday) when the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Month
| Description | The enumerated month of the year (e.g., 11) when the the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Month Name
| Description | The month name (e.g., November) when the the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Fulfill Year
| Description | The year when the item was checked in, fulfilling the schedule. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Date/Time
| Description | The date and time when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Day
| Description | The enumerated day (1-31) of the month when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Day Name
| Description | The day of the week (e.g., Wednesday) when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Month
| Description | The enumerated month of the year (e.g., 11) when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Month Name
| Description | The month name (e.g., November) when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Pull Year
| Description | The year when the scheduled item will appear on the Pull List if the item is in Available status. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Date/Time
| Description | The date and time when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Day
| Description | The enumerated day (1-31) of the month when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Day Name
| Description | The day of the week (e.g., Wednesday) when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Month
| Description | The enumerated month of the year (e.g., 11) when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Month Name
| Description | The month name (e.g., November) when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Recall Year
| Description | The year when a scheduled item is recalled from the patron to whom it is currently checked out so that the schedule can be fulfilled. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Item Status
| Description | The current circulation state of a scheduled item (e.g., Available, On Loan, etc.). |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduled Items Count
| Description | The total number of items scheduled. |
| Type | Measure |
| Universe | Circulation Scheduled Items |
| Appears in |
Scheduling Policy Name
| Description | The name of the policy that specifies the conditions under which a library item is scheduled for use by a patron. The scheduling policy specifies the embargo period, recall and pull dates, and notification policy for schedules created for a specific patron borrower category, material format, etc. |
| Type | Dimension |
| Universe | Circulation Scheduled Items |
| Appears in |
Secondary Library Type
| Description | Sub-category of Primary Library Type that further describes the library, e.g., private/independent, library school, medical, cooperative/consortium/process, etc. |
| Type | Dimension |
| Universe | Group Activity | Institution Title Holdings | LHR Item Detail |
| Appears in |
Serial Receiving Status
| Description | Value that determines the receiving state of a serial item. Includes Received, Claimed, or Stopped Claiming. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Date
| Description | The date a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Day
| Description | The enumerated day (1-31) of the month a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Day Name
| Description | The day of the week (e.g., Wednesday) a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Month
| Description | The enumerated month of the year (1-12) a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Month Name
| Description | The month name (e.g., November) a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Serials Received Year
| Description | The year a serial was received by the institution. |
| Type | Dimension |
| Universe | Serials Received |
| Appears in |
Series Statement
| Description | From the 490 $a of the bibliographic record, a series statement for a series title, statement of responsibility, etc. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail |
| Appears in |
Settled Item Barcode
| Description | The unique, machine readable code used to identify the item when performing library functions such as check in, check out, etc. |
| Type | Dimension |
| Universe | Circulation Fiscal Transactions |
| Appears in | Fiscal Detail Report |
Settled Item Title
| Description | The descriptive name used to identify an intellectual work such as a book, film or other composition. |
| Type | Dimension |
| Universe | Circulation Fiscal Transactions |
| Appears in | Fiscal Detail Report |
Shelving Location
| Description | The location within a branch where an item is shelved. |
| Type | Dimension |
| Universe | Acquisitions | Cataloging |
| Appears in | Branch Item Holdings by Shelving Location | New Titles List | Open Encumbrances | Payment Activity by Classification | Payment Activity by Fund | Payment Activity by Location | Payment Activity by Material Format | Payment Activity by Processing Type | Payment Activity by Requestor | Payment Activity by Vendor | Receiving Activity by Location | Removed Titles List | Title Copy Detail Report |
Shelving Scheme
| Description | Determines the classification to use to organize an item on the shelf. Possible values include: Library of Congress, Dewey, National Library of Medicine. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in | Payment Activity by Classification | Title Copy Detail Report |
Shipping Type
| Description | Type or method of shipping chosen by the Institution for the items on an order (e.g. standard, next day, air mail, etc.). |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in | Vendor Performance |
Source Application
| Description | Process name for the application that performed some action (e.g. RECORD MANAGER, WMS, OCLC PROCESSING, etc.) |
| Type | Dimension |
| Universe | Cataloging | Group Activity |
| Appears in | Count of New and Removed Group Titles | New Titles List | Removed Titles List |
Source Data
| Description | Name of the data set that supplies data for reports, e.g., Circulation Events, Cataloging Title Volatility, etc. |
| Type | Dimension |
| Universe | Data Refresh Activity |
| Appears in | Acquisitions Data Last Refreshed | Cataloging Data Last Refreshed | Circulation Data Last Refreshed | E-Resources Data Last Refreshed | Group Data Last Refreshed |
Staff Order Item Notes
| Description | Note for an order item entered by the library to designate special instructions or facts about this item. Multiple notes are concatenated using a pipe (|) delimiter. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Staff-Received Request Count
| Description | The number of ILL requests that were manually marked as received by the borrowing institution. |
| Type | Measure |
| Universe | Interlibrary Loan |
| Appears in |
Statistics Value
| Description | Value representing the number of volumes being received for a specific order item. This value is used for generating statistics for the total number of volumes for the library. It must be enabled by Customer Support to display in Acquisitions. The default value is 1. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Subscription End Date
| Description | The date the order item's subscription ends, e.g., 2017-12-31. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Subscription Principal ID
| Description | Identifier assigned automatically by the system to all subscription order items that are renewals of the same original subscription item, e.g., 41846. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Subscription Renewal Count
| Description | The number of times the subscription has been renewed. At the Order Item level, a numeric value of one (1) indicates a renewed subscription item. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Subscription Renewal Setting
| Description | Value on a subscription order that indicates whether the institution plans to renew the subscription or not, e.g., RENEW, DO_NOT_RENEW, DO_NOT_RENEW_UNDER_REVIEW. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Subscription Renewal Status
| Description | The value that indicates if a subscription item has been renewed or not, i.e. Renewed or Not Renewed. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Subscription Start Date
| Description | The date the order item's subscription ends, e.g., 2017-01-01. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
System Invoice Number
| Description | Identifier generated by the system and used by the WorldShare Platform to uniquely identify an invoice (e.g. INV-2014-1). |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in | Paid Invoice Summary Report | Paid Invoice Item Detail Report | Title Copy Detail Report |
Tax Calculation Method
| Description | The method by which the tax of an item is calculated. Determines primarily whether service and shipping charges are included with the unit price when calculating the tax amount. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Time to Fulfillment
| Description | Number of days from the date the item was ordered to the date the item was received. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in | Vendor Performance |
Time to Fill
| Description | =If(DaysBetween(CurrentDate();[Hold On Hold Date])>-10000;(DaysBetween([Hold Request Placed Date];[Hold On Hold Date]));"N/A") |
| Type | Dimension |
| Universe | Circulation Hold Request |
| Appears in |
Title
| Description | The descriptive name used to identify an intellectual work such as a book, film or other composition. Unique by OCLC number. |
| Type | Dimension |
| Universe | Acquisitions | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail | Overlap | Serials Received |
| Appears in | New Titles List | Open Encumbrances | Paid Invoice Item Detail Report | Removed Titles List | Serials Received Summary Report | Title Copy Detail Report | Titles Held by a Single Institution |
Title eISSN
| Description | An Electronic International Standard Serial Number (ISSN) is a unique eight-digit number used to identify an electronic periodical publication. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail |
| Appears in |
Title EISSN
| Description | An Electronic International Standard Serial Number (ISSN) is a unique eight-digit number used to identify an electronic periodical publication. |
| Type | Dimension |
| Universe | Overlap |
| Appears in |
Title Holding Added Date
| Description | The date and time a title was added to an institution's collection. |
| Type | Dimension |
| Universe | Cataloging | Institution Title Holdings |
| Appears in | Titles Held by a Single Institution |
Title Holding Added Day Name of Week
| Description | Name of the day (e.g., Wednesday). |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Added Day of Month
| Description | Numeric value representing the day of month. |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Added Month Name
| Description | Name of the month. |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Added Month Number
| Description | Numeric value representing the month of the year (e.g., 12). |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Added Year
| Description | Numeric value representing the year (e.g., 2015). |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Added Year Month
| Description | The date and time a title was added to an institution's collection. |
| Type | Dimension |
| Universe | Institution Title Holdings |
| Appears in |
Title Holding Removed Date
| Description | The date and time a title was removed from an institution's collection. |
| Type | Dimension |
| Universe | Cataloging |
| Appears in |
Title Holdings Quantity
| Description | The number of titles held by an institution. A title is a distinct OCLC number (one title has many items). |
| Type | Measure |
| Universe | Cataloging |
| Appears in | Title Holdings by Material Format |
Title ISBN
| Description | International Standard Book Number is a unique numeric commercial book identifier. The old format is 10 digits, and the new format is 13 digits. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail | Overlap |
| Appears in | Titles Held by a Single Institution |
Title ISSN
| Description | An International Standard Serial Number (ISSN) is a unique eight-digit number used to identify a periodical publication at a specific media type. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail | Overlap |
| Appears in | Titles Held by a Single Institution |
Title ISSNL
| Description | A Linking International Standard Serial Number (ISSN) is a unique eight-digit number used to identify a periodical publication at a specific media type. This could be a series of ISSN numbers linked to this publication. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail | Overlap |
| Appears in |
Title Limit Exceeded Denials (TR_B2 & TR_J2)
| Description | The number of times access to an eJournal or eBook was denied because the licensed simultaneous-user limit for the user's institution was exceeded. Sourced from the TR_J2 and TR_B2 reports. |
| Type | Measure |
| Universe | E-Resources COUNTER 5 |
| Appears in | COUNTER 5 Merged E-Journal/E-Book Usage Detail | COUNTER 5 Merged E-Journal/E-Book Usage Summary |
Title No License Denials (TR_B2 & TR_J2)
| Description | The number of times access to an eJournal or eBook was denied because the user's institution did not have a license to the content. Sourced from the TR_J2 and TR_B2 reports. |
| Type | Measure |
| Universe | E-Resources COUNTER 5 |
| Appears in | COUNTER 5 Merged E-Journal/E-Book Usage Detail | COUNTER 5 Merged E-Journal/E-Book Usage Summary |
Titles Net Change
| Description | Calculated measure, diff of Added Titles and Removed Titles. |
| Type | Measure |
| Universe | Group Activity |
| Appears in | Count of New and Removed Group Titles |
Total Access Denial Count
| Description | Count of turnaways typically due to simultaneous user limit exceeded or requests for access to items that have not been adequately licensed. |
| Type | Measure |
| Universe | E-Resources COUNTER 4 |
| Appears in |
Total Amount Expended Including Child Funds
| Description | =If ( ([Fund Name Level 2]="") ) Then ( [Expended Amount]) ForAll ([Fund Name Level 2];[Fund Name Level 3];[Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 3]="") Then [Expended Amount] ForAll ([Fund Name Level 3];[Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 4]="") Then [Expended Amount] ForAll ([Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 5]="") Then [Expended Amount] ForAll ([Fund Name Level 5]) Else [Expended Amount] |
| Type | |
| Universe | Acquisitions |
| Appears in | Payment Activity by Fund |
Total (Avg)
| Description | =Round((([Items Checked In]+[Items Checked Out]+[Bills Created]+[Holds Fulfilled]+[Items Soft Checked Out]+[Bills Paid]+[Items Received]+[Items Renewed]+[Bills Waived])/[Day Count]);2) |
| Type | |
| Universe | Circulation Events |
| Appears in | Hourly Average Circulation Activity Summary Report |
Total Copies Expended Including Child Funds
| Description | =If ( ([Fund Name Level 2]="") ) Then ( [Copies Expended]) ForAll ([Fund Name Level 2];[Fund Name Level 3];[Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 3]="") Then [Copies Expended] ForAll ([Fund Name Level 3;[Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 4]="") Then [Copies Expended] ForAll ([Fund Name Level 4];[Fund Name Level 5]) ElseIf ( [Fund Name Level 5]="") Then [Copies Expended] ForAll ([Fund Name Level 5]) Else [Copies Expended] |
| Type | |
| Universe | Acquisitions |
| Appears in | Payment Activity by Fund |
Total Fund Amount Budgeted
| Description | Sum of amount budgeted for a fund and all its child funds. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Total Fund Amount Encumbered
| Description | Sum of amount encumbered for a fund and all its child funds. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Total Fund Amount Expended
| Description | Sum of amount expended for a fund and all its child funds. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Total Fund Future Encumbered Amount
| Description | The sum of the future encumbered amounts for a fund and all its child funds. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Total Fund Prepaid Amount
| Description | The sum of the prepaid amounts for a fund and all its child funds. |
| Type | Measure |
| Universe | Acquisitions |
| Appears in |
Totals
| Description | =[Items Checked Out]+[Items Renewed]+[Holds Fulfilled]+[Items Soft Checked Out] |
| Type | |
| Universe | Circulation Events |
| Appears in | High Use Circulation Titles Summary Report | Monthly Circulation Statistics Report |
Totals greater than
| Description | =[Items Checked Out]+[Items Renewed]+[Holds Fulfilled]+[Items Soft Checked Out] |
| Type | |
| Universe | Circulation Events |
| Appears in |
Turnaway Access Denial Count
| Description | Number of times users were denied access to an electronic resource because the simultaneous user limit allowed by a license was exceeded. |
| Type | Measure |
| Universe | E-Resources COUNTER 4 |
| Appears in |
Uniform Title Added Entry
| Description | From the 730 $a of the bibliographic record, a preferred title used as an access point that may not be more appropriately assigned as fields 130, 630, or 830. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail |
| Appears in |
Uniform Title Main Entry
| Description | From the 130 $a of the bibliographic record, the preferred title access point used to bring together bibliographic entries for a work when various expressions or manifestations have appeared under different titles. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail |
| Appears in |
Unique Title Count
| Description | The number of titles held by only one group member. |
| Type | Measure |
| Universe | Group Titles |
| Appears in |
Unique Titles
| Description | Do not use. |
| Type | Filter |
| Universe | Institution Title Holdings |
| Appears in |
Unique Titles Count
| Description | The count of unique titles (unique OCLC Numbers) for a given dataset. |
| Type | Measure |
| Universe | LHR Item Detail |
| Appears in |
Universal Decimal Classification (UDC) Number
| Description | From the 080 $a of the bibliographic record, the number taken from the Universal Decimal Classification (UDC) scheme. |
| Type | Dimension |
| Universe | Cataloging | Group Activity | Group Titles | Institution Title Holdings | LHR Item Detail |
| Appears in |
User Filter
| Description | Do not use. |
| Type | Filter |
| Universe | Serials Received |
| Appears in |
User First Name
| Description | The first name of the user that executed the report. |
| Type | Dimension |
| Universe | Acquisitions | Cataloging | Circulation Events | Circulation Fiscal Transactions | Circulation Hold Request | Circulation Item Status | Circulation Patron Information | Circulation Scheduled Items | E-Resources COUNTER 4 | Group Activity | Group Titles | Institution Title Holdings | Interlibrary Loan | LHR Item Detail | Overlap | Serials Received |
| Appears in |
User Full Name
| Description | The full name of the user that executed the report. |
| Type | Dimension |
| Universe | Acquisitions | Cataloging | Circulation Events | Circulation Fiscal Transactions | Circulation Hold Request | Circulation Item Status | Circulation Patron Information | Circulation Scheduled Items | E-Resources COUNTER 4 | Group Activity | Group Titles | Institution Title Holdings | Interlibrary Loan | LHR Item Detail | Overlap | Serials Received |
| Appears in |
User Last Name
| Description | The last name of the user that executed the report. |
| Type | Dimension |
| Universe | Acquisitions | Cataloging | Circulation Events | Circulation Fiscal Transactions | Circulation Hold Request | Circulation Item Status | Circulation Patron Information | Circulation Scheduled Items | E-Resources COUNTER 4 | Group Activity | Group Titles | Institution Title Holdings | Interlibrary Loan | LHR Item Detail | Overlap | Serials Received |
| Appears in |
Value
| Description | Do not use. |
| Type | Dimension |
| Universe | Circulation Events |
| Appears in | Outstanding Fees and Bills Report | Overdue Items Aging Report |
Vendor Accountancy System ID
| Description | Value to track the identifier used by your parent institution's financial system. OCLC recommends using this field for your enterprise resource planning (ERP) system. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Active Indicator
| Description | Value ("Y" or "N") indicating if the address is an active address for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address City
| Description | The city for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Country
| Description | The country for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Default Indicator
| Description | Value ("Y" or "N") indicating if the address is the default address for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Name
| Description | The name of an address for the vendor. A vendor may have multiple associated addresses. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address PO Box
| Description | The post box for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Postal Code
| Description | The postal code for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Public Indicator
| Description | Value ("Y" or "N") indicating if the vendor address is public. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Role
| Description | The type(s) of address for the vendor address. E.g., Billing. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address State/Province
| Description | The state/province for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Address Street
| Description | The street line for the vendor address. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Alternate Name
| Description | The alternate name(s) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Active Indicator
| Description | Value ("Y" or "N") indicating if the contact is an active contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Company Name
| Description | The company name of the vendor contact, if different from the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Default Indicator
| Description | Value ("Y" or "N") indicating if the contact is the default contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Department
| Description | The department(s) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Email Address
| Description | The email address(es) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Fax Number
| Description | The fax number(s) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact IM Address
| Description | The instant messaging address(es) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Language
| Description | The language spoken by the contact for a vendor. E.g., French. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Mobile Number
| Description | The mobile phone number(s) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Name
| Description | The name of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Phone Number
| Description | The phone number(s) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Public Indicator
| Description | Value ("Y" or "N") indicating if the vendor contact is public. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Roles
| Description | The role(s) the contact plays for a vendor. E.g., Sales Contact. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Short Name
| Description | The preferred name of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Contact Title
| Description | The title(s) of the contact for a vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Count
| Description | The number of unique vendors. |
| Type | Measure |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Country
| Description | The country location of the vendor. E.g., Thailand. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Currency
| Description | The primary currency used by the vendor. E.g., EUR. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Customer/Account Number
| Description | The customer/account number(s) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Default Contact
| Description | The default contact for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Default Delivery Method
| Description | The default delivery method of the vendor. E.g., Print. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor FEIN
| Description | The default delivery method of the vendor. E.g., Print. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor ID
| Description | Unique system-supplied identifier for all vendors (public and private). |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Identifier Tax Number
| Description | The tax number(s) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Identifier URL
| Description | The Uniform Resource Locator (URL) value(s) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor ILS Supplier Number
| Description | Value used to track the vendor identifier used by your previous ILS. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor In Use Indicator
| Description | Value ("Y" or "N") indicating if the vendor is in use by the institution. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor ISBN Prefix
| Description | The ISBN prefix for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Language
| Description | The primary language spoken by the vendor, e.g, French. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Local Identifier
| Description | An identifier for a vendor automatically generated by the system and unique for that institution. E.g., LVN-126. |
| Type | Dimension |
| Universe | Acquisitions | Acquisitions Vendor |
| Appears in | Paid Invoice Item Detail Report |
Vendor Match Codes
| Description | Values when a code is needed to identify (match) vendors in other systems. Using the same match code for the same vendor in both WMS and other systems facilitates sharing vendor information between systems. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Name
| Description | The commercial entity from which the library orders and receives materials. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in | Acquisitions Dashboard | COUNTER 4 Merged Database Usage Detail | COUNTER 4 Merged Database Usage Summary | COUNTER 4 Merged E-Journal/E-book Usage Detail | COUNTER 4 Merged E-Journal/E-book Usage Summary | COUNTER 4 Merged Vendor Usage Detail | COUNTER 4 Titles with Zero Usage Detail | COUNTER 4 Top 100 Title Usage | COUNTER 5 Merged E-Journal/E-book Usage Summary | COUNTER 5 Multimedia/Journal Article Usage Detail | COUNTER 5 Multimedia/Journal Article Usage Summary | Open Encumbrances | Paid Invoice Summary Report | Paid Invoice Item Detail Report | Payment Activity by Fund | Payment Activity by Location | Payment Activity by Material Format | Payment Activity by Processing Type | Payment Activity by Requestor | Payment Activity by Vendor | Title Copy Detail Report | Vendor Performance |
Vendor Notes
| Description | The vendor note(s) applied to a vendor by the institution. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor OCLC Symbol
| Description | The OCLC symbol for the vendor, if applicable. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Order Item Notes
| Description | Note(s) for an order item provided to the vendor to designate special instructions about this item. Multiple notes are concatenated using a pipe (|) delimiter. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Vendor Order Item Number
| Description | Identifier supplied by the vendor for an order item. The identifier is unique to the vendor. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Vendor Previous Name
| Description | The previous name(s) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Public Indicator
| Description | Value ("Y" or "N") indicating if the vendor is public. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor Roles
| Description | The role(s) the vendor plays for libraries. E.g., Provider. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Vendor SAN
| Description | The Standard Address Number (SAN) for the vendor. |
| Type | Dimension |
| Universe | Acquisitions Vendor |
| Appears in |
Withdrawn Date
| Description | The date a specific copy of an item was withdrawn from the collection within Acquisitions. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Withdrawn User
| Description | The full name of the user who withdrew a copy of an item from the collection within Acquisitions. |
| Type | Dimension |
| Universe | Acquisitions |
| Appears in |
Year Item Recalled Date
| Description | The year the item was recalled. |
| Type | Dimension |
| Universe | Circulation Item Status | Circulation Scheduled Items |
| Appears in |