|Top Previous Next|
When you start exporting claims into the staging tables you might encounter errors at first. This usually results from table definition issues. The HIPAA Eligibility Responder displays a very detailed error message that tells you which claim failed, at what field and if applicable, which line.
This information should help you to trouble shoot the problems. It sometimes takes serious detective work to find and correct errors.
Below are some of the most common errors:
Item cannot be found:
This error happens when a column that was selected for export does not exist in the Header table. In this particular case it is the field 'ClaimNo'. If you receive this error, go back to your table admin tool and check the field 'ClaimNo'
Multi-step OleDB Operation generated errors
This is typically the message when the field definition in the database is different from the data. Here we see that the error occurred with the billing provider's specialty. The field definition in the table was set as varchar(10) and the value here:000000002331 has 12 digits, causing the error message.
Field doesn't have a default value
The field 'ClaimNo' is defined as 'Not Null'. But somehow this data was not present and HIPAA Claim Master tried to update the table with a null ClaimNo.
This error occurrs when the HIPAA Claim Master tries to write a letter to a field that is defined as 'Integer' for example. The data type of the column does not match the data type of the value.
Claim Detail Errors
The errors with the claim detail table are similar, only that the error message indicates also at which line number it occurred.