Skip to main content
OCLC Support

Comparison of Classic WorldShare Reports and WorldShare Reports in Power BI actions

  1. Last updated
  2. Save as PDF
A quick reference guide comparing common actions and steps between Classic WorldShare Reports and WorldShare Reports in Power BI.

Overview

The new Microsoft Power BI reporting platform for WMS offers updated views of standard reports and some new reports. This page provides an overview of updated terminology, new reports, and new report fields.

Updated terminology

Classic WorldShare Reports WorldShare Reports in Power BI
General
Reports Reports / Visualizations
Report object Report field
Universe Dataset
Report names
Patron Counts Summary Report Patron Counts Summary
Patron Information Detail Report Patron Information Detail
Circulation Events Detail Report Circulation Events Detail
High Use Circulation Titles Summary Report High Use Circulation Titles
Hourly Average Circulation Activity Daily Chart Hourly Average Circulation Activity
Hourly Average Circulation Activity Summary Report Hourly Average Circulation Activity
Monthly Circulation Statistics Report Monthly Circulation Statistics
Patron Counts Summary Report Patron Counts Summary
Patron Information Detail Report Patron Information Detail

New report columns

Report name Column name
All Checked Out Items
  • Item Status Loan Policy Name
  • Item Call Number Main Class
  • Item Call Number Subclass
Circulation Events Details
  • Event Pickup Branch Name
  • Event Pickup Branch Location
  • Event Transaction Source
Patron Information Detail
  • Patron Public Notes
  • Patron Staff Notes
Items in Transit
  • Item Enumeration and Chronology
  • Item Status Transfer Routing Reason
  • Item Call Number Main Class
  • Item Call Number Subclass
Lost or Missing Items
  • Item Edition
  • Item Last Seen Date
  • Item Last Seen Institution Symbol
  • Item Last Seen Branch Name
  • Item Last Seen Branch Location
Overdue Items
  • Patron Email Address
  • Patron Phone Number
  • Patron Street Address 1
  • Patron Street Address 2
  • Patron City/Location
  • Patron State/Province
  • Patron Postal Code
  • Item Status Loan Policy Name
Recalled Items
  • Patron Barcode
  • Patron Email Address
  • Patron Phone Number
  • Patron Street Address 1
  • Patron Street Address 2
  • Patron City/Locality
  • Patron State/Province
  • Patron Postal Code

New report fields

Report field Definition Dataset
Patron Expiration Year Month The calendar year and month (e.g., 2023-04) that the patron user record expires, thereby making them inactive in the library system. Patron Information
Patron Registration Year Month The calendar year and month (e.g., 2023-04) on which the patron record was created. Patron Information
Serial Receiving Status Code The underlying, untranslated code value representing the receiving disposition of the serial, e.g., Received, Claimed. Serials Received

Updated field values

Binding Status

Dataset(s): Serials Received

Classic Reports value Power BI Reports value
BOUND Bound
N/A N/A
NOT_BOUND Not Bound
PENDING Pending
SENT Sent to Bindery

Email Address Type

Dataset(s): Circulation Events, Circulation Item Status, Patron Information

Classic Reports value Power BI Reports value
HOME Home
N/A N/A
OTHER Other
WORK Work

Event Hold Approval Status

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
N/A N/A
NOT_REQUIRED Not required
PROVIDED Approved
REQUIRED Requires approval

Event Hold Forwarding Level

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
GROUP Group
INSTITUTION Institution
N/A N/A

Event Hold Fulfillment Method

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
COLLECT Collect for loan
IN_HOUSE_USE In-house use
N/A N/A

Event Hold Preparation Status

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
N/A N/A
NOT_REQUIRED Not required
PROVIDED Prepared
REQUIRED Requires preparation

Event Hold Request Origin

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
ILL ILL
N/A N/A
PATRON Patron
STAFF Staff

Event Hold Request Scope

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
BIB Title level
ITEM Item level
N/A N/A

Event Transaction Source

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
ACQUISITIONS Acquisitions
BURSAR_IMPORT Bill Connector Import
BURSAR_TRANSFER Bill Connector Transfer
CIRC_API External Application
CIRC_PAS WMS Circ Patron Service
CIRC_PAS_BURSAR_TRANSFER Bill connector transfer
CIRC_PATRON_ACCOUNTS_BUSINESS_INTERNAL System
CIRC_PLATFORM_EXTERNAL_PAYMENTS External Payments
D2D D2D
DIGBY Digby
EXTERNAL_PAYMENTS External Payments
HEALTHCHECK Health Check
ILL Interlibrary Loan
MEMBERSHIP_POLICY Membership Policy
N/A N/A
NAVIGATOR WorldCat Navigator
NCIP External Application
NCIP_API_LEGACY External Application
OFFLINE Offline Circulation
OTHER Other
PLATFORM_PATRON Patron
POLICY System
RESHARE ReShare
SHAREIT SHAREit
SIP Self Service
STAFF Staff
SYSTEM System
UNKNOWN Unknown
WCL WorldCat Local
WMS_CIRC_PATRON_SERVICE WMS Circ Patron Service
ZFL ZFL-Server

External Request Role

Dataset(s): Circulation Events

Classic Reports value Power BI Reports value
N/A N/A
REQUESTER Requester
SUPPLIER Supplier

Item Lending Policy

Dataset(s): Circulation Item Status

Classic Reports value Power BI Reports value
N/A N/A
WILL_LEND Will lend
WILL_NOT_LEND Will not lend

Item Material Format

Dataset(s): Circulation Events, Circulation Item Status

Classic Reports value Power BI Reports value
Archv Archive material
Archv_Digital Downloadable archive material
ArtChap Article/Chapter
ArtChap_Artcl Article
ArtChap_Chptr Chapter
ArtChap_Digital Electronic article
ArtChap_mss Article Manuscript
Audiobook Audiobook
Audiobook_Cassette Audiobook on Cassette
Audiobook_CD Audiobook on CD
Audiobook_Digital eAudiobook
Audiobook_LP Audiobook on LP
Audiobook_Tape Audiobook on Tape
Book Book
Book_Braille Braille book
Book_Continuing Continually updated resource
Book_Digital eBook
Book_LargePrint Large print book
Book_Mic Microform
Book_Mss Book Manuscript
Book_printbook Print Book
Book_thsis Thesis/dissertation
CompFile Computer file
CompFile_Digital Computer file (digital)
CorpProf Corporate profile
Encyc Encyclopedia article
Game Game
Game_Digital Video game
Image Image
Image_2D Image (2D)
IntMM Interactive Multimedia
IntMM_Digital Interactive Multimedia (digital)
Jrnl Periodical
Jrnl_Digital ePeriodical (digital)
Jrnl_Issue Periodical issue
Kit Kit
Map Map
Map_Digital eMap
Map_mss Map Manuscript
MsScr Musical score
MsScr_Digital Downloadable musical score
MsScr_mss Musical score manuscript
Music Music
Music_Cassette Musical cassette
Music_CD Musical CD
Music_Digital eMusic
Music_LP Musical LP
N/A N/A
News Newspaper
News_Digital eNewspaper
Object Object
Object_Digital Object (digital)
otr Other
Paper Paper
Pub Publisher record
Rev Review
Snd Sound recording
Snd_Cassette Sound recording on cassette
Snd_CD Sound recording on CD
Snd_Digital Downloadable sound recording
Snd_LP Sound recording on LP
Toy Toy
Und Format undetermined
Video Video
Video_Bluray Blu-ray video
Video_Digital eVideo
Video_DVD DVD video
Video_Film Film
Video_VHS VHS Video
Vis Visual material
Vis_Digital Downloadable visual material
Web Internet resource
Web_Digital Website

Item Record Type

Dataset(s): Circulation Item Status

Classic Reports value Power BI Reports value
MULTI_PART Multipart
N/A N/A
SERIAL Serial
SINGLE_PART Single-part

Item Status Transfer Routing Reason

Dataset(s): Circulation Item Status

Classic Reports value Power BI Reports value
HOLD Hold
MANUAL Manual
N/A N/A
NULL N/A
RESHELVE Reshelve
SCHEDULED Schedule

Item Type

Dataset(s): Circulation Item Status

Classic Reports value Power BI Reports value
CIRC_MANAGED Temporary Item
CONTAINER Bound Item
FREE_TEXT Free text
N/A N/A
TEMPORARY Temporary Item
VOLUME Item

Material Format

Dataset(s): LHR Item Detail, Collection Title Volatility

Classic Reports value Power BI Reports value
ARCHIVALMATERIALS Archival Material
ARTICLES Article
AUDIOBOOKS Audiobook
BOOKS Book
COMPUTERFILES Computer File
FORMATUNDEFINED Format Undefined
GAMES(ALL) Game
IMAGES Image
INTERACTIVEMULTIMEDIA Interactive Multimedia
INTERNETRESOURCES Internet Resource
JOURNALS/MAGAZINES Journal/Magazine
KITS Kit
MAPS Map
MUSIC Music
MUSICALSCORE Musical Score
N/A N/A
NEWSPAPERS Newspaper
OBJECTS Object
TOYS Toy
VIDEOS Video
VISUALMATERIALS Visual Material

Material Subformat

Dataset(s): LHR Item Detail, Collection Title Volatility

Classic Reports value Power BI Reports value
ARTICLES,NONDIGITAL N/A
BLU-RAY Bluray
BOOKS:MICROFORM Microform
BRAILLE Braille
CASSETTE Cassette
CD CD
CONTINUALLYUPDATEDRESOURCES Continually Updated Resource
DIGITALOBJECTS Digital Object
DOWNLOADABLEARCHIVALMATERIALS Downloadable Archival Material
DOWNLOADABLEARTICLES Downloadable Article
DOWNLOADABLEMUSICALSCORES Downloadable Musical Score
DOWNLOADABLEVISUALMATERIALS Downloadable Visual Material
DVDS DVD
EAUDIOBOOK eAudioBook
EBOOKS eBook
EJOURNALS/EMAGAZINES eJournal/eMagazine
EMAPS eMap
EMUSIC eMusic
ENEWSPAPERS eNewspaper
EVIDEOS eVideo
FILMS Film
JOURNALS/MAGAZINES,NONDIGITAL N/A
LARGEPRINT Large Print
LP LP
MANUSCRIPT Manuscript
MANUSCRIPT ARTICLE Manuscript Article
MANUSCRIPT MAP Manuscript Map
MANUSCRIPT MUSICAL SCORE Manuscript Musical Score
MANUSCRIPTARTICLE Manuscript Article
MANUSCRIPTMAP Manuscript Map
MANUSCRIPTMUSICALSCORE Manuscript Musical Score
MAPS,NONDIGITAL N/A
N/A N/A
OTHER Other
PHYSICALARCHIVALMATERIALS Physical Archival Material
PRINTBOOK Print Book
THESIS/DISSERTATIONS Thesis/dissertation
VHS VHS
VIDEOGAMES Video Game
WEBSITE Website

Patron Address Type

Dataset(s): Circulation Events, Circulation Item Status, Patron Information

Classic Reports value Power BI Reports value
HOME Home
N/A N/A
OTHER Other
WORK Work

Patron Membership Status

Dataset(s): Circulation Events, Circulation Item Status, Patron Information

Classic Reports value Power BI Reports value
ACTIVE Active
CANCELLED Cancelled
N/A N/A
PENDING Pending
RENEWAL_PENDING Pending renewal

Patron Phone Type

Dataset(s): Circulation Events, Circulation Item Status, Patron Information

Classic Reports value Power BI Reports value
HOME Home
MOBILE Mobile
N/A N/A
OTHER Other
WORK Work

Publication Frequency

Dataset(s): Serials Received

Classic Reports value Power BI Reports value
ANNUAL Annual
BI_ANNUAL Every 2 Years
BI_MONTHLY Bimonthly
BI_WEEKLY Biweekly
MONTHLY Monthly
N/A N/A
NOT_IN_USE Not Specified
QUARTERLY Quarterly
SEMI_ANNUAL Semiannual
TRI_ANNUAL 3/Year
TRIENNIAL Every 3 Years
WEEKLY Weekly

Serial Receiving Status

Dataset(s): Serials Received

Classic Reports value Power BI Reports value
CLAIMED Claimed
N/A N/A
RECEIVED Received
STOPPED_CLAIMING Stopped Claiming

Shelving Scheme

Dataset(s): LHR Item Detail, Circulation Events, Circulation Item Status, Collection Title Volatility

Classic Reports value Power BI Reports value
DEWEY_DECIMAL Dewey Decimal
LIBRARY_OF_CONGRESS Library of Congress
MARC_CODE MARC Code
N/A N/A
NATIONAL_LIBRARY_OF_MEDICINE National Library of Medicine
OTHER Other
SHELVED_SEPARATELY Shelved Separately
SHELVING_CONTROL_NUMBER Shelving Control Number
SUPERINTENDENT_OF_DOCUMENTS Superintendent of Documents
TITLE Title
UNKNOWN Unknown