New user questions

[Brian McGinity]

I just got the csv to 837p example running. I want to use the csv as
input and see it will work.

What is the best way to setup the directory structure to run
transformations for a few different doctor’s claims?

Is a new data directory needed each time a transfomation is run?

Or can the same data directory be reused an just update the .CMD file
and the .CSV file with the new infomation?

Thanks for helping...
Brian

[Com1 Software]

Brian,

In the case of example 21 we have a pre-configured database for
the Institution and the insurance carrier data. This allows you to
edit the institution and insurance carrier data using the 297s
administration
screens. As a result you would want to keep your databases in separate
folders for each
provider. In example 21 we are looking at one provider and one
insurance carrier. In the C1.INI
you will see that it says
[system]
purgesystem=carriergroup
When the purge is run the insurance carrier and the institution data
along with their insurance contract table
data is not purged.

On the other hand Example 52 uses a different purge than example 21 in
the C1.INI
[system]
purgesystem=all

This clears the entire database in a folder and thus the ability to
let the source file build everything
in your database. This allows you the ability to have multiple
unrelated providers being processed
within a single folder by just copying the new source file to the file
named specified in the c1.acu.
Since example 52 is using the ACU to convert an X12 837 file, we take
advantage of the fact that
the 837 has enough information to build our databases correctly.

In some of our other example we do use the purgesystem=all. In these
examples we are typically doing a two pass
bcu where the first file the BCU process is the institution, provider,
and insurance carrier data and the secon pass file has
the claim data. The reason we split the process, was to be efficient,
but there is no other reason that a single CSV file
can't be set up to contain all the data you would be needed to build a
single pass bcu that would use purgesystem=all.

Hope that helps to start to answering some of your questions.

Thanks
Dave

[Admin Mailer]

Just to be clear, this program can be run from something like the
windows scheduler? The job could execute a .bat file and generate the
837p without a user sitting in from of computer, right?

[Com1 Software]

Yes, The translator has two executable programs, the C1A3F297.EXE the
translator administration program and the translator itself, the
C1C3F298.EXE. The C1C3F298 program is run using the CMD file as a
parameter.

Example Batch File:

cd\c1a3f297
c1c3f298 \provider1\example.cmd


The only thing you have to watch out for is to to make sure that when
you run the C1C3F298 program, that
you start it in the base directory that it is installed in as outlined
in the example. The reason for this is so that
it will detect it's registration files.

[Admin Mailer]

Thanks for the info. This is really a great tool.

Any chance you have this as a Oracle Stored Procedure? Ideally, it
would great to do the transformation inside the db as a function
call. I am debating if I should buy this product or write it in
plsql. Possibly we could collaborate on such an idea and add it to
your existing product line.

Out of all the products that I've looked at no one does tranformations
in an Oracle function.

[Com1 Software]

We have been asked that before.

http://www.harbour-project.org/
http://en.wikipedia.org/wiki/Harbour_%28software%29

http://groups.google.com/group/harbour-users
http://groups.google.com/group/harbour-devel

We are looking at the RDD as a way to access databases directly in the
future.

Let me know if you think we can make an Oracle Stored Procedure using
Harbour.