LIBRARY CIRC EVENT TYPE Table
Includes codes and desciptions about the event type (return, loan, hold), and the circulation type (i.e., the source such as PC Client, Self-Check, Your Acct). Excluded are details about active holds (Z37) or active loans (Z36). If you want a historical report about holds, contact the MIT Libraries Aleph Administrator. Use this table to limit Circulation statistics by event or circulation types.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIRCULATION_TYPE |
XXX |
VARCHAR2 |
50 |
CIRCULATION_TYPE_CODE |
XXX |
VARCHAR2 |
1 |
LIBRARY_CIRC_EVENT_TYPE |
2 digit code from Aleph database representing the circulation even type (e.g. 50 for Loan). |
VARCHAR2 |
100 |
LIBRARY_CIRC_EVENT_TYPE_CODE |
The description of the library circulation event (e.g. Loan, Return). |
NUMBER |
22 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |