Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY CIRCULATION DETAIL Table


Includes information about the circulation transaction including dates, hours and staff checking out the item; as well as the type of material (BOOK, ISSUE, etc.). This data comes from the Aleph Z35 Events Table. Note: Do not use this table to determine the Total counts of Circulation prior to 7/9/2001; there is no detail information available in the Circulation Detail table until this date. Refer to the Item Detail table to obtain this data.


Field Name

Description

Data Type

Length

LIBRARY_BORROWER_STATUS_KEY

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

VARCHAR2

20

LIBRARY_CATALOGER_NAME

The staff user name associated with a circulation transaction. This is NOT the library patron; it is the library staff member who performed the transaction.

VARCHAR2

10

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_CIRCULATION_EVENT_DATE

The date a circulation transaction was registered.

DATE

8

LIBRARY_CIRCULATION_EVENT_HOUR

The time that a circulation transaction was registered.

VARCHAR2

5

LIBRARY_CIRC_EVENT_TYPE_KEY

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

VARCHAR2

50

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

LIBRARY_ITEM_KEY

XXX

VARCHAR2

15

LIBRARY_KEY

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

VARCHAR2

3

LIBRARY_MATERIAL

XXX

VARCHAR2

5

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

WAREHOUSE_LOAD_DATE

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

DATE

8