Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Free Text field in Item record stored in which database table?

    Free Text field in Item record stored in which database table?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

    Question

    We could make use of Pick and Scan to update Free Text field in Item records if we can run an Access report on this field. However, this field is not stored in ITEM table. Which table stores Item record Free Text field?

    Answer

    The "Free Text" data is in the MFHD_ITEM table:

    Name      Null? Type
    --------- ----- -------------
    MFHD_ID         NUMBER(38)
    ITEM_ID         NUMBER(38)
    ITEM_ENUM       VARCHAR2(80)
    CHRON           VARCHAR2(80)
    YEAR            VARCHAR2(20)
    CAPTION         VARCHAR2(256)
    FREETEXT        VARCHAR2(256)

    The general guideline is that human-readable public info about items is in the MFHD_ITEM table (except barcodes, which are in ITEM_BARCODE), while generally internal/staff data about items is in the ITEM table (number of pieces, whether it's on Reserve, spine label, and lots of circulation-related info).


    • Article last edited: 10-Apr-2022
    View article in the Exlibris Knowledge Center
    1. Back to top
      • FPC:No funds in new ledger
      • From what point are recall fines calculated in Voyager for an overdue item that is recalled?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved