Thanks Razzak I was told it would be ANSI or something like that. I looked at some of the info from Medicare's site and it is way over my head. It looks like a lot of work.
Thanks for the links. Marc ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 8:47 AM Subject: [RBG7-L] - Re: 835 Payment info > At 07:38 AM 8/24/2004 -0500, Marc Shluter wrote: > > >Does anyone know how to import 835 insurance payment data > >into Rbase? > > > >This is the payment info or EOB (explination of Benefits) > >from the insurance company. > > > Marc, > > Is the data from insurance company EDI or ASCII? > > If EDI: > http://www.razzak.com/projects/835payment/835_EDI.pdf > > If ASCII: > http://www.razzak.com/projects/835payment/835_DataSpecs.pdf > > Either way, design a very specific R:BASE database to achieve > you goal. Then use the following syntax: > > LOAD Payment835 FROM filename AS FORMATTED USING + > Colname1 5 19, + > Colname2 20 39, + > Colname3 40 59, + > : > : > : > Colname9 120 123 > > In case of *multiple* segments, you'll need to load the > entire data in a TEMPORARY table and then parse each line > using the loop. ( DECLARE c1 CURSOR FOR SELECT ... ) > > Position 1 thru 4 defines the loop information. > > Good luck! > > Ver Best R:egards, > > Razzak. > >
