LIBRARY HOLDINGS DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HOLDINGS_CALL_NUMBER |
XXX |
VARCHAR2 |
100 |
HOLDINGS_CALL_NUMBER_PREFIX |
XXX |
VARCHAR2 |
100 |
HOLDINGS_SUMMARY_STATEMENT |
XXX |
VARCHAR2 |
500 |
IS_OPEN_HOLDINGS |
XXX |
VARCHAR2 |
1 |
LIBRARY_CATALOG_KEY |
Key used to join to the LIBRARY_CATALOG table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
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 |
12 |
LIBRARY_HOLDINGS_KEY |
XXX |
VARCHAR2 |
9 |
LIBRARY_KEY |
Key used to join to the LIBRARY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
RECORD_CREATE_DATE |
XXX |
DATE |
|
RECORD_UPDATE_DATE |
XXX |
DATE |
|
RETENTION_NOTE |
XXX |
VARCHAR2 |
500 |
SUBSCRIPTION_END_DATE |
End date of the Serial subscription |
DATE |
|
SUBSCRIPTION_START_DATE |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |