Collection Code Mapping

How were items assigned a collection?

During mapping, CCS staff reviewed a list of the over 6,000 unique combinations of Item cat 2, Item cat 3, Item Type and Home Location found in the Symphony database, and assigned a matching Collection code to each combinations.

Example:

Item Cat 2

ADULT

ADULT

Item Cat 3

AUDIOBKCD

AUDIOBKCD

Item Type

NEW_AUDBK

NEW_AUDBKL

Home Location

WLK-NEW

EVK_AV

Collection

Multimedia

Multimedia

There were a number of unique combinations that we were unable to identify with the above information. 

Example:

Item Cat 2

JUV

ADULT

Item Cat 3

BOOK

BOOK

Item Type

BOOK

BOOK

Home Location

J-DEPT

LOWERLEVEL

Collection

???

???

For these combinations, Polaris added in the additional field of Item Cat 4. This generated a new list of over 8,000 unique combinations of Item cat 2, Item cat 3, Item Cat 4, Item Type and Home Location. CCS then went through these combinations and assigned the proper collection code where applicable.

Item Cat 2

ADULT

ADULT

Item Cat 3

BOOK

BOOK

Item Type

BOOK

BOOK

Home Location

MAINLEVEL

MAINLEVEL

Item Cat 4

FIC

900

Collection

Fiction

Nonfiction

In some instances, we were still unable to identify which collection the item belonged in. 

For example, because many libraries used Item Cat 4 to identify a book as Large Type, we still couldn’t ascertain whether or not some combinations belonged to Fiction or Nonfiction collections.

Item Cat 2

ADULT

ADULT

Item Cat 3

BOOK

BOOK

Item Type

BOOK

BOOK

Home Location

2LEVEL

A-DEPT

Item Cat 4

LARGEPRT

LARGEPRT

Collection

???

???

Polaris was able to do some additional mapping based on call number specifically for Large Print materials:

  • If the call number contains text only, items will be mapped to Fiction.

  • If the call number contains one or more number, assign non-fiction.

Some items whose collection could not be clearly identified based on Item Cat 2, Item Cat 3, Item Type, Home Location and Item Cat 4 have not have been mapped to a collection. These items will be targeted for cleanup during data testing.