LIBRARY CIRC ITEM STATUS Table
Includes codes and descriptions about the item status (2 Day Loan, ILB Loan, 2 Week Loan, etc. Use this table to limit circulation reports by item status.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_CIRC_ITEM_STATUS |
Description of the item status, or circulation rules, for the item. E.g. 30 Day Loan. Use to limit queries by item status. When used with LIBRARY_CIRCULATION_DETAIL, this is the item status at the time of the event, not necessarily the current item status. (Z35-ITEM-STATUS) |
VARCHAR2 |
40 |
LIBRARY_CIRC_ITEM_STATUS_CODE |
Two digit code for the item status, or circulation rules, for the item. (e.g. 01 for 30 Day Loan). Use to limit queries by item status. When used with LIBRARY_CIRCULATION_DETAIL, this is the item status at the time of the event, not necessarily the current item status. (Z35-ITEM-STATUS) |
VARCHAR2 |
3 |
LIBRARY_CIRC_ITEM_STATUS_KEY |
Key used to join to the LIBRARY_CIRC_ITEM_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |