Version: All

Q - I tried to access Elliott Item master column ITEM_CASE_SIZE in Report Desk.  In one of the Report Desk reports, I wanted to drag ITEM_CASE_SIZE to the report body.  But I can't find that column under the IMITMFIL node.  See example below:

On the other hand, I have confirmed that the EL850CF.EXE database tab points to the correct database (ELIDATA02) and that the database is configured to point to a DDF folder that has the latest Elliott DDF.  If I go to the PSQL Control Center, I can see that the IMITMFIL table has ITEM_CASE_SIZE column as well.  See sample screen below:

A - After investigating this case further, we found out that it is due to the fact that there are DDF files in the corresponding DATA folder.  The PSQL engine may be confused when the DDF files are found in the corresponding DATA folder.  By removing it, the ITEM_CASE_SIZE column shows up:

Please see this related KB article: https://support.elliott.com/knowledgebase/articles/1853854-ddf-files-in-data-folder-may-confuse-psql

EMK