The CO APCD contains millions of claims across all health plans for multiple years. Health insurance payers submit data monthly and the entire database is refreshed every other month, so the CO ACPD is continually evolving and being enhanced.
Data Warehouse Refresh Resources
The CO APCD Data Warehouse is refreshed every other month, incorporating new years of data while also improving the quality of the existing data by implementing new business rules, adding previously missing files, or correcting concerns. The breakdown of paid-through dates by business line for the most recent refresh is available here.
The Runout Report for the most refresh is now available for download and provides important information regarding the length of time between the service date and paid date (‘claims lag’) for medical and pharmacy claims in the CO APCD.This analysis helps answer several key questions including how long it takes to achieve “completeness,” how lag time varies by payer type (commercial, Medicaid, etc), and by claim type (medical, pharmacy, inpatient, outpatient, etc).
The Data Discovery Log documents data quality items identified following file submission and processing, enhancement and loading of data into the CO APCD following each refresh of the warehouse.
Query: CO APCD Data Quality
The Query: CO APCD Data Quality series is designed to:
- explain the foundations of how CIVHC approaches data quality as administrator of the CO APCD,
- detail the processes and systems that bring the data into the warehouse, and
- define what steps are taken before data is released.
As of April 2021, the Colorado All Payer Claims Database (CO APCD) contained nearly 920 million claims for approximately 65 percent of insured individuals in Colorado with medical coverage, reflecting over 3.4 million lives.When those with dental and pharmacy coverage are added, the CO APCD spans 4.5 million unique lives Read more…
Human nature is to use history to inform the future, to apply lessons learned to situations in order to more easily navigate them and avoid possible uncertainty. Unfortunately, this can lead to disappointment or frustration when events do not unfold in the anticipated ways. It works much the same way 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…
Query: CO APCD Data Analytics
The Query: CO APCD Data Analytics series is designed to:
- provide insight into CIVHC's approach and philosophy of data analytics,
- outline the what is possible and what is not with the data, and
- demystify the process of CO APCD data release.
With a resource the size of the Colorado All Payer Claims Database (CO APCD), it is easy to presume that the possibilities for exploration are endless. In some senses, it is true, comprehending the potential combinations of data elements from over 800 million claims is nearly impossible. However, the scale Read more…
In 2010, the Colorado General Assembly saw the opportunities an immense repository of data such as the Colorado All Payer Claims Database (CO APCD) could afford – they also saw the possibilities for exploitation and built safeguards into the use of the CO APCD. When drafting the legislation that shaped Read more…
The Colorado All Payer Claims Database (CO APCD) is a state-legislated, secure health care claims database compliant with all federal privacy laws. The complexity and scale of the database continually grows with millions of claims submitted by payers each month, reflecting over 4.5 million lives. It contains nearly 920 million Read more…