The Carolina Cost and Quality Initiative

The Carolina Cost and Quality Initiative is a collaborative partnership between UNC’s Gillings School of Global Public Health and the Cecil G. Sheps Center for Health Services Research. Its mission is to promote population-based research on the incidence and prevalence of disease in insured populations, patterns of utilization and treatment, and cost of care in North Carolina in order to improve the delivery and quality of care for its residents.

The Initiative currently maintains claims data from North Carolina Medicaid and Blue Cross Blue Shield of North Carolina.

North Carolina Medicaid and Blue Cross Blue Shield of North Carolina (BCBSNC) claims data are available as limited datasets. Patient identifiers are encrypted and no identification of individual patients is possible.

NC Medicaid Claims Data 

The NC Medicaid database contains claims data from the North Carolina Department of Health and Human Services Division of Health Benefits.  These data are updated monthly

The database includes the following:

  • Claims information (including doctor visits, inpatient and outpatient care, prescription medications, dental treatments, charge amounts, dates of service, and diagnoses and procedures).
  • Provider information (including specialty and location).
  • Member information (including date of birth, gender, county/ZIP code of residence, race and ethnicity).

Dates available: Jan. 2013 – 3 months prior to the current month (e.g., if today is April, data thru January is available)

Blue Cross Blue Shield of North Carolina (BCBSNC) Claims Data 

The BCBSNC database contains claims data on health care services reimbursed by BCBSNC. The database includes claim records from insured groups, administrative services only (ASO) groups, and individual market and Affordable Care Act Exchange Plans.

The database includes the following:

  • Claims information (including doctor visits, inpatient and outpatient care, prescription
    medications, dental treatments, charge amounts, dates of service, and diagnoses and procedures).
  • Provider information (including specialty and location).
  • Member information (including date of birth, gender, county/ZIP code of residence).

Data are updated approximately every January and July and are on a 3 month lag, i.e. data ingested in July would contain claims through March.  Data ingested in January would contain data through September.

Dates available: January 2006 – March 2024.

North Carolina State Health Plan (SHP) Claims Data

The SHP database contains claims data on health care services reimbursed by NC SHP.

The database includes the following:

  • Claims information (including doctor visits, inpatient and outpatient care, prescription medications, dental treatments, charge amounts, dates of service, and diagnoses and procedures).
  • Provider information (including specialty and location).
  • Member information (including date of birth, gender, county/ZIP code of residence).

Data are updated approximately every April and October and are on a 3 month lag, i.e. data ingested in April would contain claims through January.  Data ingested in October would contain data through July.

Dates available: January 2017 – December 2023

BCBSNC Files

BCBSNC Data Dictionary

NC Medicaid Files

Medicaid Data Dictionary

SHP Files

CCQI SHP Variable List

Excel versions of data dictionaries and additional look-up tables are available upon request.

Blue Cross Blue Shield of North Carolina (BCBSNC) Data

BCBSNC Yearly Membership by Plan Type

North Carolina Medicaid Data

NC Medicaid Yearly Membership by Plan Type

Aged, blind, and disabled. This category includes Medicaid recipients who are older adults (age 65 or older), blind, or those considered disabled (under the Social Security disability standards).  This category includes some dual eligibles (those who receive both Medicare and Medicaid), as well as individuals who are aged, blind or disabled who only receive Medicaid.  These individuals are entitled to full Medicaid benefits.

Children and Families. This category includes Medicaid recipients who are children under age 19, young adults ages 20-21, and the parents or other caretaker relatives of children who are taking care of the children under age 19. It also includes pregnant women who qualify on the basis of their pregnancy.

Medicare Savings Programs (sometimes referred to as Medicaid for Medicare Qualified Beneficiaries (MQB)). This category includes aged (65 or older), blind, or disabled adults who receive Medicare. There are different types of Medicare Savings programs. Individuals enrolled in the different Medicare Savings programs have incomes too high to qualify for full Medicaid services. These individuals get help paying some of the Medicare cost sharing (such as the Part B premium, or deductible, depending on the type of Medicare Savings program). They do not get full Medicaid coverage.  Thus, unlike the regular aged, blind, and disabled category, the Medicare Savings individuals are not eligible for coverage of Medicaid-covered services that Medicare does not cover (such as dental services or hearing aids).

Other Medicaid. This includes other groups, not included in the other categories. For example, this includes people enrolled in Medicaid through the Family Planning program, Breast and Cervical Cancer program, or emergency Medicaid.

NC Health Choice. This program covers children who are enrolled in North Carolina’s Child Health Insurance Program (CHIP). This includes children ages 6-18 whose income is too high to qualify for Medicaid, but no more than 210% of the federal poverty guidelines.

North Carolina State Health Plan

NC State Health Plan Yearly Membership by Member Age

General Eligibility  

Only University of North Carolina at Chapel Hill faculty, staff, and graduate students are permitted to access data maintained by the Carolina Cost and Quality Initiative. Project proposals must be submitted to a review committee for approval in order to assure the feasibility of the proposed research.

 

Cost of Data

For unfunded projects, there are no fees for initial consultations or creation of basic analytic data sets of reasonable size. It is anticipated that these basic services will take up to 10 hours (2 hours of analytic consultation and 8 hours of analytic time). Charges per year of data will be made for requests that exceed three years of data. These charges cover costs associated with data preparation.

Funded projects will be asked to pay for all analytic costs. We recommend including sufficient funding for analytic time in all grant proposals. Funding to pay for data management and programming time must be arranged and documented before the data request is submitted. Data management or programming work will be estimated based on a needs assessment using an hourly rate of $98/hour. 

 

Data Storage

All data, including analysis subsets and extracts, must be stored and analyzed on approved secure servers at the Sheps Center. Server access fee of $5,500 per user per year will apply. This fee supports systems maintenance and security controls.

Requests for preliminary data for grant submissions or planning purposes can be submitted by filling out the CCQI preliminary request form. Please note that preliminary information is limited to counts and basic descriptive statistics.

Step 1: Prepare your data request

Timeline: 1-2 weeks
First, download and complete a draft of the
CCQI Data Request Form. Submit this draft form here.

The CCQI Project Management team will reach out to schedule a consultation to discuss your project’s aims, budget, and timeline.

Download the remaining forms and DUAs required for your request and complete them.

Once you’ve collected all the required forms and signatures, submit all documents to the CCQI Project Management team for their review.

Forms and DUAs required for all CCQI Data Requests

Step 2: Submit your request for approval

Timeline: 1-2 months
Your request will first be reviewed by a UNC Oversight Committee. This committee may request additions/revisions to your request prior to final approval.

Once approved by UNC, your request will be sent to each relevant data owner for approval. The data owners may also require edits to the request before approving.

CCQI Oversight Committee Evaluation Criteria:

  1. Is the research question one that is in keeping with the overall focus of the Initiative and important to be answered, for North Carolinians or the US health system as a whole, either from a policy or practice
    perspective?
  2. Can the research question be adequately answered using the requested database? Are there an adequate number of cases to be studied for the proposed analysis? Are the right data elements available and specified? For the key data elements needed, is the quality of the data adequate?
  3. Is the proposed methodology sound and viable with respect to the research questions, population and data requested?
  4. Does the research team possess the requisite skills/experience and proposed resources to conduct the research with high standards and in an adequately specified time frame?

Step 3: Get your data!

Timeline: 1-2 months
The CCQI project Management team will reach out to you once your project is approved to introduce you to your assigned Sheps programmer(s).

Sheps programmers will begin extracting your project-specific analytic dataset from the master data. Data prep time depends on the capacity and complexity of the request.

If you aren’t already accessing Sheps servers, you will need to sign Sheps’ user agreements here and familiarize yourself with using the Sheps Research Computing Cluster.

Our programmers will work with you to ensure that the data extract meets your specifications.

Happy researching!

More questions?

Check out our FAQs or contact us anytime at ccqi@schsr.unc.edu.

Data use agreements must be kept up to date. All staff and researchers with access to the data must sign a DUA.

 

The following funding acknowledgment must be included in all journal articles or conference abstracts using CCQI databases:

The database infrastructure used for this project was funded by the Cecil G. Sheps Center for Health Services Research; the Department of Health Policy and Management, UNC Gillings School of Global Public Health; the CER Strategic Initiative of UNC’s Clinical and Translational Science Award (UL1TR001111); and the UNC School of Medicine.

 

Additional Responsibilities When Using BCBSNC Data:

  • All journal articles and conference abstracts must be submitted to the Sheps Center to send on to BCBSNC and/or the State Health Plan at the time of submission to journal or conference, or earlier.

 

Additional Responsibilities When Using NC Medicaid Data:

  • All journal articles and conference abstracts must be submitted to the Sheps Center to send on to NC Division of Health Benefits at least 30 days prior to submission for publication.

For more information on the Carolina Cost and Quality Initiative, please contact:

Sandra B. Greene, DrPH

Co-Director, Program on Health Economics and Finance & Senior Research Fellow

919 966-0993

sandrab_greene@unc.edu

 

General CCQI Inquiries:

ccqi@schsr.unc.edu