Overview of using the LCCLASS_VW view in Voyager Prepackaged Access Reports
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Question
Overview of using the LCCLASS_VW view (table) in Voyager's Prepackaged Access Reports.
Answer
This table parses LC class numbers, which greatly facilitates statistics by call number.
Consider the class number, ML410. Class=ML, classnumber=410, firstletter=M, longclass=MLbb410.
Those b’s are blanks. Longclass is padded with blanks so that numbers sort nicely. When a class number has a decimal point and digits following, these are not included in longclass.
Additional Information
If you are doing statistics by the first letter of the LC class code, you can easily add a description of the class to your results. Link firstletter in LCCLASS_VW to ClassLetter in LCClassBrief and show the Description field.
If you are doing statistics by the alphabetic part of the LC class code, you can easily add a description of the class to your results. Link firstletter in LCCLASS_VW to ClassLetters in LCClassDetailed and show the Description field.
The basic information provided here is also applicable to NLMCLASS_VW as the parsing is similar. DEWEYCLASS_VW is quite different, see: Overview of the DEWEYCLASS_VW view in Voyager Prepackaged Access Reports
Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes. Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.
- Article last edited: 19-Oct-2020