Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY COLLECTION Table


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.)


Field Name

Description

Data Type

Length

LIBRARY_COLLECTION

Description for the item's collection within the library. E.g. Stacks, Journals (Z30-COLLECTION)

VARCHAR2

100

LIBRARY_COLLECTION_CODE

Code for the item's collection within the library. E.g. STACK, JRNAL (Z30-COLLECTION)

VARCHAR2

5

LIBRARY_COLLECTION_KEY

Key used to join to the LIBRARY_COLLECTION table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

20

LIBRARY_ITEM_MATERIAL

Values are Book, Bound Issue, Serial (Z30-MATERIAL)

VARCHAR2

30

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8