LIBRARY CALL NO STRUCTURE Table
Includes codes and descriptions of Classification Schemes. Use this table to limit the query by whether there is a Call Number, Classification type and Prefix (Dewey Decimal, SCORE, etc.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_BLANK_CALL_NUMBER |
Set to "Y" when the call number field is empty, otherwise is it set to "N". |
VARCHAR2 |
1 |
IS_INVALID_CALL_NUMBER |
Set to ""Y"" when no $$h was found when parsing the call number, otherwise it is set to ""N"". Note: it could be an acquisition record with no Call No. yet assigned. If field says: ""No Call No."" or $$2 ""Hfcl"" this is valid since it may be a Journal. It |
VARCHAR2 |
1 |
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_PREFIX |
Call No. Prefix, E.g., SCORE. Indexed and used both to limit queries and perform sorts. (Z30-CALL-NO) |
VARCHAR2 |
20 |
LIBRARY_CALL_NUMBER_TYPE |
Classification types taken from the MARC Format for Holdings Data (852), the Location (shelving scheme). E.g., 0 - LC; 1 - DDC; 3 - SuDocs, 7 - Source specified in $2; 8 - Other. N/A is added when there is no scheme. (Z30-CALL-NO-TYPE) |
VARCHAR2 |
100 |
LIBRARY_CALL_NUMBER_TYPE_CODE |
Numeric code for classification types taken from the MARC Format for Holdings Data (852), the Location (shelving scheme). E.g., 0 - LC; 1- DDC; 3 - SuDocs; 7 - Source specified in $2; 8 - Other. N/A is added when there is no scheme. (Z30-CALL-NO-TYPE) |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |