270 batch troubleshooting

aethelwulffe wrote on Wednesday, June 01, 2011:

Using mmf systems code for 270 batch creation, I have discerned a number of errors.  I am confident that there is a possibility that the original code might work for *someone*, but I have not discovered anyone who claims that this is so.

The following items require modification:
ISA01-  Must be configurable via x12 partner configuration interface and draw values form there.
ISA02-  Must be configurable, and have the default all spaces.  Currently, it is hard coded to all zeros (not universally acceptable).
ISA03- Must be configurable
ISA04- Must be configurable, and have the default all spaces.  Currently, it is hard coded to all zeros (not universally acceptable).
GS02- Not using the correct variable from x12 partner configuration
GS03-  Must be configurable in x12 partner and echo values from there, removing trailing spaces.
BHT05- Time format error, perhaps needs configuration formatting options, but my partners require the following formats:

$GS[4] = str_pad(date('Ymd'),8," ");			// Date [CCYYMMDD] 
	
	$GS[5] = str_pad(date('Hi'),4," ");	

Original code (I believe) used ‘His’ and ‘ymd’, even though the REM statements stated the correct requirements.

GS06 and ST02 could also use configuration options, and perhaps incrementing.  I can see uses for reporting in the EMR, and of course some B2B partners may require it’s configuration

The upshot?
To fully support all EDI formats as well as hcfa we simply need to make all header and tail element configurable in x12 Partner setup, and draw values for those elements from the DB.  The current implementation of EDI exports is crippled by hard-coded and erroneous classes and file generators.  This is a pretty simple fix really, and a huge time saver.

  The next issue:
Some clearing houses offer 837/835 exchange without supporting 270/271 data.  For instance, we can use Availity to do Medicaid claims in a batch with BCBS, but we must submit 270’s to Payspan or directly to Medicaid.  For those very common, possibly normal cases, we need to support configuration of insurance data to indicate which x12 partner to use based on the file type exported.  This simply requires another value added to the insurance information to indicate a second x12 partner to whom 270’s a sent.

Finally, we need a eligibility report that operates in a totally different manner, more like the billing module.  Currently, the report does not seem to use any filters other than date.  Picking an x12 partner only sets the values (and badly/incompletely at that) for the header, and requires you to manually remove incompatible patients from the report before creating a batch.  The data displayed for the patients does not show a visit date or other discriminating data.  Picking future dates, and selecting specific providers does not create a list either.

aethelwulffe wrote on Wednesday, February 29, 2012:

OK,
  I had been re-writing the 270 report and generator, and basically discovered that it will never really work for my applications, so I intend to supplant it with a new system, using the opportunity to create function includes and start using mulch-dimensional arrays in reports.

Currently, the report search criteria is based on calender events already scheduled.  There are some problems with that, as the scheduled provider might not be the rendering (billing) provider.  This may well kill the puppy right there.  Next, some folks may want to check eligibility on unscheduled patients, either before scheduling, or because they don’t use the calender for all patient contacts.

  My primary concern is to determine what search parameters other businesses require.  I am including some and/or search criterion that draws from patient data, insurance company, and x12 partner configuration fields, so that if you need to search for a custom demographics field like “Program” or “Active” you can, as well as optionally restrict to patients on the calender.  I need to include the ability to search out who the provider is based on user table settings, and be able to replace a non-billing provider with a billable one, both in appointment based searches as well as in non-appointment based.  In our set-up, there is already data for that, as well as x12 partner data that avoids the hard-coded ISA and GS header segments of the output file, but these would need to be added to the distribution code base/data base fields as well.  It think it would also be a good idea to stop requiring separation of the x12 partner when creating output.  If more than one x12 partner is present, then more than one file should be created with a combined log output.  This should probably also happen for claims.

Finally, I think there may be a demand for code/diagnosis specific eligibility verification.  That means, if you draw up a list of patients scheduled for a procedure, and then you can expand an individual patient in the interface to add codes just like you can in a fee sheet.  This data is sent to the payer for pre-authorization of the procedure.  It is likely that for planned procedures, this system should be integrated with the whole “procedures” dealie.

  input please:  What search criteria would you folks like to see for checking eligibility?