This site under reconstruction.
In the last post I wrote about messy data where some people shared the same SSN or some had 2 SSN. How about where some had NO SSN? This is coming from what I think is a large healthcare insurer and yet the data is sloppy. Maybe I’m being too harsh or unrealistic? I’ve had…
“Some people have 2 social security numbers or others share the same security number.” My boss just stared silently at me like, “You’ve got to be kidding me.” While I’m waiting to move onto the next stage of the ACA electronic filing, I’m working on the reconciliation process our broker goes through and boy, is it…
For those of you who generated the healthcare data via Excel, the biggest hurdle in sending the data electronically via the UI channel is figuring out how to convert your excel data into xml. Excel has a way of doing this conversion, but only if the schema is simple. Unfortunately, the government’s schema is not simple…
If you are trying to find someone to transmit your ACA data because you don’t know how to do xml, it may be very expensive. We were looking into having someone do the conversion and transmission of data in case I don’t figure it out and it turns out the price is too steep. The…
I’m learning something new – xml. Phase II of the ACA / 1094-1095C reporting is to electronically send the data to the IRS. But the electronic submission can’t be just any ol’ submission. The information needs to be in xml. So, I have been doing a lot of reading and experimenting to see how I…
I’m still working on the ACA report but it looks like we have about 80% of the data locked down. The other 20% appears to have data that doesn’t make sense when you compare various pieces of the data (hire date, term date, date coverage began, date ended, paycheck dates). The HR VP is now…
You must be logged in to post a comment.