Selecting Fields to Export

<< Click to Display Table of Contents >>

Navigation:  Using the Database >

Selecting Fields to Export

Previous pageReturn to chapter overviewNext page

The HIPAA Premium Payment Master can export all the fields. You might not want to export every field, but only those that you have in your database. You are really only limited by your database engine. In order to reassemble the payment from the database, it is better to have all the fields selected and available.

Once you have created created your tables and tested connection and table names, you can select which fields to export. Follow the instructions below.

1.Select Data Export arrow SQL Setup in the main menu.
 
setup12
The "SQL Setup" menu
2.You will be confronted with the following screen where you can set up the database connection and enter the names of the database tables.
 
data
The "Database Server Setup for OLE/ODBC Connection" window
3.The right side of the screen shows all the available database fields and columns. Choose fields to be exported by selecting checkboxes in front of the fields in the following tables:
 
Header
TradingPartnerID
Filename
FileVersion
TransactionNo
TraceType
TRNOriginatingID
HandlingCode
TotalAmount
PaymentMethod
PaymentFormat
OriginatingDFIIDQual
OriginatingDFIID
SenderAccountQual
SenderAccount
OriginatingID
OriginatingSupplCode
ReceivingDFIIDQual
ReceivingDFIID
ReceiverAccount
EffectiveDate
CurrencyEntityID
CurrencyCode
MasterAccount
HDR_ClientReportingCategory
etc.

Detail

PaymentID - Header Table's Auto Key
InsuredID
RemittanceRefType
RemitanceReference
PaymentAction
Amount
BilledAmount
OtherIDQual
OtherID
CoveragePeriod
AdministrativeInfo
ContractServiceCharge
InsurancePremiumInfo
ServiceCharge
AdjAmount
AdjReason
MemberCount
MemberUnit

 

Tip: We recommend to select all fields. This makes it possible to reassemble all the information in the EDI file and create the image. You can click on "Select ALL" and then test the configuration. With the scripts supplied with the application you should have no error messages.

 

Tip: Sometimes it might be necessary to rename a field or fields. Some legacy database want upper case only or lower case only field names. The HIPAA Premium Payment Master allows you to rename any field in any table. Click twice (not double-click) on a field and you are in "Edit" mode. Read more in the following "Renaming Fields" sub-topic.

edit3

The field selection list in "Edit" Mode

 

4.Once you have made your selection or selected all you have to test your setup, click on the "Test Configuration" button.
 
test-conf
The "Test Configuration" button
 
The program will connect to the database and read the table definitions. Afterwards, all the fields that you selected will be tested.

Notice: Before you can save your field configuration, you have to test the setup to make sure that all the fields that you selected exist in the tables that you specified. The table scripts that come with the HIPAA Premium Payment Master do not have all the fields because some of the fields are very specific and not of use to many people.

You should receive a message like this. Click "OK."

setup-ok
The success message
 
If there are errors, refer to the following "Troubleshooting Data Fields" sub-section.

5.Only after the configuration have been checked out, are you allowed to save it. Click the "Save Field Configuration" button.

Important! After you have checked the setup and got the success message, you still need to save the configuration otherwise nothing will be exported.

save-field-config
The "Save Field Configuration" button

 

Renaming Fields

There are a few reasons why you would want to use different field names than the ones given by the HIPAA Premium Payment Master:

Your database cannot handle long column names such as "CA Clipper" or "IBM AS 400."
You already have a staging table and want to import the data straight into your own table which has different field names.

HIPAA Premium Payment Master lets you change the names of the columns that you selected for export:

1.Check the box near the field for import.
2.Click the field name twice. Do not double-click, but slowly click twice. You will see that the field name is now editable.
3.Change the name to your value and click somewhere outside the field.
4.Your field name has now been changed.
 
edit2 Changed to: create3
Editing a field name

 

The new value will be saved as long as this field is selected for Import. If you unselect the field and save your selection, the field will revert to its original name.

 

Notice: Field names must not contain spaces.

 

Troubleshooting Data Fields

If fields don't exist in the database that you specified, you will see the error screen:

The "SQL Errors" window

Study the errors in detail and see what went wrong. In our case, for demonstration purposes we have changed the names and that caused the error. A solution is to click the "Uncheck the Fields in Error" button and return to the field selection screen.

FieldError1

The fields in error are now unchecked.