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 |