LIBRARY HOLDINGS DETAIL Table
View exposing detailed library holdings records including item identifiers, locations, volume attributes, and availability indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HOLDINGS_CALL_NUMBER |
Holdings call number associated with the record. |
VARCHAR2 |
100 |
HOLDINGS_CALL_NUMBER_PREFIX |
Holdings call number prefix associated with the record. |
VARCHAR2 |
100 |
HOLDINGS_SUMMARY_STATEMENT |
Holdings summary statement associated with the record. |
VARCHAR2 |
500 |
IS_OPEN_HOLDINGS |
Indicator identifying whether open holdings (Y/N). |
VARCHAR2 |
1 |
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
LIBRARY_COLLECTION_KEY |
Surrogate key identifying the library collection. |
VARCHAR2 |
12 |
LIBRARY_HOLDINGS_KEY |
Surrogate key identifying the library holdings. |
VARCHAR2 |
9 |
LIBRARY_KEY |
Surrogate key identifying the library. |
VARCHAR2 |
3 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
RECORD_CREATE_DATE |
Date associated with record create. |
DATE |
|
RECORD_UPDATE_DATE |
Date associated with record update. |
DATE |
|
RETENTION_NOTE |
Retention note associated with the record. |
VARCHAR2 |
500 |
SUBSCRIPTION_END_DATE |
Date associated with subscription end. |
DATE |
|
SUBSCRIPTION_START_DATE |
Date associated with subscription start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |