Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY CIRC ITEM STATUS Table


View exposing library circulation item status reference values used to describe the availability and circulation state of items.


Field Name

Description

Data Type

Length

LIBRARY_CIRC_ITEM_STATUS

Library circ item status associated with the record.

VARCHAR2

40

LIBRARY_CIRC_ITEM_STATUS_CODE

Code identifying library circ item status.

VARCHAR2

3

LIBRARY_CIRC_ITEM_STATUS_KEY

Surrogate key identifying the library circ item status.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE