Skip to main content
OCLC Support

Report fields D-H

View all report objects D-H available to retrieve data for standard reports in WorldShare Reports in Power BI.
D  E  F  H

D

Report field Description Appears in
Discount Amount
  • Type: Measure
  • Dataset(s): Acquisitions
Monetary amount deducted from the retail price for a specific item. Paid Invoice Detail

Paid Invoice Summary

 

D  E  F  H

E

Report field Description Appears in
Edition
  • Type: Dimension
  • Data(sets): Collection Title Volatility
A specific version of a work (e.g., the seventeenth edition of Webster's Dictionary). New Titles List

Open Encumbrances

Payment Activity Analysis

Removed Titles List

Title Copy Payment Detail
Encumbered Amount
  • Type: Measure
  • Dataset(s): Acquisitions
Monetary amount held or reserved on a fund. Typically used when an item has been ordered but not yet invoiced or paid. Open Encumbrances
Encumbered Copies Received
  • Type: Measure
  • Dataset(s): Acquisitions
Number of copies received for an acquisition order item still in an encumbered state. Open Encumbrances
Event Bill Reason
  • Type: Dimension
  • Dataset(s): Circulation Events
The reason that a bill was assessed for an event. Examples include: Overdue, Lost Item, Processing. Daily Payments
Event Borrower Category
  • Type: Dimension
  • Dataset(s): Circulation Events
The borrower category of the patron associated with an event. Circulation Events Detail

Monthly Circulation Statistics
Event Branch Name
  • Type: Dimension
  • Dataset(s): Circulation Events
The branch name associated with an event. Circulation Events Detail

Daily Payments

Hourly Average Circulation Activity

Monthly Circulation Statistics
Event Count
  • Type: Measure
  • Dataset(s): Circulation Events
The total number of events.

 Note: This circulation activity is derived from WMS transactions only. It does not include circulation activity from a previous ILS.

Daily Payments
Event Currency
  • Type: Dimension
  • Dataset(s): Circulation Events
The fiscal currency of an event. Daily Payments
Event Date
  • Type: Dimension
  • Dataset(s): Circulation Events
The date of an event. Hourly Average Circulation Activity
Event Date/Time
  • Type: Dimension
  • Dataset(s): Circulation Events
The date/time of an event. Circulation Events Detail

Daily Payments

High Use Circulation Titles
Event Day Name of Week
  • Type: Dimension
  • Dataset(s): Circulation Events
The day of the week (e.g., Wednesday) for an event. Circulation Events Detail

Hourly Average Circulation Activity
Event Due Date/Time
  • Type: Dimension
  • Dataset(s): Circulation Events
The date and time of the due date for an item in an event. Circulation Events Detail
Event Fiscal Amount Paid
  • Type: Measure
  • Dataset(s): Circulation Events
The monetary amount paid for a given bill.

 Note: This circulation activity is derived from WMS transactions only. It does not include circulation activity from a previous ILS.

Daily Payments
Event Hour of Day 24
  • Type: Dimension
  • Dataset(s): Circulation Events
The hour of the day on a 24 hour clock for an event. Hourly Average Circulation Activity
Event Loan Policy
  • Type: Dimension
  • Dataset(s): Circulation Events
The name of the policy that specifies the conditions under which a library item is checked out to a patron in an event. The loan policy specifies whether a specific material format may be checked out to a specific patron borrower category and, if so, for what period of time. Circulation Events Detail
Event Month Name
  • Type: Dimension
  • Dataset(s): Circulation Events
The month name (e.g., November) for an event. Monthly Circulation Statistics
Event Patron Membership Expiration Date
  • Type: Dimension
  • Dataset(s): Circulation Events
The expiration date of the patron's membership period at the time of the event. Circulation Events Detail
Event Patron Membership Policy Name
  • Type: Dimension
  • Dataset(s): Circulation Events
The name of the library's membership policy that applies to the patron's membership at the time of the event. Circulation Events Detail
Event Patron Membership Start Date
  • Type: Dimension
  • Dataset(s): Circulation Events
The date when a patron's membership fee was fully paid or waived, and the membership period began at the time of the event. Circulation Events Detail
Event Patron Membership Status
  • Type: Dimension
  • Dataset(s): Circulation Events
The patron's membership status at the time of the event, e.g., Active, Pending, etc. Circulation Events Detail
Event Payment Method
  • Type: Dimension
  • Dataset(s): Circulation Events
The form of payment used to pay a bill transaction for an event. Payment methods are defined by the library and usually include categories such as cash, check and credit. Daily Payments
Event Pickup Branch Location
  • Type: Dimension
  • Dataset(s): Circulation Events
The service location at a library branch where an item is sent to fulfill a hold request. Circulation Events Detail
Event Pickup Branch Name
  • Type: Dimension
  • Dataset(s): Circulation Events
The branch where an item is sent to fulfill a hold request. Circulation Events Detail
Event Staff Full Name
  • Type: Dimension
  • Dataset(s): Circulation Events
The full name (given name and surname) of the staff member who performed an event. Circulation Events Detail

Daily Payments
Event System Index Number
  • Type: Dimension
  • Dataset(s): Circulation Events
A system-generated value representing a unique circulation event transaction within the reporting system, for purposes of returning distinct records. This index value may change over time and should not be used as a filter for locating specific records. Circulation Events Detail

Daily Payments
Event Transaction Source
  • Type: Dimension
  • Dataset(s): Circulation Events
The service or agent that originated the event. Circulation Events Detail

Daily Payments

Hourly Average Circulation Activity

Monthly Circulation Statistics
Event Type
  • Type: Dimension
  • Dataset(s): Circulation Events
The kind of event that has occurred. Examples include checkout, place order, waive bill, etc. Circulation Events Detail

Monthly Circulation Statistics
Event Year
  • Type: Dimension
  • Dataset(s): Circulation Events
The calendar year in which the event occurred. Monthly Circulation Statistics
Expended Amount
  • Type: Measure
  • Dataset(s): Acquisitions
The monetary amount an institution has spent on acquired items. Acquisitions Overview

Paid Invoice Detail

Paid Invoice Summary

Payment Activity Analysis

Title Copy Payment Detail

 

D  E  F  H

F

Report field Description Appears in
Fiscal Action Type
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The kind of fiscal transaction. Examples include: ASSESS, CANCEL, PAY, PEND, REFUND, WAIVE.
  • ASSESS - Represents that a bill was created. Links to one or more of the other action types.
  • CANCEL - One or more bills was fully cancelled. Links back to one or more ASSESS transactions.
  • PAY - One or more bills was partially or fully paid. Links back to one or more ASSESS or PEND transactions.
  • PEND - One or more bills are waiting for online payment to process. Links back to one or more ASSESS or PAY transactions.
  • REFUND - One or more bills was partially or fully refunded. Links back to one or more ASSESS or PAY transactions.
  • WAIVE - One or more bills was partially or fully waived. Links back to one or more ASSESS transactions. 
Fiscal Detail
Fiscal Bill Note
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
Note associated with a fiscal transaction that provides additional information for other library staff (e.g., the reason that the bill was waived, canceled, or refunded, the interlibrary loan request associated with the bill, etc.). Outstanding Fees and Bills
Fiscal Bill Reason
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The reason for the fiscal transaction. Examples include: Overdue, Lost Item, Processing. Fiscal Detail

Outstanding Fees and Bills
Fiscal Currency
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The three-character code (e.g., CAD, EUR, USD) that designates the monetary unit in which the fiscal transaction is recorded. The currency code is based on the ISO-4217 standard. Fiscal Summary

Outstanding Fees and Bills
Fiscal Payment Method
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The form of payment used to pay a fiscal transaction. Payment methods are defined by the library and usually include categories such as cash, check and credit. Fiscal Detail
Fiscal Transaction Amount
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The monetary amount of a fiscal transaction, inclusive of taxes and other related charges. Fiscal Detail

Outstanding Fees and Bills
Fiscal Transaction Date
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The date of a fiscal transaction. Fiscal Detail

Fiscal Summary

Outstanding Fees and Bills
Fiscal Transaction Outstanding Amount
  • Type: Measure
  • Dataset(s): Circulation Fiscal Transactions
The remaining monetary amount of a bill, inclusive of taxes and other related charges, after any payment has been applied. Outstanding Fees and Bills
Fiscal Transaction Staff Full Name
  • Type: Dimension
  • Dataset(s): Circulation Fiscal Transactions
The full name (given name and surname) of the staff member that performed a fiscal transaction. Fiscal Detail
Fund Balance
  • Type: Measure
  • Dataset(s): Acquisitions
=[Budgeted Amount]-[Fund Encumbered Amount]-[Fund Expended Amount]  
Fund Code
  • Type: Dimension
  • Dataset(s): Acquisitions
Identifier provided by the institution for a specific fund on a budget. Each fund code must be unique per budget. Open Encumbrances

Paid Invoice Detail

Paid Invoice Summary

Payment Activity Analysis

Title Copy Payment Detail
Fund Encumbered Amount
  • Type: Measure
  • Dataset(s): Acquisitions
The summary monetary amount held or reserved on a fund. Typically used when an item has been ordered but not yet invoiced or paid. Fund Balance
Fund Expended Amount
  • Type: Measure
  • Dataset(s): Acquisitions
The summary monetary amount an institution has spent on acquired items for a fund. Fund Balance
Fund Name
  • Type: Dimension
  • Dataset(s): Acquisitions
Name provided for a fund. Used to provide an internal way to reference the fund by the institution. Acquisitions Overview

Open Encumbrances

Paid Invoice Detail

Paid Invoice Summary

Payment Activity Analysis

Title Copy Payment Detail
Fund Name Level 1
  • Type: Dimension
  • Dataset(s): Acquisitions
Fund name of the top level fund in the fund hierarchy. Fund Balance

Payment Activity Analysis

Title Copy Payment Detail
Fund Name Level 2
  • Type: Dimension
  • Dataset(s): Acquisitions
Fund name of the second level fund in the fund hierarchy. Fund Balance

Payment Activity Analysis

Title Copy Payment Detail
Fund Name Level 3
  • Type: Dimension
  • Dataset(s): Acquisitions
Fund name of the third level fund in the fund hierarchy. Fund Balance

Payment Activity Analysis

Title Copy Payment Detail
Fund Name Level 4
  • Type: Dimension
  • Dataset(s): Acquisitions
Fund name of the fourth level fund in the fund hierarchy. Fund Balance

Payment Activity Analysis

Title Copy Payment Detail
Fund Name Level 5
  • Type: Dimension
  • Dataset(s): Acquisitions
Fund name of the fifth level fund in the fund hierarchy. Fund Balance

Payment Activity Analysis

Title Copy Payment Detail

 

D  E  F  H

H

Report field Description Appears in
Hold Item Consultations
  • Type: Measure
  • Dataset(s): Circulation Events
The number of times that a staff user issued a requested item to a patron for in-house use.

 Note: This circulation activity is derived from WMS transactions only. It does not include circulation activity from a previous ILS.

High Use Circulation Titles

Monthly Circulation Statistics
Hold Item Consultations (Avg)
  • Type: Measure
  • Dataset(s): Circulation Events
=Round (([Hold Item Consultations]/[Day Count]);2) Hourly Average Circulation Activity

Monthly Circulation Statistics
Holds Fulfilled
  • Type: Measure
  • Dataset(s): Circulation Events
The number of holds fulfilled.

 Note: This circulation activity is derived from WMS transactions only. It does not include circulation activity from a previous ILS.

High Use Circulation Titles

Hourly Average Circulation Activity
Holds Fulfilled (Avg)
  • Type: Measure
  • Dataset(s): Circulation Events
=Round (([Holds Fulfilled]/[Day Count]);2) Hourly Average Circulation Activity