Skip to main content
OCLC Support

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.

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
Appears in Merged COUNTER Database Usage DetailMerged COUNTER Database Usage Summary | Merged COUNTER 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
Appears in Merged COUNTER Database Usage DetailMerged COUNTER Database Usage Summary | Merged COUNTER 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 (in US Eastern Time) 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 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 (in US Eastern Time) 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

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 (US Eastern Time) when the patron or borrowing institution created the request.
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 (in US Eastern Time) 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

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 (in US Eastern Time) when an active ILL request met or exceeded the borrower's need-before date.
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 Local 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., Direct Request) submitted the ILL request to potential lenders.
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., Direct Request) 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., Direct Request) 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., Direct Request) 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., Direct Request) 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., Direct Request) 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 completed in the ILL system.
Type Measure
Universe Interlibrary Loan
Appears in  

Request Purchase Order Date/Time

Description The date and time (in US Eastern Time) when the purchase order was submitted.
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 FormatPayment 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
Appears in Merged COUNTER Database Usage DetailMerged COUNTER Database Usage Summary | Merged COUNTER 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 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 HoldingsLHR 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  

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 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 TitlesNew 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  

Subscription End Date

Description The date the order item's subscription ends, e.g., 2017-12-31.
Type Dimension
Universe Acquisitions
Appears in  

Subscription Master 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 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 TitlesInstitution Title HoldingsLHR Item Detail | Overlap | Serials Received
Appears in New Titles List | Open EncumbrancesPaid 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 HoldingsLHR 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 HoldingsLHR 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 | Institution Title HoldingsLHR 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 HoldingsLHR Item Detail | Overlap
Appears in  

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
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 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  

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
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  

User Filter

Description Do not use.
Type Filter
Universe 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 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
Appears in Paid Invoice Item Detail Report

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  

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  

 

  • Was this article helpful?