Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare


    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?


    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
    • Was this article helpful?