Once payer-submitted data has successfully passed the extensive initial validation and quality tests performed by CIVHC and data manager Human Services Research Institute (HSRI) and NORC at the University of Chicago, the data are ready to be ingested into the warehouse. Previous queries have detailed the process for the monthly submission and intake Read more…
Each month, health insurance payers submit millions of medical, professional, pharmacy, dental, and vision claims for inclusion in the Colorado All Payer Claims Database (CO APCD). CIVHC continuously works closely with submitters to ensure they understand the submission requirements and that the process is as smooth as possible. After submissions pass Read more…
As administrator of the Colorado All Payer Claims Database (CO APCD), CIVHC is required by statute not only to maintain the database, but to continually improve the quality and utility of the CO APCD. One of the most essential activities to enhancing the CO APCD is annually updating the CO APCD Rule and Data Submission Read more…
As of June 2023, the Colorado All Payer Claims Database (CO APCD) contained over one billion claims spanning 2013 through 2022. These claims were submitted by commercial health insurance plans, including Medicare Advantage, voluntarily submitted Employee Retirement Income Security Act (ERISA) and mandated non-ERISA self-insured employer plans, Medicaid, and Medicare Fee-for-Service (FFS). The CO Read more…
The Colorado All Payer Claims Database (CO APCD) contains over 1.1 billion claims, with more added every month. These claims are submitted by commercial health insurance plans, including Medicare Advantage, voluntarily submitted Employee Retirement Income Security Act (ERISA) and mandated non-ERISA self-insured employer plans, Medicaid, and Medicare Fee-for-Service (FFS). The CO APCD Read more…
The Colorado All Payer Claims Database (CO APCD) contains over 1.1 billion claims, with more added every month. These claims are submitted by commercial health insurance plans, including Medicare Advantage, voluntarily submitted Employee Retirement Income Security Act (ERISA) and mandated non-ERISA self-insured employer plans, Medicaid, and Medicare Fee-for-Service (FFS). The CO APCD Read more…
A previous query defined the different nuances encompassed under the term “data quality” to help shed light on the myriad factors that can impact the contents of an output from the Colorado All Payer Claims Database (CO APCD). This piece will outline some baseline expectations for users who are new to claims Read more…
As of June 2023, the Colorado All Payer Claims Database (CO APCD) contained over 1 billion claims, representing over 5 million insured lives in Colorado, spanning from 2013-2022. Of these claims, there are over 65 million behavioral health claims contained in the CO APCD, representing over three million unique Coloradans Read more…
Analyst: Trang Giang, MBA, Data Quality Analyst, CIVHC Introduction: Why did you decide to go into health care analytics? I got into health care analytics entirely by accident, and now it is my career as well as my passion. I graduated with a finance degree and an MBA, but the Read more…
Claims data is very different than other types of data typically encountered by actuaries, accountants, analysts, and researchers. If not prepared for the unique challenges it presents, it is easy to conclude that something is wrong with a data set. The phrase “data quality” is frequently used as a catch-all Read more…