This is the second in a series of blogs about what, exactly, is in the Colorado All Payer Claims Database (CO APCD). Today we’re looking at professional claims, which are generally used by providers in settings other than hospitals. Like medical claims, professional claims include basic information about why you went to the doctor, and who you visited. Professional claims focus a bit more on diagnoses and treatment than the medical claims and this information forms the basis for the cost of the visit. In the coming months we will explore additional claims that insurance companies send to the CO APCD like pharmacy claims, and dental claims and how that data is protected and incorporated in the database.

Sometimes really cool things are made up of really boring parts; take the Internet for example. When we log on to Facebook, we’re seeing a finished page that has pictures and text and lots of exciting ways to interact with the content. But, on the backside, Facebook is nothing more than a bunch of computer code: 


The CO APCD is pretty similar. To file a claim, providers fill out a form that has a bunch of tiny boxes and submit it to the insurance company. After processing by the payer, the claim ends up in the CO APCD, and is even more boring to look at than the form (how is that even possible?).

Really, really boring!

However, in the same way that each line of computer code gibberish translates to something cool, each of the boxes on an insurance claim contains information that can be used to do something pretty awesome. Let’s take a look at what goes into those boxes – and we promise to make it as interesting as possible.

Now, different types of providers fill out different versions of these forms so rather than explore a bunch of really boring forms, we’re going to use a general example to show what kind of information is provided in a typical medical claim. Additionally, we’re only focusing on what is collected by the CO APCD and not delving into any privacy or security concerns – all that stuff is coming, don’t worry, we want to take this step by step and not drop too much info on y’all all at once.

Click on the image below to interact with the table and see what the CO APCD collects.

Professional Claim Dissection Table