[RBG7-L] - Re: 835 Payment info

[A. Razzak Memon]

Marc,

It is very easy once you understand the file structure!

Very Best R:egards,

Razzak.

At 08:53 AM 8/24/2004 -0500, Marc Shluter wrote:

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.
>
>