Has anyone created an ANSI 837 file , NSF File  or a hicfa 1500 print image file from data contained in there Sesame Database?  

Thanks

Thanks Erika,

As you know the HCFA 1500 is a medical billing form. In the past I had a Q&A win application that using a free form report printed the correct data on to the old HCFA 1500 form. As time went on and electronic billing became a necessity, they used some unique techniques to get the data to a clearing house for the billing.  The people using it have not been very receptive to switching away from Q&A. Recently they have seen what is capable with Sesame and I have started to win them over. They are starting to realize that many, many improvements could be had using Sesame and Sbasic but a big issue is billing capabilities. I am working on options for this.

The HCFA 1500 has been replaced by what is now commonly called the CMS 1500. It is an improved version of the old HCFA 1500. There are also many clearing houses that you can submit claim through that will validate accuracy and completeness of data and format for HIPPA compliance without the submitter incurring any costs. (The payer source incurs the cost) They will accept ANSI 837, NSF and print image files.

I figure there are a couple of options.

1.      find the structure to the ANSI 837 and figure out how to create it
2.      find the structure to the NSF file and figure out how to create it
3.      as you stated use Sbasics printing commands and layout the data as needed to print to the new CMS 1500 and then see if I can print that to a file in an acceptable print Image format
4.      find a small third party claims software program and see if I can pump the data from Sesame into it and then call the application from Sesame.

I was struggling with the best road to take so I figured I would ask on the forum if anyone has had experience with the different file formats. This forum and all the people on it have become my safety net and valued and trusted resource. As long as I know you all are out there to throw out bits of insight and knowledge, I feel capable of solving any task.

Thanks

Hi Robert

I still have a Q&A client that is outputting HCFA and CMS formats.  Some claims are still done manually using the HCFA and others are sent electronically using CMS formats.  I can provide you the Q&A File Print Specs with the coordinates for both forms if you need them.  I have not yet converted them to Sesame (may never happen), so I have not tried this in Sesame yet.

Let me know if this will help you.

I will see if I can contact client on Wed and get copy of both of the Print Specs. 

My thought was that those coordinates might be useful when writing the Print String.  I will probably have to send you the entire Q&A file so you can match the fields with the specs.  I will try to get with some records that you can use as an example. 

I would probably take the approach of scanning the form to use as a Sesame background, but would split it into Tabs to eliminate the scrolling.  Hmmm, I am thinking that this Q&A application also has all the programming to fill in as many fields as possible for Primary and Secondary billing purposes, very little data entry is needed since many XLUs from Patient/Doctors/Carriers/ProcCode/DiaCode databases.  Could be translated directly into Sesame.  Usually takes less than 2 mins to fill in a full form.

This will be Q&A 4.0, they never upgraded, is that OK? 
Do you still have version 4?  If not, I will upgrade to version 5 for you. 

I have been using NSF version T0301, HIPAA compliant format for electronic claim submission. I make the file using Q&A. Not worked on it for Sesame yet. But ANSI 837 is the way to go, as NSF might not be accepted in the future.

Thanks Bob. I get the data from my visit record and do not print form 1500. But it should work either way once you have made the code. Thanks again.