Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Library Item Detail


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

LIBRARY_CATALOG

Includes bibliographic data such as Title, Author, Imprint, Year of Publication, ISSN/ISBN, Call Number, bib record creation and update dates and the bib system number (from MIT01). Data in this table is taken from the Z13 table in Aleph. Do not use the call number for limiting queries, use the LIBRARY_CALL_NUMBER_SEARCH table to limit the query by classification.

Dimension

Libraries

MIT ONLY

Daily

05-APR-2012

LIBRARY_ITEM_STATUS

Includes descriptions of both the Item Status (e.g., 28 Day Loan, 1 Week Loan) and the Item Processing Status (e.g., On Order, Received, Claimed). Note that only the description of the codes are currently included (e.g., Received) and not the codes themselves (e.g., RD). Use this table to limit by statuses.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_COLLECTION

Includes codes and definitions of library collections as well as the type of material. Data in this table is taken from the Z30 table in Aleph. Use this table to limit the query to collection (e.g., Stacks, Electronic Journals, Basement, etc.)

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY

Includes codes and descriptions of the MIT Libraries. This is the library that "owns" the item. (these are defined as Sub Libraries in Aleph, and include SAS, Document Services, Physics Reading Room, etc.). Use this table to limit the query by library that owns the item. Use the LIBRARY_FUND "Paying Library" field to limit the query by the library that paid for the item.

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_ITEM_DETAIL

Includes detailed information contained in the Item Records in Aleph (e.g., Barcode, Serial Levels, Call Number, Update Date). Data in this table is taken from the Z30 table in Aleph

Fact

Libraries

MIT ONLY

Daily

08-JAN-2020

LIBRARY_CALL_NO_STRUCTURE

Includes codes and descriptions of Classification Schemes. Use this table to limit the query by whether there is a Call Number, Classification type and Prefix (Dewey Decimal, SCORE, etc.)

Dimension

Libraries

MIT ONLY

Daily

Unavailable

LIBRARY_CALL_NUMBER_SEARCH

Includes the classification number and a calculated classification number. Use this table to limit the query by classification.

Dimension

Libraries

MIT ONLY

Daily

08-JAN-2020