Free Text field in Item record stored in which database table?
- 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