Uploading ERA is broken

jpmd wrote on Friday, April 03, 2009:

When a ERA file is uploaded it does appropriately match the reject reason on the right column on Version 3.0.

‘Unknown Adjustment’

Is anyone using this function?

Jude A. Pierre, MD
www.phyaura.com

jpmd wrote on Sunday, April 19, 2009:

Rob
Have you been able to look into this error/bug. Whenever we upload a ERA file it does not drop the reason code in the right column.  How is this supposed to work?  Where could we pull a report on rejection codes for working our A/R.

Thanks

JPMD

sunsetsystems wrote on Sunday, April 19, 2009:

Do you mean me?  I can’t look into a problem without very specific information.  In my experience it’s common to find garbage data in ERA files.  Also if you want to discuss it in the Developers forum, then it’s best to present a question or comment that relates to the X12 835 format.

Rod
www.sunsetsystems.com

jpmd wrote on Sunday, April 19, 2009:

Yes Rod,  Sorry for being vague.
Here is  sample ERA from ZirMed.  You seem to be the expert on this and would like for our team to know more to contribute.  We need to run some standard reports on reject codes and need to direction as to how the code is processed. If different ERA files will produce different results than should we not standardize this some how.  Thanks and here is the file without patient information.

ISA|00|          |00|          |ZZ|ZIRMED         |ZZ|611340767     

|090413|0935|U|00401|000001593|1|P|^~GS|HP|ZIRMED|P0954|20090413|0935|1593|X|004010X091A1~ST|835|0001~BPR|I|152.36|C|ACH|CCP|

01|071000013|DA|922188|1592000000||01|xxxxxxxxx|DA|xxxxxxxx|20090413~TRN|1|884669217|1592015694~REF|EV|P0954~DTM|405|20090410

~N1|PR|MEDICARE PART B~N3|532 RIVERSIDE AVE.|P.O. BOX

2360~N4|JACKSONVILLE|FL|322310000~REF|2U|09102~PER|CX||TE|8664549007~N1|PE|HEALTH LINK ASSOCIATES LLC|XX|1497800000~N3|PO BOX

3597~N4|SPRING

HILL|FL|346113597~REF|TJ|000000000~LX|1~CLP|4470-145430|19|380.9|152.36|38.09|MB|1009086470390~NM1|QC|1|Lnmane|Fname||||HN|00

0000000A~NM1|74|1|||J~NM1|82|1||||||XX|1518088061~NM1|TT|2|MUTUAL OF OMAHA INSURANCE

COMP|||||PI|30090~MOA|||MA01|MA18~DTM|050|20090327~SVC|HC^99223|362.66|145.06||1~DTM|472|20090208~CAS|CO|45|181.33~CAS|PR|2|3

6.27~REF|LU|21~AMT|B6|181.33~SVC|HC^93010|18.24|7.3||1~DTM|472|20090208~CAS|CO|45|9.12~CAS|PR|2|1.82~REF|LU|21~AMT|B6|9.12~CL

P|1068-139876|4|723.7|0|0|MB|1009098154520~NM1|QC|1|Lname2|Lname2||||HN|000000000A~NM1|74|1|||B~NM1|82|1||||||XX|1669474219~M

OA|||MA01~DTM|050|20090408~SVC|HC^93925|347.88|0||0||1~DTM|472|20090129~CAS|CO|11|347.88~REF|LU|11~LQ|HE|M25~LQ|HE|N115~SVC|H

C^93970|375.82|0||0||1~DTM|472|20090129~CAS|CO|18|375.82~REF|LU|11~CLP|2142-158063|4|0|0|0|MB|1009099254570~NM1|QC|1|Lname3|l

astname3||||HN|000000000A~NM1|74|1|||H~NM1|82|1||||||XX|1518088061~MOA|||MA130~DTM|050|20090409~SVC|HC^99253|0|0||0||1~DTM|47

2|20090407~REF|LU|21~LQ|HE|M79~SE|61|0001~GE|1|1593~IEA|1|000001593~

The file name that we upload is this SMFL0[1].15369.20090413.093528039.ERA.835.  Would this make a difference?

sunsetsystems wrote on Monday, April 20, 2009:

I can’t spare the time to study this right now, but you can find the parsing logic in library/parse_era.inc.php.   It’s pretty easy to follow.

Rod
www.sunsetsystems.com