LIBRARY ITEM DETAIL Table
Includes detailed information contained in the Item Records in Aleph (e.g., Barcode, Serial Levels, Call Number, Update Date). Data in this table is taken from the Z30 table in Aleph
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CALL_NUMBER |
Shelving location without the collection information; MIT puts both the classification and rest of the call number (vol. item, part, date) in $$h. Do not use to limit a query to check whether it is null, since it never is (if blank it is set to N/A) Instead use the IS_BLANK_CALL_NUMBER field from the LIBRARY_CALL_NO_STRUCTURE table, and the CALL_NUMBER_SEARCH field from the LIBRARY_CALL_NUMBER_SEARCH table to limit query by class. |
VARCHAR2 |
100 |
CALL_NUMBER_CLASS |
Use to display the Class No. in a report. Type 0 only (LC) Class No. up to first period (note that some classes should include the period and number following it but don't because the data does not come from 050 $$a - the class was extracted with the letter and number up to the first period only from the Aleph item record). This field should not be used to limit by Class No. Use the CALL_NUMBER_SEARCH field from the LIBRARY_CALL_NUMBER_SEARCH field to limit a query. (Z30-CALL-NO) |
VARCHAR2 |
50 |
CALL_NUMBER_PREFIX |
Used for display in reports when the LIBRARY_CALL_NUMBER_STRUCTURE table is not used in the query. Taken from $$k (E.g. SCORE) Use the LIBRARY CALL_NUMBER _PREFIX field from the LIBRARY_CALL_NUMBER_STRUCTURE table to limit query or if the field will be used to sort data. (Z30-CALL-NO) |
VARCHAR2 |
50 |
CALL_NUMBER_SEARCH_KEY |
Key used to join to the LIBRARY_CALL_NUMBER_SEARCH table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
50 |
CALL_NUMBER_SORT |
Used to sort the call number according to LC class based on the Aleph filing system. Use in the Report Outliner - Category box (top box) to enter for a sort, then hide it from displaying. |
VARCHAR2 |
80 |
CALL_NUMBER_SOURCE |
$$2 (used only when call number type is 7) Hfcl - Half class or Mu - Music (Z30-CALL-NO) |
VARCHAR2 |
50 |
CALL_NUMBER_SUFFIX |
No longer used, was used for Serial or On Reserve (Z30-CALL-NO) |
VARCHAR2 |
50 |
CHRONOLOGICAL_I |
Year (Aleph Z30) |
VARCHAR2 |
20 |
CHRONOLOGICAL_J |
month (Aleph Z30) |
VARCHAR2 |
20 |
CHRONOLOGICAL_K |
day (Aleph Z30) |
VARCHAR2 |
20 |
CHRONOLOGICAL_L |
Suppl, etc. (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_A |
vol. level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_B |
issue no level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_C |
subpart of vol level, eg. Supplement (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_D |
4th level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_E |
5th level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_F |
6th level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_G |
Alternative schema - 1st level (Aleph Z30) |
VARCHAR2 |
20 |
ENUMERATION_H |
Alternative schema - 2nd level (Aleph Z30) |
VARCHAR2 |
20 |
IS_ITEM_LOCATION_TEMPORARY |
Used to limit queries by overriding of the location fields by the HOL (holdings) record. Based on the Item status and item process statuses. E.g., could be in bindery, etc. |
VARCHAR2 |
1 |
ITEM_PROCESS_STATUS_DATE |
XXX |
DATE |
8 |
LIBRARY_ADM_KEY |
Key used to join two tables by the LIBRARY_ADM number, as opposed to the LIBRARY_CATALOG_KEY. Used especially with Course Reserves data, where LIBRARY_RESERVE_CATALOG_KEY does not match up with LIBRARY_CATALOG_KEY, but connect to a shared LIBRARY_ITEM_DETAIL. |
VARCHAR2 |
20 |
LIBRARY_CALL_NO_STRUCTURE_KEY |
Key used to join to the Library_Item_Detail_Table. Consists of: Library Call No. Type Code (Code of classification scheme); Prefix; Is Library Call No. Valid; and Is blank Call No. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_CALL_NUMBER_ALEPH |
The call number as stored in the Aleph database, including subfield (e.g. $$h) markers. |
VARCHAR2 |
200 |
LIBRARY_CATALOGER_ID |
Staff User name for the last persion to update the item. (Z30-CATALOGER) |
VARCHAR2 |
10 |
LIBRARY_CATALOG_KEY |
Key used to join to the LIBRARY_CATALOG table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_COLLECTION_KEY |
Key used to join to the LIBRARY_COLLECTION table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_HOLDINGS_KEY |
XXX |
VARCHAR2 |
9 |
LIBRARY_HOL_DOC_NUMBER_X |
Holdings system number generated in Aleph MIT_60. (Z30-HOL-DOC-Number) |
VARCHAR2 |
9 |
LIBRARY_ISSUE_ARRIVAL_DATE |
XXX |
DATE |
8 |
LIBRARY_ISSUE_EXPEC_ARRVL_DATE |
XXX |
DATE |
8 |
LIBRARY_ITEM_BARCODE |
Unique identifier of item. When an item is ordered, an item record is created and given an ""N"" barcode (a prefix N and a sequential number); after it arrives and is physically barcoded, ""N"" is replaced with a physical bar code (with a prefix of 39080) this has a Process Status of: Received/not yet available (reserve, etc.); after available, prefix is dropped and status changes. This is an instance where the Barcode (Fact Table) may be used to limit since it is a unique entry. (Z30-BARCODE) |
VARCHAR2 |
15 |
LIBRARY_ITEM_DESCRIPTION |
For Serials or multivolumes - vol., pt, issues, dates (Z30-DESCRIPTION) |
VARCHAR2 |
200 |
LIBRARY_ITEM_ISSUE_DATE |
For serials - Z30 Issue Date - Publication date of issue. |
DATE |
8 |
LIBRARY_ITEM_KEY |
XXX |
VARCHAR2 |
15 |
LIBRARY_ITEM_LAST_RETURN_DATE |
Date of last return transaction (circulation). (Z30-DATE-LAST-RETURNED). Used for statistical purposes. |
DATE |
8 |
LIBRARY_ITEM_LOANS_NUMBER |
Cumulative number of loans for item - from July, 1995 to present only. (Z30-NO-LOANS). Use for statistical purposes. |
NUMBER |
22 |
LIBRARY_ITEM_OPEN_DATE |
Date the item record was created. (Z30-OPEN-DATE) |
DATE |
8 |
LIBRARY_ITEM_STATUS_KEY |
Key used to join to the LIBRARY_ITEM_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_ITEM_UPDATE_DATE |
Date the item was last updated. (Z30-UPDATE-DATE) |
DATE |
8 |
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_ORDER_KEY |
Key used to join to the LIBRARY_ORDER table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
14 |
LIBRARY_ORDER_STATUS_KEY |
Key used to join to the LIBRARY_ORDER_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_KEY |
Key used to join to the LIBRARY _ORDER_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_VENDOR_KEY |
Key used to join to the LIBRARY_VENDOR table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
ORDER_NUMBER |
Order number from Acquisitions order record (Z30-ORDER-NUMBER) |
VARCHAR2 |
30 |
PUBLIC_NOTE |
Item note for display in the public OPAC (Z30-NOTE-OPAC) |
VARCHAR2 |
50 |
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 |