Report objects Q-Z
View all report objects Q-Z available to retrieve data for standard reports in WorldShare Reports in Power BI.
| R S T U V R |
| Report field | Description | Appears in |
|---|---|---|
Remaining Fund %
|
=If([Budgeted Amount]=0 Or [Fund Balance] =0) Then 0 Else [Remaining Fund %] | Fund Balance |
Remaining Fund Balance
|
=[Budgeted Amount]-[Fund Encumbered Amount]-[Fund Expended Amount] | Fund Balance |
Remaining Total Fund Balance
|
=[Total Fund Amount Budgeted]-[Total Fund Amount Encumbered]-[Total Fund Amount Expended] | Fund Balance |
Removed Titles
|
The number of titles that an institution no longer has their OCLC symbol attached to, for a given time frame. | New Titles List Removed Titles List |
Requestor Name
|
Patron that has requested an order item. If null, then no patron has requested this order item. | Acquisitions Overview Open Encumbrances Payment Activity Analysis Title Copy Payment Detail |
| R S T U V S |
| Report field | Description | Appears in |
|---|---|---|
Serial Receiving Status Code
|
The underlying, untranslated code value representing the receiving disposition of the serial, e.g., Received, Claimed. | Serials Claimed Summary Serials Received Summary |
Serials Received Date
|
The date a serial was received by the institution. | Serials Received Summary |
Settled Item Barcode
|
The unique, machine readable code used to identify the item when performing library functions such as check in, check out, etc. | Fiscal Detail |
Settled Item Title
|
The descriptive name used to identify an intellectual work such as a book, film or other composition. | Fiscal Detail |
Shelving Location
|
The location within a branch where an item is shelved. | Acquisitions Overview Item Holdings Insights Open Encumbrances Payment Activity Analysis Receiving Activity by Location Title Copy Payment Detail |
Shipping Type
|
Type or method of shipping chosen by the Institution for the items on an order (e.g. standard, next day, air mail, etc.). | Vendor Performance |
Source Application
|
Process name for the application that performed some action (e.g. RECORD MANAGER, WMS, OCLC PROCESSING, etc.) | New Titles List Removed Titles List |
System Invoice Number
|
Identifier generated by the system and used by the WorldShare Platform to uniquely identify an invoice (e.g. INV-2014-1). | Paid Invoice Detail Paid Invoice Summary Payment Activity Analysis Title Copy Payment Detail |
| R S T U V T |
| Report field | Description | Appears in |
|---|---|---|
Time to Fulfillment
|
Number of days from the date the item was ordered to the date the item was received. | Vendor Performance |
Title
|
The descriptive name used to identify an intellectual work such as a book, film, or other composition. Unique by OCLC number. | LHR Duplicate Barcodes New Titles List Open Encumbrances Removed Titles List Paid Invoice Detail Payment Activity Analysis Serials Claimed Summary Serials Received Summary Title Copy Payment Detail |
Title Holding Added Date
|
The date and time a title was added to an institution's collection. | New Titles List Removed Titles List |
Title Holding Removed Date
|
The date and time a title was removed from an institution's collection. | New Titles List Removed Titles List |
Title Holdings Quantity
|
The number of titles held by an institution. A title is a distinct OCLC number (one title has many items). | Title Holdings Insights |
Title Limit Exceeded Denials (TR_B2 & TR_J2)
|
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. | COUNTER 5 E-Journal/E-Book Usage Detail COUNTER 5 E-Journal/E-Book Usage Summary |
Title No License Denials (TR_B2 & TR_J2)
|
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. | COUNTER 5 E-Journal/E-Book Usage Detail COUNTER 5 E-Journal/E-Book Usage Summary |
Total Amount Expended Including Child Funds
|
=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] | Payment Activity Analysis |
Total Copies Expended Including Child Funds
|
=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] | Payment Activity Analysis |
Total Fund Amount Budgeted
|
Sum of amount budgeted for a fund and all its child funds. | Fund Balance |
Total Fund Amount Encumbered
|
Sum of amount encumbered for a fund and all its child funds. | Fund Balance |
Total Fund Amount Expended
|
Sum of amount expended for a fund and all its child funds. | Fund Balance |
|
Total Item Investigations (TR_J3 & TR_B3)
|
The total number of times a content item, or information related to a content item, was accessed. | COUNTER 5 E-Journal/E-Book Open Access Usage Summary |
Total Item Requests (TR_J3 & TR_B3)
|
The number of times a user requested the full content of an item. | COUNTER 5 E-Journal/E-Book Open Access Usage Summary |
| R S T U V U |
| Report field | Description | Appears in |
|---|---|---|
Unique Item Investigations (TR_J3 & TR_B3)
|
The number of unique content items investigated in a user-session. | COUNTER 5 E-Journal/E-Book Open Access Usage Summary |
Unique Item Requests (TR_J3 & TR_B3)
|
The number of unique content items requested in a user-session. | COUNTER 5 E-Journal/E-Book Open Access Usage Summary |
| R S T U V V |
| Report field | Description | Appears in |
|---|---|---|
Vendor Name
|
The commercial entity from which the library orders and receives materials. | Acquisitions Overview Open Encumbrances Paid Invoice Detail Paid Invoice Summary Payment Activity Analysis Title Copy Payment Detail Vendor Performance |