LIBRARY ITEM STATUS Table
Includes descriptions of both the Item Status (e.g., 28 Day Loan, 1 Week Loan) and the Item Processing Status (e.g., On Order, Received, Claimed). Note that only the description of the codes are currently included (e.g., Received) and not the codes themselves (e.g., RD). Use this table to limit by statuses.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_ITEM_PROCESS_STATUS |
Description of the item processing status, e.g. On Order. Use to limit queries by processing status. (Z30-ITEM-PROCESS-STATUS) |
VARCHAR2 |
40 |
LIBRARY_ITEM_PROCESS_STAT_CODE |
XXX |
VARCHAR2 |
3 |
LIBRARY_ITEM_STATUS |
Description of the item status, or circulation rules, for the item. E.g. 28 day loan. Use to limit queries by item status. (Z30-ITEM-STATUS) |
VARCHAR2 |
40 |
LIBRARY_ITEM_STATUS_CODE |
XXX |
VARCHAR2 |
3 |
LIBRARY_ITEM_STATUS_KEY |
Key used to join to the LIBRARY_ITEM_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |