LIBRARY BORROWER STATUS Table
Includes codes and desciptions about the borrower's status (Graduate student, Boston Library Consortium, etc.) and type (BLC - Umass-Amherst, Undrgraduate Student - Wellesley, etc.). Use this table to limit Circulation statistics by borrower status or type.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_BORROWER_STATUS |
The description for the library borrower status. (e.g. Faculty). Older statuses marked do not use were in use prior to August 2007. |
VARCHAR2 |
40 |
LIBRARY_BORROWER_STATUS_CODE |
Two digit code for the library borrower status. (e.g. 11). Older statuses marked do not use were in use prior to August 2007. |
VARCHAR2 |
3 |
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_BORROWER_TYPE |
The description for the library borrower type. Generally represents the patron's primary MIT department affiliation (e.g. Libraries). Older statuses marked do not use were in use prior to August 2007. |
VARCHAR2 |
40 |
LIBRARY_BORROWER_TYPE_CODE |
Two letter code for the library borrower type. Generally represents the patron's primary MIT department affiliation (e.g. WG). These codes have no meaning outside of reporting with Aleph data. Older statuses marked do not use were in use prior to August 2007. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |