Shelflist Report Definition, 2017 March Release

Description

The Shelflist Report includes a list of all locations and their associated top containers.

Purpose

This report is intended to support storage assessment, inventorying, shelf-reading projects. It is designed to answer the following questions:

  • What are the locations that do not have associated containers?

  • What are the locations that have containers, and what containers are they and to what accessions and resources do they belong?  

  • What are the temporary locations and which ones have associated containers, and what containers are they and to what accessions and resources do they belong?

Data Sources

Label

Table

Field

Example

Repository

repository
name

Special Collections

Temporary Location

location
temporary_id

null

Building

location
building

Library

Floor

location
floor

4

Room

location
room

440

Area

location
area

Manuscripts

Location Barcode

location
barcode

11988006457623

Coordinate Label 1

location
coordinate_1_label

Row

Coordinate Indicator 1

location
coordinate_1_indicator

1

Coordinate Label 2

location
coordinate_2_label

Section

Coordinate Indicator 2

location
coordinate_2_indicator

1

Coordinate Label 3

location
coordinate_3_label

Shelf

Coordinate Indicator 3

location
coordinate_3_indicator

1

Location Profile

location_profile
name

Compact Storage Shelf

Title

accession
resource
title
title

Cadek Conservatory programs and photographs

Identifier

accession
resource
identifier
identifier

MS-009

Container Type

container
type_1_id

Box

Container Indicator

container
indicator_1

1

Container Barcode

container
barcode_1

11988006458544

Container Profile

container_profile
name

Document Case (Legal)

Formatting

Enumeration identifiers should be translated to their corresponding enumeration values for the fields listed below.

  • location.temporary_id
  • container.type_1_id

Brackets, quotation marks, commas, and null values should be removed from the fields listed below. Instead, subfields should be separated by hyphens, e.g. ABC123-DEF456-GHI789-JKL123.

  • accession.identifier
  • resource.identifier

Additional Notes

When constructing the report, care must be taken to allow nulls in all fields.  In particular, the report should not fail simply because an institution has chosen not to use the Location or Container Management functionality.

Sample Exports