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.
