Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY CIRCULATION DESK Table


Includess the IP Address of the client (GUI or Web), the 3-digit Code for where the item was checked out (the library or self-check desk), and the Name of the Library or Location to which the item belongs.


Field Name

Description

Data Type

Length

LIBRARY_CIRCULATION_DESK_KEY

Key used to join to the LIBRARY_CIRCULATION_DESK table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

35

LIBRARY_CIRC_DESK

The circulation desk that a circulation computer's IP address is associated with. Used in reports that are meant to measure service desk activity, as opposed to use of the collection.

VARCHAR2

50

LIBRARY_CIRC_DESK_IP_ADDR

The internet IP address for a circulation workstation. Used in reports that measure circulation desk activity.

VARCHAR2

20

LIBRARY_OF_CIRC

XXX

VARCHAR2

100

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8