Medical Related Database

  • Thread starter Thread starter Brigham Siton
  • Start date Start date
B

Brigham Siton

Is there anybody here that is developing or has developed a Medical Related
Database?

I just have a question on EDI.

Thank you very much.
 
Brigham Siton said:
Is there anybody here that is developing or has developed a Medical
Related Database?

I just have a question on EDI.

Thank you very much.
Click to expand...

I've done databases and I've done a bit medical EDI, but not both
together. Still, I may be able to answer your question. What is it?
 
Great! I need to know the records layout for exporting and importing the
Form 837. Or if you have any other solution to do this.

Thanks so much and looking forward to hear from you.
 
Brigham Siton said:
Great! I need to know the records layout for exporting and importing
the Form 837. Or if you have any other solution to do this.
Click to expand...

Are you talking about the HIPAA (ASC X12N) 837 Health Care Claim
transaction?
 
Our mail goal is to be able to process this transactions inbound and
outbound.

What we are planning to do is to have on our website a form that the doctors
and hospitals can use to submit claims.

Then we collect these data and dump into access for manual review of the
processors. Then we transfer it into the actual claims processing (AS/400
based system).

I really appreciate your time helping me with this.
 
Great. You are the man.

I will reaserach more into this. You are right, discussion forums is not
suitable for this subject.

In regards to our website, it is a secure site.

Anyway, thank you very much for all your help.
 
Sorry to jump in on this discussion, but I am currently
working on the 837 professional. What a bear! Hours of
work?

But I actually have a small question. I have gotten to the
point of creating all the segments. However, each segment
is in a seperate record so that when I exported it I could
see that the order was right. It is so hard to view!

As you know I can't have carriage returns in the file, so
my question is, what is the best way to export without
carriage return. I have tried moving everything into a
memo field, but it is a blob. I have tried using VB to
write to the file, but I still get the carriage returns.

Any help would greatly be appreciated.

James Muka
 
James Muka said:
Sorry to jump in on this discussion, but I am currently
working on the 837 professional. What a bear! Hours of
work?

But I actually have a small question. I have gotten to the
point of creating all the segments. However, each segment
is in a seperate record so that when I exported it I could
see that the order was right. It is so hard to view!

As you know I can't have carriage returns in the file, so
my question is, what is the best way to export without
carriage return. I have tried moving everything into a
memo field, but it is a blob. I have tried using VB to
write to the file, but I still get the carriage returns.

Any help would greatly be appreciated.
Click to expand...

You should be able to write out the segments to a text file using
standard VB I/O statements without getting carriage returns. I've done
it; the trick is to finish each Print# statement (if that's what you
use) with a semicolon, like this:

Print #intFileNo, strSegmentData;
 
Back
Top