This project has moved and is read-only. For the latest updates, please go here.

Parsing UB-04 claim data

Sep 10, 2014 at 1:07 AM
Hello,

We have UB-04 claim data available as text files. Each file has multiple claims separated by line breaks. Can I use the X12 Parser to parse & transform this data to XML similar to what I am currently doing for X12 4010 and 5010 professional and institutional claims?

Any help would be greatly appreciated.

Kind Regards,
nk5491
Sep 11, 2014 at 4:23 AM
Can someone please help with this?

Thank you,
nk5491
Sep 15, 2014 at 2:58 PM
This is an example of the Ub-04 claim available in text format. Does the X12parser support parsing this format?


ABC CHILDRENS RES HOS 1234567
P O BOX 1111 DEPT 55 0000000000012345 0000
CITY ST 111110001
1111222222 1111333333 11-2223333 123456 123456
                                     1111 STREET LANE APT 555
LNAME, FNAME N. CITY ST 12345

09271994 F 123456789 1 1 11 01



LNAME FNAME
1111 STREET LANE APT 555
CITY ST 12345-
(111)222-3333


0250 PHARMACY 120611 1 9070
0402 ULTRASOUND 76705 120611 1 78500












0001 001 001 010112 87570
                                                                1033112230
MYCHOICE-MYCARE 123456789 Y Y 87570



LNAME,FNAME N. 18 AB12345657 WT01
                                                      NONE

28261 V4579 V623 V180 V183 V0481
9
                                                      1111111111
                                                DRLNAME              DRFNAME


 MYCHOICE-MYCARE  A1112BC2000A
 PO BOX 1111
 CITY ST 1234511

Thanks for your help,
nk5491
Sep 16, 2014 at 6:44 PM
Can someone from the X12Parser team please respond?

Thanks,
nk5491
Sep 16, 2014 at 8:16 PM
The text you are showing me is no longer in an X12 format.
My only guess is that they have layed out the data so that it could be projected onto a UB-04 form. But that may not be the case either.
The format looks like it was created to be human readable and not automation readable.

I am not sure why someone is giving you these files, but it appears to be a proprietary format. Perhaps you can ask them for the raw x12 files that generated these files. Most everyone receives claims as x12 or as paper, so there must have been some internal program that generated this.
Sep 16, 2014 at 10:01 PM
Dear dstrubhar,
Thank you so much for taking the time to respond, I really appreciate it.
You are absolutely correct. This is data projected from a UB-04 form. And it adheres to the official UB-04 data spec.

Unfortunately, we have to live with this format because that's the only format this particular Provider supports (for now). We receive 4010 and 5010s (raw X12 files) from all other providers and your X12 parser has been a huge blessing!

Based on your feedback, it appears I am going to have to write a parser from the ground up to make it automation readable by referring to the UB-04 spec (lines1-4 are provider name and address, left justified, positions 1-20, etc).

Once again, thank you for your response.

Kind Regards,
nk5491