Skip to main content
OCLC Support

Records reports

If you have not configured email reports, see Institution settings, Reports for instructions.

Record reports contain information about records you output from Collection Manager. They are separated into reports about deleted records, new records, and updated records. Each report includes details about the associated files of records (deleted, new, and updated files of records).

Record reports have a size limit of less than 5,000 rows. If the limit is exceeded, the remainder of the report is not available via email or in the OCLC Usage Statistics Portal. You will see the following message: "Your report does not contain all of the data. You are viewing [number] rows of [number] total rows."

Records reports

Report General information included in the report Columns included in the report Notes

Deleted Records

Reporting Period

Institution Name

Institution Symbol

Total number of records

Provider

Collection Name

Title

ISBN/ISSN

OCLC Number

File Name

Multiple occurrence

The Delete Records Report displays titles that have been deleted from your collections.

New Records

Reporting Period

Institution Name

Institution Symbol

Provider

Collection Name

Title

ISBN/ISSN

OCLC Number

Record not delivered*

File Name

Multiple occurrence

The New Records Report displays titles that have been added to your collections.

*The Record not delivered column is especially of interest to libraries that changed a collection-level record delivery setting Record Output to Do not include records already held in WorldCat so that Collection Manager does not deliver records for items you already held in WorldCat. The items not delivered as New records will appear in the report with the word NONDELIVERY in the Records not delivered column. You can use the information for your statistics.

Monthly Records

Reporting Period

Institution Name

Institution Symbol

Provider

Collection Name

New

Updates

Deletes

The Monthly Records Report provides a monthly summary of activity. It shows the number of records output for each provider, collection, and if records were new, updates, or deletes. It also includes the total number of records delivered.

Record delivery is counted by a combination of OCLC number, library symbol, and date. The example below would represent one Update, one New, and one Delete record:

OSU OCLC#1 Provider 1 Collection A New

OSU OCLC#1 Provider 2 Collection B Update

OSU OCLC#1 Provider 3 Collection C Delete

 Note: If you enabled Include a complete set of records with every delivery for Subsequent Record Output in your collection's settings, the delivered updated records will be included in the Records Delivered total.

Updated Records

Reporting Period

Institution Name

Institution Symbol

Provider

Collection Name

Title

ISBN/ISSN

OCLC Number

File Name

Update Reason

Action

Multiple occurrence

The Updated Records Report displays titles in your collection that have been updated and lists why the record was updated. See Reasons for updated records for more information.

Update Reason

Updated Record Reports contain an Update Reason column. If you select to receive Update Records reports, the content of the reports will depend on the settings you choose in Institution Settings > MARC Records > WorldCat Updates as follows:

If you selected to receive WorldCat update records:

  • Details about what was enhanced in the WorldCat record / what triggered output of an updated record will be included in your report.

If you did not select to receive WorldCat update records (you selected None):

  • Details about enhancements to the WorldCat record will not be included in your report. However, you will receive an updated record when an OCLC control number (an OCLC number) changes.

Consider selecting the Updated Records report to ensure you are notified about OCLC number merges.

Action

The Action column can have the value New, Deleted, or Updated.

A report representing a collection that had a DDA title triggered for purchase could appear as follows:

Action Update reason
NEW Removed from collection eblebookspda - Added to collection eblebooks
DELETED Removed from collection eblebookspda - Added to collection eblebooks
UPDATED OCLC control number change—WorldCat record variable field(s) change: 505, 520

Reasons for updated records

Map data values to all of your records in Institution Settings > MARC Records > Customize Records in the Add Fields section. Choose a Tag, Ind 1, Ind 2, and sub-field. Choose a value from the drop-down list. Please see the data values in Table 1 for details.

Table 1

Data values you can map to your records, Table 1

Values Additional options More information
Cataloging Partner Data If you select the value Cataloging Partner Data, an additional drop-down list of values will appear. These additional values apply only to cataloging partner collections. See Data values for cataloging partner collections.
Collection Custom Text Use the Collection Custom Text value to map collection-level notes to your records. Custom text labels can be used with knowledge base, cataloging partner and query collections to remember what notations were placed in custom text areas. For example, you can include your own version of the provider name in each record from a collection. To do so, do two things:
Enter your version of the provider name within a collection and define a custom text label.
Add the Collection Custom Text value to a MARC tag in the Customize Records institution settings.
See Collection Custom Text.
Collection Level Data
 
 
 
Collection ID  
Collection Name

OCLC will automatically add to the 590$b.

Records from your WorldCat holdings will have "WorldCat holdings" as the collection name (if the titles are not in another collection).

Provider

OCLC will automatically add to the 590$a.

Records from your WorldCat holdings will have "OCLC" as the provider (if the titles are not in another collection).

Collection Note Notes are notes you enter at the collection-level. They are sometimes used by WorldCat Discovery and WMS libraries to expose a note to patrons.
Copy Call Number

Choose the call number you want from the WorldCat record:

050 (Library of Congress)
055 (Classification numbers assigned in Canada)
060 (National Library of Medicine)
070 (National Agricultural Library)
080 (Universal decimal classification numbers)
082 (Dewey decimal classification numbers)
086 (Government document classification numbers)
090 (Locally assigned LC-type call numbers)
092 (Locally assigned Dewey call numbers)
096 (Locally assigned NLM-type call numbers)

Choose to use the format and spacing exactly as it appears in the WorldCat record or customize the format and spacing.

See Copy call numbers from WorldCat records to your records for more details and for examples.
Date Delivered

Select the format:

  • YYMMDD
  • YYYYMMDD
  • YYMM
  • YYYYMM
  • MM/DD/YYYY
  • DD/MM/YYYY
  • YYYY-MM-DD
  • YYYY-MM
 
Enter Free Form Text

Use the Enter Free Form Text value to enter text that will be constant data in every record. Enter Free Form Text differs from Collection Custom Text and Collection Level Data, Public Notes for which you map the values in the Customize Records tab but enter collection-specific text within specific collections.

See How to Enter Free Form Text for more information.

 

KB Title Level Data Coverage Dates Format in your records: fulltext@2012
  Coverage Enumerations Format in your records: fulltext@volume:1;issue:1
  Coverage Note  
  Linking Key A Linking Key is a knowledge base title-level value that corresponds to the title_id column in the KBART file. It is used for ebook, audio, video, image, and journal formats.
  Location  
  Title Note  
  Vendor ID  
LSN (Local Systems Number) Libraries that receive WorldCat records for a data sync collection can use the LSN (Local Systems Number) value to include their local system number in a variable field/subfield. If you need your local system number in the 001, note that you will need to manually add it to your records. See Default values in records for more information.
OCLC Number Use this value to add the OCLC control number to a field/subfield in your records. See Default values in records for more information.
Reason for Updated Record By default, the reason an updated record was output will be included in your reports. To include the reason in each updated record, add this value.

See Reasons for updated records for more information.

Transaction Type Add this value to include New, Updated, or Deleted in each record. See Criteria for new, update and delete records for more information.

How to Enter Free Form Text

Use the Enter Free Form Text value to add your own text to a field across records for titles from a knowledge base collections.

As shown in the example, after you select the Enter Free Form Text value, a text box will appear for you to type in text. Then, click the add button (Add button) to add another field. Combine your free text with other data values. For example, type "The collection name is" as free text and add a Value and a Type to create the phrase "The collection name is [Collection Name]."

To use the Enter Free Form Text value:

  1. Navigate to Institution Settings > MARC Records > Customize Records.
  2. Click the add button (Add button) to add a field, if needed. Enter a tag, indicators, and a subfield. For example, add the Tag 999 and the Subfield a.
  3. From the Value drop-down list, select Enter Free Form Text.
  4. Enter free text. For example, enter "The collection name is."
  5. If you want to add another value, click the add button (Add button) to add another value.
  6. Check the box if you do not want to add a space between two values.
  7. Select a Value and a Type. For example, select KB Collection Level Data and Collection Name.

Free form text interface

Reasons for updated records

The reason a record is updated will be included in your reports in by default. The reasons will be included in our records if you map the value to your records. If you map the Reason for Updated Record value to your records, the reason(s) you received an updated record will appear in your update records. We recommend adding this value to your records if you enable WorldCat Updates. See MARC Records, WorldCat Updates for more information.

To map the reason for updated record to a field in your records:

  1. Add a field in the Customize Records tab, enter a tag, and so forth.
  2. Select the Reason for Updated Record value.

Common reasons for updated records

Common reasons for an updated record are:

  • KB collection level note change
  • KB collection name change
  • KB coverage dates change
  • KB coverage enumerations change
  • KB coverage note change
  • KB location change
  • KB provider name change
  • KB title level note change
  • KB URL change
  • LBD data change
  • LHR data change
  • WorldCat record 040 $e
  • WorldCat record DtSt change
  • WorldCat record encoding level change
  • WorldCat record variable field(s) change **
  • OCLC control number change
  • RDA change
  • Subsequent record output **

** Please note:

  • For records that include the reason WorldCat record variable field(s) change: Tags may be included with the reason. Whether or not a tag is included is based on the tags you selected to specify the changes that will trigger the output of an updated record.
    See your settings in Institution Settings > MARC Records > WorldCat Updates > Update Conditions. For more information about the setting, see MARC Records, WorldCat Updates and expand the Include and Exclude sections.
    • Example:
      WorldCat record variable field(s) change: 650
  • For records that include the reason Subsequent record output: These records are from collections where you have chosen the option in the collection-level settings Include a complete set of records with every delivery to have the entire collection delivered with every run.
    For more information about the setting, see Collection-level settings in knowledge base collections or Collection-level settings in query collections.
     
  • If a record has multiple reasons, the reasons will be separated by hyphens.
    • Example of a single reason:
      WorldCat record variable field(s) change: 650, 700, 710
    • Example of multiple reasons:
      OCLC control number change—WorldCat record variable field(s) change: 650, 700, 710—WorldCat record 040—RDA change

Collection Custom Text

Custom text labels can be used with knowledge base, cataloging partner and query collections to remember what notations were placed in custom text areas. See Collection Custom Text for instructions.