LIBRARY HOLDINGS Table
View exposing library holdings summary records including bibliographic identifiers, locations, and holdings counts used for collection reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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_HOLDINGS_KEY |
Surrogate key identifying the library holdings. |
VARCHAR2 |
9 |
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 |