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…
Previous queries have detailed the process for the monthly submission and intake of claims data to the Colorado All Payer Claims Database (CO APCD). This query explores the steps the data undergo after being accepted into the warehouse. Once payer-submitted data has successfully passed the extensive initial validation and quality Read more…
Each month, health insurance payers submit millions of medical, professional, pharmacy, and dental claims for inclusion in the Colorado All Payer Claims Database (CO APCD). CIVHC along with data managers, Human Services Research Institute (HSRI) and NORC at the University of Chicago, continually work closely with submitters to ensure they 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 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…
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…
As of June 2023, the Colorado All Payer Claims Database (CO APCD) contained over 1 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…
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…
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…
As administrator of the Colorado All Payer Claims Database (CO APCD), one of the CIVHC’s key responsibilities is continually working to improve the completeness, quality, and utility of the database. One of the most essential activities in continuing enhance the CO APCD is annual updates of the Data Submission Guide Read more…