Skip to main content
OCLC Support

Exported Item Lists column descriptions

Find information about the columns located in exported item lists in GreenGlass.

Column descriptions

Find information about the columns located in exported item lists. 

Column Description
Location Code The ILS location code of the item.
Location Name A natural language translation of the location code. Often used in the OPAC display.
Display Call Number The call number GreenGlass has derived from your records, which we believe to be the one used locally for spine labels and shelf-listing. At the point of export, item lists are always sorted on this data element.
Display Call Number Normalized The normalized Display call number supports re-sorting.
Title The title of the book, as it appears in the library's record. It's rare for this to be missing, but it does happen (a concatenation of all 245 subfields except $6 & $8).
Enumeration Enumeration of an item, often included for items in multi-volume sets. If the enumeration is followed by an asterisk (*), it was harvested by GreenGlass from the call number field.
Possible Multi-Volume Set GreenGlass derives this indicator from a combination of item data including enumeration and OCLC Work ID. This field is available in new projects beginning in January 2018.
Copy Number The copy number assigned by the library to the item. This field is not included in all exports.
Possible Duplicate This Yes/No indicator has been assigned by GreenGlass.  For more information, watch the Tutorial: Understanding Possible Duplicates (5:09)
Multi-Edition Title This Yes/No indicator has been assigned by GreenGlass.  For more information, watch the Tutorial: Understanding Multi-Edition Titles (3:00)
Author The first cited author in the library's record (a concatenation of all 1XX (first occurrence) subfields except $0, $4, $6, & $8).
Publisher The first publisher cited in the library's record (a concatenation of all 260/264 subfields).
Publication Year Publication Year from the library's record (fixed field 008 bytes 07-10, then 260/264$c).
Edition Edition Statement from the library's record (a concatenation of all 250 subfields except $6 & $8).
Primary Language The MARC language code, as it appears in the library's MARC field 008; 35-37.
Place of Publication The place of publication from the library's MARC field 008; 15-17.
Series The first series cited in the library's record.
LC Subclass The Library of Congress subclass for the item. This field is always provided even if the library only uses Dewey classifcation. 
Dewey Class The Dewey Decimal Class number for the item. This field will only exist if the project was set to include Dewey according to the library’s response on the data questionnaire.
Recorded Uses — Item This count is specific to the item. Depending on the parameters of the project, it may include internal use indicators, like re-shelving counts, browses or reading room loans, etc.
Recorded Uses — Title If there are multiple items associated with a single bib record, this count combines all the item use tallies into a single number. This is the usage tally visible online.
Last Charge Date — Item This date is specific to the item. This field is not included in all exports.
Last Charge Date — Title If there are multiple items associated with a single bib record, this date reflects the most recent charge date for any of the associated items. This field is not included in all exports.
Last Add Date — Title If there are multiple items associated with a single bib record, this date reflects the most recent add (or acquisition) date for any of the associated items. This field is not included in all exports.
Global Holdings Same Edition The count of all holdings for the exact edition; as set in WorldCat™.
Counting Holdings — Same Exact edition WorldCat™ tallies. This tally includes your library's holding.
Country Holdings — Any Edition Related edition WorldCat™ tallies. This tally includes your library's holding.
State/Province Holdings — Same Edition Exact edition WorldCat™ tallies. This tally includes your library's holding.
State/Province Holdings — Any Edition Related edition WorldCat™ tallies. This tally includes your library's holding.
Comparator Library Holdings — Same Edition Exact edition WorldCat™ tallies. All of your library's comparator libraries are combined. Each comparator is counted once regardless of whether the library has set holdings under more than one symbol. If your library named no comparators, this column will not appear in the export. This tally does not include your library's holding.
Comparator Library Holdings — Any Edition Related edition WorldCat™ tallies. All of your library's comparator libraries are combined. Each comparator is counted once regardless of whether the library has set holdings under more than one symbol. If your library named no comparators, this column will not appear in the export. This tally does not include your library's holding.
Special Category Yes means that the bibliographic record has been flagged according to the Special Category Rules established by the library or by the group.
Allocated for Retention For group projects, post-allocation. Yes means that this title has been allocated for retention by your library and should not be deselected.
HathiTrust Public Domain Yes means the title has been identified as public domain by HathiTrust.
HathiTrust In-Copyright Yes means the title has been identified as in-copyright by HathiTrust.
HathiTrust URL Links to the HathiTrust Catalog Record and can be embedded in local catalogs for users to access full text for public domain titles.
Reviewed in CHOICE Yes means the title was reviewed by CHOICE. This column will only be present if the project includes Choice Analysis. 
CHOICE OAT Yes means the title was reviewed by CHOICE as an Outstanding Academic Title. This column will only be present if the project includes Choice Analysis. 
OPAC URL A URL link to the library's public catalog.
WorldCat™ URL A URL link to the bib record in WorldCat™.
OCLC Work ID An OCLC assigned number used to associate various editions of a given work. For more information about the OCLC Work ID, watch the Tutorial: Understanding Multi-Edition Titles (3:00)
WorldCat™ OCLC Number The OCLC number from the WorldCat™ record that GreenGlass matched to the library's bib record.
Bib Record Number The library's internal unique identifier for a bibliographic record.
Bib Control Number The library's bibliographic control number. Depending on your library's catalog, this may or may not be the same as the Bib Record Number.
Item Control Number The library's item control number.
Item Type Code The library's item type code.
Item Status Code The library's item status code.
ISBN The exported ISBN is taken from the first 020$a in the library's MARC record.
Barcode The barcode number assigned to the item by the library.

Same and Any Edition Holdings Tallies 

In GreenGlass, there are two ways to estimate the extent to which titles in your collection are widely or scarcely held by other libraries:

  1. Same Edition Holdings Tallies: represent the number of libraries that have a holding set in WorldCat on the same OCLC number as yours, or, on an OCLC record that has been merged with yours. 
  2. Any Edition Holdings Tallies: represent the number of libraries that have a holding set on the same or related edition of the work as established by OCLC's implementation of work families. 

In Exported Item Lists, Same Edition tallies and Any Edition tallies are delivered in separate columns. 

 Note: Any Edition holdings tallies represent the number of libraries that have a holding set on the same or related edition of the work. Same and Any Edition tallies will match if there are no other editions of this work. If they don't match, Any edition tallies will always be bigger.  

Additional views of Same and Any Edition Holdings Tallies:

  • In Collection, Visualize, Same edition and Any edition tallies appear when the Comparator Libraries distribution type is selected.
  • In the GreenGlass Item Lists, Same edition tallies precede the slash and Any Edition tallies follow the slash. 
  • In Query Builder, choose to set WorldCat overlap thresholds on Same or Any edition tallies via the radio buttons. Example use cases include:
    • Lists of weeding candidates
      • Use Same Edition thresholds to return smaller lists of weeding candidates.
    • Lists of scarcely held titles
      • Use Any Edition thresholds to avoid identifying too many titles that are not rare.