Notifications
Clear all
Topic starter
Hello CHUG,
There are a lot of features in our custom forms that are coded to function based on ICD-9 codes. I'm assuming that we are not alone in this. How is everyone identifying which forms contain code that look for only ICD9 codes? I believe that we will have to update these forms to look for the new ICD10 code, but going through each form manually is ALOT of work (we have over 1500 custom forms, 300+ providers.)
Thank you.
Mike
Posted : August 6, 2015 5:21 am
The VFE kits produce a text file that lists which obs terms, custom lists etc were used. I tried using windows search to look for ICD within a folder that had all of our VFE forms in it and it did find some forms with ICD9 codes in them. You might need to modify your windows search to allow it to search through the files contents - not just for file name. Hope this helps.
Posted : August 6, 2015 6:06 am
I use File Locator (There is a free version File Locator Lite and File Locator Pro with more search features). This has been very helpful in searching the CONTENT of files. I was not able to get windows search to work (it ignored the VFE file extensions) so I finally gave up on it. - Beverly
Posted : August 6, 2015 8:18 am
Topic starter
Thank you for the feedback. If anyone else has another process for this please feel free to post on this chain. It would be nice to have a few different options for everyone on here.
Beverly/Jenn, May I ask is there any specific identifier you're searching for in the files? I was thinking "ICD" since I don't believe that is included in the ICD10 codes.
-Mike
Posted : August 6, 2015 8:32 am
Yes, I looked for "ICD" and it found that within the text files that are generated from the VFE kit. When you save the VFE form, it generates several files with the file extensions of :.ckt, .dlg, .efm, .pef, .txt,.xlt and .xlw. Windows can search within the .txt tiles. You can open one up in notepad just to look and see what you might find in there. Jen
Posted : August 6, 2015 8:42 am
Topic starter
Yeah, I see the file you're talking about. That works great for the order/med buttons that include ICD. At first glance I didn't see any code included from the MEL worksheet. We have a lot of code that is setup in there to trigger visibility fields based on ICD codes.
Posted : August 6, 2015 8:56 am
Gotcha, hopefully the other program mentioned can search within the other file types then. I've just started looking myself and only use VFE a little right now but did find a few of our forms that need modification. I haven't validated at all but am checking the formset table to see if that offers anything also. Good luck!
select * from formset where FORMXLATEDEF like '%ICD%'
select * from formset where WATCHERS like '%ICD%'
Posted : August 6, 2015 9:56 am
Topic starter
Hey Jennifer,
Just wanted to check if that query worked out for you?
Thanks for the help.
Mike
Posted : August 17, 2015 10:15 am
It definitely returned several forms and it may work but I need to validate it. I'm not sure we have a form with the MEL in it like you do. I am able to see within the watchers and the other field holding mel though. If you have one form example that you know has ICD codes in the worksheet area, can you send it to me and I can load in my test system and see if this query finds it as expected? I'll send you the results to see you feel it will work. Sorry, I work more with Crystal and the database these days and haven't been making most of our VFE edits - only importing and testing. Thanks. Jen
Posted : August 18, 2015 12:01 pm
