LIBRARY CALL NO STRUCTURE Table
View exposing parsed library call number structure attributes used for shelving organization, catalog navigation, and search operations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_BLANK_CALL_NUMBER |
Indicator identifying whether blank call number (Y/N). |
VARCHAR2 |
1 |
IS_INVALID_CALL_NUMBER |
Indicator identifying whether invalid call number (Y/N). |
VARCHAR2 |
1 |
LIBRARY_CALL_NO_STRUCTURE_KEY |
Surrogate key identifying the library call no structure. |
VARCHAR2 |
30 |
LIBRARY_CALL_NUMBER_PREFIX |
Library call number prefix associated with the record. |
VARCHAR2 |
20 |
LIBRARY_CALL_NUMBER_TYPE |
Library call number type associated with the record. |
VARCHAR2 |
100 |
LIBRARY_CALL_NUMBER_TYPE_CODE |
Code identifying library call number type. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |